Your cart is empty.
Keep shoppingMicrosoft Excel for Mac: Beginners Excel 2019 Course
401 students
Microsoft Excel for Mac: Beginners Excel 2019 Course
Learning Excel on a Mac? Then this beginner Mac Excel 2019 course is for you
Created bySimon Sez IT
Last updated 12/2023
English
English [Auto],
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.
Explore related topics
Course content
15 sections • 69 lectures • 10h 27m total length
Requirements
- Microsoft Excel 2019 version Mac installed and ready to use on your computer.
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:
5+ hours of video tutorials
57 individual video lectures
Exercise files to practice what you learned
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!
Who this course is for:
- Those new to using Microsoft Excel.
- No previous knowledge of Excel required. This course is created for absolute beginners.
- If you want to refresh your memory and understanding of Excel.
- Users of earlier versions of Excel looking to update their skills to 2019