6 Hr Excel Mastery: Beginner to Pro (2023)

Focused View

Andrea Maddes

6:07:42

143 View

1. Introduction

1. Start Your Excel Journey.mp4

01:32

2. Read me.html

2. Start with Excel

1. Open and save a Workbook.mp4

01:14

2. Workbook structure.mp4

05:52

3.1 Project.xlsx

3. Entering data & Cell formatting.mp4

06:41

3. Page setup and layout

1.1 Project.xlsx

1. Page setup, Print layout, Header & Footer.mp4

09:23

4. Workbook navigation

1.1 Foodsales Dataset 4.0.xlsx

1. Intro Dataset.mp4

01:01

2. Find&Replace function.mp4

03:25

3. Notes and comments.mp4

03:46

4.1 Foodsales Dataset 5.0.xlsx

4. Hyperlinks.mp4

03:07

5. Data manipulation

1. Copy and paste.mp4

04:51

2. Paste special options.mp4

06:41

3. Autofill and Flashfill.mp4

02:57

4.1 Foodsales Dataset 6.0.xlsx

4. Hide and manage rows and columns.mp4

02:12

6. Tables

1. Create a table.mp4

04:01

2. Modify a table.mp4

04:09

3.1 Foodsales Dataset 7.0.xlsx

3. Sort and filter.mp4

09:09

7. Base formulas

1. SUM, MAX, MIN, AVERAGE (Calculation functions).mp4

09:09

2. Lock cells.mp4

05:43

3. COUNT, COUNTA, COUNTBLANK (Count functions).mp4

05:44

4. IF (Conditional function).mp4

03:57

5. RIGHT, LEFT, MID, UPPER, LEN (Text functions).mp4

03:40

6. CONCAT, TEXTJOIN (Text functions).mp4

03:51

7.1 Foodsales Dataset 8.0.xlsx

7. Show formulas.mp4

01:01

8. Options and views

1. Personalizing Views, Ribbon, Quick Acces Toolbar.mp4

07:56

2. Workbook properties.mp4

06:10

9. Import Data

1. .TXT and .CVS import formats.mp4

07:19

2.1 incidents dataset 1.0.zip

2.2 Safety Dataset 11.0.xlsx

2. Import project dataset.mp4

02:38

10. Format and Summarize Data

1. Text to columns function.mp4

03:37

2. Clean the dataset.mp4

03:38

3. Conditional formatting.mp4

07:09

4. Find and remove duplicates.mp4

04:02

5. Go-to function.mp4

03:49

6.1 Safety Dataset 12.0.xlsx

6. Sparklines.mp4

06:28

11. Intermediary Formulas

1. Nested IF, IFS.mp4

05:34

2. AND, OR.mp4

05:08

3. COUNTIF, SUMIF, AVERAGEIF.mp4

04:28

4. COUNTIFS, SUMIFS, AVERAGEIFS (Multiple criteria).mp4

04:17

5.1 Safety Dataset 13.0.xlsx

5. MINIFS, MAXIFS.mp4

04:07

12. Dates Formulas

1. TODAY, NOW.mp4

01:50

2. YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.mp4

02:02

3. WEEKDAY, WORKDAY, NETWORKDAYS.mp4

03:35

4. SWITCH.mp4

02:12

5.1 Safety Dataset 14.0.xlsx

5. Apply dates functions to the dataset.mp4

04:42

13. Charts

1. Create a chart.mp4

05:44

2.1 Safety Dataset 15.0.xlsx

2. Modify chart elements and format.mp4

05:52

14. Lookup formulas

1. VLOOKUP, HLOOKUP.mp4

08:45

2.1 Safety Dataset 16.0.xlsx

2. INDEX, MATCH.mp4

04:42

15. Formatting Data

1. Data validation.mp4

10:36

2. Grouping Data.mp4

03:05

3. Subtotals.mp4

05:19

4. Formula-based conditional formatting.mp4

06:23

5.1 Safety Dataset 17.0.xlsx

5. Manage conditional formatting rules.mp4

04:28

16. Advanced functions management

1. PMT, NPER.mp4

04:29

2. Scenario manager.mp4

05:13

3. Goal seek.mp4

02:59

4.1 Safety Dataset 18.0.xlsx

4. Error checking.mp4

08:50

17. Pivot Tables

1. Create a pivot table.mp4

09:17

2. Modify a pivot table.mp4

07:53

3. Values options and Cell formats.mp4

06:25

4. Pivot table options and dynamic filters.mp4

06:10

5. Pivot charts.mp4

02:58

18. Advanced Charts

1. Tree Map and Sunburst.mp4

06:11

2. Histogram.mp4

03:40

3. Box & Whisker.mp4

07:06

4. Filled map.mp4

02:25

5. Waterfall.mp4

01:13

6. Funnel.mp4

02:04

7.1 Safety Dataset 19.0.xlsx

7. Combo.mp4

05:27

19. Macros

1. Record a macro.mp4

