Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 7 hours on-demand video
  • 6 articles
  • 24 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

Boost your Excel skills - Boost your career. Master Microsoft Excel worksheets, functions, & more. Excel 2016-2019 & 365
Rating: 4.6 out of 54.6 (5,869 ratings)
56,082 students
Created by Steve McDonald
Last updated 2/2020
English
English, Italian [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • In this course, you'll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools.
  • You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer.
  • I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations.
  • Use the most commonly used Excel functions to make powerful calculations.
  • Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
  • Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond.
  • Great for beginners to intermediate Excel users.
Curated for the Udemy for Business collection

Requirements

  • All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning.

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 of Microsoft Excel all the way to Excel mastery. 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 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 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 Buy now button or check out one of the free preview lectures and I'll see you in the course.

100% Satisfaction Guaranteed

Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free.

So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.

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.

Course content

13 sections • 66 lectures • 6h 52m total length

  • Preview02:21
  • Preview07:22
  • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
    09:47
  • Using Excel Templates to Save Time and Effort
    08:56

  • Preview02:42
  • Preview02:52
  • Creating Simple Formulas to Do Powerful Calculations
    07:03
  • Working with Workbooks and Worksheets
    08:42
  • Put Your Knowledge to Work - Create Your First Excel Document
    00:23

  • Preview03:24
  • Formatting Subheadings and Columns and Alphabetizings Lists
    03:28
  • Entering and Formatting Numbers
    02:55
  • Create Formulas to Quickly Calculate Your Costs
    06:08
  • Formatting - Grids and Spacing
    03:25

  • Preview04:00
  • What is a Formula and What Can It DO for You?
    02:00
  • What is a Function and What Does IT Do?
    08:32

  • Preview06:35
  • Preview03:46
  • Absolute vs. Relative Cell References
    06:52
  • Excel Shortcuts for Mac
    00:21

  • How to Use the Downloads to Learn Functions Faster
    04:14
  • Preview03:04
  • COUNT, COUNTA and COUNTBLANK Functions
    04:05
  • IF Functions
    09:36
  • SUMIF and SUMIFS Functions
    06:22
  • COUNTIF and COUNTIFS Functions
    04:26
  • VLOOKUP Function
    12:35
  • LEFT, RIGHT and MID Functions
    08:54

  • CONCATENATE - Combining Text
    04:36
  • LEN - Length of Text
    03:04
  • FIND and SEARCH
    03:52
  • MIN and MAX
    04:54
  • AND and OR
    06:10
  • ROUND, CEILING and FLOOR
    13:24
  • TODAY and NOW
    02:30
  • CONDITIONAL FORMATTING
    08:46
  • ALT Shortcut Keys for INDEX/MATCH Lecture
    04:17
  • INDEX and MATCH
    09:37
  • UPPER, LOWER, and PROPER
    04:13

  • Charts Download
    00:09
  • Introduction - How to Create a Chart
    Preview07:14
  • Format Your Chart
    07:13
  • Create a Bar Chart
    05:54
  • Create a Pie Chart
    11:36
  • Create a Line Chart
    05:14

  • Pivot Tables Download
    00:04
  • Introduction to Pivot Tables - Preparing Your Data
    11:07
  • How to Create a Pivot Table
    12:13
  • Put Your Pivot Table to Work
    13:37
  • Pivot Charts Download
    00:07
  • Pivot Charts
    06:57

  • Import from Web, Copy/Paste, and Cleaning Up Data
    07:30

Instructor

Steve McDonald
Dedicated Instructor Will Help You Excel | 300K+ Students
Steve McDonald
  • 4.5 Instructor Rating
  • 27,244 Reviews
  • 360,150 Students
  • 21 Courses

Learning is easier with 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 tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

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 up for a course today and I'll help you reach the level of success you deserve. 

I'll see you in there!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.