Leave your message to get our quick response
edoxi automated message icon

Advanced Excel Course in Riyadh

Data professional analysing performance metrics on desktop screens in office setting
Edoxi’s 20-hour Advanced Excel Course in Riyadh teaches you data analysis, workflow automation, & creation of dynamic reports and dashboards. Our course covers Pivot Tables, Advanced Formulas, Macros (VBA), Data Validation, and Financial Modelling. Gain real-world experience through a comprehensive capstone project. Earn certification and prepare for careers in finance, data analysis, HR, operations, and management. Enrol now.
 
Course Duration
20 Hours
Corporate Days
4 Days
Learners Enrolled
100+
Modules
8
star-rating-icon1
star-rating-icon2
star-rating-icon3
Course Rating
5
star-rating-5
Mode of Delivery
Online
Classroom
Certification by

What Do You Learn from Edoxi's Advanced Excel Training in Riyadh?

Mastery of Advanced Excel Functions
Master complex calculations and data retrieval by utilising logical, financial, and lookup functions like XLOOKUP and INDEX-MATCH.
Data Analysis with Pivot Tables
Learn to transform raw data into meaningful insights using pivot tables, slicers, and calculated fields for dynamic reporting.
Process Automation with Macros
You learn to create and implement VBA macros to automate repetitive tasks, increasing efficiency and reducing human error.
Financial Modelling & Forecasting
Learn to develop professional financial models using What-If Analysis, Goal Seek, and Data Tables for strategic business planning.
Dynamic Dashboard Creation
Gain expertise in designing interactive dashboards with conditional formatting, charts, and slicers to visualise KPIs and business metrics.
Data Management & Validation
Learn how to implement advanced data validation techniques, sorting methods, and filtering to maintain data integrity and accuracy.

About Our Advanced Excel Course in Riyadh

Edoxi’s 20-hour Advanced Excel course in Riyadh is designed to deliver practical, hands-on learning for professionals. This course helps you enhance your data analysis, reporting, and automation skills in today’s data-driven workplace. The course focuses on advanced Excel functionalities such as pivot tables, dynamic arrays, advanced formulas, and macros (VBA), enabling you to improve productivity and make data-backed business decisions with confidence.

Our Advanced Excel classes follow a practice-oriented approach through interactive workshops, real-world case studies, and guided exercises. You gain hands-on experience in financial modelling, automated reporting, and data analysis using industry-relevant Excel tools. These sessions help you apply theoretical concepts to real workplace scenarios across multiple business functions.

By completing Edoxi’s Advanced Excel course in Riyadh, you build a strong skill set applicable across industries, including finance, retail, healthcare, and government sectors in Saudi Arabia. The course offers personalised attention, practical learning resources, and flexible training options. Corporate training solutions are also available for organisations aiming to upskill their workforce in Advanced Excel. To know more about the details regarding the Advanced Excel course fee, enrollment details, or customised training support, you can contact Edoxi in Riyadh.

Key Features of Edoxi's Advanced Excel Training

Hands-On Practical Workshops

Apply concepts through guided exercises in Microsoft Excel's advanced features and functionality.

Comprehensive PDF Formula Guide

Access to detailed documentation of all formulas and functions covered during the training for future reference.

Pre and Post-Assessment

Evaluate your Excel proficiency before and after the course to measure improvement and knowledge retention.

Industry-specific Customised Project

Practice with an industry-specific project tailored to your professional needs and business requirements.

Who Can Join Our Advanced Excel Course in Riyadh?

Finance & Accounting Professionals

Financial analysts, accountants, and auditors who work with large datasets and need to streamline financial reporting and analysis.

Business & Data Analysts

Professionals responsible for processing data, creating reports, and delivering actionable insights to support decision-making.

Sales & Marketing Teams

Team members who track performance metrics, analyse customer data, and create sales forecasts to drive business growth.

HR & Administrative Personnel

Staff managing employee records, payroll data, and performance analytics who need to improve data management efficiency.

Project Managers

Professionals organising budgets, timelines, and resource allocation who require better data organisation and visualisation tools.

Students & Fresh Graduates

Individuals seeking to enhance their employability by acquiring in-demand Excel skills valued across all industries.

Advanced Excel Course Modules

Module 1: Excel Fundamentals
  • Chapter 1.1: Understanding Excel Basics

    • Lesson 1.1.1: Overview of the Basics of Excel
    • Lesson 1.1.2: Cell Reference (Relative, Absolute, Mixed)
    • Lesson 1.1.3: Circular and 3D Cell Reference
    • Lesson 1.1.4: Custom Number Formatting
