Excel 2019 Beginners (Mac)
Excel 2019 Beginners (Mac)
- DURATION: 5h 14m
- VIDEOS: 57
- LEVEL: Intermediate
- Description
- Course Resources
Welcome to the exciting world of Microsoft Excel 2019 for Beginners on Mac! In this course, you will embark on a journey to master the essential spreadsheet creation and manipulation skills using the powerful Excel software designed specifically for Mac users.
You’ll start with an introduction to Excel, exploring the nuances between PC and Mac versions. Learn the basics of the Excel window and mouse and trackpad features, ensuring you are comfortable navigating the interface. Dive into creating new workbooks, entering text and numbers, crafting basic formulas, and understanding the difference between relative and absolute references.
As you progress, discover the art of saving and sharing your spreadsheets, and become adept at navigating large workbooks with freeze panes, split screen, and window arranging options. Uncover the secrets of page setup and print options and efficiently move, copy, and paste data. Delve into formulas and functions, working with sheets and formatting worksheets like a pro.
By the end of the course, you should be confidently creating and editing charts, mastering sorting and filtering techniques, and handling various data manipulation tasks. Excel for Mac will no longer hold secrets for you. Enroll now to gain valuable skills to enhance your productivity and proficiency in the digital workplace.
In this course, students will learn how to:
- Create, open, and save workbooks efficiently in Excel Mac.
- Master Excel for Mac basics, understanding relative references and order of operations.
- Set up and print workbooks accurately, utilizing Excel’s page setup options.
- Utilize freeze panes and split screens effectively for improved workbook navigation.
- Move data seamlessly within Excel for Mac using cut, copy, and paste functions.
- Implement basic formulas and functions to perform calculations in Excel for Mac.
- Format spreadsheets adeptly, ensuring proper cell formatting and styles.
- Create visually appealing charts and graphs, enhancing data representation skills.
- Develop proficiency in sorting and filtering data in Excel for effective analysis.
- Demonstrate comprehensive understanding and application of key Excel for Mac functionalities.
WHAT YOU GET
Certificate of Completion
- Earn a certificate each time you complete a course.
- Showcase your commitment to continuous growth and professional development.
- Impress potential employers.
- Enhance your professional profile.
- Available in PDF format to Download or Print.
INSTRUCTOR
Deborah Ashby
Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!
The course has exercise files included. You will need to download the Excel 2019 for Mac Beginners Files Zip File to your PC or Mac (the files are not compatible with a mobile device). Note, this course is designed to be taken on a Mac.
Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded you’ll need to unzip the file to access all the exercises included.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More