Microsoft Excel 2016 Tutorial.
Microsoft Excel 2016 Tutorial. Advanced Level.
Welcome to Microsoft Excel 2016 Advanced Level.
In this third course of our series we will take care of both the creation and editing of Macros. But furthermore, we will take a look at some of the new advanced tools of Microsoft Excel 2016:
For instance, the Share button will let you save spreadsheets in the cloud. Moreover, Excel 2016 has many new advanced features in the File menu, such as those for document sharing in the cloud!
But that's not all! The Check for Issues tool will automatically look for data errors within your workbook. While the Protect Workbook option will help you to safely encrypt your Excel book, thus keeping your data safe from other people. Optionally you may use the Protect Current Sheet option or protect your main Workbook structure only. Finally you could apply the Mark as Final option and make it a Read Only file.
Also you can now Recover Unsaved Workbooks, giving you the option of recovering your work in case there's a power cut or other system error. Just click this option to se the list of all the auto-stored Workbooks!
And let's not forget to mention the Browser View option. This icon will allow you to choose which spreadsheets will be visible when you preview the selected workbook on an Internet Browser.
For example, when you preview the Workbook on IE or Chrome, you could select to show the entirety of the Workbook, or just couple of Spreadsheets, or even more, just certain data within a Spreadsheet.
Finally let's go to the Insert Tab, here you will find the Add-ins icon which will allow you to add yet new features to Microsoft Excel.
During this step by step course you will learn:
- Financial Formulas.
- Manual and Automatic Calculations.
- Workbook Printing.
- Financial Functions.
- Date & Time Functions.
- Lookup & Reference Functions.
- Math & Trig Functions.
- Auditing of Formulas.
- Professional Online Consultancy for all the topics covered in this course.