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.