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 Personal Development Mindfulness 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++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2.5 hours on-demand video
  • 1 article
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel for Mac - Office 365 on Mac OS

The complete guide to Microsoft excel for Apple Mac OS X - Office 365
Rating: 4.6 out of 54.6 (401 ratings)
1,547 students
Created by Colin Marks
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Use Microsoft Excel 2016 for Mac with confidence in an Office environment.
  • learn how to use the most common Excel formulas and functions to carry out day to day spreadsheet tasks.
  • Produce excel spreadsheets to the highest standard
  • Use formulas and functions to carry out tasks
  • Give them the tools to be able to tackle more complex formulas
Curated for the Udemy for Business collection

Requirements

  • No Prior spreadsheet experience is needed to take the class.
  • Students should have Microsoft Excel installed on their computer so that they can follow along with the lectures.

Description

Microsoft Excel is one of the most popular computer applications in offices over the last 20 years. For years people have struggled with compatibility issues between Microsoft and Apple Mac OS. This is slowly changing, Microsoft Office 365 has brought the two operating systems closer, its now easier than ever to collaborate with other users, its easier than ever to create a file on a Window PC and edit it on your favourite MacBook. 

Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about it  than you actually do. This course is designed from the bottom up, focusing on the most important elements of Microsoft Excel to give you the skills and confidence to perform everyday spreadsheet tasks in the average office. 

Have you used Excel before and now have moved over to Apple Mac OS, we will look at the main differences in the two versions and also show some useful tips so that you can become a competent Microsoft Excel user

Who this course is for:

  • This course is designed for anybody who has no spreadsheet experience but wishes to become a competent Microsoft Excel user.
  • This course can be used as a refresher course for users who have used Microsoft Excel on a Windows PC but are now using an Apple Mac

Course content

10 sections • 30 lectures • 2h 30m total length

  • Preview03:06

  • Preview07:16
  • Creating Spreadsheets
    01:48
  • Saving a Spreadsheet
    04:41

  • Cells
    03:46
  • Finding and Replacing Data
    02:35
  • Sorting Data in a Spreadsheet
    03:49
  • Filtering Data
    02:27
  • Cut, Copy and Paste Content and Deleting Cell Content.
    03:33

  • Rows and Columns
    05:11
  • Worksheets
    03:25

  • Creating formulas
    04:42
  • Formula Quiz
    1 question
  • Using the Autofill button
    03:37
  • Absolute Cell Reference
    05:34
  • Functions
    06:05
  • The IF Statement
    08:52

  • Cell Formatting
    03:55
  • Formatting Cell Contents (Fonts)
    05:10

  • Creating a chart
    03:37
  • Editing Charts
    04:22

  • The Page Set Up Options
    07:36
  • Printing
    02:08

  • Practice Part one
    19:28
  • Practice Part two
    14:16
  • Bonus Lecture
    00:14

  • Conditional formatting - The Basics
    04:17
  • Condition Formatting - creating rules
    04:38
  • Conditional Formatting- Clearing formatting
    01:21
  • Conditional Formatting - Dates
    05:32
  • Conditional Formatting- Data Bars
    03:07

Instructor

Colin Marks
Certified Microsoft & Apple Trainer
Colin Marks
  • 4.6 Instructor Rating
  • 1,906 Reviews
  • 8,682 Students
  • 9 Courses

I am an IT Trainer with over 8 years experience in delivering training in both Apple and Microsoft to a large array of clients, in both public training centres and corporate environments.

I have an IT teaching diploma and focus mainly on software training. I hold a current Microsoft Office Master certificate and have been teaching Microsoft Office Specialist (Word, Excel, Access, Powerpoint and Outlook all to an advanced level) for the past 6 years.

The training I deliver ranges from iPad and iPhone training to Office productivity applications like Pages, Numbers and Keynote. I also train in video editing software like Final Cut Pro X and iMovie.

I feel the most important part of training is developing a connection with your students, building trust in both sides.

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