Gre8 Time Education

09/12/2022

Complete Your Registration
https://forms.gle/o859N9WK7eixNfvX8
What is Advance Excel?
Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

Microsoft Advance Excel Syllabus.
1] Educational
• Attendance Sheet
• Mark Statement sheet
• Logical Functions
2] Accounting & Reports
• Salary Sheet
• Invoice Bill
• Profit & Loss Sheet
• Benefits of A/c on Computers
• Loan Statement
3] MS-Excel Features
• Paste Special
• Basic Formula Workflow
• Useful Function in financial modeling
• Format Cell in A/c.
4] Data Tools & Validation
• Import External Files with Adv. Formulation
• Advance Filter
• Power Query
5] Financial Functions
• Duration Functions
• Schedule functions
• PMT & IRR Functions
6] Logical Functions
• IFNA
• IFERROR
• OR, AND & XOR
• TRUE & FALSE
7] Text Functions
• Text Cell Function & Formatting
• Combination functions
• Data Arrangement functions
8] Date & Time functions
• Date & E-Date Functions
• Net count of Date and Time.
• Conversion of Date & Time
9] Lookup and Reference
• INDEX & MATCH Functions
• Vlookup, Hlookup & Xlookup
• Column and Row Functions
• Transpose Functions
• Advance Hyperlinking
10] Accounting Reports & 30+ Assignments of Advance Excel.
• Count Functions
• Mathematics Function
• Inventory Reports
• Information Functions
• Financial Functions

Join Advance Excel Course Only in Rs. 1500/- For 30 Days.
Online Batch Started.
 Interested Student Can Join 3 Day Free.


Complete Your Registration
https://forms.gle/o859N9WK7eixNfvX8