This online course has been made for those who regularly use Microsoft Excel 2016 but want to become fully familiar with the various tools and features the program offers.
The course Microsoft Excel 2016: Advanced is focused mainly on the creation of charts and automation of the work in the program by using macros.
Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics.
You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content.
You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.