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

TallyPrime GST Exam Paper

   TallyPrime (GST) Q-1) Pass the following Journal Entries for the month of April-2021.                  1 Ashok Traders Started Fast Track Agency by bringing in cash of Rs.700000 2 Ashok Traders opened a bank account with ICICI bank, Vadodara for the firm by depositing cash of Rs.200000 3 Ashok Traders rented an office space for Rs.3000 per month on April 01-2021. He paid security deposit of Rs.45000 by cheq. 4 Ashok Traders issued cheq. And purchased the following fixed assets. 1.        Cell Phone for office usage for Rs.18000 2.        Furniture for Rs.75000 3.        An Air conditioner for Rs.55000 4.        Electrical fittings for Rs.22000 5 Ashok traders withdrew Rs.15500 cash for personal use. 6 Ashok traders paid Rs.2500 in cash towards office maintenance charges for Apr...
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

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