Benefits of the course

• Build financial models from scratch (shown step-by-step)
• Format sheets and charts professionally
• Learn new keyboard shortcuts and be even faster in Excel
• Use Cell Styles and format spreadsheets easier and faster
• Writing Formulas and performing Calculations
• Create charts with Trend Lines, and Dual Axis
• Use Excel as a Database with Sort and Filter options
• How to avoid the most common Database Design flaws
• Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
• Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
• Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
• MIS Reporting
• Power BI & Power Query for Automation
• Learn several hidden Excel tips and tricks