Course Information
Course Overview
Learn to Manage Your Data Using Spreadsheet Functionality
In this Learning Microsoft Excel 2016 for Mac training course, expert author Guy Vaccaro will teach you everything you need to know to be able to work in Excel 2016, including managing your own workbooks, formatting worksheets, and creating and using formulas. This course is designed for the absolute beginner, meaning no previous experience with Excel is required.
You will start by learning how to manage Excel workbooks and worksheets, including creating and saving a new workbook, saving Excel files in other formats, and using the Excel 2016 templates. From there, Guy will teach you how to enter and edit data in cells. This video tutorial also covers how to use basic mathematical operators, format worksheets, and use mathematical formulas. Finally, you will cover advanced formatting and security, including activating worksheet and workbook protection and password protecting the workbook file.
Once you have completed this computer based training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac. Working files are included, allowing you to follow along with the author throughout the lessons.
Course Content
- 10 section(s)
- 60 lecture(s)
- Section 1 Your Excel 2016 Journey Starts Here
- Section 2 Managing Excel Workbooks And Worksheets
- Section 3 Entering And Editing Data In Cells
- Section 4 Math Basics
- Section 5 Formatting Worksheets
- Section 6 Page Setup And Printing
- Section 7 Mathematical Formulas
- Section 8 Advanced Formatting
- Section 9 Security
- Section 10 Excel 2016 Summary
What You’ll Learn
- Once you have completed this training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac
Skills covered in this course
Reviews
-
BBrad Counihan
Well done, loved the recap/summary at the end of each section!
-
CCameron Kelly
This course was exactly what I expected from browsing the course materials. It is very much an Excel Basics course and if you've used Excel for any duration of time you've probably learned most of what you might here. If you are new to Excel or if you find yourself struggling with basics (formatting, using formulas, printing, and etc.) this could definitely be beneficial.
-
RRosemarie
GOOD PACE! GREAT INFORMATION!
-
AAndrew S. VanHoose
He's a really good teacher. Give that man a raise ;)