Data Analysis with Microsoft Excel – Internship Inclusive

About Course

This Data Analysis with Microsoft Excel – Internship Inclusive course is your pathway to unlocking insights from data, ideal for those who want to harness Excel’s power to make data-driven decisions. With a hands-on approach, you’ll learn how to analyze, visualize, and present data effectively, preparing you to solve real-world business problems. Plus, the included internship placement ensures you apply your new skills in a professional setting, gaining valuable experience that sets you apart in the job market.

Learning Objectives

By the end of this course, you will be able to:

Master Core Excel Functions and Formulas
- Understand and effectively use key Excel functions for data manipulation, such as VLOOKUP, INDEX, MATCH, and logical functions.
- Work with nested formulas to solve complex data challenges efficiently.
Clean and Prepare Data for Analysis
- Utilize techniques to clean, organize, and structure raw data, preparing it for accurate analysis.
- Learn data validation methods to reduce errors and ensure data integrity.
Analyze Data with Pivot Tables and Pivot Charts
- Build and customize Pivot Tables to summarize large datasets.
- Create Pivot Charts to visualize data insights and trends for more dynamic reporting.
Create Visualizations and Dashboards
- Use charts, graphs, and conditional formatting to present data insights effectively.
- Design interactive dashboards that allow end-users to explore data insights independently.
Perform Descriptive and Exploratory Data Analysis
- Apply Excel functions and formulas to perform essential descriptive analyses.
- Explore data patterns and trends using advanced Excel tools such as slicers, and filters
- Prepare interactive dashboards revealing detail insights using slicers.
Effectively Communicate Insights with Data Storytelling
- Learn to present data findings in a clear, concise, and compelling way.
- Develop storytelling techniques to turn data into actionable insights for stakeholders.
Apply Data Analysis Skills in a Real-World Internship
- Gain practical experience with a hands-on internship, applying your skills in a professional setting.
- Build a portfolio of data analysis projects and develop problem-solving abilities that translate into career-ready skills.

This course will equip you with the practical knowledge and experience needed to excel as a data analyst and make an impact in any data-driven role. Enroll now and start transforming your career with Teck-Skills!

Master essential Excel functions like VLOOKUP, INDEX, and MATCH for data manipulation.
Clean and organize raw data to prepare it for analysis.
Use Pivot Tables and Pivot Charts to summarize and visualize large datasets.
Use Power Query for data manipulation and transformation.
Create interactive dashboards with charts, graphs, and conditional formatting.
Conduct trend analysis and forecasting using Excel’s advanced tools.
Build interactive dashboards and make informed business decisions
Communicate data insights effectively using storytelling techniques.

Course Content

Module 1: Introduction to Data Analysis & Excel Fundamentals

1.1 Introduction to Data Analysis

22:35
1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials

22:24
1.3 Data Types in MS Excel

08:24
1.4 Data Entry in Ms Excel

09:07
1.5 Formatting I

10:03
1.6 Formatting II

09:29
1.7 Formatting III – Conditional Formatting I

08:03
1.8 Formatting III – Conditional Formatting II

07:08
1.9 Structured Datasets

02:47
1.10 Unstructured Datasets

03:59
1.11 Protecting a Sheet

08:09
1.12 Protecting a Document

04:01
1.13 Printing an Excel Document

11:12
Download Learning Resources

Module 2: Essential Excel Functions for Analysis

2.1 Number Functions I

19:06
2.2 Number Functions II

17:08
2.3 Consolidation

09:29
2.4 Logical Functions I – IF, SUMIF, COUNTIF

16:45
2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR

18:30
2.6 TEXT Functions

14:52
2.7 Time and Date Functions I

09:25
2.8 Time and Date Functions II

12:05
2.9 Time Intelligence Functions

17:19
2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP

10:27
2.11 Lookup Functions – INDEX AND MATCH

08:25
2.12 Lookup Functions – WILDCARDS

06:26
2.13 Error Handling Functions

07:49
2.14 Lookup Functions – Multiple VLOOKUP

06:13
2.15 Other Data Analysis Functions

13:46

Module 3: Data Cleaning & Preparation (ETL in Excel)

3.1 Removing Duplicates

04:51
3.2 Removing Blank Rows

08:17
3.3 Removing Blank Columns

06:53
3.4 Text to Columns

00:00
3.5 Find and Replace

02:59
3.6 Data Validation I

16:52
3.7 Data Validation – Custom Formula

19:03
3.8 Searchable Dropdown List

09:10
3.9 Handling Missing and Inconsistent Records

06:19
3.10 Introduction to Power Query

24:14

Module 4: Exploratory Data Analysis (EDA)

Module 5: Advanced Excel Tools for Data Analysis

5.1 Power Query – Data Cleaning

07:32
5.2 Power Query – Transformation

06:00
5.3 Power Query – Transpose

01:35
5.4 Power Query – Unpivot

02:43
5.5 Data Scraping with Power Query

07:22
5.6 Multiple Files Combination – Append

13:18
5.7 Multiple Files Combination – Merge

07:19
5.8 Group and Aggregate

03:22
5.9 M Language in Power Query

05:17
5.10 Data Normalization I

06:20
5.11 Data Normalization II

14:06
5.12 Data Modeling

08:49
5.13 What IF Analysis – Scenario Manager

10:36
5.14 What IF Analysis – Goal Seek and Solver

13:18
5.15 What IF Analysis – Data Table

08:05

Module 6: Data Visualization & Dashboards

6.1 Introduction to Visualizations

