Excel for Analysts

Focused View

Gillian Jackson

3:01:04

15 View

1. Introduction to Large Worksheets

1. Introduction.mp4

03:03

2. Data Analysis.html

3.1 worldbank extract.csv

3. Navigating Excel.mp4

01:45

4. Viewing Data.mp4

04:39

5. Viewing Large Workbooks.mp4

05:20

6. Printing Large Workbooks.mp4

04:46

7. Large Worksheets Quiz.html

8.1 Wikipedia Data.xlsx

8. Multiple Worksheets.mp4

04:12

9. Multiple Worksheets Quiz.html

10.1 SalesData.xlsx

10. Formatting and Filtering Data.mp4

07:12

11. Formatting and Filtering Data Quiz.html

2. Functions

1.1 ListofExcelFunctions.xlsx

1. Functions Overview.mp4

03:09

2.1 eCommerce 2.xlsx

2. Logic Functions 1 IF Functions and Embedded IF Functions.mp4

03:46

3. Logic Functions.html

4. Logic Functions 2 SUMIFs, AVERAGEIFs, COUNTIFs, OR, AND, NOT.mp4

08:50

5. Working With Dates.mp4

06:07

6. Dates.html

7.1 Register.xlsx

7. TEXT Functions.mp4

05:34

8. TEXT Functions Part 2.mp4

03:59

9. TEXT Functions Part 3.mp4

00:59

10. Text Functions.html

11.1 Functions.xlsx

11. Absolute Referencing.mp4

04:42

12. Absolute Referencing.html

13. HLOOKUP , VLOOKUP and XLOOKUP.mp4

06:42

14. INDEX + MATCH.mp4

04:38

15. HLOOKUP , VLOOKUP and XLOOKUP , INDEX + MATCH.html

3. Data Tools

1. Intro to Data Tools.mp4

01:13

2.1 Functions.xlsx

2. Scenario Manager.mp4

02:38

3. Goal Seek.mp4

01:06

4. Data Validation.mp4

03:47

5. Scenario Manager, Goal Seek and Data Validation.html

6.1 GrossProfit.xlsx

6. Cell References, Trace Precedents and Dependents and Watch Window.mp4

06:07

7. Cell References, Trace Precedents and Dependents and Watch Window.html

8. Formatting Tables.mp4

07:57

9. Pivot Tables.mp4

13:40

10.1 World Athletic Top 100 M Men.html

10. Importing Data from the Web to Create Tables and Pivot Tables.mp4

04:28

11. Tables and Pivot Tables.html

12. Charts Part 1.mp4

06:44

13.1 StudentData.xlsx

13. Charts Part 2.mp4

06:35

14. Charts.html

15. Analysis Toolpack - Histograms.mp4

08:54

16. Analysis Toolpack - Regression.mp4

05:57

17. Analysis Toolpack.html

4. Building Dashboards

1.1 StudentData.xlsx

1. Introduction to Dashboards.mp4

02:20

2. Dashboard Setup.mp4

12:59

3. Creating a Dashboard.mp4

12:26

4. Creating Slicers and Conditional Formatting in a Dashboard.mp4

04:50

5. Dashboards Quiz.html

Description

Master Excel Skills to Elevate Your Data Analysis and Reporting

What You'll Learn?

Go from beginner to advanced by using Excel to conduct insightful and powerful analysis. You will boost your confidence in using Excel!
Create pivot tables, charts, and dashboards in Excel using dynamic functions like VLOOKUP, HLOOKUP, XLOOKUP.
Use the Maps feature in Excel to analyze customer data by address.
Unearth the true story behind data to effectively explain to your stakeholders what is happening in the business.
Use Excel shortcuts to make data analysis easier and faster.
Use Logic functions like AND, IF, embedded IFs, SUMIFS, AVERAGEIF, COUNTIF + Conditional Formatting, Data Sorting and Filtering.
Use the features of the Data Analytics toolbar including creating a Histogram and conducting Regression Analysis.
Use Data validation to force specific data types to be entered in Excel Sheets.
Use Goal Seek and Scenario Manager to help you run different Scenarios in your Excel Models.
All the information is broken down into simple steps.
You will explore different data sets across industries.

