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 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

TALLYPRIME GST ADVANCE || SYLLABUS

TALLYPRIME GST ADVANCE  ü   Volume -1  (Journal Entries, Provisions Entry, Prepaid Entries, & Other Adjustment Entries) ü   Volume -2  (Purchase & Sales Invoices || Purchase Return & Sales Return) ü   Bank Payment  ü   Bank Receipt ü   Cost Centers ü   Interest Calculations ü   Use separate Actual & Billed Qty columns in invoice ü   CGST, SGST  & IGST ü   Multiple Price List ü   Purchase & Sales Voucher class ü   Bank Reconciliations (BRS)   ü   Volume -3   Purchase and Sales Manufacturing ü   Godown Creations ü   Internal Stock Transfer ü   Cost Centers ü   Use Pre-defined Cost Center Allocations during Entry ü   Manufacturing Journal ü   Stock Journal with Class ü   Purchase Order ü   Receipt Note ü   Rejections Out ü   Sales Order ü   Delivery Note ü   Rejection In ü   Multy Currency ü   Price List...
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