Module 2: Functions and Formulas
  • Chapter 2.1: Mastering Excel Functions

    • Lesson 2.1.1: Date and Time Functions
    • Lesson 2.1.2: Text Functions
    • Lesson 2.1.3: Database Functions
    • Lesson 2.1.4: Writing Conditional Expressions (Using IF)
    • Lesson 2.1.5: Using Logical Functions (AND, OR, NOT)
    • Lesson 2.1.6: IF, AND, OR Functions Used Together
    • Lesson 2.1.7: Power Functions (COUNTIF, COUNTIFS, SUMIF, SUMIFS, SUMPRODUCT)
    • Lesson 2.1.8: Financial Functions (PMT, IRR)
Module 3: Lookup and Reference
  • Chapter 3.1: Working with Lookup and Reference Functions

    • Lesson 3.1.1: Using VLOOKUP, HLOOKUP, MATCH, INDEX
    • Lesson 3.1.2: VLOOKUP with Exact Match and Approximate Match
    • Lesson 3.1.3: Nested VLOOKUP with Exact Match
    • Lesson 3.1.4: VLOOKUP with Tables and Dynamic Ranges
    • Lesson 3.1.5: Using VLOOKUP to Consolidate Data from Multiple Sheets
    • Lesson 3.1.6: XLOOKUP Function with Advanced Options
Module 4: Data Validation and Formatting
  • Chapter 4.1: Advanced Data Validation Techniques

    • Lesson 4.1.1: Specifying a Valid Range of Values for a Cell
    • Lesson 4.1.2: Specifying a List of Valid Values for a Cell
    • Lesson 4.1.3: Custom Validations Based on a Formula
    • Lesson 4.1.4: Making a Dynamic List
    • Lesson 4.1.5: Creating Dependent Drop-Down Lists
  • Chapter 4.2: Advanced Conditional Formatting

    • Lesson 4.2.1: Using Auto Formatting for Worksheets
    • Lesson 4.2.2: Conditional Formatting for Rows, Columns, and Cells
    • Lesson 4.2.3: Wildcard Formatting
  • Chapter 4.3: Working with Templates

    • Lesson 4.3.1: Designing Template Structures
    • Lesson 4.3.2: Using Templates for Worksheet Standardisation
  • Chapter 4.4: Working with Tables

    • Lesson 4.4.1: Table Formatting
    • Lesson 4.4.2: Automating Calculations
    • Lesson 4.4.3: Managing Datasets
  • Chapter 4.5: Sorting and Filtering Data

    • Lesson 4.5.1: Sorting Tables
    • Lesson 4.5.2: Multiple-Level Sorting
    • Lesson 4.5.3: Custom Sorting
    • Lesson 4.5.4: Filtering Data with AutoFilter
    • Lesson 4.5.5: Using Advanced Filter Options
Module 5: Enhanced Visualisation Techniques
  • Chapter 5.1: Working with Reports and PivotTables

    • Lesson 5.1.1: Creating Subtotals and Multi-Level Subtotals
    • Lesson 5.1.2: Creating and Formatting PivotTables
    • Lesson 5.1.3: Using Pivot Charts
    • Lesson 5.1.4: Consolidating Data from Multiple Sheets and Files
    • Lesson 5.1.5: Using Data Consolidation Features
    • Lesson 5.1.6: Show Values As (% of Row, Column, Running Total, Compare Fields)
    • Lesson 5.1.7: Viewing Subtotals under Pivot
    • Lesson 5.1.8: Creating Slicers and Timelines
  • Chapter 5.2: Charting and Data Visualisation

    • Lesson 5.2.1: Formatting Charts with 3D Graphics
    • Lesson 5.2.2: Using Bar and Line Charts Together
    • Lesson 5.2.3: Using Secondary Axis in Charts
    • Lesson 5.2.4: Dynamic Chart Sharing with PowerPoint and Word
Module 6: Automation
  • Chapter 6.1: Working with Macros

    • Lesson 6.1.1: Relative and Absolute Macros
    • Lesson 6.1.2: Editing Macros
    • Lesson 6.1.3: Creating Automation Buttons
Module 7: What-If Analysis and Excel Features
  • Chapter 7.1: What-If Analysis Tools

    • Lesson 7.1.1: Goal Seek
    • Lesson 7.1.2: Data Tables
    • Lesson 7.1.3: Scenario Manager
    • Lesson 7.1.4: Analyze Data
  • Chapter 7.2: Useful Excel Features

    • Lesson 7.2.1: Flash Fill, Sparklines, Remove Duplicates
    • Lesson 7.2.2: Text to Column, Freeze Pane, Split
    • Lesson 7.2.3: Protecting Files, Sheets, Workbooks, and Ranges
Module 8: Comprehensive Project and Review
  • Chapter 8.1: Final Project and Review

    • Lesson 8.1.1: Recall and Summary
    • Lesson 8.1.2: Hands-On Excel Project

Download Advanced Excel Course Brochure

