Skip to main content

Advance Excel Syllabus (M S OFFICE EXCEL 2021)

 Advance Excel Syllabus

 

Home Menu:

·         Clipboard

·         Font

·         Alignment

·         Numbers

·         Styles

·         Cells

·         Editing

 

Insert Menu:

·         Pivot Table & Pivot Chats

·         Tables

·         Charts

·         Sparklines

·         Filters

·         Link

 

Page Layout Menu:

·         Page Setup

·         Scale To Fit

·         Sheet Options

·         Arrange

 

Formulas Menu:

·         Vlookup

·         Hlookup

·         Xlookup

·         Student Marksheet (Summation, Maximum, Minimum, Average, Status, Grade)

·         Salary Slip (Basic, HRA, DA, TA, PF, ESI , Gross Salary, Net Salary) 

·         If Condition

·         Count

·         Count If

·         Concatenate

·         Find

·         Abs

·         Ceiling

·         Round

·         Even

·         Odd

·         Exact

·         Fact

·         Left

·         Len

·         Lower

·         Upper

·         Mod

·         Power

·         Product

·         Replace

·         Rept

·         Sqrt

 

Data Menu:

·         Get Transform Data

·         Sort & Filter

·         Data Tools

·         Text To Column

·         Data Validations

·         Goal Seek

·         What If Analysis

·         Outline

 

Review Menu:

·         Proofing

·         Language

·         Comments

·         Protects

·         Encrypt With Password

 

View Menu:

·         Workbook Views

·         Show

·         Zoom

·         Windows

 

 

Projects & Tables

Labels:

Comments

Post a Comment

Popular posts from this blog

SAP-FICO with GST (Goods & Service Tax), TDS (Tax Deducted at Source) Index /Syllabus / System Application Programming & Data Processing (Finance & Controlling)

   SAP (FICO) FINANCE & CONTROLLING System Application Programming & Data Processing BASIC SETTING OF FICO CHAPTER NO   PARTICULAR T-CODE 1   Define company OX15 2   Define company code (HO) OX02 3   Assign company code to company OX16 4   Define business area OX03 5   Define chart of account OB13 6   Assign company code to chart of accounts OB62 7   Define accounts group with Number range OBD4 8   Define retain earning account OB53 9   Assign...
Post a Comment
Read more

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...
Post a Comment
Read more

What is a Tense? (PAST TENSE, PRESENT TENSE & FUTURE TENSE)

  What is a Tense??? è   Tense denotes  time  &  Action/ Activity Action or Activity è   Some movement o     Physical o     mental   Characteristics of time è   Time is an abstract –concept. è   The concept of time is based on geographical fact. è   Time is infinite. è   Time is dynamic. è   Time is unidirectional. è   Time never returns. Three division of time PAST                                       PRESENT                                 FUTURE 1)      PRESENT TENSE a.      Simple present tense  (11 occasions) b...
Post a Comment
Read more