About this course
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.
It is a practical hands- on course. Delegates are "learning by doing" with access to MS Excel Software for the course duration.
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
What you will learn
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
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.
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)
Recent reviews
Great course, learned new tips and tricks thanks louise
Very beneficial, some really useful tips and an easy to follow session. Thank you Louise
I will found the course beneficial , a bit more time spent on the separate topics might benefit some and notes to refer back to would be great .