MS Excel 2016: Advanced

MS Excel 2016: Advanced
Duration: 14 Hours 30 Minutes
Knowledge Test: Test Exercises
Certificate of completion: No
Creator: Gopas

Description: The course MS 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.
List of Lessons
Sparklines
Charts creation
Chart design
Chart formatting
Screenshots and screen clipping
Shapes
SmartArt
Themes
Proofing tools
Tracking changes
Comments
Managing multiple windows
Splitting worksheets into panes
Workbook views
Header and footer
Page setup
Microsoft account
File properties
Workbook protection
Workbook inspection
File AutoRecovery
Using templates
Compatibility issues
Saving a workbook to the Web
Introduction to macros
Macro recording
Macro editing
Macro security
Digitally signed macros