The Complete Excel Bootcamp: From Beginner to Expert

Focused View

Dee Naidoo

5:41:53

146 View

1. Introduction

1.1 Datasets.pdf

1.2 Datasets.zip

1. Introduction to the Course.mp4

01:52

2.1 Datasets.pdf

2.2 Datasets.zip

2. What is Excel and why use it.mp4

02:49

2. The Basics of Excel

1.1 Datasets.pdf

1.2 Datasets.zip

1. Understanding Excel s Interface.mp4

04:50

2.1 Datasets.pdf

2.2 Datasets.zip

2. A Note about the Course.mp4

00:30

3.1 Datasets.pdf

3.2 Datasets.zip

3. Introduction to the Excel Ribbon.mp4

03:19

4.1 Datasets.pdf

4.2 Datasets.zip

4. Introduction to Project 1.mp4

03:52

5.1 Datasets.pdf

5.2 Datasets.zip

5. Styling on Excel.mp4

08:15

6.1 Datasets.pdf

6.2 Datasets.zip

6. Cell Referencing and Introduction to Basic Formulas.mp4

14:28

7.1 Datasets.pdf

7.2 Datasets.zip

7. Formatting Cells on Excel.mp4

10:57

8.1 Datasets.pdf

8.2 Datasets.zip

8. Referencing other Sheets, Hiding and Changing Tab Colours.mp4

07:35

9.1 Datasets.pdf

9.2 Datasets.zip

9. Adding Notes and Comments on Excel.mp4

03:03

3. Tables and Formulas on Excel

1.1 Datasets.pdf

1.2 Datasets.zip

1. Tables on Excel.mp4

08:00

2.1 Datasets.pdf

2.2 Datasets.zip

2. Sorting, Filtering, Slicing and Removing Duplicates.mp4

11:09

3.1 Datasets.pdf

3.2 Datasets.zip

3. Introduction to Project 2.mp4

00:49

4.1 Datasets.pdf

4.2 Datasets.zip

4. Introduction to Formulas and Functions (Working with Operations).mp4

06:05

5.1 Datasets.pdf

5.2 Datasets.zip

5. Using Functions in Excel.mp4

06:19

6.1 Datasets.pdf

6.2 Datasets.zip

6. Working with Inequalities.mp4

11:02

7.1 Datasets.pdf

7.2 Datasets.zip

7. Using the Formula Bar and tracing precedents and dependents.mp4

06:09

8.1 Datasets.pdf

8.2 Datasets.zip

8. Working with Dates (Using WEEKDAY and WEEKNUM).mp4

07:31

9.1 Datasets.pdf

9.2 Datasets.zip

9. Working with Errors.mp4

06:36

10.1 Datasets.pdf

10.2 Datasets.zip

10. Using Name Manager.mp4

04:06

11.1 Datasets.pdf

11.2 Datasets.zip

11. Using Round and an Introduction to Nested Formulas.mp4

04:45

4. Popular Functions and Formulas

1.1 Datasets.pdf

1.2 Datasets.zip

1. Introduction to Project 3.mp4

01:19

2.1 Datasets.pdf

2.2 Datasets.zip

2. Joining Cells using Ampersand and TEXTJOIN.mp4

05:55

3.1 Datasets.pdf

3.2 Datasets.zip

3. Separating Text using TEXTSPLIT and Text to Columns.mp4

06:13

4.1 Datasets.pdf

4.2 Datasets.zip

4. Using Lookup Functions (VLOOKUP).mp4

06:18

5.1 Datasets.pdf

5.2 Datasets.zip

5. Using XLOOKUP.mp4

09:04

6.1 Datasets.pdf

6.2 Datasets.zip

6. Using HLOOKUP.mp4

04:50

7.1 Datasets.pdf

7.2 Datasets.zip

7. Changing Case using Formulas on Excel.mp4

03:52

8.1 Datasets.pdf

8.2 Datasets.zip

8. Using the TRIM Function.mp4

03:19

9.1 Datasets.pdf

9.2 Datasets.zip

