We've updated our Sexual Harassment Courses to include changes to The Worker Protection Act

Microsoft Excel 2013: Advanced

Previous
Microsoft_Excel_2013_Advanced
Microsoft Excel 2013
Microsoft Excel 2013
Microsoft Excel 2013
Next
Microsoft_Excel_2013_Advanced

Course Overview

Format

  • Advanced
  • 11-12 Study Hours
  • Online Study
  • Self-Printed Certificate

Accreditation

  • Online Interactive Course
  • Virtual College Endorsed

Course description

This online course has been designed those with previous experience of Microsoft Excel 2013 who are looking to boost their skills and knowledge of the program.

The course Microsoft 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.

You will learn

  • 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

Who is it for?

Roles including:

  • Office computer user
  • Those wanting to develop Microsoft Execel skills and knowledge
  • Job Seekers
  • Those working with computers
  • Those using Microsoft Excel at work, home or in education

How the online courses work