4.66 out of 5
4.66
412045 reviews on Udemy

Microsoft Excel – Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2023
Instructor:
Kyle Pew
1,374,327 students enrolled
English [Auto] More
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Access to a Professional Trainer with 10+ years of Excel Training

Microsoft Excel all in One Package

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 – An Introduction to Excel

  • Microsoft Excel 102 – Intermediate Level Excel

  • Microsoft Excel 103 – Advanced Level Excel

  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Recent Student Review

  • You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don’t doubt it, buy it. I’ve learned so much in this course. Hope more courses are on the way because I’d buy every single one of them. Thanks again bro. God bless you and your family.

  • Happy to say that I now “know” excel. I realize there is so much more to learn, but it’s a start! Thank you for being such a great instructor… now on to the next class.

  • Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them.

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA

What’s Included?

  • 18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)

  • Downloadable Exercise Files to follow along and practice with

  • Additional Exercise Files are provided at the end of each major section (101, 102, 103 and VBA) that you can download and practice the skills you’ve learned

  • Section Quizzes to Test Your Knowledge on the Lecture Topics

  • QA board where you can post questions, screenshots of your progress and communicate with the instructor and fellow students in the course.

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Microsoft Excel 101 Course Introduction

1
Ask Questions

Participants are encouraged to ask questions throughout the course to enhance their understanding.

2
Course Exercise Files

Downloadable exercise files are provided to facilitate hands-on learning.

3
Certificate of Completion

Upon course completion, participants have the opportunity to earn a certificate as recognition.

Microsoft Excel Fundamentals

1
Launching Excel

Learn how to open Microsoft Excel and access its features.

2
Microsoft Excel Startup Screen

Explore the initial screen and its functionalities.

3
Introduction to the Excel Interface

Get acquainted with the Excel user interface.

4
Customizing the Excel Quick Access Toolbar

Discover how to personalize the Quick Access Toolbar for efficiency.

5
More on the Excel Interface

Dive deeper into Excel's interface components.

6
Understanding the Structure of an Excel Workbook

Gain insight into the structure of Excel workbooks.

7
Saving an Excel Document

Understand the process of saving Excel files.

8
Opening an Existing Excel Document

Learn how to access and work with previously created Excel files.

9
Common Excel Shortcut Keys

Master essential keyboard shortcuts for increased productivity.

10
Excel Fundamentals Quiz

Test your knowledge of Excel fundamentals through a quiz.

Entering and Editing Text and Formulas

1
Entering Text to Create Spreadsheet Titles

Explore techniques for entering text to create informative spreadsheet titles.

2
Working with Numeric Data in Excel

Understand how to input and manipulate numeric data effectively.

3
Entering Date Values in Excel

Learn the ins and outs of entering date values accurately.

4
Working with Cell References

Master the use of cell references in Excel formulas.

5
Creating Basic Formulas in Excel

Get hands-on experience in creating basic Excel formulas.

6
Relative Versus Absolute Cell References in Formulas

Differentiate between relative and absolute cell references.

7
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)

Grasp the order in which Excel calculates formula operations.

8
Entering and Editing Text and Formulas Quiz

Assess your proficiency with a quiz on text and formula entry and editing.

Working with Basic Excel Functions

1
The structure of an Excel Function

Learn about the components and structure of Excel functions.

2
Working with the SUM() Function

Understand how to use the SUM function to total values.

3
Working with the MIN() and MAX() Functions

Explore the MIN and MAX functions for finding minimum and maximum values.

4
Working with the AVERAGE() Function

Discover how to calculate averages using the AVERAGE function.

5
Working with the COUNT() Function

Learn to count cells containing data with the COUNT function.

6
Adjacent Cells Error in Excel Calculations

Understand and troubleshoot errors that may occur in Excel calculations.

7
Using the AutoSum Command

Simplify summation with the AutoSum command.

8
Excel's AutoSum Shortcut Key

Speed up calculations with a handy keyboard shortcut.

9
Using the AutoFill Command to Copy Formulas

Efficiently replicate formulas using the AutoFill command.

10
Basic Excel Functions Quiz

Test your knowledge of basic Excel functions with an interactive quiz.

Modifying an Excel Worksheet

1
Moving and Copying Data in an Excel Worksheet

Learn how to rearrange and duplicate data within a worksheet.

2
Inserting and Deleting Rows and Columns

Discover methods for adding or removing rows and columns.

3
Changing the Width and Height of Cells

Customize cell dimensions to accommodate your data.

4
Hiding and Unhiding Excel Rows and Columns

Control the visibility of rows and columns as needed.

5
Renaming an Excel Worksheet

Learn how to rename worksheets to improve organization.

6
Deleting an Excel Worksheet

Explore the process of removing unnecessary worksheets.

7
Moving and Copying an Excel Worksheet

