# Advanced Excel > Join Edoxi’s 20-hour Advanced Excel Training in Riyadh. Master data analysis, reporting, automation, pivot tables, functions, & macros. Enrol to get certified. ## Course Details - Rating: 5/5 - Location: Riyadh - Category: Business operations - Sub-Category: Microsoft Applications ## Course Introduction 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 Overview - Delivery Modes: Online, Classroom - Course Duration: 20 Hours - Corporate Days: 4 Days - Learners Enrolled: 100+ - Modules: 8 ## 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 This Course ## 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. Read More ## 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 ## Hands-On Lab Activities **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 - 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 ## How To Get an Advanced Excel Course Certification? Here’s a four-step guide to becoming a certified Advanced Excel professional. 1. Join Edoxi’s 20-hour Advanced Excel Course in Riyadh. 2. Learn from expert trainers through interactive sessions. 3. Complete all course modules and practical project activities. 4. Earn Edoxi’s Advanced Excel Course Completion Certificate. ## 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. ## Frequently Asked Questions **Q: What are the prerequisites for joining this Advanced Excel Course?** A:  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. **Q: How is Edoxi’s Advanced Excel Course different from a basic Excel course?** A: 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. **Q: Can I create automated reports after completing this course?** A:  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. **Q: Will I learn to build dashboards and visualisations?** A: 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. **Q: How will Advanced Excel skills help my career in Riyadh?** A:  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. **Q: What is the approximate salary of Advanced Excel professionals in Riyadh?** A: 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. **Q: Does this course cover the latest features in Excel 365?** A:  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. **Q: Do you offer customised corporate training for teams?** A: Yes. Edoxi provides tailored Advanced Excel training for corporate teams, focusing on industry-specific applications and practical examples relevant to your business operations. **Q: Which related courses complement this Advanced Excel Course?** A:  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.  **Q: How long does the Advanced Excel Course in Riyadh take to complete?** A:  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. **Q: What kind of certification will I receive after this course?** A:  You will earn Edoxi’s Advanced Excel Course Completion Certificate, which is recognised by industry professionals and can boost your career credibility in Riyadh. **Q: Will I get hands-on practice during the course?** A:  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. **Q: Is this Advanced Excel training suitable for professionals from non-finance backgrounds?** A:  Absolutely. While finance professionals greatly benefit, the course is relevant for anyone working with data, reporting, operations, or business analysis across any industry. **Q: Can I access course materials after completion?** A:  Yes. You can have access to Edoxi’s comprehensive training materials, including Excel templates, step-by-step guides, and recorded sessions for future reference. ## Trainer - Name: 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. ## Enrol in This Course - Course URL: https://www.edoxi.com/riyadh/advanced-excel-course - Phone: +971 43801666 - Email: info@edoxi.com