EXCEL Training
Superior Excel training customized to meet your specific requirements:
- Master the use of some of Excel’s most useful functions (SUM, VLOOKUP, IF, AVERAGE, DATE, SUMPRODUCT etc.)
- Apply names to cells and formulas
- Create dynamic charts
- Learn how to protect your data
- Navigate between and name different sheets
- Conditional formatting techniques
- And much more…
- Unlock dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions etc.
- Maintain and summarize large sets of data
- Understand TABLES to dynamically update your data
- Best techniques for Sensitivity Analysis
- Scenario Manager
- Data tables
- Goal Seek
- Create dynamic reports with Excel PIVOT TABLES
- Build an interactive dashboard that updates new data
- Unlock dynamic formulas with SUMIFS, Nesting IF, OFFSET, FINANCIAL functions
- Advanced Conditional formatting techniques
- Automate & create interactive dashboards with Form controls (check box, Combo box, List Box etc.)
- An introduction to VBA – automate monthly time-consuming tasks with a single click of a button
Contact Us
- beta@icon.co.za
- training@betafinance.co.za
- duediligence@betafinance.co.za
- valuations@betafinance.co.za
- +27 (0)82 6010 519
- 011 883 2093
- Nelson Mandela Square 2nd FloorWest Tower Maude Street Sandown