Microsoft Excel 2013: Advanced

Producer: Gopas

Duration: 15 hours.
This product is an online product and is a single-user, 1-year licence.


The course MS Excel 2013: 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.

The course takes the form of tutorial, exercise and quiz.

Course Content
- Pre-assessment (optional)
- 29 lessons
- Final test

This product allows the student to print a certificate from the course on successful completion.

The recommended settings to run this course are:
- Any of following internet browsers: Internet Explorer 6.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
- 1 GHz CPU; 512 MB RAM; OS Windows 2000, XP, Vista or Windows7
- Display resolution of 1280 x 1024
- Soundcard, speakers or headphones are recommended


This course covers the following topics

• 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


Once you have completed this course you will be able to:
Use macros to automate functions in the spreadsheet
Use shapes and SmartArt graphics in your worksheets
Prepare tables or the entire workbook for printing
Protect workbooks and manage access to them

* required field