Have a question?
Message sent Close
4.79 out of 5
4.79
1494 reviews on Udemy

Complete Excel Mastery: Microsoft Excel Beginner to Advanced

Master Microsoft Excel quickly & easily. Microsoft Excel beginner to Excel pro - Excel 2010, Excel 2013, Excel 2016, 365
Instructor:
Steve McDonald
29.096 students enrolled
English [Auto]
Feel confident using Excel in the workplace.
Be able to create and navigate Excel spreadsheets.
Be able to create tables, charts, pivot tables and more.
Use all of the most common formulas and functions.
Use keyboard shortcuts and productivity hacks to get more done faster.
While I can't make promises, my goal is to help you get the raise, promotion, or new job that you deserve.

Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

Excel is one of the most important skills in today’s job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

If you need to know Excel, you’re in the right place. 

This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

This course was created using Excel 2016, but it is good for versions 365, 2019, 2013 and 2010, as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn’t cover Mac-specific keyboard shortcuts and interface.

We’ll start at the very beginning, with opening and saving a worksheet in Excel. 

I’ll show you what all the tools do and walk you through each Excel skill that you need to know.

I’ll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I’ll teach you amazing keyboard shortcuts to make your work faster and more productive. You’ll learn how to record macros so you can do a whole series of actions with the just click of a button.

We’ll keep going until you’re a pro at Excel. When you finish this course, you’ll know more than most people who use Excel at their job every day.

Here’s some of what you’ll learn.

  • Creating spreadsheets in Excel

  • Saving your work where you can find it

  • Working with multiple workbooks in Excel

  • Formatting and printing

  • Importing data from CSV files, Access and the web

  • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others

  • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more

  • Creating tables

  • Sorting and filtering your data

  • Creating pivot tables

  • Creating pivot charts from your pivot tables

  • Fun New features for Excel

  • Keyboard shortcuts to make your work go faster

  • How to record basic macros to automate repetitive tasks

  • A whole lot more

The course comes with a certificate of completion, a full 30-day money back guarantee, and I’m always available to answer questions or share additional resources if you get stuck.

Thanks for checking out my biggest Excel course ever!

I’ll see you in there!

Creating Your First Excel Document

Other Popular Excel Functions

Creating Charts From Your Spreadsheet

Pivot Tables and Pivot Charts

New Features for Excel 2016

Saving Your Work

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.8
4.8 out of 5
1494 Ratings

Detailed Rating

Stars 5
830
Stars 4
504
Stars 3
137
Stars 2
15
Stars 1
8
861379e19bd5feb464efe50b60568c3f

Includes

13 hours on-demand video
6 articles
Certificate of Completion

Lưu trữ

Chuyên mục

  • Không có chuyên mục
Dark mode