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
Online
10 - 14 Dec 2023
2500 €
Turkey (Istanbul)
24 - 28 Dec 2023
5000 €
Egypt (Sharm El-Sheikh)
14 - 18 Jan 2024
4500 €
Jordan (Amman)
04 - 08 Feb 2024
3200 €
France (Paris)
26 Feb - 01 Mar 2024
5500 €
UK (London)
18 - 22 Mar 2024
5800 €
UK (London)
25 - 29 Mar 2024
5800 €
Egypt (Cairo)
31 Mar - 04 Apr 2024
3500 €
Spain (Barcelona)
08 - 12 Apr 2024
5500 €
Egypt (Cairo)
14 - 18 Apr 2024
3500 €
Italy (Rome)
15 - 19 Apr 2024
5500 €
UAE (Dubai)
21 - 25 Apr 2024
4500 €
Egypt (Sharm El-Sheikh)
12 - 16 May 2024
4500 €
Online
19 - 23 May 2024
2500 €
Malaysia (Kuala Lumpur)
26 - 30 May 2024
4500 €
UAE (Dubai)
02 - 06 Jun 2024
4500 €
Netherlands (Amsterdam)
10 - 14 Jun 2024
5500 €
Online
16 - 20 Jun 2024
2500 €
Italy (Rome)
17 - 21 Jun 2024
5500 €
Malaysia (Kuala Lumpur)
30 Jun - 04 Jul 2024
4500 €