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 AWS Certified Developer - Associate CompTIA Security+
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 Neuroscience Coaching
Web Development JavaScript React CSS Angular PHP Node.Js WordPress 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 Google Analytics
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++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 6.5 hours on-demand video
  • 2 articles
  • 63 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel - From Beginner to Expert in 6 Hours

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.
Rating: 4.5 out of 54.5 (15,560 ratings)
103,923 students
Created by Todd McLeod
Last updated 12/2015
English
English, French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Learn Microsoft Excel 2013
  • Learn from a Microsoft Certified Master Instructor with over 15 years of experience teaching individuals of all ability levels
  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
  • Presented with high-quality video lectures, this Excel course will visually show you how to easily do everything in Excel
  • Lifetime access to this Excel class allows you to easily review material and continue learning new material
  • Excel Project Files and Excel Templates are included allowing for enhanced learning through hands-on activities
  • After taking this training, you will be an expert at Microsoft Excel
  • Money Back Guarantee - Satisfaction Guaranteed or Your Money Back
Curated for the Udemy for Business collection

Requirements

  • In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel.

Description

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel. A university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Microsoft Excel.

In only five hours of videos, provided to you in 75 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

  • Learn how to navigate around Excel
  • Learn how to enter and edit data in Excel
  • Learn how to adjust the way data and information are displayed in Excel
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to create powerful calculations with Excel functions
  • Learn how to visually represent your data with charts and graphs in Excel
  • Learn how to use Excel data tools like sorting, subtotaling, and filtering
  • Learn how to "freeze columns and rows" with freeze panes in Excel
  • Learn how to remove duplicates from data in Excel
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn how to automate Excel tasks with time-saving macros
  • Learn how to integrate Microsoft Excel with Microsoft Word
  • Learn how to use passwords in Excel to protect your work in multiple scenarios
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Learn how to use printing and sharing in Excel

As bonus material, you will also learn two very incredible, and super valuable, skills:

  • how to harvest data from the web
  • how to create online forms which allow you to gather data from individuals

As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."

Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.

This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

Who this course is for:

  • From beginners, to advanced users, this course is perfect for all ability levels
  • Lifetime access to this Excel training allows you to come back to review material or learn more about MS Excel

Featured review

Alaceya Grant
Alaceya Grant
1 course
1 review
Rating: 4.5 out of 5a year ago
At first I was intimidated by the constant usage of numbers, since math and decimals frighten me; however, the instructor speaks in a very fluid, coherent and calming way that it keeps me motivated and willing to learn.

Course content

22 sections • 83 lectures • 6h 33m total length

  • Preview01:35
  • Screen Settings Quiz
    1 question
  • The Quizzes Are Optional
    01:18
  • The Quizzes Are Optional
    4 questions
  • Getting Your Certificate of Completion
    05:55
  • Getting Your Certificate of Completion
    1 question
  • Course Files
    00:11

  • Excel Quick Start
    06:08
  • Preview04:04
  • Preview05:14
  • Functions
    05:47
  • Creating Charts
    05:53
  • Calculating A Grade Example
    15:39
  • Preview06:58

  • Preview07:46
  • Introduction To Excel
    7 questions
  • Writing Formulas
    06:47
  • Writing Formulas
    4 questions
  • Formula Essentials
    03:04
  • Formula Essentials
    4 questions
  • Relative, Absolute, & Mixed References
    06:20
  • Relative, Absolute, and Mixed References
    5 questions

  • Introduction to Functions
    07:08
  • Introduction to Functions
    5 questions
  • Payment Function & Loans
    05:55
  • Payment Function & Loans
    4 questions
  • Future Value Function & Pensions
    05:02
  • Future Value Function & Pensions
    2 questions
  • VLOOKUP Function & Gradebooks
    02:36
  • VLOOKUP Function & Gradebooks
    2 questions
  • IF, Concatenate, & Evaluation
    02:56
  • IF, Concatenate, & Evaluation
    2 questions
  • Conditional Formatting
    01:39
  • Conditional Formatting
    2 questions
  • IFERROR Function & Dynamic Amortization Tables
    03:04
  • IFERROR Function & Dynamic Amortization Tables
    1 question

  • Preview04:11
  • Visually Representing Data
    3 questions
  • Creating Charts
    05:57
  • Creating Charts
    4 questions
  • Formatting Charts
    05:47
  • Formatting Charts
    4 questions
  • Scatter Charts
    06:54
  • Scatter Charts
    3 questions
  • Combo Charts
    06:27
  • Combo Charts
    3 questions
  • Pivot Charts
    03:54
  • Pivot Charts
    3 questions

  • Finding Data
    03:01
  • Finding Data
    2 questions
  • Copying Data From The Web
    08:36
  • Copying Data From The Web
    2 questions
  • Transposing Data
    00:58
  • Transposing Data
    1 question
  • Copying Data From The Web II
    03:53
  • Copying Data From The Web II
    3 questions
  • Parsing Data
    09:23
  • Parsing Data
    3 questions
  • Web Scraping Software
    02:10
  • Web Scraping Software
    1 question

  • Freeze Panes
    01:44
  • Freeze Panes
    1 question
  • Filtering Data
    01:42
  • Filtering Data
    2 questions
  • Removing Duplicates
    03:21
  • Removing Duplicates
    2 questions
  • Sorting Data
    01:47
  • Sorting Data
    1 question
  • Subtotaling Data
    06:07
  • Subtotaling Data
    2 questions
  • Data Tables
    08:55
  • Data Tables
    2 questions

  • Exploring The Find Function
    11:22
  • Exploring The Find Function
    2 questions
  • Exploring Filters Further
    02:41
  • Exploring Filters Further
    2 questions
  • The Advanced Filter
    11:44
  • The Advanced Filter
    2 questions
  • The Find Function II
    06:31
  • The Find Function II
    2 questions

  • Introduction to Pivot Tables
    02:44
  • Introduction to Pivot Tables
    2 questions
  • Creating a Pivot Table
    05:01
  • Creating a Pivot Table
    1 question
  • Exploring Pivot Tables
    03:04
  • Exploring Pivot Tables
    2 questions
  • Recommended Pivot Tables
    02:47
  • Recommended Pivot Tables
    1 question
  • Grouping in Pivot Tables
    03:14
  • Grouping in Pivot Tables
    3 questions
  • Using "Slicers" in Pivot Tables
    02:00
  • Using "Slicers" in Pivot Tables
    3 questions
  • Creating Pivot Charts
    02:47
  • Creating Pivot Charts
    2 questions

  • Formatting Your Worksheet
    02:37
  • Formatting Your Worksheet
    2 questions
  • Formatting Essentials
    03:51
  • Formatting Essentials
    3 questions
  • Formatting Fundamentals
    04:11
  • Formatting Fundamentals
    3 questions
  • Design Considerations
    03:46
  • Design Considerations
    4 questions
  • Inserting & Deleting Cells, Columns, & Rows
    01:22
  • Inserting & Deleting Cells, Columns, & Rows
    1 question
  • Formatting Options
    05:00
  • Formatting Options
    3 questions
  • Formatting Examples
    05:00
  • Formatting Examples
    3 questions
  • Formatting Secrets
    06:35
  • Formatting Secrets
    3 questions

Instructor

Todd McLeod
Tenured College Professor
Todd McLeod
  • 4.5 Instructor Rating
  • 45,103 Reviews
  • 319,178 Students
  • 19 Courses

I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life.

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