06:24

2. Control buttons.mp4

01:56

3. Form controls.mp4

04:45

4.1 safety dataset 20.0.zip

4. Copy macros with VBA.mp4

04:22

20. Advanced Workbook Options

1. Link data.mp4

05:07

2. Protect Sheet.mp4

06:13

3. Macros on protected sheets.mp4

03:34

4. Protect Workbook.mp4

01:33

5.1 safety dataset 21.0.zip

5. Recover Workbook (Autosave - Autorecover).mp4

02:47

Description

Everything you need: Excel functions, Excel formulas, Excel Macros, VBA, Pivot Tables, Excel options.

What You'll Learn?

Gain a deep understanding of basic Excel functions and formulas to perform precise data analysis and calculations.
Develop the skills to effectively manage and analyze data in Excel, and visualize the insights through charts and graphs.
Enhance your data representation skills by creating impactful charts and graphs in Excel, and choosing the right chart type to communicate insights effectively.
Improve work efficiency by acquiring advanced Excel techniques like macros, conditional formatting, and data validation, and apply these in real situations.
Streamline your work processes and optimize efficiency by using advanced Excel techniques.

Who is this for?

Students: This course is suitable for students of all levels who want to enhance their Excel skills for academic or personal use.

Working Professionals: The course is designed for people of all ages in the work environment who want to improve their Excel skills to increase their productivity and efficiency.

Job Seekers: The course is ideal for individuals who are seeking a competitive edge in the job market and want to demonstrate their Excel proficiency to potential employers.

MOS Exam Preparation: The course is also suitable for individuals who are preparing for the Microsoft Office Specialist (MOS) Excel certification exam.

Anyone Interested in Improving their Excel Skills: This course is suitable for anyone who wants to improve their Excel skills, regardless of their background or experience level. The course is designed to be comprehensive and accessible to all.

More details

Description
This comprehensive beginner to advanced Excel course covers a wide range of essential topics to help you become a master in the software. The main topics include:

Introduction to Excel interface and navigation, which provides a foundation for the rest of the course and helps you to get familiar with the basic components of the software.
Basic and advanced formulas and functions, such as SUM, AVERAGE, IF, INDEX, MATCH, and VLOOKUP. You will learn how to create and use formulas to perform calculations, perform logical tests, and look up data from other worksheets.
Cell formatting and data management techniques, including sorting and filtering. You will learn how to format cells, sort and filter data, and create dynamic data ranges.
Creating charts and graphs to visually represent data. You will learn how to choose the right chart type, format charts, and add custom data labels.
Pivot tables, a powerful data analysis tool in Excel, used for aggregating, categorizing, and analyzing data. You will learn how to create pivot tables, format pivot tables, and create pivot charts.
Macros and VBA, which automate tasks and repeat sequences of actions with a single command. You will learn how to record macros, edit macros, and use VBA to create custom functions and procedures.
Collaboration and sharing features. You will learn how to share workbooks, resolve conflicts, and use version history to track changes.
Data validation and protection, including data validation rules, password-protecting workbooks, and protecting worksheet elements. You will learn how to validate data, set password protection, and protect cells, ranges, and worksheets.
Advanced charting and dashboard creation, using techniques such as conditional formatting, sparklines, and data bars. You will learn how to create interactive charts and dashboards, apply conditional formatting, and create custom charts and graphs.
Managing and analyzing large data sets using advanced techniques. You will learn how to analyse data and connect to external data sources.
With this comprehensive course, people of all ages and backgrounds can become Excel experts, regardless of their prior experience with the software.
Who this course is for:
Students: This course is suitable for students of all levels who want to enhance their Excel skills for academic or personal use.
Working Professionals: The course is designed for people of all ages in the work environment who want to improve their Excel skills to increase their productivity and efficiency.
Job Seekers: The course is ideal for individuals who are seeking a competitive edge in the job market and want to demonstrate their Excel proficiency to potential employers.
MOS Exam Preparation: The course is also suitable for individuals who are preparing for the Microsoft Office Specialist (MOS) Excel certification exam.
Anyone Interested in Improving their Excel Skills: This course is suitable for anyone who wants to improve their Excel skills, regardless of their background or experience level. The course is designed to be comprehensive and accessible to all.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Andrea Maddes

Instructor's Courses

Hello, I'm Andrea, a 26-year-old business analyst and MOS specialist from Switzerland. I have a Bachelor's degree in Economics and a passion for IT, especially Excel. I have a deep understanding of the software and a strong commitment to helping others master it.I'm fluent in 5 languages, which gives me a better perspective on how to communicate concepts in a simple and accessible way. My goal is to share my knowledge and passion for Excel with others, and to help them achieve their goals and reach their full potential with the software.In my daily work, I use Excel extensively and I'm always striving to improve my skills and knowledge. I'm a dedicated learner, constantly exploring new features and techniques to expand my capabilities and stay ahead of the curve.Join me on this journey and discover how Excel can transform your work and life!

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.