Many of our clients send their staff on our Excel Modeling Training Course to ensure when they attend their business specific Excel modeling course, they do not waste time understanding common Excel tools. The Excel Model building training course will cover aspects required to build any type of model, from Financial to Engineering Models.
Although we do not cover VBA or Visual Basic on the modeling course, we do offer an Excel VBA Course if required. We will cover recording and running Macros however. Please contact us for any further information.
Excel Model Building Training Course Information
| |
Our Excel Modeling training course is a 1 day course. The course will start at 09:30 and run until 16:30 to 17:00 |
| |
We can run your Excel Modeling training course in London either at our Excel Training center in the City or on-site at you office. We can even provide the training equipment if you do not have a dedicated IT training room |
| |
We run the Excel Modeling training course when you need it, not to a predefined schedule. That means your team can decide a date that is suitable for all. |
| |
We have a unique pricing structure for our Excel Model Building training course. We charge per day, not per delegate which means last minute changes to your Excel Modeling Preparation course is not affected.
. The Excel Modeling course will be tailored to your exact needs and you will not be held up (or holding up) other users on your Excel Modeling Course.
If you have 8 delegates on the course, this equates to less than £100 per person. You will not find a more cost effective rate anywhere else. As mentioned on our home page, clients like Google, HSBC and many more make use of us, as we are the best Excel training course provider with a cost that won't rob your training budget |
Excel Modeling Training Course Content
- How to create and edit Range Names for Formula compiling
- Applying range names in Formulae
|
- IF, AND, OR
- VLOOKUP, HLOOKUP, MATCH, INDEX other functions on request
|
- Understanding Nesting
- Nesting using the Functions Dialogue
- Nesting using spreasheet formula building
|
- Tracing Dependent, Precendents
- Tracing Arrows
|
- Protecting only cells that contain Functions or Formulas
- Data Validation
|
- Sorting
- Pivot Tables
- Using Excel Lists
- Using Text to Columns
|
- Using Data Tables
- Goal Seek
- Solver
- Scenarios
|
- Adding Form controls - Combobox, Check, Option Buttons, Lists,
- Protecting Sheets and Workbooks
|
- Sharing workbooks
- Tracking Changes
- Accept / Reject Changes
|
- Recording Absolute / Relative Macros
- Running macros from worksheet buttons
- Attaching macros to form controls
- Basic Macro Editing
- Sample VBA Function
|
| |
| |
Please note the above Excel Modeling training course content can be customized to suit your exact needs depending on your existing knowledge of Excel. Feel free to contact us to help you build the perfect Excel Modeling Training Course. We believe that we are the best Excel Modeling Training Provider in London and can provide training on any function if requested
* All prices are excluding VAT and subject to a 5 day cancellation period for our Excel Modeling Training Course. Also have a look at our Excel Training Courses from MTC
|
