Skip to content

Microsoft Excel Intermediate - In-company

Online or on-site course with 1 year tutor support and certificate


MS Office Training Ltd

Summary

Price
£650 inc VAT
Finance options

£550 per day of training for in company groups of 8 delegates, £400 for one-to-one...

Study method
Onsite
Duration
1 day · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

15 students enquired about this course

Add to basket or enquire

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.

Tailored training courses:

In, in company training, 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.

Certificates

Certificate of completion

Digital certificate - Included

Description

Recap on Excel formulas and calculations

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

Group editing worksheets

Autofill and Flash Fill

Changing Excel’s environment Options

  • Changing the default number of sheets
  • Creating an Autofill Custom List
  • Adding tools to the Quick Access Toolbar

Mastering Excel Tables

  • Introducing Excel Tables
  • Formatting a Table
  • Creating Calculated Columns
  • Using Slicers to filter your data
  • Using Totals to get statistics out of your data
  • Removing duplicates
  • Converting Tables back to normal Ranges

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
  • Text Functions
  • Date Functions

Conditional formatting

  • Apply Conditional Formatting
  • Customising Conditional Formatting
  • Using Icons in Conditional Formatting
  • Using Formulas to conditionally format cells

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
  • Sorting and Filtering by Conditional Formats

Charts

  • Analyse trends in data using Sparklines
  • Creating charts from start to finish
  • Exploring the different Chart Types
  • Apply Chart Styles
  • Formatting Chart Elements
  • Filtering Charts by Series or Categories
  • Adding a Trendline to a Chart
  • Create a Chart Template

Attaching security to a spreadsheet and workbook

  • Protect Cells
  • Protect Structure of worksheets
  • Protect a Workbook by adding passwords

Introduction to Pivot Tables

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

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.

Career path

Excel know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

Questions and answers

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.