Advanced Microsoft Excel
overview
This course provides users with the knowledge to use the more complex features of Excel. It is designed to give an insight into some of the more advanced features in Excel and will be of particular interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.
course details
COURSE DURATION | LANGUAGE | CERTIFICATE |
12 Hours – 2 Hours per Day | English | DISS Certificate |
*Please notify us if an interpretation is required |
course benefits/progression opportunities
Course objectives
By the end of the program, participants will be able to:
- Develop skills for advanced use of excel
- Identify the different use of excel functions and shortcuts
- Learn how to perform complex functions
- Develop skills in analysis using excel
- Learn how to present data using charts and tables
- Master the use of excel macros and pivot tables.
course outline
Day 1 | |||
Module 1: Advanced Excel Shortcuts | Module 2: Data Presentation with charts | Module 3: Sorting And Filtering data | Module 4: Manipulating Dates |
|
|
|
|
Module 5: Advanced Excel Formulas | Module 6: Text Formulas | Module 7: Data Validations and Protection |
|
|
|
Day 2 | ||||
Module 8: What-if Analysis | Module 9: Data Tables | Module 10: Working with Outlines | Module 11: Analysing Data with Pivot Tables | Module 12: Excel Macros |
|
|
|
|
|
COURSE TYPE: CLASSROOM
DATE | DAY | QATAR TIME |
3-4 Feb 21 | Wed-Thu | 09:00-15:00 |
3-4 Mar 21 | Wed-Thu | 09:00-15:00 |
5-6 Apr 21 | Mon-Tue | 09:00-15:00 |
3-4 May 21 | Mon-Tue | 09:00-15:00 |
2-3 Jun 21 | Wed-Thu | 09:00-15:00 |
5-6 Jul 21 | Mon-Tue | 09:00-15:00 |
2-3 Aug 21 | Mon-Tue | 09:00-15:00 |
1-2 Sep 21 | Wed-Thu | 09:00-15:00 |
4-5 Oct 21 | Mon-Tue | 09:00-15:00 |
1-2 Nov 21 | Mon-Tue | 09:00-15:00 |
1-2 Dec 21 | Wed-Thu | 09:00-15:00 |
TESTIMONIAL
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Meet THE INSTRUCTORS
Instructor Name
Profession
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Instructor Name
Profession
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Related Courses
Introduction to Artificial Intelligence with Python Programming
7-11 Feb 21
09:00-15:00 (Qatar)
CCNA : Implementing and Administering Cisco Solutions v1.0 (200-301)
Upcoming Course Date