reed.co.uk Courses

Header

January sale shop all deals

Microsoft Excel Intermediate - In-company / Bespoke


MS Office Training Ltd

Summary

Price
£400 inc VAT
Payment options

£400 for one-to-one courses and £550 per day of training for in company groups of 8

... Read more
Study method
On-site
Duration
2 Days, Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

31 students enquired about this course

Add to basket or enquire

Enquire now

Overview

Course Objectives

The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.

'

Customer Feedback

  • Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.

  • Kelly Moreley - TACT
  • Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.
  • Jenny Price - Acer

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

  • Our competitive rates start from £550.00 per day of training

Tailored training courses:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Description

Quick Recap Using references in Excel formulas

  • Overview of formulas in Excel
  • Relative, Absolute and Mixed cell references

Group editing worksheets

Mastering Excel Tables

  • Introducing Excel Tables
  • Creating Calculated Columns
  • Formatting a Table
  • Using Advanced Table Tools
  • Using Slicers
  • Converting Tables to Ranges
  • Removing duplicates

Using names Ranges

  • In Excel formulas
  • As a way of navigating through the workbook

Advanced Formulas

  • Simple IF examples
  • Using IF to check if a cell is blank
  • Nested IFs
  • VLOOKUP
  • HLOOKUP
  • PMT financial Function
  • Database Functions
  • Text Functions
  • Date Functions

Conditional formatting

  • Apply Conditional Formatting
  • Customising Conditional Formatting
  • Using Icons in Conditional Formatting

Linking spreadsheets and workbooks

  • Making a reference to another worksheet
  • Making a reference to another workbook
  • Editing links
  • Troubleshooting links

Analysing databases

  • Quick analysis
  • Sorting a database
  • Apply filters to a database
  • Advance filter
  • Outline data by levels
  • Sorting and Filtering by Conditional Formats

Charts

  • Analyse trends in data using Sparklines
  • Creating charts from start to finish
  • Available chart types
  • Create a Chart Template
  • Formatting Chart Elements and Styles
  • Filtering Charts by Series or Categories
  • Adding a Trendline to a Chart

Attaching security to a spreadsheet and workbook

  • Protect a worksheet
  • Protect a workbook

Introduction to Pivot Tables

  • What are Pivot Tables?
  • Using recommended pivot tables to analyse your data

Changing Excel’s environment Options

Who is this course for?

For those who want to explore in more detail formulas and functions, data analysis and data presentation.

Requirements

Preferably, delegates would have attended the Excel Introduction course.

Questions and answers

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals

Mobile Navigation