Microsoft Excel (Advanced)

Course Highlights

On completion of this course, delegates will be able to:

  • Use Range names
  • Import and Export data
  • Use complex functions
  • Use Lookup & Reference functions
  • Use Pivot Tables and Pivot Charts

It is a practical hands- on course. Delegates are "learning by doing" with access to MS Excel Software for the course duration.

Click below for feedback from clients – also browse down for further course details

Michaella O
16/11/2022
Brilliant training, well-structured session. Thanks Louise
Emilia Z
29/09/2021
Thank you Louise, you are very patient on all the questions. The introduction course was last week. The Intermediate and the Advanced were held on a Monday and Wednesday, well this is how it was for me, and it was great because the previous class was still fresh in my mind so it really helped. I think that to apply the knowledge there is an additional need to work with a group in a section, so that we all know what to do and how to make the best use of Excel because it is powerful , it creates collaboration and good time monitoring and most importantly reduce unnecessary work.
Linda C
29/09/2021
Really easy to follow, Material shown was really valuable.
Joanne S
29/09/2021
Excellent course and the trainer was very good. Very clear and informative. Learned a lot and will definitely be useful in our work at RTB.
Cathal R
13/01/2021
Good refresher, and found some more effecient ways to do the things I have been doing, which should save me a bit more time.
Zoe G
12/01/2021
Louise was amazing! She was in contact prior to the course to find out what we would find most beneficial in the course. She clearly really knows her stuff. Went at a good pace and kept us engaged. Learnt plenty of new tips, tricks and formulae, which will definitely be useful in my job. thanks so much Louise!
Breda K
19/02/2019
Joe was a very personable and helpful trainer. The attendees had varying degrees of excel knowledge and therefore it was challenging for Joe to cover everything for all individuals but his knowledge of excel is excellent and he provided some excellent tips and short cuts for the more advanced users.
Read more reviews

Overview

MS Excel the popular spreadsheet from Microsoft. This 1 day course is designed to increase users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts. Joe O’Connor is a Certified Microsoft Master Instructor.

What's Included

Introduction

  • Review Exercise

Working with Named Ranges

  • Creating Range Names
  • Range Names in Calculations

Importing and Exporting Data

  • Using Paste Special
  • Importing a Text File into Excel

Complex Functions

  • Using Paste Special
  • Nested If and IfError Functions
  • AND / OR Functions
  • IsError Function

Lookup and Reference Functions

  • Using the VLOOKUP Function
  • Using SumIFs Fucnction

Pivot Table & Charts

  • Creating Pivot Tables
  • Editing Pivot Tables
  • Printing Pivot Tables

Dashboards

  • Explanation of Dashboards (This is a separate course).

Macros

  • Understand Macros (This is a separate course)

Course Includes

Learn by doing – in additional to the formal presentations from Trigraph, attendees will benefit by using the MS Excel software itself on their own dedicated PC / Laptop. They will build their own Worksheets.

The training materials are fully owned by Trigraph which means we have full flexibility to tailor the content to suit particular client requirements.

Requirements

It is assumed that you can bring your own laptop to the course with MS Excel installed.

Users with a basic understanding of MS Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.

A working knowledge of using PCs, Windows, gained from the workplace or by prior attendance on a course.

Show the next months
in
Powered by Administrate Software for Training Providers
© Copyright - Trigraph Professional Training