© 2024 Escribir College of Advanced Studies | All rights reserved

Rahim Zulfiqar Ali Microsoft Excel Course - Basic to Advanced - June 24 Prepare anywhere, anytime, and at your own pace. Skill Based Courses

Top Seller

What you'll be learning in this course

USD 40

(Price is inclusive of taxes)

Course Start Date : 10 Dec 2022
Course End Date : 06 Jun 2024

This course includes

Click here to add promo coupon ?

Course Detail

37 chapters

55 lectures

1 - Introduction to Excel - Module A - Excel Basics (for Beginners)

2 - Relative _ Absolute Cell References - Module A - Excel Basics (for Beginners)

3 - Formatting Paste Special - Module B - Excel Essentials

4 - Excel Tables - Module B - Excel Essentials

5 - Data Filters and Sorting - Module B - Excel Essentials

6 - Data Validation Tips _ Tricks - Module B - Excel Essentials

7 - Named Ranges - Module B - Excel Essentials

8 - Worksheet and Workbook Protection - Module B - Excel Essentials

9 - Printing and Page Layout Tab - Module B - Excel Essentials

10 - Handle Formula Errors - Module B - Excel Essentials

11 - Using IF Formula, Nesting IF Formulas - Module C - Excel Formulas and Functions

12 - Using IF with AND OR Formulas - Module C - Excel Formulas and Functions

13 - COUNTIFS, SUMIFS, AVERAGEIFS Formulas - Module C - Excel Formulas and Functions

14 - Excel TEXT Functions - Module C - Excel Formulas and Functions

15 - VLOOKUP Function, INDEX, MATCH Function - Module C - Excel Formulas and Functions

16 - XLOOKUP, XMATCH Function - Module C - Excel Formulas and Functions

17 - Indirect Function - Module C - Excel Formulas and Functions

18 - Offset Function - Module C - Excel Formulas and Functions

19 - Formula Editing Tips _ Tricks - Module C - Excel Formulas and Functions

20 - Date and Time Functions - Module C - Excel Formulas and Functions

21 - Maths Functions - Module C - Excel Formulas and Functions

22 - Dynamic Array Formulas - Module C - Excel Formulas and Functions

23 - Conditional Formatting - Module D - Data Analysis

24 - WHAT IF Analysis - Module D - Data Analysis

25 - Linear Regression - Module D - Data Analysis

26 - Data Analysis Feature - Module D - Data Analysis

27 - Data Storytelling Tips - Module D - Data Analysis

29 - Dynamic Advanced Charts - Module E - Excel Charts and Visualizations

30 - Pivot Table with Dashboard - Module F - Pivot Table

31 - Advanced Pivot Table Tips _ Tricks - Module F - Pivot Table

32 - Top 10 Power Query Tips - Module G - Modern Excel - DAX and Power Query

33 - Introduction to Power Pivot - Module G - Modern Excel - DAX and Power Query

34 - Apply DAX in Power Pivot for Analysis - Module G - Modern Excel - DAX and Power Query

35 - Module H - Bonus 1 - Dashboard Reporting in Excel with Tips

36 - Module I - Bonus 2 - Advanced Excel - More Scenario Examples

38 - Module K - 24 Excel Tips in 24 Minutes

39 - Module L - 15 Excel Functions Refresher

  • Instructor

Rahim Zulfiqar Ali


Rahim Zulfiqar Ali is a Microsoft Certified Trainer (MCT), Microsoft Office Specialist Expert in Excel 2013, 2016 & 2019 (MSOM), and Member of the International Association of Microsoft Certified Trainers (IAMCT).

Rahim has been actively involved in training & teaching professionals with many organizations and institutions as visiting faculty member and trained thousands of professionals. He gained the repute of an international level trainer in EXCEL and POWER BI with his knowledge of enabling maximum learning & retention in the least possible time.

Positively, training is more of his passion than his profession as he empowers others to create value for their enterprises. Rahim is driven by a mission in life that aims to provide his participants with a better understanding, enabling them to focus better and achieve the results they seek.

Escribir Academy FZE LLC, Business Centre, Sharjah Publishing City Free Zone, Sharjah, United Arab Emirates | Contact No.: +971 56 1769211 /+92 345 8287222