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+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation 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++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 8.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Learn Excel - The Excel Tutorial for Beginners

Excel training covering Microsoft Excel basics, Excel formulas, Excel functions, formatting, graphics, & layout
Rating: 3.8 out of 53.8 (151 ratings)
12,795 students
Created by Todd McLeod
Last updated 11/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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 format worksheets in Excel for impact and appeal
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to use "paste special" to copy data from the web and get it into Excel
  • Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts
  • Learn how to include hyperlinks to external resources and call-out text boxes
  • Learn tips and tricks about Excel, as well as Excel shortcuts
  • Learn the fundamentals of using Microsoft Excel

Requirements

  • All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.

Description

You can learn Microsoft Excel easily and quickly if it is taught correctly.

Developed by a Microsoft Certified Master Instructor, this course provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. Taught by 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 learn Microsoft Excel.

Providing a comprehensive curriculum of 92 video lectures, including 45 hands-on exercises, 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 format worksheets in Excel for impact and appeal

  • Learn how to "transpose data" - switching the columns and rows in Excel

  • Learn how to use "paste special" to copy data from the web and get it into Excel

  • Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts

  • Learn how to include hyperlinks to external resources and call-out text boxes

  • Learn tips and tricks about Excel, as well as Excel shortcuts

As bonus material, you will also be provided with 

  • a comprehensive set of 45 "hands-on exercises"

  • solutions to all of the "hands-on exercises"

If you need to prove that you have learned the material, or if you are 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 "hands-on exercises."

As an additional bonus, you can download all of the Excel project files that are used in the videos.

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:

  • This course is for beginners

Course content

13 sections • 93 lectures • 8h 24m total length

  • Preview04:09
  • Preview05:47
  • Understanding Versions
    07:49
  • How To Succeed
    09:21
  • Course Resources
    04:38
  • Accelerate Learning
    02:20

  • Preview04:27
  • Hands-on Exercise #1
    02:20
  • Hands-on Exercise #2
    04:12
  • Hands-on Exercise #3
    05:24
  • Hands-on Exercise #4
    06:51

  • Preview06:16
  • Finding Your Way Around Excel
    06:37
  • Mouse Pointer Awareness
    05:12
  • Writing Formulas
    11:23
  • Preview05:39
  • Ranges & Names
    05:20

  • Quiz - Getting Started
    03:22
  • Hands-On Exercise #1
    04:01
  • Hands-On Exercise #2
    01:27
  • Hands-On Exercise #3
    02:52
  • Hands-On Exercise #4
    02:03
  • Hands-On Exercise #5
    03:23
  • Preview05:27
  • Hands-On Exercise #7
    05:44
  • Hands-On Exercise #8
    06:28
  • Hands-On Exercise #9
    07:37
  • Hands-On Exercise #10
    08:17

  • Overview
    03:19
  • Preview04:49
  • Format Cells - Number
    07:18
  • Format Cells - Alignment
    07:28
  • Format Cells - Font
    06:37
  • Format Cells - Border
    02:47
  • Format Cells - Fill
    04:48
  • Clear Formats
    06:24
  • Format As Table
    02:11

  • Hands-On Exercise #1
    05:17
  • Hands-On Exercise #2
    03:40
  • Hands-On Exercise #3
    04:38
  • Hands-On Exercise #4
    08:06
  • Hands-On Exercise #5
    02:27
  • Hands-On Exercise #6
    05:54
  • Hands-On Exercise #7
    13:08

  • Overview
    02:56
  • Copy As Picture
    02:59
  • Paste
    06:40
  • Paste Special
    04:07
  • Format Columns & Rows
    04:57
  • Styles
    03:12
  • Pictures & Shapes
    06:20
  • Smart Art, Word Art, & Symbol
    10:28
  • Link & Text Box
    06:31
  • Add-Ins
    02:48

  • Hands-On Exercise #1
    01:25
  • Hands-On Exercise #2
    08:42
  • Hands-On Exercise #3
    10:17
  • Hands-On Exercise #4
    08:12
  • Hands-On Exercise #5
    07:30
  • Hands-On Exercise #6
    03:00
  • Hands-On Exercise #7
    05:45
  • Hands-On Exercise #8
    05:09
  • Hands-On Exercise #9
    07:09

  • Overview
    10:15
  • Background
    08:56
  • Stacking Order
    03:22
  • Align, Group, Rotate
    03:31
  • Zooming In & Out
    02:58
  • Templates
    12:24

  • Hands-On Exercise #1
    01:29
  • Hands-On Exercise #2
    00:58
  • Hands-On Exercise #3
    04:20
  • Hands-On Exercise #4
    02:03
  • Hands-On Exercise #5
    01:16

Instructor

Todd McLeod
Tenured College Professor
Todd McLeod
  • 4.5 Instructor Rating
  • 45,349 Reviews
  • 319,952 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.