Real-World Projects in the Advanced Excel Course in Riyadh

Edoxi’s 20-hour Advanced Excel Training in Riyadh includes a real-world project designed to strengthen practical data management, financial analysis, and reporting skills using Microsoft Excel. Below is the key capstone project covered in the course

Projects

  • Import and Clean Data

    This project focuses on importing and cleaning sales data from multiple sources, such as CSV files and databases. You learn to remove duplicates, standardise data formats, handle missing values, and apply consistent formatting to ensure data accuracy and reliability across datasets.

  • Implement Data Validation

    You learn to implement robust data validation rules, including date validation, dropdown lists for products and regions, and input restrictions. Error alerts are configured to prevent incorrect entries and maintain data integrity during data entry.

  • Calculate Financial Metrics

    As part of the analysis, you build advanced formulas to calculate revenue, profit, discounts, variable costs, and tiered commission structures. These financial metrics help simulate real-world business calculations and performance evaluation.

  • Create Advanced Reports

    The project concludes with the creation of advanced sales reports, including product-wise, salesperson-wise, monthly, and quarterly performance reports. Interactive dashboards are developed using PivotTables, slicers, and data visualisations to enable dynamic performance tracking and decision-making.

Advanced Excel Course Outcomes and Career Opportunities in Riyadh

Edoxi’s 20-hour Advanced Excel Training in Riyadh equips you with practical spreadsheet skills required in today’s data-driven workplaces. By the end of the programme, you

Course Outcome Image
Develop advanced proficiency in Excel functions, lookup formulas, pivot tables, and data validation techniques for accurate data handling and analysis.
Gain hands-on experience in automating workflows using macros (VBA), reducing manual effort and improving operational efficiency.
Build professional dashboards and reports that transform raw data into clear, actionable business insights for management and stakeholders.
Strengthen financial modelling and forecasting capabilities using What-If Analysis, Goal Seek, and Data Tables to support strategic decision-making.
Enhance your employability across various industries, including finance, sales, HR, operations, and administration, where advanced Excel skills are in high demand in Riyadh.
Increase workplace productivity and career growth potential with a recognised course completion certificate and Microsoft Excel Expert credentials.

Career Opportunities After Advanced Excel Certification in Riyadh

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Reporting Specialist
  • Accountant
  • Operations Analyst
  • Sales Analyst
  • HR Analyst
  • Project Coordinator
  • Office Manager

Companies Hiring Advanced Excel Professionals in Riyadh

  • SABIC (Saudi Basic Industries Corporation)
  • Saudi National Bank (SNB)
  • Riyad Bank
  • STC (Saudi Telecom Company)
  • Almarai Company
  • Saudi Electricity Company
  • Ma’aden (Saudi Arabian Mining Company)
  • Elm Company
  • Arasco
  • Alat

Advanced Excel Training Options in Riyadh

Classroom Training

  • 20 hours of classroom training

  • Hands-on practice with the latest Excel features

  • Small group sessions for personalised attention

  • Direct interaction with an Excel specialist trainer

  • Access to a dedicated computer lab environment

Live Online Training

  • 20 hours of live online training

  • Virtual access to expert-led Excel instruction

  • Real-time demonstration of formulas and functions

  • Interactive problem-solving sessions

  • Flexible scheduling options for working professionals

Corporate Training

  • 2-4 days of corporate training

  • Customised intensive programs

  • On-site or virtual delivery options

  • Group-focused practical exercises

  • Industry-specific examples and applications

  • Covers all training logistics, including venue, food and refreshments

  • Tailored content for organisational needs

Do You Want a Customised Training for Advanced Excel?

Get expert assistance in getting you Advanced Excel Course customised!

How To Get an Advanced Excel Course Certification?

Here’s a four-step guide to becoming a certified Advanced Excel professional.

Do You Want to be a Certified Professional in Advanced Excel?

Join Edoxi’s Advanced Excel Course

Why Choose Edoxi For Advanced Excel Training in Riyadh?

Edoxi, recognised as a leading Advanced Excel training institute in Riyadh, offers a 20-hour course designed to equip professionals with advanced Excel skills to enhance productivity and data-driven decision-making. Here’s why professionals choose Edoxi

Specialised MS Office Training Lab

Learn in our purpose-built computer lab in Riyadh, fully equipped with the latest Microsoft Office software and optimised workstations for hands-on Excel practice and productivity applications.

Flexible Learning Options

We offer flexible learning options, including online and classroom formats, making it convenient for both students and working professionals.

Trusted by Leading Organisations

Edoxi has earned the trust of national and multinational companies, as well as government entities in Riyadh, as a preferred partner for Microsoft Office and Excel training.

Complete Career Development Pathway

Build upon your Excel skills with our related programs, including Power BI, Data Analytics, and Financial & Accounting courses, designed to enhance your career growth in Riyadh.

