MS Excel 2016: Advanced

£14.00

Price is per online user of this course. EU applicable VAT is added.

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, learners will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics. They will learn to prepare a table or the entire worksheet before printing and will familiarise themselves with the options of protecting and sharing the workbook content. They will further familiarise themselves with the usage of macros, including their creation and editing and also examine the options of macro security.

See below for further information.

Sold By: Core Learning Services (008)

Description

Course 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 AutoRecovery
  • Using templates
  • Compatibility issues
  • Saving a workbook to the Web
  • Introduction to macros
  • Macro recording
  • Macro editing
  • Macro security
  • Digitally signed macros

Discounts

For multiple purchase discounts or to find out if discounts are available on mixed course purchases please phone a customer advisor on 0844 85 9218.

Payment Options

The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email [email protected]

Additional information

Subject

level

guided-learning-hours

resource-type

accredited-qualification

online-access-duration

Available for immediate enrolment

Yes