Skip to product information
1 of 1

Avrio Products

MS Excel 2016 Expert self-study

MS Excel 2016 Expert self-study

Regular price R 1,000.00
Regular price Sale price R 1,000.00
Sale Sold out

Excel 2016 Expert

You will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide yourself to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers.

You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. You will customize your Excel 2016 environments to meet project needs and increase productivity.  Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Course Objectives:

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Work with macros

The training manual for this Excel 2016 Expert course will be send to you via email as soon as payment is received.  You will also receive some training spreadsheets which you can use while working through the manual.  The manual is very user friendly with screen shots telling you exactly what to do next while studying.

After completing your self-study you will write a short test which will be marked by the trainer and if you pass you will be issued a "Certificate of Completion" for the Excel 2016 Expert course.  Please note that the certificate is not accredited, but the knowledge you will gain through this course is of high value!

Order your Excel 2016 Expert self-study course today and open up a world of advanced Microsoft Excel knowledge.

 

 

View full details