All courses
All courses
Course categories
Contact us

Microsoft Excel Intermediate, 1 day

Delivered at your office or a training centre, in groups or 1-2-1

This course focuses on writing formulas, analysing data and outputting reports. Use the formula help tools to find and write formulas to output results from multiple questions. Efficiently output accurate reports to analyse sets of data. You will learn how to use rules to automatically format data to make it stand out. We will also look at ways to compare different sets of data. Those attending will also learn lots of time-saving tips and tricks.

Check availability in your area…

Key features

  • Live instructor-led course with 6 hours of training
  • Session runs from 9.30–5pm with normal breaks included
  • Fully certified trainer
  • Get key skills and practical knowledge
  • This course is available for delivery at your office, 1-2-1 and groups – contact us
  • Course materials included
  • Recognised course certificate

What will I learn?

Lesson 1

 Calculating with Absolute Reference: Understanding the difference between a Relative and Absolute referenced formula. Using a $ sign to lock formulas
onto cells when copying. 

Lesson 2

 Working with Groups of Worksheets: Grouping sheets together. Inputting
data into multiple sheets. Writing formulas to sum between sheets. 

Lesson 3

Creating Linked Tables: Linking to a source table. Using Paste Link to link a table to another file. Using Link Manager to manage linked tables. 

Lesson 4

The Function Library: Using the Function Library to help you write formulas. Search formulas with Insert Function. Writing statistical functions: COUNTA, COUNTBLANK, COUNTIFS and more. 

Lesson 5

 The Logical IFS Function: Writing Logical IFS functions to generate results
from a test. Running multiple tests for multiple results. 

Lesson 6

 Conditional Formatting: Automatically format data using rules. Enabling text and numbers to standout with automatic formatting. Copy formatting with

As an IT professional I need accredited training and your courses meet that criteria with the bonus of great customer care”

Charlie A

the Format Painter. 

Lesson 7

 The Side by Side Feature: Viewing two tables in two different files together.
Viewing two tables in two different sheets in the same file together. 

Lesson 8

 Pivot Table Report: Analysing table data with PivotTable reports. Managing a PivotTable’s layout. Output statistics. Controlling number formats. Creating a
PivotChart, and inserting Slicers for filtering. 

Lesson 9

Using Data Validation: Apply Data Validation to control and quicken the input of data. 

Lesson 10

 Lookup Functions: The Lookup and Reference function. Best practices for writing a VLOOKUP function. Best practices for writing an HLOOKUP function.
Achieving a professional finish to formulas by nesting within an IFERROR. 

Lesson 11

 Printing Options: Printing page titles across pages. Scaling content for print.

 

Download course details as a PDF

Interested in this course? Get in touch...

Call:
01225 308979

Email:
info@go.courses

Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
London
United Kingdom
EC1V 2NX

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Blog

Who actually delivers the Go.Courses training? Meet our trainer - Alan Gilbert

If you’d like to know a little bit more about the people delivering our training courses, read on. Meet our trainer Alan Gilbert, a man who knows how to deliver excellent training courses for us, particularly in Microsoft Excel and Powerpoint.

Blog

The Power of Microsoft VBA

With Microsoft VBA you can develop programs that control Microsoft Excel and Access, and other programs in Microsoft Office. With training courses available for all experience levels, it’s easy to get trained up in VBA.

Blog

5 reasons why you should invest in Microsoft Excel training

If you’ve never had Excel training you could be making mistakes and wasting time. Most people aren’t using Excel at its best. Keep reading to find out the top 5 reasons why Excel training is a wise investment.

Blog

The top 5 benefits of Power BI

Power BI is a useful cloud-based tool for working with data. To help you understand just how much Power BI can help your business, here are the top 5 benefits.

Blog

5 most useful things to learn about Microsoft Excel

From the simplest spreadsheets through to complicated systems, everyone in your business should know how to use Microsoft Excel on a basic level. We provide you an overview of the most useful things to learn about Microsoft Excel and advice on how to learn them effectively.

Blog

Is Microsoft VBA difficult to learn?

With the right training, learning Microsoft VBA is easy. The Microsoft VBA Introduction course makes it easy to learn VBA primarily for Excel. There’s also an Advanced VBA training course if you’re looking for a higher difficulty level.

Blog

How can I learn Excel quickly?

As specialists in instructor-led IT training, Go.Courses have a wide range of Excel courses and many can be delivered in as little as 2 hours. Here’s a quick overview of 5 of our most popular Excel training courses.

Blog

Why 2019 is an important year for Microsoft Azure certifications

You may have heard about some changes in Microsoft Azure recently. Here’s an overview of what’s changing, how to adapt and embrace these changes, and why Azure could be the best option for your IT infrastructure in 2019 and beyond.

Blog

Is Microsoft Azure Certification worth it?

With Microsoft Azure Certification, technology professionals are more likely to get hired, demonstrate clear business impact, and advance their careers. Microsoft Azure courses are available in locations all over the UK. Here’s an overview of the Microsoft Azure Solutions Architect Technologies AZ-300 course which will help you achieve Azure Certification.

Delighted satisfaction rating