Bua Training
Suggested Uses
Training Course Outline
After the Course
You will be able to record macros, create templates to be used for future calculations, summarise information with pivot tables and use passwords to protect your work. You will also be able to combine powerful mathematical functions to automate tasks and use array formulas.
  • Financial Management
  • Store, sort and filter lists such as names and addresses
  • Create financial templates such as invoices or expenses sheets
  • Display your data on a chart
  • Summarise large volumes of information in pivot tables
  • Create sophisticated formulas to calculate information
  • Link to external databases
  • Name a Cell or Range
  • Array Formulas
  • Spreadsheet Security
  • How to Use what You’ve Learnt
  • Left, Mid & Find
  • Date-Based Functions
  • More Functions
  • Conditional Formatting
  • Print Options
  • Customise Toolbars & Menus
  • Templates
  • Custom Views
  • Validation
  • Macros
  • VLookup & HLookup
  • Solver
  • Scenarios
  • Consolidate Data
  • Microsoft Excel Level 4

    Microsoft Excel is a spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections. Microsoft Excel training courses are available at our state of the art training centre in Dublin City Centre or we are happy to travel to your company premises anywhere in Ireland.

    Fill out Microsoft Excel Pre-Course Questionnaire

    If you would like to have a course customised for your organisation, please contact us.
    Back to Software Training Course List
    1 Day Intensive
    Private Course
    Public Course
    Training Rooms
    Post-Course Support
    Consultancy Available
    © Bua Training 2020