Course Content
01 – Introduction to Excel – Module A – Excel Basics (for Beginners)
01 - Introduction to Excel - Module A - Excel Basics (for Beginners)
0/1
02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)
02 - Relative & Absolute Cell References - Module A - Excel Basics (for Beginners)
0/1
03 – Formatting Paste Special – Module B – Excel Essentials
03 - Formatting Paste Special - Module B - Excel Essentials
0/1
04 – Excel Tables – Module B – Excel Essentials
04 - Excel Tables - Module B - Excel Essentials
0/1
05 – Data Filters and Sorting – Module B – Excel Essentials
05 - Data Filters and Sorting - Module B - Excel Essentials
0/1
06 – Data Validation Tips & Tricks – Module B – Excel Essentials
06 - Data Validation Tips & Tricks - Module B - Excel Essentials
0/1
07 – Named Ranges – Module B – Excel Essentials
07 - Named Ranges - Module B - Excel Essentials
0/1
08 – Worksheet and Workbook Protection – Module B – Excel Essentials
08 - Worksheet and Workbook Protection - Module B - Excel Essentials
0/1
09 – Printing and Page Layout Tab – Module B – Excel Essentials
09 - Printing and Page Layout Tab - Module B - Excel Essentials
0/1
10 – Handle Formula Errors – Module B – Excel Essentials
10 - Handle Formula Errors - Module B - Excel Essentials
0/1
11 – Using IF Formula, Nesting IF Formulas – Module C – Excel Formulas and Functions
11 - Using IF Formula, Nesting IF Formulas - Module C - Excel Formulas and Functions
0/1
12 – Using IF with AND OR Formulas – Module C – Excel Formulas and Functions
12 - Using IF with AND OR Formulas - Module C - Excel Formulas and Functions
0/1
13 – COUNTIFS, SUMIFS, AVERAGEIFS Formulas – Module C – Excel Formulas and Functions
13 - COUNTIFS, SUMIFS, AVERAGEIFS Formulas - Module C - Excel Formulas and Functions
0/1
14 – Excel TEXT Functions – Module C – Excel Formulas and Functions
14 - Excel TEXT Functions - Module C - Excel Formulas and Functions
0/1
15.1 – VLOOKUP Function, INDEX, MATCH Function – Module C – Excel Formulas and Functions
15.1 - VLOOKUP Function, INDEX, MATCH Function - Module C - Excel Formulas and Functions
0/1
15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel
15.2 - Match Type +1 OR 1 in Match Function in Microsoft Excel
0/1
15.3 – Module C – 15 – INDEX and MATCH Function
15.3 - Module C - 15 - INDEX and MATCH Function
0/1
16 – XLOOKUP, XMATCH Function – Module C – Excel Formulas and Functions
16 - XLOOKUP, XMATCH Function - Module C - Excel Formulas and Functions
0/1
17 – Indirect Function – Module C – Excel Formulas and Functions
17 - Indirect Function - Module C - Excel Formulas and Functions
0/1
18 – Offset Function – Module C – Excel Formulas and Functions
18 - Offset Function - Module C - Excel Formulas and Functions
0/1
19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions
19 - Formula Editing Tips & Tricks - Module C - Excel Formulas and Functions
0/1
20 – Date and Time Functions – Module C – Excel Formulas and Functions
20 - Date and Time Functions - Module C - Excel Formulas and Functions
0/1
21 – Maths Functions – Module C – Excel Formulas and Functions
21 - Maths Functions - Module C - Excel Formulas and Functions
0/1
22 – Dynamic Array Formulas – Module C – Excel Formulas and Functions
22 - Dynamic Array Formulas - Module C - Excel Formulas and Functions
0/1
23 – Conditional Formatting – Module D – Data Analysis
23 - Conditional Formatting - Module D - Data Analysis
0/1
24.1 – WHAT IF Analysis – Module D – Data Analysis
24.1 - WHAT IF Analysis - Module D - Data Analysis
0/1
24.2 – Module D – 24 – WHAT IF Analysis – Data Table
24.2 - Module D - 24 - WHAT IF Analysis - Data Table
0/1
24.3 – Module D – 24 – WHAT IF Analysis – Scenario Manager
24.3 - Module D - 24 - WHAT IF Analysis - Scenario Manager
0/1
25 – Linear Regression – Module D – Data Analysis
25 - Linear Regression - Module D - Data Analysis
0/1
26 – Data Analysis Feature – Module D – Data Analysis
26 - Data Analysis Feature - Module D - Data Analysis
0/1
27 – Data Storytelling Tips – Module D – Data Analysis
27 - Data Storytelling Tips - Module D - Data Analysis
0/1
28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations
28 Introduction to Charts 29 - Dynamic Advanced Charts - Module E - Excel Charts and Visualizations
0/1
30 – Pivot Table with Dashboard – Module F – Pivot Table
30 - Pivot Table with Dashboard - Module F - Pivot Table
0/1
31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table
31 - Advanced Pivot Table Tips & Tricks - Module F - Pivot Table
0/1
33 – Introduction to Power Pivot – Module G – Modern Excel – DAX and Power Query
33 - Introduction to Power Pivot - Module G - Modern Excel - DAX and Power Query
0/1
34 – Apply DAX in Power Pivot for Analysis – Module G – Modern Excel – DAX and Power Query
34 - Apply DAX in Power Pivot for Analysis - Module G - Modern Excel - DAX and Power Query
0/1
35 – Dashboard Reporting in Excel with Tips – Module H – Bonus 1 – Dashboard Reporting in Excel
35 - Dashboard Reporting in Excel with Tips - Module H - Bonus 1 - Dashboard Reporting in Excel
0/1
36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I
36 - Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) - MODULE I
0/1
37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I
37 - Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I
0/1
38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY
38 - How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY
0/1
39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I
39 - NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I
0/1
40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel
40 - SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel
0/1
41 – Wildcard Search in Excel – Module I
41 - Wildcard Search in Excel - Module I
0/1
$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI
$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI
0/1
Microsoft Excel Course for Data & Business Analytics (Basic to Advanced)
About Lesson