10:41
6.2 Visualization – Pie Charts and Donought Chart

14:44
6.3 Visualization – Column Chart and Bar Chart

05:48
6.4 Visualization – Funnel Chart

04:58
6.5 Visualization – Waterfall Chart

04:15
6.6 Visualization – Line Chart

08:12
6.7 Visualization – Cards

14:42
6.8 Interactive Dashboard

25:55
6.9 Executive Summary

08:30

Module 7: Excel Automation with Macros & AI

Module 8: Real-World Business Applications

Module 9: Capstone Project and Certification

Data Analysis with Microsoft Excel Internship
A complete data analysis internship program with Microsoft Excel

Introduction

04:33
Project Resources
1. The Bosh Sales Agency – Data Cleanup

10:17
2. Customer Contact Details – Data Cleaning

24:19
3. Friend Request Data Cleaning Task

09:46
4. Dataset Reconciliation Request

19:42
5. Late Submission Analysis

18:25
6. Population Data Extraction and Analysis – Nigerian States

27:22
7. Sales Data Analysis for Rocry Shopping Company

34:30
8. Bank Reconciliation Exercise

16:13
9. Employee Data Adjustment – Madox Cooperation

32:43
10. Mini Super Store Data Analysis

42:37
11. Student Performance Analysis Report – School XYZ

01:17:36
12. Sales Transaction Data Analysis

36:16
13. Supplier Transaction Record Template Design

01:10:27
14. Sales Data Executive Reporting

54:13
15. Kracks Consultant & Infrastructure

24:20
16. Quick Job Applicant Data Cleaning

00:00
17. McSmith Recruiting Services – Candidate Selection Analysis

17:53
18. UK Excel Assessment for Data Analyst Role

32:52
19. Kace Communications – Mast Code Extraction

10:30
20. Credit Card Spending Habits in India

51:03
21. RushTech Financials

48:41
22. LayKon Designs & Research Institute

32:28
23. Flourish Fish Farms – Sales Automation & Dashboard

59:13
24. Tunia Technologies – Sales & Performance Dashboard

52:04
25. GreenBrew Ltd Financial Analysis

00:00
26. Creating your Data Analysis Portfolio

01:16:24
27. Professional CV and Cover Letter

08:21
28. LinkedIn Optimization

00:00
28. LinkedIn Optimization

00:00

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Victor Odomovo

3 weeks ago

The course is simplied and educative

About Course

Learning Objectives

What Will You Learn?

Course Content

Module 1: Introduction to Data Analysis & Excel Fundamentals

1.1 Introduction to Data Analysis

1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials

1.3 Data Types in MS Excel

1.4 Data Entry in Ms Excel

1.5 Formatting I

1.6 Formatting II

1.7 Formatting III – Conditional Formatting I

1.8 Formatting III – Conditional Formatting II

1.9 Structured Datasets

1.10 Unstructured Datasets

1.11 Protecting a Sheet

1.12 Protecting a Document

1.13 Printing an Excel Document

Download Learning Resources

Module 2: Essential Excel Functions for Analysis

2.1 Number Functions I

2.2 Number Functions II

2.3 Consolidation

2.4 Logical Functions I – IF, SUMIF, COUNTIF

2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR

2.6 TEXT Functions

2.7 Time and Date Functions I

2.8 Time and Date Functions II

2.9 Time Intelligence Functions

2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP

2.11 Lookup Functions – INDEX AND MATCH

2.12 Lookup Functions – WILDCARDS

2.13 Error Handling Functions

2.14 Lookup Functions – Multiple VLOOKUP

2.15 Other Data Analysis Functions

Module 3: Data Cleaning & Preparation (ETL in Excel)

3.1 Removing Duplicates

3.2 Removing Blank Rows

3.3 Removing Blank Columns

3.4 Text to Columns

3.5 Find and Replace

3.6 Data Validation I

3.7 Data Validation – Custom Formula

3.8 Searchable Dropdown List

3.9 Handling Missing and Inconsistent Records

3.10 Introduction to Power Query

Module 4: Exploratory Data Analysis (EDA)

4.1 EDA – Sorting

4.2 EDA – Filtering

4.3 Table – Slicers

4.4 Advance Filters

4.5 Pivot table for Data Analysis I

4.6 Pivot table for Data Analysis II

Module 5: Advanced Excel Tools for Data Analysis

5.1 Power Query – Data Cleaning

5.2 Power Query – Transformation

5.3 Power Query – Transpose

5.4 Power Query – Unpivot

5.5 Data Scraping with Power Query

5.6 Multiple Files Combination – Append

5.7 Multiple Files Combination – Merge

5.8 Group and Aggregate

5.9 M Language in Power Query

5.10 Data Normalization I

5.11 Data Normalization II

5.12 Data Modeling

5.13 What IF Analysis – Scenario Manager

5.14 What IF Analysis – Goal Seek and Solver

5.15 What IF Analysis – Data Table

Module 6: Data Visualization & Dashboards

6.1 Introduction to Visualizations

6.2 Visualization – Pie Charts and Donought Chart

6.3 Visualization – Column Chart and Bar Chart

6.4 Visualization – Funnel Chart

6.5 Visualization – Waterfall Chart

6.6 Visualization – Line Chart

6.7 Visualization – Cards

6.8 Interactive Dashboard

6.9 Executive Summary

Module 7: Excel Automation with Macros & AI

Data Analysis with Microsoft Excel Internship
A complete data analysis internship program with Microsoft Excel