Microsoft Certified Expert Instructors

Learn from industry professionals holding Microsoft certifications, bringing real-world experience and practical insights directly to the classroom.

Personalised Learning Experience

With smaller class sizes and one-to-one training options, each of you can receive individual attention. This ensures maximum skill acquisition and practical application for workplace success in Riyadh.

students-image

Edoxi is Recommended by 95% of our Students

Meet Our Mentor

Our mentors are leaders and experts in their fields. They can challenge and guide you on your road to success!

mentor-image

Asim Nath Dubey

Asim Nath is an Accounting and Microsoft Office trainer at Edoxi Training Institute. He has over 13 years of training experience and has successfully trained more than 3000 professionals in Accounting and Microsoft Office applications. Asim’s specialisations include Financial Accounting, Tally, Zoho and Quickbooks. His background in financial accounting adds valuable insights to business presentation training.

Asim is an expert in MS Office, including PowerPoint, Excel, and Power BI, positioning him as a well-rounded specialist in the Microsoft Suite. Asim employs a practical, business-focused teaching methodology. His one-to-one training approach ensures each student receives personalized attention. He emphasizes real-world applications, helping professionals create impactful business presentations.

Locations Where Edoxi Offers Advanced Excel Course

Here are the major international locations where Edoxi offers Advanced Excel Course

FAQ

What are the prerequisites for joining this Advanced Excel Course?
 You should have basic Excel proficiency, including knowledge of spreadsheets, formatting, and simple formulas. If you are not confident with these skills, Edoxi recommends starting with a Basic to Intermediate Excel course before joining this Advanced Excel training.
How is Edoxi’s Advanced Excel Course different from a basic Excel course?
This Advanced Excel training in Riyadh goes beyond basic formulas and formatting. You master complex functions, pivot tables, macros, automation, advanced reporting, and sophisticated data modelling techniques that give you a competitive edge in data-driven roles.
Can I create automated reports after completing this course?
 Yes! The Advanced Excel classes teach you how to use macros, advanced functions, and data validation techniques to build automated reporting systems that save time and reduce errors in repetitive tasks.
Will I learn to build dashboards and visualisations?
Absolutely. You learn to design dynamic dashboards using pivot tables, charts, conditional formatting, and slicers to visualise data effectively, track KPIs, and support decision-making.
How will Advanced Excel skills help my career in Riyadh?
 Advanced Excel skills are highly sought after across industries in Riyadh, including finance, retail, government, and consulting. Mastering these skills can improve your job prospects, make you eligible for higher-paying roles, and enhance your performance in data analysis and business operations.
What is the approximate salary of Advanced Excel professionals in Riyadh?
Professionals skilled in Advanced Excel can earn between SAR 8,000 and SAR 18,000 per month, depending on experience, industry, and role. Senior analysts or finance professionals with advanced Excel expertise can earn even more.
Does this course cover the latest features in Excel 365?
 Yes. Edoxi’s Advanced Excel training in Riyadh is regularly updated to include the latest Excel 365 features such as dynamic arrays, XLOOKUP, LET functions, and enhanced pivot table functionality.
Do you offer customised corporate training for teams?
Yes. Edoxi provides tailored Advanced Excel training for corporate teams, focusing on industry-specific applications and practical examples relevant to your business operations.
Which related courses complement this Advanced Excel Course?
 You can enhance your data skills with related courses, such as:
 
  • Basic to Intermediate Excel – solidify your foundational skills
  • Power BI – learn business intelligence reporting
  • Power Query and Power Pivot – advanced data modelling techniques
  • MS Office – improve productivity with Word, PowerPoint, and Outlook
  • Data Analytics – strengthen analytical decision-making.
  • Financial Modelling with Excel – build robust financial models. 
How long does the Advanced Excel Course in Riyadh take to complete?
 Edoxi’s Advanced Excel classes are designed to be completed in 20 hours, depending on whether you opt for weekend or weekday batches. You can choose classroom or online delivery modes for flexibility.
What kind of certification will I receive after this course?
 You will earn Edoxi’s Advanced Excel Course Completion Certificate, which is recognised by industry professionals and can boost your career credibility in Riyadh.
Will I get hands-on practice during the course?
 Yes. Edoxi emphasises practical learning through real-world projects, exercises, and case studies. You can apply advanced formulas, macros, pivot tables, and dashboards on live datasets.
Is this Advanced Excel training suitable for professionals from non-finance backgrounds?
 Absolutely. While finance professionals greatly benefit, the course is relevant for anyone working with data, reporting, operations, or business analysis across any industry.
Can I access course materials after completion?
 Yes. You can have access to Edoxi’s comprehensive training materials, including Excel templates, step-by-step guides, and recorded sessions for future reference.