Microsoft Excel for Data Analytics

Focused View

Damilare Abolaji

6:55:59

48 View

1. First, Introductions!

1. Introduction.mp4

00:39

2. Introduction to Spreadsheets.mp4

18:34

3. Navigating Workbooks.mp4

04:54

4. Templates! Templates!! Templates!!!.mp4

06:06

5. Tabs, Ribbons, Groups.mp4

04:17

6. Cells, Rows, Columns & Ranges.mp4

06:25

7. Imputing and Formatting Data.mp4

19:09

8. Basic Excel Formulas.mp4

05:56

2. Basic Excel Functions

1. Relative and Absolute References.mp4

13:48

2. Structure of an Excel Function.mp4

03:20

3. SUM().mp4

07:56

4. MIN() & MAX().mp4

04:23

5. AVERAGE().mp4

01:57

6. COUNT().mp4

02:36

7. Adjacent Cell Errors.mp4

03:19

8. Autosum.mp4

06:11

3. Applying Formats

1. Applying simple formats.mp4

06:45

2. Conditional formatting.mp4

09:09

3. Named Ranges and Tables.mp4

14:58

4. More Functions

1.1 TheIFFunctionstoresalesdataraw-230126-092418.xlsx

1. IF().mp4

13:57

2. Nested-IF().mp4

11:40

3.1 TheIFFunctionstoresalesdataraw-230126-092418.xlsx

3. IFS().mp4

06:39

4.1 count ifraw-230126-092908.xlsx

4. COUNTIF().mp4

08:16

5.1 storesalesdataraw-230126-095106.xlsx

5.2 sumifraw-230126-092859.xlsx

5. SUMIF().mp4

08:45

6.1 iferrorraw-230126-092734.xlsx

6. IFERROR().mp4

04:19

7.1 vlookupraw1-230126-094953.xlsx

7. VLOOKUP().mp4

12:42

8.1 HLOOKUPraw-230126-094944.xlsx

8. HLOOKUP().mp4

07:59

9.1 storesalesdataraw-230126-094936.xlsx

9. Assignment 1.mp4

00:31

10. INDEX().mp4

06:22

11. MATCH().mp4

03:41

12.1 indexmatchraw1-230126-094926.xlsx

12. INDEX()-MATCH().mp4

20:00

13. Assignment 1.html

14. Assignment 2.mp4

00:39

5. Analytics in Excel

1. Basic Excel Charts.mp4

20:12

2.1 pivottableraw-230126-093345.xlsx

2. Pivot Tables.mp4

13:31

3. Grouping Pivot Tables.mp4

07:15

4. Calculated Fields in Pivot Tables.mp4

04:36

5. Filtering Pivot Table Data.mp4

03:39

6. More Analytics!

1. Pivot Charts.mp4

08:08

2. Slicers.mp4

03:19

3. Dashboards (Part 1).mp4

19:01

4. Dashboards (Part 2).mp4

10:07

7. Even More Analytics!

1.1 powerpivotraw-230126-093812.xlsx

1. Power Pivot.mp4

06:14

2. Activating Power Pivot Add-in.mp4

02:03

3. Data Models.mp4

10:01

4. Creating Pivot Tables from Data Models.mp4

05:12

8. Exploring Scenarios in Excel

1.1 scenarioraw-230126-094122.xlsx

1. Goal Seek tool.mp4

08:36

2. Solver tool.mp4

11:08

3. Data tool.mp4

02:38

4. Scenario Manager.mp4

07:24

9. Bonus!

1.1 datacleaningraw-230126-094302.xlsx

1. Data Cleaning in Excel.mp4

09:39

2. The Query Editor.mp4

15:51

10. Capstone Project

1.1 capstone-230126-094450.pdf

1.2 TNMTRetailsalesdocforCapstoneProject-230126-094456.xlsx

1. Capstone Project.mp4

01:33

Description

Boost Your Career with In-Depth Spreadsheet Skills

What You'll Learn?

By the end of this course, students will be able to proficiently use Excel functions and formulas to manipulate and transform raw data, including tasks such as
Students will develop the ability to perform complex data analysis tasks using advanced Excel features. This includes creating pivot tables, employing data vali
Upon completion of this course, participants will be able to design and generate compelling data visualizations, such as charts and graphs, to effectively commu
Learners will acquire skills in data cleaning and quality assurance by identifying and rectifying errors, handling missing data, and applying data validation te

Who is this for?

Beginner Data Analyst seeking to develop their skill in Microsoft Excel.

What You Need to Know?

Absolutely no prior experience is required. Rest assured that you will gain comprehensive knowledge, covering everything you need to know throughout the course.

More details

Description
Dive into the world of data analytics with the ultimate Excel mastery course! Unleash the full potential of Microsoft Excel as you embark on a journey from spreadsheet basics to becoming a data analytics pro.
What You'll Learn:
Data Manipulation Magic: Harness the power of Excel functions to effortlessly sort, filter, and analyze your data
Insights at Your Fingertips: Master advanced data analysis techniques using pivot tables, Power Query, and Power Pivot
Visual Storytelling: Transform raw data into compelling visualizations with charts and graphs that speak volumes
Data Cleaning Demystified: Tackle data imperfections with confidence, ensuring accuracy and reliability
Real-world Applications: Apply your skills to real-world scenarios, making Excel your trusted ally in business decision-making

Who Is This Course For?
Professionals seeking to enhance their data analysis capabilities
Business analysts, marketers, and decision-makers looking to leverage data for strategic insights
Excel enthusiasts eager to unlock its full potential for analytics

Why Excel for Data Analytics?
Universal Tool: Excel is the industry-standard spreadsheet software used by professionals worldwide
Accessible Learning: No prior analytics experience required - this course is your entry point to the exciting world of data insights
Career Boost: Elevate your professional profile by adding valuable data analytics skills to your toolkit

Why Enroll Now?
Seize the opportunity to master Excel for data analytics in a dynamic and engaging learning environment. Whether you're a beginner or have some Excel experience, this course will equip you with the skills needed to confidently navigate the data-driven landscape.
Join us and empower yourself with Microsoft Excel for Data Analytics â€“ because data is not just information; it's your competitive advantage!
Enroll today and chart your course to becoming a data analytics maestro with Microsoft Excel!
Who this course is for:
Beginner Data Analyst seeking to develop their skill in Microsoft Excel.

User Reviews

Rating

average 0

Total votes0

Focused display

Senior Business Intelligence Developer with a proven track record of leveraging data analytics and strategic insights to drive business growth. Strong expertise in data modeling, visualization, and reporting, with a deep understanding of advanced analytics and data governance. Recognized for exceptional communication skills and ability to present complex data in a concise and meaningful manner.

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.