Advance Excel
(1 Months)
Module - 1
(15 Days)
01. Excel Introduction
02. Customizing Excel
03. Using Basic Functions
04. Formatting and Proofing
05. Mathematical Functions
06. Protecting Excel
07. Text Functions
08. Date and Time Functions
09. Advanced Paste Special Techniques
Module - 2
(15 Days)
10. New in Excel 2013 / 2016 & 365
11. Sorting and Filtering
12. Printing Workbooks
13. What If Analysis
14. Logical Functions
15. Data Validation
16. Lookup Functions
17. Pivot Tables
18. Charts and slicers
18. Planning a Dashboard
Project on Advance Excel
(2 Days)