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
UK (London)
27 - 31 Mar 2023
5200 €
Egypt (Cairo)
02 - 06 Apr 2023
3000 €
Egypt (Cairo)
16 - 20 Apr 2023
3000 €
Italy (Rome)
17 - 21 Apr 2023
5200 €
UAE (Dubai)
23 - 27 Apr 2023
4500 €
Germany (Munich)
08 - 12 May 2023
5200 €
Egypt (Sharm El-Sheikh)
14 - 18 May 2023
3500 €
Online
21 - 25 May 2023
2500 €
Malaysia (Kuala Lumpur)
28 May - 01 Jun 2023
4500 €
UAE (Dubai)
04 - 08 Jun 2023
4500 €
Netherlands (Amsterdam)
12 - 16 Jun 2023
5200 €
Online
18 - 22 Jun 2023
2500 €
Italy (Rome)
19 - 23 Jun 2023
5200 €
Malaysia (Kuala Lumpur)
02 - 06 Jul 2023
4500 €
Spain (Barcelona)
03 - 07 Jul 2023
5200 €
Germany (Munich)
31 Jul - 04 Aug 2023
5200 €
Spain (Barcelona)
31 Jul - 04 Aug 2023
5200 €
UK (London)
31 Jul - 04 Aug 2023
5200 €
Jordan (Amman)
13 - 17 Aug 2023
3200 €
Turkey (Istanbul)
20 - 24 Aug 2023
4000 €