Master techniques for relocating or duplicating entire worksheets.

8
Modifying Worksheets Quiz

Test your skills in worksheet modification through a quiz.

Formatting Data in an Excel Worksheet

1
Working with Font Formatting Commands

Explore font formatting options to style your text.

2
Changing the Background Color of a Cell

Customize cell backgrounds for visual impact.

3
Adding Borders to Cells

Apply borders to cells for improved data separation.

4
Excel Cell Borders Continued

Delve deeper into cell border formatting.

5
Formatting Data as Currency Values

Format numbers as currency for financial presentations.

6
Formatting Percentages

Learn to display numbers as percentages.

7
Using Excel's Format Painter

Copy formatting from one cell to another with the Format Painter tool.

8
Creating Styles to Format Data

Create and apply custom styles to format data consistently.

9
Merging and Centering Cells

Combine cells and center content for neat formatting.

10
Using Conditional Formatting

Apply conditional formatting rules to highlight specific data conditions.

11
Editing Excel Conditional Formatting

Modify and manage conditional formatting rules.

12
Formatting Data Quiz

Assess your knowledge of Excel data formatting through a quiz.

Inserting Images and Shapes into an Excel Worksheet

1
Inserting Images

Learn how to add images to Excel worksheets.

2
Inserting Excel Shapes

Discover how to insert various shapes into your Excel documents.

3
Formatting Excel Shapes

Customize the appearance and properties of shapes.

4
Working with Excel SmartArt

Explore SmartArt graphics to visually represent information.

Creating Basic Charts in Excel

1
Creating an Excel Column Chart

Learn to create column charts to visualize data.

2
Working with the Excel Chart Ribbon

Explore chart-related options in the Excel Ribbon.

3
Adding and Modifying Data on an Excel Chart

Modify chart data to reflect changes in your worksheet.

4
Formatting an Excel Chart

Customize chart elements for better presentation.

5
Moving a Chart to another Worksheet

Relocate charts to different worksheets for organization.

6
Working with Excel Pie Charts

Create and work with pie charts to represent data.

7
Microsoft Excel Charts Quick Guide (DOWNLOAD)

Download a quick reference guide for Excel charts.

8
Working with Excel Charts Quiz

Test your knowledge of Excel chart creation and management.

Printing an Excel Worksheet

1
Viewing your Document in Print Preview

Review how your document will appear when printed.

2
Changing the Margins, Scaling and Orientation

Adjust page margins, scaling, and orientation for printing.

3
Excel Worksheet Margins

Explore margin settings for better page layout control.

4
Working with Page Layout View

Utilize Page Layout View to optimize your worksheet for printing.

5
Adding Header and Footer Content

Include custom headers and footers in printed worksheets.

6
Printing a Specific Range of Cells

Print only selected cells or ranges from your worksheet.

7
Printing an Excel Worksheet Quiz

Test your knowledge of Excel printing options and settings.

Working with Excel Templates

1
Intro to Excel Templates

Understand the concept of Excel templates.

2
Opening an Existing Template

Learn how to open pre-designed Excel templates.

3
Creating a Custom Template

Create your own custom Excel templates to streamline tasks.

4
Excel Templates Quiz

Assess your understanding of Excel templates with a quiz.

Excel 101 - Practice What You've Learned (DOWNLOAD)

1
Excel 101 - Practice What You've Learned (DOWNLOAD)

Access practice exercises to apply and solidify your Excel skills.

Congratulations! You've Built a Solid Microsoft Excel Foundation

1
Congratulations!

Celebrate your achievement in building a strong foundation in Microsoft Excel.

Microsoft Excel 102 Course Introduction

1
Excel 102 Course Exercise Files -- DOWNLOAD

Download exercise files for hands-on practice.

Working with an Excel List

1
Understanding Excel List Structure

Gain an understanding of the structure of Excel lists.

2
Sorting a List Using Single Level Sort

Learn how to sort lists with single-level sorting.

3
Sorting a List Using Multi-Level Sorts

Explore multi-level sorting techniques.

4
Using Custom Sorts in an Excel List

Customize sorting to fit your specific needs.

5
Filter an Excel List Using the AutoFilter Tool

Filter list data using the AutoFilter tool.

6
Creating Subtotals in a List

Add subtotals to organize and summarize list data.

7
Format a List as a Table

Convert a list into a structured Excel table.

8
Using Conditional Formatting to Find Duplicates

Apply conditional formatting to identify duplicate entries.

9
Removing Duplicates

Learn how to remove duplicate entries from a list.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
412045 Ratings

Detailed Rating

Stars 5
250621
Stars 4
132280
Stars 3
24711
Stars 2
2924
Stars 1
1668
569f2464895357c1d3804287f8489f4b

Includes

21 hours on-demand video
15 articles
Certificate of Completion
Go to Top