Data Analysis with Microsoft Excel – Complete Course → 2.26 Pivot table – 1

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 10 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 21
- 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 24 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
- Quiz2.1
  
  Advance Class Assessment 5 questions
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.25 DataBase System

Next 2.27 Pivot Table 2

27 Comments

Fredrick Chirwa

29/03/2022

Thank you!

Akinsanya Samson Oluwasogo Pelumi

13/04/2022

learned alot from this.
thanx

Genevieve Eze

27/04/2022

I have really learnt a lot from this and I’m so glad I keyed into this
Thanks a lot Mr Awesome

Oguntuwase Temidayo

27/05/2022

I have really learnt a lot from this, very easy to pull big data , thank so much sir

Yekini Michael Olaitan

01/06/2022

Thank you, am really learning alot

Nnamdi Ajiduah

07/08/2022

This is so awesome, you are indeed an amazing teacher.

Salome Briggs

17/08/2022

You make learning so easy and fun. Thanks Mr. Awesome.

OKEOWO DAVID ODUMUYIWA

05/09/2022

Thumbs up! Good content

Akinyuwa Bosede

08/09/2022

Wow
Am grateful I found this site

Shaibu Eleojo Sunday

04/12/2022

learnt a lot, many thanks

Agboola Toluse David

20/12/2022

Thanks for this well explanatory lesson

Simon Boakye

20/12/2022

Nice lesson!

Egbeahie, Whitney Ehiluonamhen

08/01/2023

Nice one. Thanks a lot

Onome Mafuru

29/01/2023

Deeply insightful, thanks.

Moditsa Cordelia Rampya

09/03/2023

Absolutely knowledgeable class.

Apeji Yaariv

24/03/2023

👍

Ileogben obogua George

24/05/2023

please there should be a sample data set to practices as we learn thanks

Awesome Emmanuel A.

24/05/2023
Reply

The lesson materials/Dataset is attached for you to practice along.
It’s under the Video description of the first video

Ogah John

31/05/2023

Waw
Clear and precise

Ibrahim Dan Azumi Bala

22/06/2023

Thank you so much Sir

Mercy Ori Oche

15/08/2023

Good day Mr Awesome, please sir the dataset is not opening on Excel, instead it’s opening on google sheet.
How can I convert it to Excel from google sheet sir?
thank you sir.

Awesome Emmanuel A.

15/08/2023
Reply

On that same Google Sheet, Click on File, you will see Download. Download it in Excel format and use.
Best regards

Mercy wanjiku

03/10/2023

Nice lesson with great ideas.

Mercy wanjiku

03/10/2023

This is the best part I didn’t know about.

Matthew Anthony Edet

22/01/2024

Great lesson, Sir

Uchenna Adaeze Perpetual

29/01/2024

Thank you sir

FAITH

13/02/2024

this was really interesting to me

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 21

Application Class 12

27 Comments

Leave a Reply to Mercy wanjiku Cancel reply

6 Comments