Udemy

Microsoft Excel for Mac: Beginners Excel 2019 Course

Enroll Now
  • 400 Students
  • Updated 12/2023
  • Certificate Available
4.5
(107 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
10 Hour(s) 27 Minute(s)
Language
English
Taught by
Simon Sez IT
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.5
(107 Ratings)

Course Overview

Microsoft Excel for Mac: Beginners Excel 2019 Course

Learning Excel on a Mac? Then this beginner Mac Excel 2019 course is for you

**This course includes practice exercises and LIFETIME access**

Learn Excel for Mac 2019 with this brilliant beginner course from Excel experts Simon Sez IT.


Much of Excel’s Mac functionality is similar to PC functionality, but it’s not exactly the same. So you shouldn’t watch a PC training video expecting that all the features, hints and tips will work the same way and be found in the same place on a Mac.

Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user.

If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you.

This course is specifically recorded using Excel for Mac 2019, however, many of the mac features we teach are the same in other versions of the software.


In this course we show you how:

  • To create, open and save new workbooks in Excel Mac.

  • The basics of how Excel for Mac works including relative references and order of operations.

  • To set up your workbooks and print the right thing in Excel.

  • To use freeze panes and split screens.

  • To move data around in Excel for Mac.

  • Basic formulas and functions work in Excel for Mac.

  • To format your spreadsheets correctly.

  • To create some amazing looking charts and graphs.

  • To sort and filter your data in Excel

***Exercise and demo files included***


This course includes:

  1. 5+ hours of video tutorials

  2. 57 individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…

"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."

- Yunesh Garusinghe

"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."

- Cavin Macwan

"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"

- Coreen Teoh


Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Course Content

  • 15 section(s)
  • 69 lecture(s)
  • Section 1 Introduction to Excel
  • Section 2 Excel 2019 for Mac Beginner: Creating Workbooks
  • Section 3 Excel 2019 for Mac Beginner: Saving Workbooks
  • Section 4 Excel 2019 for Mac Beginner: Navigating Large Workbooks
  • Section 5 Excel 2019 for Mac Beginner: Page Setup and Print Options
  • Section 6 Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells
  • Section 7 Excel 2019 for Mac Beginner: Moving Data
  • Section 8 Excel 2019 for Mac Beginner: Formulas and Functions
  • Section 9 Excel 2019 for Mac Beginner: Working with Sheets
  • Section 10 Excel 2019 for Mac Beginner: Formatting Worksheets
  • Section 11 Excel 2019 For Mac Beginner: Charts
  • Section 12 Excel 2019 for Mac Beginner:Sorting and Filtering
  • Section 13 Excel 2019 for Mac Beginner: Conclusion
  • Section 14 Extras
  • Section 15 Additional Training

What You’ll Learn

  • Discover Excel for Mac is different from Excel for PC.
  • How create, save, and open a workbook.
  • Complete data entry, cell formatting, and working with multiple worksheets.
  • The basics of entering and editing data in a workbook.
  • Discover how to format dates and numbers.
  • Effectively use autofill and flashfill so you are more productive.
  • Discover the essentials of using fomulas and functions.
  • How to rename, insert, move, and reference an Excel 2019 worksheet.
  • Discover how to create charts and graphs.
  • Learn practical methods to sort and filter your data.


Reviews

  • S
    Sasha Burgstaler
    5.0

    This has been extremely helpful and very easy to follow. I'm loving it!

  • D
    Dean Hajas
    3.5

    I took another course that was written for P.C. in a school that I'm studying law at. It was a night mare to attempt to translate everything from one formatting style to another live. This Excel for beginners has covered areas that were insufficiently covered in the other module company.

  • A
    Afshin Zanjani Pirbazari
    4.0

    It was a great experience.

  • B
    Barbara Burkhardt
    5.0

    This lady is fantastic. To the point and explains everything clearly. Very happy with her.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed