EXCEL at Work - Complete MS Excel Mastery Beginner to Pro (Udemy.com)

Learn Excel 2016. Master Excel formulas, functions, pivot charts & Excel shortcuts. Also works w/Excel 2010 & Excel 2013

Created by: Steve McDonald

Produced in 2021

icon
What you will learn

  • Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons.
  • Learn all of the basics of opening an Excel document, creating a spreadsheet and saving your document to your computer.
  • Create a spreadsheet from scratch in Excel.
  • Use the most commonly used Excel functions to make powerful calculations.
  • Create your own Excel charts, graphs and tables.
  • Learn to use several of the new Excel 2016 features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
  • Create pivot tables and charts for lightening fast sorting and organizing.
  • Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016.

icon
Quality Score

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

Overall Score : 92 / 100

icon
Course Description

"Your Excel skills could land your next job."
- Fortune Magazine
A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.
Are you ready to land your next job and increase your pay by 13%?
This course is designed to teach you the basics and beyond of Excel 2016. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.
Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:
  1. Create a basic Kitchen Remodel Costs worksheet.
  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.
  3. Create professional looking pie charts, bar charts, column charts and more.
  4. Create a table and a range and sort your data.
  5. Create pivot charts and tables to do lightening fast analysis of your data.
  6. Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.
Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:
  1. VLOOKUP
  2. COUNT & COUNTA
  3. COUNTIF & COUNTIFS
  4. AVERAGE & AVERAGEA
  5. SUM, SUMIF & SUMIFS
  6. IF
  7. LEFT, RIGHT & MID
Here are more of the most sought after skills in Excel that are included in this course:
  1. Spreadsheets
  2. Tables
  3. Ranges
  4. Pie, Column, Bar and Line charts
  5. Pivot tables
  6. Pivot charts
  7. Tons of tips and tricks to make using Excel 2016 easier every day.
So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the TAKE THIS COURSE button or check out one of the free preview lectures to see if it's the perfect fit for you.Who this course is for:
  • This course is perfect for a first time beginner who needs to learn much more than just the basics.
  • This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
  • This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
  • This course would not be useful for an Excel user who has already reached the advanced or expert stage.

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

Complete Excel 2016 - Microsoft Excel Beginner to Advanced

$11.99

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

$11.99

icon
Reviews

4.6

389 total reviews

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

By Tasha Hatter on 12/27/2020

very helpful

By David Akinrotimi on 12/27/2020

Wow! This is the best lecture i have seen on Udemy. Thank you steve.

By Nakia Starling on 12/20/2020

The instructor thoroughly explains material in an easy to follow learning format. The learning modules are very valuable!

By Rohit Ghaghoria on 11/24/2020

Yes it is good as of now.

By Tommi finch on 11/18/2020

The layout is perfectly fine! I have A LOT to learn as I am a total beginner to Excel. I am excited, but I know I will take my time. I will say I have learned so much! And as with most skills and talents in life, practice makes perfect! I will definitely practice as I took notes on everything!

By Geogy Horing on 11/15/2020

well presented

By Ishimwe Christine on 11/11/2020

The course was well designed and cover very important skills.

By Ben Bool on 11/11/2020

Very informative and accomodating. Easy to follow, pause and go back where necessary. Lots of useful information.

By DUSHIME Jean de la Croix on 11/9/2020

try to decrease the speed

By Andreo J Mangawang on 11/4/2020

It is indeed very helpful for beginners.

By Gilberto Davila on 11/1/2020

I'm getting familiar with this new way of learning to me, and I can understand everything so far

By Celeste Koehl on 10/27/2020

So far I believe so, I am more advanced, but like to see from the beginning to make sure I haven't missed anything. I haven't had training on this course but learned as I've gone along... so I think watching from the beginning will be beneficial to me. Can I pause the course and continue as it is convenient for me?