Business Analytics with Excel
Details
Introduction
The training is a compilation of the most imporant methods used for financial analysis in business. The first part is an introduction to financial modelling(from selecting tools to conceptual model building). The next part is the practical applicability in which we deal with a great number of examples discovering new techniques and advanced features of Excel needed in business analysis. The last part is dedicated to building financial models and tackling popular problems of financial analysis with the help of the trainer.
The training is highly practical; participants work on solutions of business problems with a trainer’s assistance. Due to this approach, participants discover a great number of applicable solutions which may be later used in a lot of situations.
Who is this training for?
The training is aimed at people who deal with preparing analyses and financial models in Excel.
What will I learn?
- Create effective financial models in Excel
- Verify and bulletproof financial calculations
- Use advanced Excel functions such as Vlookup or Index
- Create appropriate references and control calculations stages
- Use Excel functions to format your models
- Learn to model interests, ROI, depreciation
- Use pivot tables to aggregate data and present the output
- Use VBA to automatize repetitive tasks
- Create scenarios and model-based simulations
- Create presentations with Excel
Outline
- Course outline
- Introduction to business modelling with Excel
- Differences between Spreadsheet and financial model
- Types of financial models in Excel
- Choosing the right tools
- Skills that will make you successful
- Building financial model
- Conceptual model
- Golden rules in model design
- Spreadsheet planning
- Steps in model building
- Data management
- Version control and documentation
- Modelling techniques
- Problems with Excel
- Strategies to avoid errors
- How to create complicated formulas in easy way
- Linking to external files
- Model validation
- Circular reference
- Financial modelling with Excel
- Formulas and functions in Excel
- Excel Shortcuts
- Mathematical and Statistical functions
- Logical functions and flow control
- Nesting functions
- Best practices
- Financial modelling functions
- Aggregating
- Vlookup Hlookup
- Working with dates
- Index functions
- Financial functions
- Formatting tools in Excel
- Simple formatting tools
- Conditional formatting
- Sparklines charts
- Financial modelling tools
- Hiding model sections
- Grouping
- Table formulas
- Goal seek
- Pivot tables
- VBA macros
- User defined functions
- Financial model examples
- Nominal and effective interest rates
- Cumulated values
- ROI
- WACC
- Depreciation
- Break-even
- Stress testing, Scenario modelling, Sensitivity risk analysis
- Financial model stress testing
- Scenario modelling
- Sensitivity analysis
- Optimization
- Graphical model presentation
- Graphical output
- Gantt, Bubble, Waterfall charts
- Dynamic range
Schedules
| Thu, Fri, Sat | 10:00 AM — 04:00 PM |
| Wed, Thu, Fri | 10:00 AM — 04:00 PM |
| Thu, Fri, Sat | 10:00 AM — 04:00 AM |
| No. of Days: | 3 |
About Us
McTimothy Associates Consulting LLC is a Professional Management consulting, Human Capital Management, and Business Training company, incorporated in Nigeria with the Corporate Affairs Commission (CAC). Our Corporate office is centrally located at Gbagada Estate Phase 2 Estate, connecting easily to both Lagos Island and Lagos Mainland. We are enabling business greatness in Africa through cutting-edge modern management practices of Business transformation, Strategy, Change management and Innovation, Leadership, Restructuring and Turnaround management, and Training solutions.
Our Philosophy is an enduring commitment to enabling businesses and the professional greatness of our clients every day. Both organizations and individual employees who have attended our indoor and outdoor management development training programs have benefited tremendously in a number of ways. We also maintain relevant accreditations/partnerships with:
- Institute of Management Consultants (IMC).
- Institute of Professional Recruitment Consultants (IPRC), Nigeria
- Association of Professional Recruitment Consultant (APRC) UK
- Nigeria Institute of Training and Development (NITAD),
- Centre for Management Development (CMD), ...
Related Courses
