The course MS Excel 2016/2019: 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.
OVERVIEW
REQUIREMENTS
- Persons who a lot of experience on Excel and want to complete advanced Excel to help with Office productivity.
- Make sure you have completed the beginners and intermediate course first or make sure you understand how to complete all elements (see other courses to consider under the progression section).
CONTENT
INDICATIVE CONTENT
- 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 Auto Recovery
- Using templates
- Compatibility issues
- Saving a workbook to the Web
- Introduction to macros
- Macro recording
- Macro editing
- Macro security
- Digitally signed macros
METHOD OF DELIVERY/DURATION
- Online and Customised for Organisations
CERTIFICATION
Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS
ASSESSMENT
- Online assessment
COST
€29.95 for one single module. Check out the great deals on completing more than one course.
PROGRESSION
This course is for those that wish to become advanced users – you will be competent in all areas of MS Excel on conclusion.
There is the option to purchase.