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 CompTIA Security+ Amazon AWS 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 Personal Transformation Meditation Life Purpose Emotional Intelligence 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 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
Office Productivity Microsoft Excel

Microsoft Excel for Mac - From Beginner to Expert in 7 Hours

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2011 for an Apple Mac.
Rating: 3.3 out of 53.3 (954 ratings)
11,705 students
Created by Todd McLeod
Last updated 12/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn the most current version of Microsoft Excel for APPLE MAC
  • 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

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 covers the most recent version of Microsoft Excel for the Mac - Microsoft Excel 2011. As tenured college faculty in computer information technology, and with over fifteen years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected a method for understanding Excel which will allow you to learn what you need to know about Microsoft Excel as quickly and efficiently as possible. 

With over five hours of video, 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

  • Learn how to harvest data from the web

  • Learn how to create online forms which allow you to gather data from individuals

  • Learn how to use templates to quickly create stunning spreadsheets

  • As a bonus, you can download all of the Excel project files used in the videos so that you can get a “hands-on” approach to learning the material

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

Ahmed Al
Ahmed Al
63 courses
16 reviews
Rating: 5.0 out of 59 months ago
Instructor is really engaging and has many ways to keep you focused and also very entertaining course. Wish this class was for excel 2019, course covers pretty much all what is needed to learn on using excel on Mac...

Course content

11 sections • 81 lectures • 7h 47m total length

  • Preview01:13
  • Preview03:00
  • Preview11:09
  • Video Settings
    03:40
  • Locating Files Used In Course
    00:56
  • Section 1 Review
    3 questions

  • Preview02:15
  • Preview08:54
  • Preview08:20
  • Functions
    15:40
  • Charts
    07:49
  • Calculating Your Grade
    15:34
  • Copying Data From The Web
    08:15
  • Gathering Data With Online Forms
    03:30
  • Section 2 Review
    7 questions

  • Introduction To Excel
    14:20
  • Mouse Pointer Awareness
    03:23
  • Preview04:16
  • Relative, Absolute, and Mixed References
    07:02
  • Section 3 Review
    2 questions

  • Introduction to Functions
    15:48
  • Payment Functions and Loans
    10:35
  • Create A Loan Amortization Schedule
    10:55
  • Future Value Functions & Pensions
    08:58
  • Investment Amortization
    09:40
  • Gradebook & VLookup
    11:51
  • The "IF" Function
    03:08
  • Conditional Formatting
    03:00
  • The "IfError" Function
    03:07
  • Section 4 Review
    3 questions

  • Introduction to Charts (graphs)
    08:16
  • The Basics of Creating Charts
    05:10
  • Chart Types
    09:35
  • Creating Charts - Pie Chart
    07:43
  • Creating Charts - Line Chart
    04:26
  • Creating Charts - Column Chart
    05:46
  • Creating Charts - Bar Chart
    03:58
  • Creating Charts - Sparklines
    04:44
  • Creating Charts - Scatter Charts
    03:56
  • Creating Charts - Area Stacked Chart
    02:06
  • Creating Charts - Combo Chart (AWESOME!!!)
    07:54
  • Creating Charts - Troubleshooting Charts
    05:22
  • Creating Charts - Pivot Charts
    06:46
  • Section 5 Review
    7 questions

  • Introduction to Data
    04:27
  • Data & Excel - Google Adwords Example
    20:30
  • Extracting Data From The Web
    13:15
  • Sorting Data
    04:32
  • Filtering Data
    07:57
  • Removing Duplicates
    01:04
  • Transposing Data
    05:41
  • Preview03:35
  • Subtotaling Data
    10:15
  • Data Tables
    06:52
  • Section 6 Review
    3 questions

  • Introduction to Pivot Tables
    06:06
  • Creating Pivot Tables
    04:12
  • Refreshing Pivot Tables
    02:05
  • Pivot Table Examples
    04:03
  • Pivot Table Grouping
    02:32
  • Pivot Charts & Slicers
    02:45
  • Section 7 Review
    1 question

  • Intro to Formatting
    01:21
  • Content & Form
    03:51
  • Saving Time With Templates
    02:45
  • Preview04:53
  • Border & Fill
    04:53
  • Predefined Styles
    02:42
  • Formatting Tour
    04:32
  • Inserting & Formatting Images
    05:32
  • Inserting Media
    05:04
  • Arrows, Circles, & Shapes
    02:26
  • Textboxes & Hyperlinks
    04:44
  • Word Art
    04:49
  • Home Ribbon Formatting
    05:41
  • You Are Amazing
    06:08
  • Section 8 Review
    4 questions

  • Printing Introduction
    01:08
  • Page Layout
    01:29
  • Page Setup
    05:55
  • Headers, Footers & Page Numbers
    03:49
  • Scaling Content
    06:34
  • Section 9 Review
    3 questions

  • Macros
    01:29
  • Not Creating A Macro
    03:20
  • Macros Illustrated
    02:47
  • Securing Workbooks
    01:11
  • Locking & Securing Worksheets
    03:04
  • Integrating Word & Excel
    03:34
  • Section 10 Review
    3 questions

Instructor

Todd McLeod
Tenured College Professor
Todd McLeod
  • 4.5 Instructor Rating
  • 46,278 Reviews
  • 323,292 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.