Who is this for?

Intermediate Data Analysts or Business Owners who are interested in expanding their skills

Managers who wish to provide more insightful reports

What You Need to Know?

Previous experience with Excel would be beneficial but if not you will still learn alot!

More details

Description
Course Description: Excel for Analysts
Section 1: Introduction to Large Worksheets
Lecture 1: Introduction (Preview enabled) - Get acquainted with the basics of handling large worksheets in Excel, setting the foundation for advanced data analysis.
Lecture 2: Navigating Excel - Learn efficient ways to navigate through large datasets in Excel.
Lecture 3: Viewing Data - Techniques for effectively viewing and interpreting data.
Lecture 4: Viewing Large Workbooks - Strategies for managing and navigating large Excel workbooks.
Lecture 5: Printing Large Workbooks - Master the nuances of printing large and complex Excel workbooks.
Lecture 6: Multiple Worksheets - Understand the dynamics of working with multiple worksheets and how to link them effectively.
Lecture 7: Formatting and Filtering Data - Learn advanced techniques in formatting and filtering data for clearer analysis.
Section 2: Functions
Lecture 8: Functions Overview - An introduction to the vast array of functions available in Excel.
Lecture 9: Logic Functions 1 - Dive into IF functions and embedded IF functions.
Lecture 10: Logic Functions 2 - Explore SUMIFs, AVERAGEIFs, COUNTIFs, and logical operators like OR, AND, NOT.
Lecture 11: Working With Dates - Master the complexities of handling dates in Excel.
Lecture 12-14: TEXT Functions Parts 1-3 - A three-part series delving deep into the TEXT functions of Excel.
Lecture 15: Absolute Referencing - Understand the importance and application of absolute referencing in Excel.
Lecture 16: HLOOKUP, VLOOKUP, and XLOOKUP - Learn the key lookup functions for data analysis.
Lecture 17: INDEX + MATCH - Advanced techniques combining INDEX and MATCH functions for sophisticated data retrieval.
Section 3: Data Tools
Lecture 18: Intro to Data Tools - Introduction to various data tools available in Excel for advanced analysis.
Lecture 19: Scenario Manager - Learn to use the Scenario Manager for forecasting and analysis.
Lecture 20: Goal Seek - Master the Goal Seek function for solving equations and achieving target values.
Lecture 21: Data Validation - Techniques for ensuring data integrity through validation.
Lecture 22: Cell References, Trace Precedents and Dependents, and Watch Window - Explore advanced features for tracking and analyzing data relationships.
Lecture 23: Formatting Tables - Learn to format tables for better readability and analysis.
Lecture 24: Pivot Tables - Comprehensive guide to creating and manipulating pivot tables.
Lecture 25: Importing Data from the Web - Techniques for importing web data to create tables and pivot tables.
Lecture 26-27: Charts Parts 1 and 2 - A two-part series on creating and customizing charts for data visualization.
Lecture 28: Analysis Toolpack - Histograms - Utilize the Analysis Toolpack for creating histograms.
Lecture 29: Analysis Toolpack - Regression - Learn regression analysis using Excel's Analysis Toolpack.
This course is designed to equip analysts with a comprehensive understanding of Excel's capabilities, ensuring proficiency in data handling, analysis, and reporting.
Who this course is for:
Intermediate Data Analysts or Business Owners who are interested in expanding their skills
Managers who wish to provide more insightful reports

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Analytics

Gillian Jackson

Instructor's Courses

Over 17 years working in the financial sector and 18+ years conducting analysis. Lead for Data and Analytics for a major financial conglomerate and Co-founder and Chief Operating Officer for an e-learning company. Certified in Advanced Microsoft Excel, proficient in Python and statistical querying. I conduct training in Excel from beginner to advanced and can help you in improving your analytical skills!

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.