Ultimate Microsoft Excel Course: Beginner to Excel Expert

Focused View

Alan Murray

15:18:35

107 View

01 - Introduction

001 Introduction to the Ultimate Excel Course.mp4

03:15

002 Download your Exercise Files.html

002 ultimate-excel-course-practise-files.zip

02 - Working with Large Worksheets

001 Keeping your Headings Visible as you Scroll.mp4

03:50

002 Splitting a Worksheet to Reference Two Different Areas.mp4

03:50

003 Hiding and Unhiding Columns.mp4

02:47

004 Sorting a Large List - Including a Super Shortcut.mp4

06:20

005 Filtering a List - One of the Most Useful Excel Skills you will EVER Need.mp4

07:10

03 - 5 Essential Tricks for Printing Spreadsheets

001 Scaling a Print to Fit onto Fewer Pages.mp4

05:26

002 Repeating your Headers Across Multiple Pages.mp4

03:06

003 Printing a Selected Range and Setting a Print Area.mp4

04:06

004 Aligning a Print on a Page.mp4

02:30

005 Using Page Breaks to Logically Break Up a Print.mp4

04:29

04 - Getting Started with Excel Formulas

001 Introduction to Formulas - Writing your First Excel Formulas.mp4

07:50

002 The Order of Calculation - BODMAS.mp4

03:13

003 Calculating Percentages.mp4

07:54

004 Unleash the Power of Excel Functions.mp4

08:44

005 Referencing other Sheets and Workbooks.mp4

11:45

006 Calculating Date Difference including Working Days Only.mp4

08:09

007 Understand Absolute Cell Addresses.mp4

06:22

008 The COUNTIF Function - An Incredibly Useful Function.mp4

13:12

009 Exercise 1 Writing Formulas.html

010 Exercise 2 Absolute References.html

011 Exercise 3 Using Functions.html

012 Exercise 4 Calculating Percentage IncreaseDecrease.html

05 - Logical Functions The Decision Making Formulas of Excel

001 IF Function 1 - Testing if a Value is Larger than a Specific Value.mp4

04:23

002 IF Function 2 - Testing if a Cell Contains Certain Text.mp4

03:52

003 IF Function 3 - Tracking Due Dates by Testing if they are Overdue.mp4

04:06

004 Using Multiple IF Functions - Nested IFs.mp4

04:50

005 AND and OR Functions for Testing Multiple Conditions.mp4

06:35

006 The IFS Function - No More Nested IFs.mp4

04:10

007 The SWITCH Function - Another Alternative to Complex Nested IFs.mp4

09:00

008 Exercise Logical Functions.html

06 - Conditional Formatting - Make your Data Come to Life

001 Create your First Conditional Formatting Rules.mp4

07:02

002 Managing Multiple Rules and Dealing with Conflicts.mp4

07:09

003 Conditional Formatting to Highlight Expired and Due Dates.mp4

07:23

004 Applying Data Bars to Compare Values or Show Progress.mp4

06:21

005 Create a Heat Map using Colour Scales.mp4

03:02

006 Using Icon Sets to Show Monthly Comparisons.mp4

08:04

007 Applying Conditional Formatting to the Entire Row.mp4

04:31

008 Testing Multiple Conditions with the AND Function.mp4

06:42

009 Exercise Working with Conditional Formatting.html

07 - Dynamic Array Functions - Formulas Have Changed

001 Introduction to Dynamic Arrays.mp4

11:54

002 The UNIQUE Function.mp4

08:20

003 The SORT Function - Sort Formula Results Automatically.mp4

08:25

004 The SORTBY Function - Sort by Any Column.mp4

06:54

005 The FILTER Function - Lookup and Return Multiple Values.mp4

20:03

006 The SEQUENCE Function.mp4

10:33

08 - Lookup Functions - The Powerful VLOOKUP Function and beyond

001 The VLOOKUP Function Explained.mp4

07:00

002 Using VLOOKUP for a Range Lookup.mp4

05:09

003 Advanced VLOOKUP with a Dynamic Column Index Number.mp4

08:59

004 Handling Error Messages with Lookup Formulas.mp4

05:24

005 A Versatile Lookup Formula - The INDEX and MATCH Combo.mp4

06:19

006 Two Way Lookup using INDEX and MATCH.mp4

04:16

007 Return Non-Adjacent Columns in an Array with INDEX and MATCH.mp4

06:19

008 XLOOKUP Function - The Successor to VLOOKUP and HLOOKUP.mp4

11:38

009 Multi-Column Lookup with XLOOKUP.mp4

03:20

010 Two-Way Lookup with XLOOKUP.mp4

04:41

011 Exercise Using the VLOOKUP Function.html

09 - Validating and Protecting Excel Data

001 Validate the Number of Characters.mp4

02:23

002 Create Date Validation Rules.mp4

02:23

003 Drop Down Lists for Easy Data Entry.mp4

04:35

004 Dependent Lists to Break up Large Lists.mp4

05:25

005 Create Custom Data Validation Messages.mp4

06:46

006 Encrypt a File from Unauthorised Access.mp4

02:48