9. Extracting Text from Excel.mp4

08:29

10.1 Datasets.pdf

10.2 Datasets.zip

10. Using Find and Replace.mp4

04:06

11.1 Datasets.pdf

11.2 Datasets.zip

11. Using IF Statements.mp4

20:33

12.1 Datasets.pdf

12.2 Datasets.zip

12. Conditional Formatting.mp4

07:35

13.1 Datasets.pdf

13.2 Datasets.zip

13. Data Bars, Icon Sets and Color Scales.mp4

05:53

5. Charts, Pivot Tables and Dashboards

1.1 Datasets.pdf

1.2 Datasets.zip

1. Introduction to Charts.mp4

12:55

2.1 Datasets.pdf

2.2 Datasets.zip

2. Creating Column Charts.mp4

14:07

3.1 Datasets.pdf

3.2 Datasets.zip

3. Creating Bar Charts on Excel.mp4

02:08

4.1 Datasets.pdf

4.2 Datasets.zip

4. Creating Line Charts on Excel.mp4

05:39

5.1 Datasets.pdf

5.2 Datasets.zip

5. Creating Histograms on Excel.mp4

02:49

6.1 Datasets.pdf

6.2 Datasets.zip

6. Creating Spark Lines on Excel.mp4

08:21

7.1 Datasets.pdf

7.2 Datasets.zip

7. Introduction to Pivot Tables.mp4

16:14

8.1 Datasets.pdf

8.2 Datasets.zip

8. Adding Percents to Pivot Tables.mp4

02:07

9.1 Datasets.pdf

9.2 Datasets.zip

9. Filters, Slicers and Timelines in Pivot Tables.mp4

04:28

10.1 Datasets.pdf

10.2 Datasets.zip

10. Introduction to Pivot Charts.mp4

04:14

11.1 Datasets.pdf

11.2 Datasets.zip

11. Dashboards on Excel.mp4

06:09

6. Important Formulas and Tips to Know

1.1 Datasets.pdf

1.2 Datasets.zip

1. Working with Dates on Excel (adding, subtracting dates).mp4

09:32

2.1 Datasets.pdf

2.2 Datasets.zip

2. Using SUMIF on Excel.mp4

06:19

3.1 Datasets.pdf

3.2 Datasets.zip

3. Hiding Rows and Columns on Excel.mp4

01:19

4.1 Datasets.pdf

4.2 Datasets.zip

4. Data Validation on Excel.mp4

04:18

5.1 Datasets.pdf

5.2 Datasets.zip

5. Remove Duplicates on Table.mp4

00:58

6.1 Datasets.pdf

6.2 Datasets.zip

6. Using Grouping on Excel.mp4

01:20

7.1 Datasets.pdf

7.2 Datasets.zip

7. Fill in Blanks in Excel.mp4

02:27

8.1 Datasets.pdf

8.2 Datasets.zip

8. Using Search and Find.mp4

04:33

9.1 Datasets.pdf

9.2 Datasets.zip

9. Freezing Rows and Columns.mp4

02:11

10.1 Datasets.pdf

10.2 Datasets.zip

10. Protecting Sheets, Cells and Workbooks.mp4

03:21

11.1 Datasets.pdf

11.2 Datasets.zip

11. Printing on Excel.mp4

04:45

12. Conclusion.mp4

00:12

Description

Learn essential Excel skills with a beginner's guide, including formulas, spreadsheets, charts, pivot tables, dashboards

What You'll Learn?

Master Excel's interface and gain a comprehensive understanding of its essential tools and features.
Develop proficiency in cell referencing and spreadsheet navigation, ensuring smooth and efficient data handling.
Learn to create powerful formulas and functions in Excel, including popular functions like VLOOKUP, XLOOKUP, and HLOOKUP.
Acquire the skills to clean, organize, merge, and join data in Excel effectively, making data management a breeze.
Discover how to create insightful charts and pivot tables that represent data in a clear and visually appealing manner.
Use pivot charts to analyze data trends and patterns, enabling data-driven decision-making.
Build compelling dashboards to present data in a clear, concise, and visually appealing way, perfect for business professionals and analysts.
Master printing and formatting techniques to ensure that your work in Excel is polished and professional.
Learn to use the search and find function to locate and edit data quickly and efficiently.
Freeze panes to make data navigation easier, allowing you to work with large datasets effortlessly.
Unlock advanced tips and tricks to enhance your productivity in Excel, enabling you to work faster and more efficiently than ever before.

