Excelerate

Modules Covered in this Excel Training

• MODULE 1 - EXCEL BASICS (for Beginners)
• MODULE 2 - EXCEL ESSENTIALS
• MODULE 3 - EXCEL FORMULAS
• MODULE 4 - DATA ANALYSIS
• MODULE 5 - INTRODUCTION TO EXCEL CHARTING
• MODULE 6 - PIVOT TABLE
• MODULE 7 - EXCEL EXTRAS

SYLLABUS:

1. ROUND() vs. ROUNDUP() & ROUNDDOWN()
2. COUNT() vs. COUNTA() & COUNTBLANK() vs. COUNTIF
3. DAY(), MONTH(), YEAR(), DATE()
4. TEXT()
5. WEEKDAY(), WORKDAY(), NETWORKDAYS()
6. WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays
7. NETWORKDAYS.INTL() for no. of business days calculations w. custom weekends/holidays
8. TODAY() and NOW() w. Shortcut
9. Text Formulas – Using CONCATENATE
10. Text Formulas – LEFT(), RIGHT() & SEARCH() - 1
11. Text Formulas – MID() & LEN()03:41
12. Text Formulas – REPLACE() & SUBSTITUTE()
13. VLookup Rules
14. VLookup With Exact Match
15. VLookup Approximate Match
16. VLookup With Trim
17. H-Lookup
18. Hyperlink To Sheet, File, Webpage, External links
19. Print Page Setup, Header & Footer
20. Data Sorting
21. Advanced Filters
22. Filtering Data
23. Basic Table
24. Advanced Table
25. Conditional Formatting: Formula-based (Colored rows based on user input)
26. Pivot Table Examples 1, 2, 3
27. Data Validation
28. Dependent Dropdown List

  NOTE: The classes will continue for ~1 hour. In case some topics remain uncovered in the class, you may join our next session.

Bonus Class on:

1. How to create online forms which allow you to gather data from individual team members
2. How to automate Excel tasks with time-saving macros
3. How to remove duplicates from data in Excel
4. VBA Macro - Making use of Excel for business purposes - Purchase Order Generator, Invoice/Billing,
5. Automatic Email Sending with attachments, MIS reports preparation