Microsoft PowerBI Business Intelligence Software Certified Instructor delivering spreadsheet software training courses for individuals and groups, both onsite and online.

Microsoft PowerBI Training

Unlock Your Data Potential

Probably the most used, and useful, application used in any organisation today, Microsoft PowerBI empowers you to quickly and efficiently analyse data. We’ll show you how to organise large amounts of data, produce professional charts and graphs, perform calculations with speed and with ease. Each level of training takes one day to complete.

Microsoft PowerBI Training Course Outlines

Microsoft Excel Introduction
Learn how to create Microsoft Excel spreadsheets in the comfort of your work place on site. We’ll help you to understand how to perform calculations and use Excel’s many built in features. See how to manage references and turn your sheets into robust working tools. Make sheets that look great when on screen and in print. Learn valuable tips and tricks for productivity.

  • Spreadsheet design and formatting
  • Using formulas for calculation
  • Understanding functions
  • Relative vs Absolute references
  • Page setup and Printing
  • Keyboard shortcuts
Microsoft Excel Intermediate
Learn how to make Excel perform calculations and formatting dependent on what your data says. Discover how to use Excel as a simple database, how add graphs and charts, the secrets of connecting your sheets together and how to organise your workbooks efficiently.

  • IF formulas
  • Conditional formatting
  • VLOOKUP formulas
  • Linking sheets
  • Sorting
  • Filtering
  • Sub totals
  • Pivot tables
  • Named ranges
  • Charts
Microsoft Excel Advanced
Learn advanced techniques for formulas, include complex logic and error handling in your sheets. Discover how to manipulate text in Excel. Expand your ability process large volumes of data. Learn how to get the most from Excel through customisation.

  • What If features (Goal Seek and Scenarios)
  • Error prevention
  • Text functions
  • Working with large sheets
  • Convert text from one to multiple columns
  • Removing duplicates
  • Macros and Automation
  • Customising ribbons and toolbars
  • Adding macros to custom ribbons
Microsoft Excel Bespoke / Tailored
Build your own course by selecting topics from three levels, or adding your own!

Get in touch for more information.

Course Delivery Options

ONSITE Learning

Learn in the comfort of your own workplace, both individually and in small groups of colleagues.

Each course is delivered by an experienced, qualified instructor who is on hand to help individual learners as well as guiding the group with hands-on examples and exercises.

Each course can be personalised to meet the individual needs of the business and the trainees

Duration: 1 day per level

REMOTE Learning

Learn with the convenience of remote meeting technology such as Teams or Zoom.

With the benefit of two screens each learner will feel involved, and the live training delivers the same quality of training as the in-room experience of trainer/delegate interaction.

The trainer will deliver the training live, with each demonstration on one screen, taking the trainee through the examples step by step on their own screen.

Each course can be personalised to meet the individual needs of the business and the trainees.

Duration: 1 day per level

More Software Training Courses