Microsoft Excel for Mac: Beginners Excel 2019 Course

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

**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!

Expected Outcomes

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