01 - Introduction to Excel - Module A - Excel Basics (for Beginners) - LWS Academy

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

0/1

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

02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)

0/1

02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)

03 – Formatting Paste Special – Module B – Excel Essentials

0/1

03 – Formatting Paste Special – Module B – Excel Essentials

04 – Excel Tables – Module B – Excel Essentials

0/1

04 – Excel Tables – Module B – Excel Essentials

05 – Data Filters and Sorting – Module B – Excel Essentials

0/1

05 – Data Filters and Sorting – Module B – Excel Essentials

06 – Data Validation Tips & Tricks – Module B – Excel Essentials

0/1

06 – Data Validation Tips & Tricks – Module B – Excel Essentials

07 – Named Ranges – Module B – Excel Essentials

0/1

07 – Named Ranges – Module B – Excel Essentials

08 – Worksheet and Workbook Protection – Module B – Excel Essentials

0/1

08 – Worksheet and Workbook Protection – Module B – Excel Essentials

09 – Printing and Page Layout Tab – Module B – Excel Essentials

0/1

09 – Printing and Page Layout Tab – Module B – Excel Essentials

10 – Handle Formula Errors – Module B – Excel Essentials

0/1

10 – Handle Formula Errors – Module B – Excel Essentials

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

0/1

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

0/1

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

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

0/1

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

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

0/1

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

15.1 – VLOOKUP Function, INDEX, MATCH Function – Module C – Excel Formulas and Functions

0/1

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

15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel

0/1

15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel

15.3 – Module C – 15 – INDEX and MATCH Function

0/1

15.3 – Module C – 15 – INDEX and MATCH Function

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

0/1

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

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

0/1

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

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

0/1

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

19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions

0/1

19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions

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

0/1

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

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

0/1

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

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

0/1

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

23 – Conditional Formatting – Module D – Data Analysis

0/1

23 – Conditional Formatting – Module D – Data Analysis

24.1 – WHAT IF Analysis – Module D – Data Analysis

0/1

24.1 – WHAT IF Analysis – Module D – Data Analysis

24.2 – Module D – 24 – WHAT IF Analysis – Data Table

0/1

24.2 – Module D – 24 – WHAT IF Analysis – Data Table

24.3 – Module D – 24 – WHAT IF Analysis – Scenario Manager

0/1

24.3 – Module D – 24 – WHAT IF Analysis – Scenario Manager

25 – Linear Regression – Module D – Data Analysis

0/1

25 – Linear Regression – Module D – Data Analysis

26 – Data Analysis Feature – Module D – Data Analysis

0/1

26 – Data Analysis Feature – Module D – Data Analysis

27 – Data Storytelling Tips – Module D – Data Analysis

0/1

27 – Data Storytelling Tips – Module D – Data Analysis

28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations

0/1

28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations

30 – Pivot Table with Dashboard – Module F – Pivot Table

0/1

30 – Pivot Table with Dashboard – Module F – Pivot Table

31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table

0/1

31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table

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

0/9

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

32.1 – How to Split Names and Emails from a List in Microsoft Excel | FORMULA | FLASH FILL | POWER QUERY

32.2 – Extract Dates from Sentences Located anywhere in a Cell in Excel | Excel Formula OR Power Query?

32.3 – How to convert Stack Data into Unstack different approaches | Unstack Uneven Data Excel Power Query

32.4 – Transform Data into Tabular Format – FORMULA or POWER QUERY? You Decide – HR Example

32.5 – An Introduction on 6 types of Joins in Power Query

32.6 – Left Outer Join & Right Outer Join in POWER QUERY

32.7 – Full Outer Join & Inner Join in POWER QUERY

32.8 – Left Anti Join & Right Anti Join in POWER QUERY

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

0/1

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

0/1

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

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

0/1

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

36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I

0/1

36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I

37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I

0/1

37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I

38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY

0/1

38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY

39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I

0/1

39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I

40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel

0/1

40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel

41 – Wildcard Search in Excel – Module I

0/1

41 – Wildcard Search in Excel – Module I

$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI

0/1

$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI

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 2 years ago

I can't proceed to the next module, it keep telling me the source is full. What can I do.

Reply

Saira Musarrat 3 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 2 years ago

done

Rahim Zulfiqar Ali 3 years ago

Microsoft Excel Course Files - GOOGLE DRIVE. Link To Download: https://drive.google.com/drive/folders/1mVObPImtMKNf4IKGwUmaeGYPYY6wUodh?usp=sharing

Reply

Kamran Ahmed 3 years ago

Thank you Sir Very Informative 1st class

Reply

Rahim Zulfiqar Ali 3 years ago

Welcome

Ademola Adetunji 3 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 3 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 3 years ago

i cleared first but its not moving forward to next

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks aamir for your input :)

Muhammad Aamir 3 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 3 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 3 years ago

Thanks

Richmond Kwadwo Sarpong 3 years ago

WELL EXPLAINED

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks

Kazim Ali 3 years ago

Dear Rehim, excellent overview summary ?

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks

ISAAC APOMAH 3 years ago

great intro

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks

Saad Bajwa 3 years ago

Hi how can we help you?

Reply

Rahim Zulfiqar Ali 3 years ago

Mark as Complete button is available on TOP right side of every video header. Click on that button.

Saad Bajwa 3 years ago

I can't go to next video why that so?

Samana Agha 3 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 3 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 3 years ago

Mark as Complete button is available on TOP right side of every video header. Click on that button.

Rida Batool 3 years ago

Detailed video about the functions of EXCEL which we never learned before. Hope to learn till advanced features.

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks

Muddassar Awan 3 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 3 years ago

Mark as Complete button is available on TOP right side of every video header. Click on that button.

Eric Adjei Nyankson 3 years ago

im done with the video for over 2 times but always redirecting me back to complete

Reply

Rahim Zulfiqar Ali 3 years ago

Mark as Complete button is available on TOP right side of every video header. Click on that button.

Longhy Heang 3 years ago

good vedeo

Reply

Rahim Zulfiqar Ali 3 years ago

Thanks

Nida Kamran 3 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 3 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 3 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 3 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 3 years ago

I am using Excel 2019 and Office 365 in most of the videos

Muhammad Khatri 3 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