Data Analysis with Microsoft Excel – Complete Course → 2.18 Basic Filter

Beginners Class 19
- Lecture1.1
  
  Introduction to Data Analysis With Ms Excel 03 min
- Lecture1.2
  
  1.1 Introduction to Excel 22 min
- Lecture1.3
  
  1.2 Excel-Formatting 32 min
- Lecture1.4
  
  1.3 Conditional Formatting-1 15 min
- Lecture1.5
  
  1.4 Conditional Formatting-2 07 min
- Lecture1.6
  
  1.5 Formulas Function -1 30 min
- Lecture1.7
  
  1.6 Formulas function-2(Result Analysis) 16 min
- Lecture1.8
  
  1.7 Formulas and Function 3 37 min
- Lecture1.9
  
  1.8 Data validation Drop down 13 min
- Lecture1.10
  
  1.9 Header and Footer 14 min
- Lecture1.11
  
  1.10 Protecting Sheet 09 min
- Lecture1.12
  
  1.11 How to Unlock Protected Sheet 17 min
- Lecture1.13
  
  1.12 Automated Calculator 14 min
- Lecture1.14
  
  1.13 Consolidation 14 min
- Lecture1.15
  
  1.14 Charts 39 min
- Lecture1.16
  
  1.15 Progress Bar Chart 17 min
- Lecture1.17
  
  1.16 Print Setup 25 min
- Lecture1.18
  
  Course Review 01 min
- Quiz1.1
  
  Beginner’s Class Assessment 11 questions
Advance Class 20
- Lecture2.1
  
  Advance Class Intro 01 min
- Lecture2.2
  
  2.17 Sorting 09 min
- Lecture2.3
  
  2.18 Basic Filter 20 min
- Lecture2.4
  
  2.19 Advance Filter 17 min
- Lecture2.5
  
  2.20 Logical Function(AND) 10 min
- Lecture2.6
  
  2.21 Logical Function(Text) 21 min
- Lecture2.7
  
  2.22 Advance Data Validation (Dropdown list) 32 min
- Lecture2.8
  
  2.23 H-Lookup 08 min
- Lecture2.9
  
  2.24 V-Lookup 05 min
- Lecture2.10
  
  2.25 DataBase System 19 min
- Lecture2.11
  
  2.26 Pivot table – 1 15 min
- Lecture2.12
  
  2.27 Pivot Table 2 11 min
- Lecture2.13
  
  2.28 Pivot table 3 09 min
- Lecture2.14
  
  2.29 Power Query 1(Text Dates) 22 min
- Lecture2.15
  
  2.30 Power Query (Finance) 19 min
- Lecture2.16
  
  2.31 Power Query(Web, Dashboard, Slicer) 33 min
- Lecture2.17
  
  2.32 Covid-19 Analysis 18 min
- Lecture2.18
  
  2.33 Data Collection(Google form) 31 min
- Lecture2.19
  
  2.34 Sales Dashboard 33 min
- Lecture2.20
  
  Course Review 01 min
Application Class 12
- Lecture3.1
  
  Application Class Intro 02 min
- Lecture3.2
  
  3.35 Automated Data Entry Form 18 min
- Lecture3.3
  
  3.36 Attendance Register(Clock In & Clock Out) 16 min
- Lecture3.4
  
  3.37 Salary Sheet with Excel 13 min
- Lecture3.5
  
  3.38 Gantt Chart 14 min
- Lecture3.6
  
  3.39 Simple & Compound Interest 23 min
- Lecture3.7
  
  3.40 Loan Payment 07 min
- Lecture3.8
  
  3.41 Drop Down List (3) 33 min
- Lecture3.9
  
  3.42 Loan Management System(Data Base) 31 min
- Lecture3.10
  
  3.43 Loan Management System(Payment Page) 12 min
- Lecture3.11
  
  3.44 Loan Management System (Home Page) 11 min
- Lecture3.12
  
  Last Course Review and more 02 min

This content is protected, please login and enroll course to view this content!

Prev 2.17 Sorting

Next 2.19 Advance Filter

24 Comments

David Nzuva Muema

19/04/2022

great

Oguntuwase Temidayo

25/05/2022

great, very explainatory

Agunbiade Olaniran Johnson

12/07/2022

love this

Osanujor Kingsley

29/07/2022

Very explanatory

Ibrahim aliyu

24/08/2022

Good

OKEOWO DAVID ODUMUYIWA

24/08/2022

This excel made easy!

Uti Juliet Okonye

06/09/2022

The facilitator is just awesome

Ojo Oluwabankole

05/11/2022

I learnt reason and how to Paste Link. Never used it before nor knew the function. I feel good.

Ojo Oluwabankole

05/11/2022

To those interested, use shortcut Ctrl + Shift + L to add filter button

Evelyn Eze

16/11/2022

excel made easy
thank you

Egbeahie, Whitney Ehiluonamhen

06/01/2023

Nice one

Kakuru Peter Gasasira

20/02/2023

great class

Olatunji Toba

03/03/2023

Good day Mr Awesome. Thanks for the teachings. Can I get a dataset to practisea with please?

Awesome Emmanuel A.

03/03/2023
Reply

Thanks for the compliment
Reach me via email
awesome8emmanuel@gmail.com

Moditsa Cordelia Rampya

09/03/2023

nice one

Chukwurah Gloria Chidinma

12/04/2023

This is great

Jasper Mawulolo Segbefia

18/07/2023

Wonderful insight into data analysis.
Thank you brother

SAMUEL EDITH

25/07/2023

Excel made easy
thank you

Orakpu Lilian Chinenye

04/09/2023

Good one

Reginald OKORO

09/09/2023

perfect

Mercy wanjiku

28/09/2023

Loved it.

STEPHEN TEI AMANOR

08/01/2024

That was very detailed

Obafemi Rosemary Idowu

30/01/2024

Mr Awesome…. this is Awesome just as your name

FAITH

13/02/2024

Thanks for this lesson

6 Comments

Anas Yakubu

06/04/2021

I enjoy the program very well I will try to invite most of my friends to enroll for it.

AWESOME EMMANUEL

06/04/2021

My pleasure, Thanks for trusting AQskill

Aminu Saleh

22/04/2021

I truly enjoyed the step by step training and am now better in excel, thank you so much sir.

Otuaga John

27/04/2021

This is indeed great and amazing,I must admit that I have a good value for my money, Honestly the course is well delivered.
Secondly,I truly appreciate how the instructor Mr Awesome is ever ready to respond as quickly as possible to any area that needs more classification during the course of my learning this program on Excel.
Thanks for your effort Mr Awesome,I will recommend this valuable course to my friends …

Otuaga John

27/04/2021

AWESOME EMMANUEL

27/04/2021

The pleasure is mine. Thanks for trusting AQskill.

Beginners Class 19

Advance Class 20

Application Class 12

24 Comments

Leave a Reply to Agunbiade Olaniran Johnson Cancel reply

6 Comments