Data Analysis with Microsoft Excel - Complete Course

Focused View

Adeiza Awesome Emmanuel

13:45:56

67 View

1. Introduction

1.1 Data Analysis(Beginners Class) Data Set.xlsx

1. 1.1 Introduction to Excel.mp4

21:52

2. 1.2 Excel-Formatting.mp4

31:21

3. 1.3 Conditional Formatting-1.mp4

14:08

4. 1.4 Conditional Formatting-2.mp4

06:44

5. 1.5 Formulas Function -1.mp4

30:05

6. 1.6 Formulas function-2(Result Analysis).mp4

15:27

7. 1.8 Data validation Drop down.mp4

12:36

8. 1.9 Header and Footer.mp4

13:34

9. 1.10 Protecting Sheet.mp4

09:11

10. 1.11 How to Unlock Protected Sheet.mp4

17:04

11. 1.12 Automated Calculator.mp4

14:06

12. 1.13 Consolidation.mp4

13:57

13. 1.14 Charts.mp4

38:59

14. 1.15 Progress Bar Chart.mp4

16:42

15. 1.16 Print Setup.mp4

24:12

2. Advance Section

1.1 Data Analysis(Advance Class) Data Set.xlsx

1. 2.17 Sorting.mp4

08:22

2. 2.18 Basic Filter.mp4

20:14

3. 2.19 Advance Filter.mp4

16:51

4. 2.20 Logical Function(AND).mp4

09:38

5. 2.21 Logical Function(Text).mp4

20:51

6. 2.22 Advance Data Validation (Dropdown list).mp4

31:16

7. 2.23 H-Lookup.mp4

07:31

8. 2.24 V-Lookup.mp4

04:50

9. 2.25 DataBase System.mp4

18:51

10. 2.26 Pivot table - 1.mp4

23:19

11. 2.27 Pivot Table 2.mp4

10:52

12. 2.28 Pivot table 3.mp4

08:17

13. 2.29 Power Query 1(Text Dates).mp4

21:36

14. 2.30 Power Query (Finance).mp4

18:39

15. 2.31 Power Query(Web, Dashboard, Slicer).mp4

32:20

16. 2.32 Covid-19 Analysis.mp4

17:24

17. 2.33 Data Collection(Google form).mp4

30:55

18. 2.34 Sales Dashboard.mp4

33:04

3. Application Section

1.1 Data Analysis(Advance Class) Data Set.xlsx

1. 3.35 Automated Data Entry Form.mp4

17:07

2. 3.36 Attendance Register(Clock In & Clock Out).mp4

15:32

3. 3.37 Salary Sheet with Excel.mp4

12:59

4. 3.38 Gantt Chart.mp4

14:09

5. 3.39 Simple & Compound Interest.mp4

22:16

6. 3.40 Loan Payment.mp4

06:08

7. 3.41 Drop Down List (3).mp4

22:34

8. 3.42 Loan Management System(Data Base).mp4

31:05

9. 3.43 Loan Management System(Payment Page).mp4

11:48

10.1 DA Assignment 2.xlsx

10.2 DA Assignment.xlsx

10.3 DA Date Assignment.xlsx

10.4 My Vlookup Exercise.xlsx

10. 3.44 Loan Management System (Home Page).mp4

10:39

4. Project

1.1 Tunia Technologies .docx

1.2 Tunia Technologies .xlsx

1. Tunia Technologies.mp4

46:51

Description

Data Analysis and Visualization

What You'll Learn?

Most common Excel functions used in the office
How to design a simple automated calculator for a shopping mall.
How to apply the skills in data analysis, grade responses or polls, and prepare results.
How to perform basic financial analysis as an accountant/finance secretary
How to design utility models such as Automated Quiz Scoring Board, Digital clock, and others
How to design a loan management system.
How to design a dynamic data base system
How to simplify voluminous entries using automated forms
Perform basic and advance analysis using Ms Excel Functions
Analyze, Transform and visualize data using tools like Pivot Tables, Power Query etc
Build interactive dashbaords

Who is this for?

Absolute beginners in data analysis

Intermediate user of Ms Excel for data analysis

What You Need to Know?

Access to Laptop or desktop with Microsoft office installed

More details

Description
Welcome to Data Analysis with Microsoft Excel course!Â .This comprehensive course is divided into three distinct classes: The Beginners Class, The Advanced Class, and The Application Class, featuring a total of 50 well-simplified and detailed lessons. Get ready to unlock the full potential of Microsoft Excel!
Course Highlights:

In this course, you will embark on a journey from the beginner level to becoming proficient in Excel, with a focus on practical applications. Here's what you'll learn:

The Basics of Microsoft Excel: Start from the ground up, mastering the essential features and functions of Excel. Learn how to navigate the interface, format cells, create formulas, and manage data effectively.

Maintaining Large Data Sets: Explore techniques for managing extensive sets of data in lists or tables. Learn how to organize, sort, filter, and manipulate data, enabling you to efficiently work with vast amounts of information.

Basic and Complex Excel Functions: Gain a deep understanding of Excel functions and formulas. Discover how to use built-in functions to perform calculations, analyze data, and solve complex problems, empowering you to derive valuable insights.

Analyzing Academic, Business, and Financial Reports: Learn how to leverage Excel's powerful analytical capabilities to interpret and analyze academic, business, and financial reports. Discover techniques for data visualization, charting, and trend analysis.

Designing Dynamic Database Systems: Dive into the realm of database design using Excel. Explore methods to create robust and dynamic database systems that can efficiently store, retrieve, and manipulate data.

Creating Dynamic Reports: Learn to design dynamic reports that automatically update and adapt to changes in the underlying data. Master the art of building interactive dashboards and reports that provide real-time insights.

Designing a Loan Management System: Discover how to create a loan management system using Excel. Learn to build automated loan calculators, track payment schedules, and generate comprehensive reports for loan management purposes.
Designing Progressive Reports: Explore advanced reporting techniques to create dynamic and visually appealing reports that showcase progress over time. Learn to present complex data in a concise and meaningful manner.

Pure Practicals: Throughout the course, emphasis is placed on practical exercises and real-world applications. Gain hands-on experience through practical examples and apply your knowledge to solve real-life scenarios.

Tutored by a Professional Trainer with years of Excel training experience, this course provides you with the guidance and expertise necessary to master Data analysis with Excel's vast range of tools and functionalities.

Enroll in the Data Analysis with Microsoft Excel course today and acquire the skills that will boost your productivity and make Excel your most valuable tool. Join us now and take your Excel skills to new heights!
Who this course is for:
Absolute beginners in data analysis
Intermediate user of Ms Excel for data analysis

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Awesome Emmanuel. I'm a British Council certified instructor based in Lagos, Nigeria. A data analyst/database administrator with over 6 years of active industrial work experience. A seasoned and resourceful ICT Tech-skill instructor, Data analyst consultant, Edu-Tech consultant and a web developer with great flair for providing soft and digital ICT skills. I have trained over 16000 African the art of Data Analysis using analytical tools like Microsoft Excel, Power BI, Tableau, Google Sheet, Looker Studio, MySQL and Python.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.