Excel Expert Test Preparation Course – Microsoft Excel Expert (Office 2016)
1500ر.س
Product description
Excel Expert Preparation Course – Microsoft Excel Expert (Office 2016) Certification Number: 45036
Course Overview
This course is designed for those with advanced experience in Excel, and aims to:
Master advanced formulas.
Create and manage professional spreadsheets efficiently.
Prepare for the Microsoft Professional Certification Exam Excel Expert (Office 2019).
Note: The course is advanced and not suitable for beginners.
Course Data
Start date: June 21
Program duration: 10 days (excluding weekends)
Number of hours: 30 hours
Course time: 6:00 PM – 9:00 PM
Material: Simplified English
Explanation language: Arabic
Course Topics
1. Workbook Management
Manage workbook options and settings
Manage workbooks
Copy macros between workbooks
Reference data in other workbooks
Enable macros in a workbook
Manage workbook versions
Prepare workbooks for collaboration
Restrict editing
Protect worksheets and cell ranges
Protect workbook structure
Configure formula calculation options
Manage comments
Use and configure language options
2. Data Management & Formatting
Fill cells using Flash Fill and advanced Fill Series
Format and validate data, including custom number formats
Configure data validation
Group and ungroup data
Calculate subtotals and totals
Remove duplicate records
3. Advanced Conditional Formatting & Filtering
Create custom Conditional Formatting rules
Use formulas within rules
Manage conditional formatting rules
4. Advanced Formulas & Macros
Perform logical operations using IF, IFS, SWITCH
Use functions SUMIF, COUNTIF, AVERAGEIF, and others
Lookup data using VLOOKUP, HLOOKUP, INDEX, MATCH
Advanced date and time functions (NOW, TODAY, WEEKDAY, WORKDAY)
Record and edit simple macros
5. Data Analysis
Summarize data using Consolidate
Perform what-if analysis (Goal Seek & Scenario Manager)
Forecast data using AND, IF, NPER
Financial calculations using PMT
Troubleshoot formulas, monitor cells, validate and evaluate formulas
6. Advanced Charts & PivotTables
Create and modify advanced charts: Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, Waterfall
Create PivotTables, add calculated fields, create Slicers
Create and format Pivot Charts
Control chart options and detailed data analysis
Official Exam Link
Microsoft Excel Expert (Office 2019) Certification
Registration for the exam and fees are included in the course price.
Trainer
Fatima Jafari
Certified trainer from the General Organization for Technical and Vocational Training in Computer and Information Technology
Holder of the title of Ideal Trainer (2017) and a Certificate of Excellence in Information Technology (2013 – King Abdulaziz University)
Over 8 years of training experience in Microsoft Office programs (from beginner to expert) at Noor Aamal Higher Institute for Training – Jeddah, Saudi Arabia
Student Feedback
“Thank you Noor Academy and a big thank you to Ms. Fatima, may God bless you and grant you success.”
“The course is wonderful and I benefited a lot.”
“Trainer Fatima is very distinguished in explanation and conveying information.”
“A cooperative trainer, her explanation is from the heart.”
Note: Please carefully read the registration and replacement policy via the link attached at the bottom of the page before completing the payment process. The institute is not responsible if these policies are not reviewed. Completing the registration process is considered explicit agreement to all terms and conditions contained therein.
All our courses are accredited by the General Organization for Technical and Vocational Training, and are issued electronically from the Mnar platform after completing all course hours.
Mnar Platform Link: https://mnar.sa/auth/trainee/login
Questions you might have

