ADVANCED FORMULA FUNDAMENTALS
- Excel general settings
- Excel formula settings
- Excel advanced settings, customize ribbon, quick access toolbar
- Excel add-ins
- Combine formulas for efficiency
EXCEL FUNCTIONS & KEYBOARD SHORTCUTS
- Navigating shortcuts
- Selecting cells
- Function keys
- Function shortcuts
- Formatting shortcuts
- Editing shortcuts
- ALT navigation key shortcut
PROFESSIONAL EXCEL SKILLS
- Excel Tools
- Custom formatting
- Absolute references
- Paste special
- Conditional formatting
- Forms & drop-down boxes
ADVANCED FORMULAS
- IF, AND, OR statements
- Nested IF, IFS
- Look-Up Functions
- Choose function
- CONCATENATE/CONCAT
- MATCH/INDEX
- SUMIF, COUNTIF, SUMIFS, COUNTIFS
- MIN, MAX, LARGE, SMALL
- Date Functions and Time periods
FINANCIAL CALCULATIONS: APPLICATIONS
- Present Value (PV), Future Value (FV), and Applications
- Net Present Value (NPV)
- Internal rate of return (IRR)
- Flat Payment Schedule (PMT)
- Using XNPV and XIRR
MODEL CONSTRUCTION TECHNIQUES
- Data tables design
- Assumptions and input variable rules
- Check box data modeling
- Spinner data
- List box data modeling
- Goal seek and solver
- Sensitivity analysis
FINANCIAL APPLICATIONS USING EXCEL FORMULAS
- Calculating Costs/Revenue
- Calculating Working Capital
- Depreciation (Straight line Depreciation and Declining Balance Depreciation)
- Taxes (Current amd Deferred Taxes)
- Equity (Dividends, Retained Earning)
EXCEL FOR REPORTING
- Creating informative charts and graphs to represent financial data
- Constructing interactive charts with basic form controls
- Creating dynamic dashboards for financial reporting
- Understanding macros and VBA for automated analysis and reporting
- Data validation and error-checking techniques for quality control
