Course Content :
Introduction to Excel
Understanding the Excel interface
Navigating worksheets and workbooks
Basic data entry and editing
Formulas and Functions
Introduction to basic formulas (e.g., SUM, AVERAGE)
Understanding cell references (relative vs. absolute)
Exploring common functions (e.g., IF, VLOOKUP)
Data Management and Analysis
Sorting and filtering data
Working with tables and ranges
Introduction to data analysis tools (e.g., PivotTables)
Formatting and Finalizing
Formatting cells and data
Adding charts and visuals
Finalizing and printing spreadsheets
2. Advanced Excel Techniques
Advanced Formulas and Functions
Nested functions and formula auditing
Array formulas and advanced calculations
Logical functions (e.g., AND, OR)
Data Analysis Tools
Advanced PivotTable techniques
Data validation and conditional formatting
What-If analysis and scenario manager
Macros and Automation
Introduction to Excel VBA
Recording and editing macros
Automation with VBA code
Data Visualization
Advanced charting techniques
Sparklines and trendlines
Interactive dashboards with slicers
Collaboration and Sharing
Working with multiple users on a shared workbook
Protecting sheets and workbooks
Sharing and publishing options
Advanced Tips and Tricks
Efficiency tips for large datasets
Customizing Excel settings and options
Troubleshooting common issues
3. Financial Modeling with Excel
Introduction to Financial Modeling
Overview of financial modeling concepts
Understanding financial statements
Excel tools for financial modeling
Building Financial Statements
Creating income statements, balance sheets, and cash flow statements
Linking statements together
Performing sensitivity analysis
Valuation Techniques
Discounted Cash Flow (DCF) analysis
enrol now