Excel Pro
Course duration: 03 months
From basic calculations to advanced data modeling, Excel and Advanced Excel together provide comprehensive solutions for business, finance, and data analysis needs.
Sumary
Content
Strong knowledge of Excel and Advanced Excel is highly valued in today's workplace, as it helps professionals manage data accurately and make informed business decisions.
Excel Fundamentals - Getting Started, Working with Data, Basic Formulas & Functions. Intermediate Excel-Logical Functions, Text Functions, Date & Time Functions, Lookup Functions.
Advanced Excel-Data Analysis Tools, Pivot Tables & Pivot Charts, Professional Reporting. Excel Automation - Advanced Tools, Introduction to Automation. Power Tools- Power Query Basics.
Importing Data, Cleaning Data, Merging Data, Refreshing Reports.