Master Microsoft Excel: From Beginner to Pro!

Focused View

Marcus Gybäck

7:37:33

0 View

1. Introduction

1. Introduction.mp4

02:57

2. Covering the basics of Excel

1. Excel Home screen.mp4

02:32

2. The interface inside of Excel.mp4

04:30

3. Excel workbook and status bar.mp4

03:11

4.1 Shortcuts Mac.pdf

4.2 Shortcuts Windows.pdf

4. Excel shortcuts and how to use them.mp4

03:47

5. Excel Basics Quiz.html

3. Formulas and Text editing

1. Working with Excel spredsheet titles.mp4

03:23

2. Numberic data and how we can work with it in Excel.mp4

06:33

3. Working with Date values and date formating in Excel.mp4

05:26

4. Cell references and how they work in Excel.mp4

03:41

5. How to work with formulas.mp4

05:20

6. Absolute and relative references in Excel.mp4

07:12

7. Formulas Quiz.html

4. Basic functions in Excel

1. The SUM() function.mp4

05:01

2. How MIN(), MAX() and AVARAGE() functions works.mp4

07:55

3. What is the Adjacent error in Excel.mp4

03:38

4.1 Top-30-useful-excel-functions.pdf

4. Lets learn the CEILING(), FLOOR() and COUNT() functions.mp4

08:20

5. Auto sum in Excel.mp4

06:21

6. Excel AutoFill.mp4

03:27

7. Excel Functions Quiz.html

5. Excel data formatting

1. Formatting our fonts.mp4

05:07

2. Working with background colors.mp4

03:49

3. Adding borders and border-styles.mp4

03:25

4. Adding our currency.mp4

02:41

5. Formatting percentage in Excel.mp4

02:01

6. Excels format painter.mp4

03:00

7. Creating custom styles in Excel.mp4

06:52

8. Creating some formatting based on conditions.mp4

06:40

9. Merging cells together.mp4

02:28

10. Excel Formatting Quiz.html

6. Tweak an worksheet in Excel

1. Moving data inside an worksheet or between workbooks.mp4

05:35

2. Editing the width and height of cells.mp4

03:12

3. Adding Removing rows and columns.mp4

03:11

4. Hiding and showing rows or columns.mp4

03:45

5. Copying or moving an Excel worksheet.mp4

03:45

6. Removing a worksheet or changing a name of a worksheet.mp4

04:25

7. Worksheet Tweaks Quiz.html

7. Working with Charts, Images and Shapes in Excel

1. Adding Excel shapes to our worksheet.mp4

05:04

2. Adding images into our worksheet.mp4

03:41

3. How we can work with Excel smartArt in our worksheet.mp4

04:38

4. Creating an line chart in excel and playing around with the chart ribbon.mp4

03:34

5. Changing the data in our line-chart and moving the line chart.mp4

06:55

6. Changing the chart type and adding a bit of formating.mp4

02:58

7. Chart, Images and Shapes Quiz.html

8. Excel templates and how to work with them

1. Excel template into.mp4

01:42

2. Working with and creating templates.mp4

12:02

3. Excel Templates Quiz.html

9. Great job! You now have a Microsoft Excel Foundation!

1. Lets do a recap on what we have done.mp4

02:31

10. Working with lists inside of Excel

1.1 Employment.xlsx

1. The structure of an Excel list.mp4

04:42

2. Multi-Level and Single-Level list sorting.mp4

05:18

3. Custom sort and filtering a list in Excel.mp4

06:55

4. Finding and removing duplicates.mp4

05:48

5. Convert a list to a table.mp4

04:52

6. Excel List Quiz.html

11. List functions in Excel

1.1 division sales new 200.xlsx

1. The DSUM() function.mp4

05:57

2.1 division sales new 200.xlsx

2. DSUM() With AND-statements or OR-statements.mp4

06:30

3. The DCOUNT() function.mp4

03:40

4. The DAVERAGE() function.mp4

03:47

5. List Functions Quiz.html

12. Import Export Data

1.1 names data.xlsx

1. Export data to a text file in Excel.mp4

04:30

2. Import data from a text file in Excel.mp4

07:53

3. Import Export Quiz.html

13. Data validation in Excel

1.1 Leads.xlsx

1. Data validation List.mp4

06:45

2.1 Excel email validation formula.txt

2. Excel Email validation.mp4

05:30

3. Excel date validation.mp4

05:49

4. Excel Text validation.mp4

04:19

5. Data Validation Quiz.html

14. Working with large sets of data

1. Grouping column and rows together.mp4

02:53

2. Freeze Panes.mp4

03:08

3. Working with printing options for large sets of data.mp4

04:42

15. PivotTables

1.1 perfume sales.xlsx

1. The power of PivotTables.mp4

02:11

2. Building our first PivotTable.mp4

03:47

3. Grouping and Formatting Data in our PivotTable.mp4

06:06

4. PivotCharts.mp4

05:33

5. Filtering data in our PivotTable.mp4

04:41

6. Styling our slicer.mp4

02:45

7. Modifying sourceData for our PivotTable.mp4

04:18

8. PivotTable Quiz.html

16. WOW! You are now a midpro in excel!

1. Lets do a small recap on what we have done.mp4

03:13

17. Protecting out workbook or worksheet