007 Protect the Structure of a Workbook.mp4

05:46

008 Protect the Data on a Worksheet.mp4

07:50

009 Exercise Validating Data Entry.html

10 - Advanced Formulas for Analysing Data

001 Using SUMIF, COUNTIF and AVERAGEIF.mp4

08:00

002 Summing the Values between Two Dates.mp4

05:44

003 An Advanced Sum Formula with SUMPRODUCT.mp4

05:53

004 Summing Values by a Specific Weekday - SUMPRODUCT Example 2.mp4

09:37

005 The Secret AGGREGATE Function.mp4

07:38

006 An Advanced Array Example of AGGREGATE.mp4

04:51

007 Exercise Analysing Data with Formulas.html

11 - Charts - Simple and Effective Data Presentation

001 Creating your First Charts.mp4

07:36

002 Adding and Removing Chart Elements.mp4

05:23

003 Formatting Charts.mp4

06:42

004 Modify the Chart Axis.mp4

07:22

005 Save Time with Chart Templates.mp4

04:35

006 Combo Charts - Two Chart Types in One Chart.mp4

06:20

007 Chart Filters.mp4

02:29

008 Interactive Charts Change Chart Data with a Drop Down List.mp4

08:03

009 Using Cell Values for Chart Labels.mp4

04:28

010 Conditional Formatting with Charts.mp4

07:58

011 Using Sparklines for Quick Data Insights.mp4

06:03

012 Exercise Working with Charts.html

12 - Manipulating Text in Excel

001 Splitting Text across Multiple Columns.mp4

07:25

002 The CONCAT and CONCATENATE Functions.mp4

06:28

003 The TEXTJOIN Function.mp4

04:10

004 Extracting Text from a cell.mp4

09:34

005 Using the MID and FIND Functions Together.mp4

07:23

006 The VALUE Function.mp4

03:34

007 The SUBSTITUTE Function to Fix a Common Dependent List Problem.mp4

07:31

008 The Awesome Flash Fill Tool.mp4

10:07

009 Exercise Text to Columns.html

010 Exercise Extracting Data with Text Functions.html

13 - Formatting your Data Ranges as Tables for Easier Management

001 Formatting your Data Range as a Table.mp4

04:00

002 Exploring the Benefits of using Tables.mp4

07:50

003 Creating your own Table Style.mp4

04:42

004 Formulas using a Tables Structured References.mp4

06:51

005 Converting a Table back to a Normal Range.mp4

01:40

006 Exercise Managing Data with Tables.html

14 - Master PivotTables for Powerful Analysis and Reporting

001 Creating a PivotTable.mp4

08:09

002 Changing the Values Function.mp4

03:19

003 Formatting Values the Efficient Way.mp4

02:20

004 Creating a PivotTable Style.mp4

05:10

005 Sorting PivotTable Fields.mp4

02:37

006 Grouping Data in a PivotTable.mp4

04:55

007 Showing Values as a Percentage, Difference From and Ranking.mp4

05:11

008 Conditional Formatting with PivotTables.mp4

03:41

009 Filtering PivotTable Data.mp4

03:59

010 Refreshing a PivotTable.mp4

04:49

011 Creating a PivotChart.mp4

05:23

012 Using Slicers for Interactive PivotTables.mp4

11:56

013 Using the Timeline Slicer.mp4

02:55

014 Exercise Using PivotTables.html

015 Exercise 2 Using PivotTables.html

15 - Getting and Transforming Data with Power Query

001 What is Power Query.mp4

03:09

002 Installing the Power Query Add-In - Excel 2010 and Excel 2013 Only.html

003 Transforming Messy Data on a Worksheet - First Example of Power Query Magic.mp4

21:26

004 The Incredible Unpivot Feature of Power Query - Real Game Changer.mp4

07:01

005 Working with International Dates and Number Formats.mp4

10:04

006 Merge Queries - A VLOOKUP Alternative.mp4

10:03

007 Merge Queries - Exploring other Join Types.mp4

06:16

008 Combine and Append Multiple Worksheets into One.mp4

10:32

009 Importing Multiple Files from a Folder into One List - Incredibly Useful.mp4

15:08

010 Importing Data from the Web.mp4

12:46

011 Exercise Import & Transform Text File.html

012 Exercise Import Data from the Web.html

16 - Working with the Data Model and PowerPivot

001 Introduction to the Data Model and PowerPivot.mp4

07:00

002 Adding Tables to the Data Model and Creating Relationships between Tables.mp4

07:46

003 Creating a PivotTable from the Data Model.mp4

05:51

004 Enabling the PowerPivot Add-In.mp4

01:12

005 Exploring the PowerPivot Window.mp4

04:39

006 Introduction to DAX - Calculated Columns.mp4

07:37

007 Introduction to DAX - Measures.mp4

10:29

17 - Introduction to Macros and VBA

001 Recording your First Macro.mp4

14:28

002 Assigning your Macro to a Toolbar Button.mp4

06:42

003 Customising the Ribbon to Add your Macro Buttons.mp4

07:42

004 Editing your Macro Code 1.mp4

12:16

