Excel

Excel Intermediate:

This course is quite heavy formula based introducing Ifs, vlookups and linking data between sheets, also you will look at working with large amounts of data helping to sort, filer and hide data.

Course Outline
Excel Intermediate 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel and focuses on working with large spreadsheets, manipulating data, using more advanced formulae and functions and advanced charting techniques.

Prerequisites

Delegates should have a basic knowledge of the Introduction outline.

Formulae/
Functions
An in-depth look into:
  • IF’s and Lookup Functions
  • Worksheet/Workbook Linking
  • Calculating with Dates
  • Subtotals
Data Manipulation
Controlling data using:
  • Auto Filtering
  • Grouping and Outlining
  • Freeze Panes Sorting Data
  • Working with Comments
Ranges
Manipulating Worksheets using:
  • Named Ranges
  • Conditional Formatting
  • Hiding/Un-hiding Data
  • Password Protecting Worksheets
  • Protecting Specific Cells
  • Changing Default Options
Advanced Charting
Building on basic Charting using:
  • Combining Multi-Chart Types
  • Custom Chart Formats
  • Creating Secondary Axis

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

"This morning I set up a Macro (as per Thursday’s advanced course) and recorded the whole operation so I could apply to future reports downloads and ‘wow’ this has really saved so much time -thank you."

Iris Vicary, Telent

"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