Excel

Excel Advanced:

Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.

Course Outline
Excel Advanced 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel wanting to further their knowledge – this course covers automating spreadsheets and using advanced data handling techniques.

Prerequisites

Delegates should have a good knowledge of the Introduction and Intermediate outline.

Advanced Functions
An in-depth look into:
  • Nesting IF’s
  • And/Or Functions
  • Array Formulas
  • Text Functions
  • Database Functions
Pivot Tables
Pivot Tables and Pivot Charts:
  • Creating and Editing Tables & Charts
  • Refreshing Data
  • Displaying Pages
  • Slicers
Templates & Editing
Templates & Advanced Editing Techniques:
  • Creating & Editing Templates
  • Deleting Templates
  • Paste Special & Paste Link
  • Data Validation
  • Custom Views
  • Shared workbooks
Spreadsheet Automation
Working with Macros:
  • Creating & Naming Macros
  • Absolute and Relative Macros
  • Creating Macro Buttons
  • The VBA screen

Tags: Microsoft Excel, Software

About the Trainers

Qualifications - European Computing Driving License (ECDL) Microsoft Office Specialists (MOS) Microsoft Office User Specialist (MOUS), Microsoft Certified Applications Specialist (MCAS), 2 of our trainers have taken the Institute of Learning Management Train the Trainer Master Class Award. Every trainer has a minimum of 5 years training experience.

mpn

NC Member logo

Latest News

Windows 8 and 10

Windows 8 courses now available.

New courses for Microsoft Windows 10 will be available soon – be one of the first to see it with us.

MS Office Training

Microsoft Office weekend training and Microsoft Office 2013 upgrade training now available.

Testimonials

"I have used NC Training Services for a number of years now to provide a range of training for staff at 2 different companies. I have always been very impressed by the flexibility of the company and the consistency of the training. The feedback from all staff who have attended the courses has been extremely positive and has definitely suited the needs of the people. Due to the ability to tailor make a course, I have been able to provide clear objectives (which can vary depending on the company/people being trained) and this is something I had not been able to do before and it certainly proved extremely beneficial for the people attending the course. I would certainly recommend NC Training Services."

Caroline Holt, Customer Service Manager

"After taking part in the intermediate and advanced excel courses I soon booked onto the word training. Nicola was both helpful and technical. The courses were just the right length and I would strongly recommend."

James Harris, Critchleys Chartered Accountants