005 Using Relative References when Recording a Macro.mp4

06:38

006 Saving a Workbook Containing a Macro.mp4

05:31

007 Editing your Macro Code 2.mp4

06:08

008 Adding a Button to the Worksheet to Run your Macro.mp4

05:50

18 - Getting Started with Writing VBA

001 Introducing the Visual Basic Editor.mp4

07:38

002 Writing your First Macro.mp4

16:43

003 Cleaning Recorded Code.mp4

12:01

004 Working with Method Arguments.mp4

08:39

005 Referencing Cells, Worksheets and Workbooks in VBA.mp4

27:06

006 Errors in VBA.mp4

09:00

007 Exercise Recording & Editing Macros.html

008 Exercise Answer Recording & Editing Macros.mp4

08:35

Description

Master Excel with this Complete Excel Course. Learn Everything Right Now (Workbooks and Real-World Exercises included).

What You'll Learn?

Become a Confident and Well-Rounded Excel user
Learn new techniques that you will be able to apply right way
Learn to write Excel formulas from scratch, up to to rock star level
Utilise the awesomeness of Power Query to import, shape and transform data for analysis
Master some of the most important functions in Excel such as IF, VLOOKUP, INDEX, SUMIF and many more
Learn the latest Cutting-Edge Excel Tips and Features that most users will not have even heard of
Automate Daily Tasks with the power of Macros and VBA
Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support

Who is this for?

You currently use Excel and want to improve your skills

You have a job role that requires a strong level of Excel expertise and you want to get up to speed quickly

You work with Excel regularly but are looking for more advanced and well-rounded skills

Anyone looking to expand their skill set in Excel to help develop their career

What You Need to Know?

You have basic Excel knowledge. The lessons start from a beginner level, but not for complete newbies.

Any version of Excel can be used. The lessons will state if a specific version of Excel is needed for that technique.

More details

Description
â˜…â˜…â˜…â˜…â˜…Â Course access includes the exactÂ files I use to download andÂ follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guaranteeÂ â˜…â˜…â˜…â˜…â˜…
It is time to master Excel. If you are a beginnerÂ and want to develop your Excel skills or have the desire to be an Excel guru, you have come to the right place.
This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.
This course is perfect if you;
Use Excel every day but want to improve your all-round skills and become the office expert
Have a basic knowledge but want to take the plunge and develop your Excel muscles
Learn all the essential skills in Excel to help get a new job or promotion
The course has been designed as a one-stop shop for all of the essential skills of Excel. It is very comprehensive and you can come back again and again to revisit the material.
The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel and amazing features on the horizon - you can be sure to find lessons added to this course so that you stay ahead of the game.
I teach in a hands-on way with unique examples demonstrating all of the essential features of Excel. You will not only understand HOW these Excel tools and formulas work but see examples of WHY they are so awesome.
By the end of the course, you will be a confident user of Excel with theÂ skills to progress your career further,Â orÂ become the office Excel guru.
During the course you will learn;
To use the power ofÂ PivotTables toÂ summarise large amounts of data and produce dynamic reportsÂ in minutes.
Be confident in using over 50 of the most importantÂ ExcelÂ functions including INDEX, VLOOKUP, MID, IF, MATCH and COUNTIF.
CreateÂ charts in a flash that visualize data effectively.
Conditional Formatting toÂ highlight data comparisons, progress and issues.
Utilise the awesomeness of Power Query to import, shape and transform data.
Clean up messy data with formulas, Flash Fill and other Excel features.
Understand the data model in Excel and PowerPivot.
To useÂ macros to automate time-consuming tasks.
And much much more.
Why learn from me?
I have been training businesses all around the world on how to get the most out of Excel forÂ over 20 years.
Learning and teaching Excel is my passion. I am a full-timeÂ Excel trainer and a Microsoft MVP, so every day I am in the thick of the action teaching others to masterÂ Excel.
I set up theÂ Computergaga blog and YouTube channel > 13 years agoÂ where I am lucky enough to haveÂ taught millions of peopleÂ across the globeÂ to increase their skills and overcome everyday real-world Excel problems.
The course includes the exactÂ files thatÂ I use in the lessons to downloadÂ andÂ follow along, lifetime accessÂ and 1 on 1 instructor support every step of theÂ way.
Don't delay. Take action. Grab a coffee and let's get started.
Your journey towards mastering Excel starts today.Â
Who this course is for:
You currently use Excel and want to improve your skills
You have a job role that requires a strong level of Excel expertise and you want to get up to speed quickly
You work with Excel regularly but are looking for more advanced and well-rounded skills
Anyone looking to expand their skill set in Excel to help develop their career

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Alan Murray

Instructor's Courses

Alan Murray is a Microsoft MVP and an Excel & Power BI trainer. He has been training for over 20 years for businesses around the world.He is the founder of the Computergaga blog and YouTube channel. It has over 600 videos and more than 35 million views. He regularly shares new Excel tips and tutorials.He is the author of the "Advanced Excel Formulas" and "Advanced Excel Success" books, showing how to get to the next level in your Excel journey.Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses.Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours.

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.