1. Protecting cells in our worksheet.mp4

00:48

2. Adding a password to our workbook and protecting the workbook structure.mp4

06:42

3. Excel Protection Quiz.html

18. Conditional functions in Excel

1.1 Sales competition 2024.xlsx

1. Excels name ranges.mp4

05:37

2. The IF() function.mp4

04:31

3. Nesting functions inside of Excel.mp4

04:58

4. The COUNTIFS() function.mp4

03:07

5. The SUMIFS() function.mp4

05:27

6. Conditional Functions Quiz.html

19. Textbased functions in Excel

1.1 products.xlsx

1. The Left(), Right(), Mid() and Len() functions.mp4

05:00

2. Using IF(), LEN() and RIGHT() functions together.mp4

03:56

3. Using the SEARCH() and CONCATENATE() functions.mp4

08:00

4. Textbased Functions Quiz.html

20. Lookup functions in Excel

1.1 employee sheet vlookup.xlsx

1. The VLOOKUP() function.mp4

07:05

2. IFERROR() function.mp4

03:40

3. Working with absolute values in our lookup functions.mp4

03:10

4. The HLOOKUP() function.mp4

05:44

5. The MATCH() and INDEX() functions.mp4

09:19

6. Using MATCH() AND INDEX() together.mp4

05:03

21. Excel Automations with Macros

1. Introduction into Excel macros.mp4

03:20

2. Creating our first macro.mp4

09:21

3. Saving our workbook with our macro.mp4

02:25

4.1 Macro.xlsx

4. How to edit our macro with VBA.mp4

05:43

22. Becoming a master in the What if tools inside of Excel

1.1 CarLoan.xlsx

1. Working with the PMT() function and Goalseek tool.mp4

07:10

2.1 shipping cost.xlsx

2. The solver tool.mp4

06:27

3. Data Tables.mp4

05:15

4.1 Scenarios.xlsx

4. Creating Scenarios.mp4

05:54

23. Excel Auditing

1. Dependents and Precendents tracing in Excel.mp4

05:21

2. Show Formulas and Evaluate Formulas.mp4

04:19

3. Error Checking.mp4

03:07

4. Watch Windows in Excel.mp4

03:59

24. Wrapping up the course

1. Congratulations! Youre now a master in Excel!.mp4

01:18

Description

Unlock the full potential of Microsoft Excel and become a valuable asset in any data-driven environment today!

What You'll Learn?

Become a pro in Excel, from beginner to Advanced
Excel fundementals
Formattings in Excel
Working with charts in Excel
Excel templates
Data validations in Excel
Pivot tables
Conditional logic and functions
Excel Macros

Who is this for?

If you want to learn Excel from beginner to advanced this course is for you.

If you want to take your excel skills to the next level this course is for you

What You Need to Know?

No prior Excel knowledge required

Microsoft Excel 2010, 2013, 2019 or Microsoft 365 to follow along in the course

More details

Description
Welcome to "Learn Excel from Beginner to Pro," your comprehensive guide to mastering Excel, the industry-standard spreadsheet software. Whether you're a novice or looking to enhance your existing skills, this course is designed to take you from the basics to advanced functionalities.

We start with Covering the Basics of Excel, ensuring you understand the interface, navigation, and essential features. Youâ€™ll learn about Formulas and Text Editing, giving you the foundation to perform calculations and manipulate text effectively.
Next, we delve into Basic Functions in Excel, covering fundamental operations like SUM, AVERAGE, and COUNT. Excel Data Formatting teaches you how to present your data clearly, making it easy to read and professional.

Youâ€™ll learn how to Tweak a Worksheet in Excel, customizing it to suit your needs. Our section on Working with Charts, Images, and Shapes in Excel helps you visualize data, making it more accessible and engaging.
Explore Excel Templates and How to Work with Them to streamline your workflow. We also cover Working with Lists Inside of Excel, teaching you to organize and manage data efficiently, along with List Functions in Excel to sort, filter, and analyze information.

In Import/Export Data, youâ€™ll learn to seamlessly move data between Excel and other programs. Our module on Data Validation in Excel ensures your data entries are accurate and consistent.
Handling large datasets can be daunting, but our segment on Working with Large Sets of Data equips you with techniques to manage and analyze vast amounts of information. PivotTables are powerful tools for summarizing data, and youâ€™ll master creating and manipulating them.

Protecting your work is crucial, so we include lessons on Protecting Your Workbook or Worksheet, ensuring your data stays secure. Conditional Functions in Excel allow you to perform actions based on specific criteria, while Lookup Functions in Excel help you search and retrieve data efficiently.
By the end of this course, youâ€™ll have the skills and confidence to use Excel proficiently, making you a valuable asset in any data-driven environment. Join us in "Learn Excel from Beginner to Pro" and unlock the full potential of Excel!
Who this course is for:
If you want to learn Excel from beginner to advanced this course is for you.
If you want to take your excel skills to the next level this course is for you

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Marcus Gybäck

Instructor's Courses

Hi!My name is Marcus and i'm a full stack web developer and architect.I've been coding since i was 8 but worked with development since 2011. I've been working with languages like PHP, Javascript, HTML, CSS, Python and have been using frameworks like Laravel, React, React-native.In my spare time i like to go out in the nature, away from the computer and code.

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.