sss

Microsoft Excel Training Courses

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work!  Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!).  Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

Microsoft Excel Advanced 2 course

1 day

This Microsoft Excel Advanced 2 course introduces delegates to a number of advanced features of data management including ‘What-if’ data analysis tools, form creation tools, customisation and Macro automation as well as exploring some of the less commonly used features of this product.

Download PDF

What will you learn?

At the end of this Microsoft Excel Advanced 2 course, delegates will be aware of some of the uses of the more sophisticated features of Excel.

Audience?

Power users who need to enhance their existing knowledge and explore some of the less frequently used features of Excel.

Course Contents


Templates

  • Creating, using and editing a template
  • Read Only files

Useful Features

  • Creating Custom Views
  • Workbook Protection
  • Summarising data using Outlining tools
  • Customising Ribbons

Forecasting Tools

  • Goal seek
  • Scenario Manager
  • Data Tables (1 and 2 way)
  • Solver

Array Formulae

  • Simple Arrays
  • Arrays using criteria
  • Frequency function
  • Dynamic Arrays

Managing Formulae

  • Tracing precedents and dependents
  • Tracing errors
  • Evaluating formulas
  • Using the Watch Window

Advanced Pivot Tables

  • Grouping / Timelines
  • Adding calculated fields
  • Slicing multiple Pivot tables
  • Adding conditional formatting
  • % Difference from

Number/Date Formatting

  • Creating bespoke number formats
  • Creating bespoke date formats

Creating Custom Forms

  • Check boxes, option buttons, combo boxes, lists and spinners

Macro Basics

  • (Macros are covered fully on the Excel VBA course)
    • What is a macro?
    • Security levels
    • Record a simple macro
    • Assign shortcut keys
    • Create a macro ribbon
      • Add/Remove a tab and icon
      • assign a macro to a icon
    • Deleting macros

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.   These may be either paper based or in Adobe pdf format or a combination thereof.

“Great pace and quite upbeat. Great instructor with good examples and happy to answer any questions. Looking forward to the remaining courses I've signed up for, would definitely recommend. (Mar 2017)”Great instructor with good examples... would definitely recommend.

Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

NOTE:   We only offer this Microsoft Excel Advanced 2 course on a private in-house basis.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com