Complete Excel 2016 - Microsoft Excel Beginner to Advanced (Udemy.com)

Master Microsoft Excel quickly & easily. Microsoft Excel beginner to Excel pro - Excel 2010, Excel 2013, Excel 2016, 365

Created by: Steve McDonald

Produced in 2021

icon
What you will learn

  • 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.

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

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 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 2016
  • 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 to date.
I'll see you in there!
Who this course is for:
  • Anyone who wants or needs to learn Microsoft Excel for their work.
  • Anyone who wishes to improve their job or career prospects in an office environment.
  • Designed for beginners who are brand new to Excel (also suitable for intermediate Excel users who want to improve).

icon
Instructor Details

placeholder

Learning is easier if you are given the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals.
My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught techno geek.
The benefit to you is that I'm a geek who still speaks the language of normal human beings.
I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.
I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.
I'm always happy to help. I believe in you, and I'm here to support you in your learning process.
Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.
Sign

icon
More courses by Steve McDonald

EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

$11.99

Excel Formulas & Functions - Find Answers in Your Excel Data

$11.99

Microsoft Excel - Excel with The Ultimate Excel Course

$11.99

Microsoft Access: Complete MS Access Mastery for Beginners

$11.99

Write to Ignite - Master the Art of Sales Copy & Copywriting

$11.99

Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

$11.99

icon
Reviews

4.6

96 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Very nice.

yes I'm a beginner and when I tried self teaching without any excel training it was a disaster! LOL

I'm really enjoying this course so far. The instructor communicates clearly and seems to be very thorough.

This course seems pretty comprehensive so far, I just in the first section.

So far it seems like a good course.

This instructor goes straight to the point. The explanations are clear, as well as the given examples. If I had discovered it earlier, it would have saved me a lot of time.

Muy práctico!

Good, clear instructions & easy to understand

This course and the Tutor is amazing. Very organised and practice oriented.
This is for complete beginner and intermediate excel expert people who will improve their skills at the end of this course.
Great value for money !!

Steve is a great teacher.

great overview of ribbon

Yes. very helpful course.