TYPE
Online Course
DURATION
15 hours
PRICE
£25.00
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
Course content
Pre-assessment (optional)
29 lessons
Final test
- 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
Lesson content
Tutorial, exercise, quiz
Target audience
Office computer user
The browse mode allows you to view the course without recording assessment scores or completion status.
You should only use this mode if you are simply reviewing the course content. In order to complete this course you should click the Launch button instead.
Click 'OK' to continue in browse mode or 'Cancel' to return to the course details page.
DummyBtn
Are you sure you want to re-launch this course?
Re-launching will remove your score and completion status!
Click below to re-launch or 'Cancel' to abort.
DummyBtn
DummyBtn
Thank you, the request has been registered. Please note: if the request is not approved within 30 days it will automatically lapse and will need to be ordered again.
DummyBtn
This item will be permanently deleted and any history will be lost.
Are you sure you wish to proceed?
DummyBtn
Please confirm the course enrolment for:
After confirmation you be will contacted separately regarding invoicing.
DummyBtn