01 – Introduction to Excel – Module A – Excel Basics (for Beginners)

Note: IF you find videos a little bit blur or to improve the view then “To watch the videos in High Definition (HD)”, Follow these steps:
1. Go to YOUTUBE website, Play any video
2. Click on the setting button (Right bottom of Video) and select 720p
3. Go back to LMS course and play video then it will adjust to that 720p view and it will be clear!
Exercise Files
.
Size: 0.00 B
Join the conversation
Eniola 123 1 year ago
I can't proceed to the next module, it keep telling me the source is full. What can I do.
Reply
Saira Musarrat 2 years ago
Assalam o Aliqum sir Rahim .Sir i enrolled in your Excel course which is free,Sir the question is i have watched it and also learned from it it`s no doubt very informative but what i have to do next ?yes there is a button most right side it does not work as clicked or we can say marked as done.let me know should i have to do some kind of assignment for gaining certificate or it`s enough to learn from videos.waiting.
Reply
Khurram Iqbal 1 year ago
done
Rahim Zulfiqar Ali 2 years ago
Microsoft Excel Course Files - GOOGLE DRIVE. Link To Download: https://drive.google.com/drive/folders/1mVObPImtMKNf4IKGwUmaeGYPYY6wUodh?usp=sharing
Reply
Kamran Ahmed 2 years ago
Thank you Sir Very Informative 1st class
Reply
Rahim Zulfiqar Ali 2 years ago
Welcome
Ademola Adetunji 2 years ago
Hello Rahim, please I would love to know how you automatically populated the series RAMDBETWEEN. Coz I tried it and I had to use my fill tool instead of automatic population.
Reply
Muhammad Aamir 2 years ago
Hi, You ask a Question how to use randbetween formula for random numbers =randbetween(select the cells range) hold the control key and press enter
Muddassar Awan 2 years ago
i cleared first but its not moving forward to next
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks aamir for your input :)
Muhammad Aamir 2 years ago
Why It's May been network loading but It's working very well. If you have some problem so contact with there social media or on this platform
Shamla Shibly 2 years ago
Assalamu alaikkum! Thank you so much for the lesson. Its really useful and really understood. Here itself I got cleared some sort of doubts I had.
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
Richmond Kwadwo Sarpong 2 years ago
WELL EXPLAINED
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
Kazim Ali 2 years ago
Dear Rehim, excellent overview summary ?
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
ISAAC APOMAH 2 years ago
great intro
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
Saad Bajwa 2 years ago
Hi how can we help you?
Reply
Rahim Zulfiqar Ali 2 years ago
Mark as Complete button is available on TOP right side of every video header. Click on that button.
Saad Bajwa 2 years ago
I can't go to next video why that so?
Samana Agha 2 years ago
I can't go to next video why that so? I watch first video 2 times still its not marking complete and I can't watch the next video.
Reply
Deniz Yelken 2 years ago
this does not work , ı can not click ,there is nothing that happen after click,is there another way to proceed videos after the first one
Rahim Zulfiqar Ali 2 years ago
Mark as Complete button is available on TOP right side of every video header. Click on that button.
Rida Batool 2 years ago
Detailed video about the functions of EXCEL which we never learned before. Hope to learn till advanced features.
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
Muddassar Awan 2 years ago
it looks detailed and informative right from the first video but its not proceeding me further .....any time slot specific for or after each video??
Reply
Rahim Zulfiqar Ali 2 years ago
Mark as Complete button is available on TOP right side of every video header. Click on that button.
Eric Adjei Nyankson 2 years ago
im done with the video for over 2 times but always redirecting me back to complete
Reply
Rahim Zulfiqar Ali 2 years ago
Mark as Complete button is available on TOP right side of every video header. Click on that button.
Longhy Heang 2 years ago
good vedeo
Reply
Rahim Zulfiqar Ali 2 years ago
Thanks
Nida Kamran 2 years ago
Asalam O Alikum Sir, Your course is really informative. Can you please share this excel setup, so we can download and install it ?
Reply
Rayhan Khan 2 years ago
Cource toh alhamdulillah bht accha hai.. 0r urdu mn hota toh or v accha smj ata ?... Rao sahazeb sir ne suggest kia apka class.. I'm from India ??
Reply
Rahim Zulfiqar Ali 2 years ago
I teach in English language to reach more audience and not very hard words used in this english version course.
Rahim Zulfiqar Ali 2 years ago
Note: IF you find videos a little bit blur or to improve the view then "To watch the videos in High Definition (HD)", Follow these steps: 1. Go to YOUTUBE website, Play any video 2. Click on the setting button (Right bottom of Video) and select 720p 3. Go back to LMS course and play video then it will adjust to that 720p view and it will be clear!
Reply
Rahim Zulfiqar Ali 2 years ago
I am using Excel 2019 and Office 365 in most of the videos
Muhammad Khatri 2 years ago
Can you tell me which version of excel is installed and used by you as i am using 2013 in office,. But i need to learn more and more ,,, kindly reply,,,
0% Complete