Course Content:
Unit 1: Review of Excel Skills:
- Constructing formulae
- Using functions
- Absolute and relative cell referencing
- Naming ranges
Unit 2: Automating Worksheets:
- Creating and editing templates
- Using data validation
- Applying workbook & cell protection
Unit 3: Further Functions:
- Nested IF functions
- Using AND OR operators
- Lookup and Reference functions
- Text functions
- Math and Trig functions
- Financial functions
Unit 4: Summarising Worksheets:
- Group and outline a worksheet
- Hiding and displaying outlines
Unit 5: Pivot Tables:
- Creating and modifying Pivot Tables
- Refreshing the data
- Grouping data within a Pivot Table
Unit 6: Data Management:
- Using worksheet auditing tools
- Tracing dependent and precedent cells
- Checking for errors & highlighting invalid data
Unit 7: Macros:
- Recording simple Macros
- Running and editing Macros
- Assigning Macros to the keyboard, toolbar buttons and menus
Unit 8: Analysis Tools:
- Using the Goalseek tool
- Creating ‘What If’ scenarios
- Creating Data Tables
Dubai (UAE)
21 - 25 Apr 2024
4500 Euro
Sharm El-Sheikh (Egypt)
12 - 16 May 2024
4500 Euro
Brussels (Belgium)
13 - 17 May 2024
5200 Euro
Online
19 - 23 May 2024
2500 Euro
Kuala Lumpur (Malaysia)
26 - 30 May 2024
4500 Euro
Dubai (UAE)
02 - 06 Jun 2024
4500 Euro
Amsterdam (Netherlands)
10 - 14 Jun 2024
5500 Euro
Online
16 - 20 Jun 2024
2500 Euro
Rome (Italy)
17 - 21 Jun 2024
5500 Euro
Kuala Lumpur (Malaysia)
30 Jun - 04 Jul 2024
4500 Euro
Barcelona (Spain)
01 - 05 Jul 2024
5500 Euro
Vienna (Austria)
22 - 26 Jul 2024
4900 Euro
London (UK)
29 Jul - 02 Aug 2024
5800 Euro
Barcelona (Spain)
29 Jul - 02 Aug 2024
5500 Euro
Amman (Jordan)
11 - 15 Aug 2024
3200 Euro
Istanbul (Turkey)
18 - 22 Aug 2024
5000 Euro
Manama (Bahrain)
25 - 29 Aug 2024
5500 Euro
London (UK)
26 - 30 Aug 2024
5800 Euro
Kuala Lumpur (Malaysia)
01 - 05 Sep 2024
4500 Euro
Manama (Bahrain)
01 - 05 Sep 2024
5500 Euro