Who is this for?

Beginners who are new to Excel and want to gain a comprehensive understanding of the software and learn essential tools and techniques to manage and analyze data.

Professionals who work with data and want to improve their Excel skills to become more efficient and productive in their roles.

More details

Description
Welcome to "The Complete Excel Bootcamp: From Beginner to Expert"! Whether you're a complete beginner or an experienced user, this course has everything you need to master Excel and become an expert in data management and analysis.
In this course, you'll learn the essential skills you need to take your Excel skills to the next level. We cover everything from the basics of Excel and its interface to advanced techniques like using VLOOKUP, XLOOKUP, and HLOOKUP functions, and building dashboards to present data. Here's what you can expect to learn:

Introduction to Excel and its interface: Get comfortable with Excel's interface, tools, and features.
Cell referencing and navigation within a spreadsheet: Learn how to navigate Excel's cells, rows, and columns, making it easy to handle even the most massive datasets.
Creating formulas and functions in Excel: Discover how to create powerful formulas and functions that help you perform calculations quickly and accurately.
Using VLOOKUP, XLOOKUP, and HLOOKUP functions: Learn how to use Excel's essential functions to find specific values and perform lookup operations.
Cleaning and organizing data in Excel: Get hands-on experience with techniques to clean, organize, and transform data.
Merging and joining data in Excel: Discover how to merge and join datasets from different sources into one cohesive unit.
Creating charts and pivot tables to represent data: Learn how to create professional-looking charts and pivot tables that represent data visually and concisely.
Using pivot charts to analyze data: Discover how to use pivot charts to analyze data trends and patterns, making it easy to understand complex datasets.
Building dashboards in Excel to present data: Get practical experience in building and designing dashboards that showcase data in a clear, visually appealing way.
Printing and formatting work in Excel: Learn how to format and print your Excel work for a professional look.
Using the search and find function in Excel: Discover how to quickly locate and edit data using the search and find function.
Freezing panes in Excel to make data navigation easier: Learn how to freeze panes to make it easier to navigate large datasets.
Advanced tips and tricks to enhance productivity in Excel: Unlock advanced techniques that can help you work faster and more efficiently in Excel.

Why you should choose this course:
My curriculum is carefully designed to teach you only the most essential Excel skills used in a business environment.
My course is concise and can be completed in just one day, allowing you to learn Excel quickly and efficiently.
I use business-related examples, data analysis, and case studies to show you how to use Advanced Excel to solve real-world problems.
You'll learn various data analysis techniques using Excel, which are useful across many different industries and professions.
My course provides ample practice exercises for data analysis and Excel, both basic and advanced, so you can master Excel through hands-on practice.
With practical examples and projects, you'll develop your skills quickly and efficiently, becoming an Excel pro in no time. Whether you're a business professional, analyst, or student, this course is perfect for anyone who wants to become an expert in Excel.
Enroll now to start your journey to becoming an Excel pro!
Who this course is for:
Beginners who are new to Excel and want to gain a comprehensive understanding of the software and learn essential tools and techniques to manage and analyze data.
Professionals who work with data and want to improve their Excel skills to become more efficient and productive in their roles.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Dee Naidoo

Instructor's Courses

Hello, I'm Dee! I am a Chemical Engineer specializing in Data Analytics.I've been using Tableau daily for the past couple of years. I love creating visualizations and letting the data speak for itself.Other than that, I love food, movies rated less than 5/10 on IMDB and escape rooms. I sound like a major nerd until I tell you that my favourite music is Rap. I adore a great view, hate raw onions, and I think that pineapple on pizza is the best combo ever!

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.