Microsoft Excel: Intermediate Express

Wed Dec 08 2021 at 09:30 am to 04:30 pm UTC+00:00

Centurion House | Manchester

SquareOne Training
Publisher/HostSquareOne Training
Microsoft Excel: Intermediate Express
Advertisement
This course was created to show people how to use the clever Microsoft Excel Data Manipulation Features.
About this Event

Who Should Attend?

Are you looking to become more confident in Excel within a short period of time? Our Excel Intermediate Express course could be perfect for you. If you currently use Microsoft Excel for basic formulas and functions such as Auto sum then this one day express course could help streamline the way you work. Designed and delivered by industry leading trainers, this course will teach you features such as VLOOKUP, pivot tables and how to work with large data.

Prerequisites

Delegates will need to have a good working knowledge of creating/formatting simple spreadsheets, basic formulas and functions for example AutoSum. You will be self taught or would of attended our Excel Introduction (Level 1) course.


On the day of training delegates will receive lunch with refreshments.

Upon completion, all delegates will receive a certificate of attendance, an extensive manual and a range of tips to save you time and improve the way you work. 

For more information about this course call (0151) 650 6907 or email [email protected]

Terms and Conditions.Generally, our courses run from 09:30 until 16:30 unless otherwise stated. Some courses will be more than 1 day so please read the dates at the time of booking.After booking via Eventbrite you will receive notification from them of your purchase. You will also receive joining instructions from the SquareOne team, confirming dates, times and location. We will also at that time check on any special needs or dietary requirements you may have.In the unlikely event that this course is cancelled – then SquareOne will work with you to schedule new dates.


Course Duration

Duration: 1 Day Classroom Training or Online


Timings: 09:30 - 16:30


Overview of shortcuts
  • Recap of Shortcuts and Tips
  • Customising the Ribbon to include useful shortcuts
  • Refresh on everyday Formulae
  • Recap of Absolute Cell Referencing
Range Names
  • Create Range Names
  • Navigate using Range Names
  • Print Range Name Areas
  • Create Formulae using Range Names
Advanced Functions
  • IF Statements
  • VLOOKUP
  • COUNTIF
Conditional Formatting
  • Apply Shading, Icon Sets and DataFills to cells based on criteria
  • Format Painter
Working with Large Data
  • Split your Worksheet
  • Freeze Panes
  • AutoFilter
  • AutoFilter Formatting and tricks
  • Sort and Custom Sort
  • Removing Duplicates
Text Functions
  • Use the Trim, Proper, Left and Right Functions
  • Concatenate Text
  • Text to Columns
  • Removing Duplicates
  • Flash Fill
Date Functions
  • Entering data Formulae
  • Now and Today Functions
  • Customising Data Formats
Tables
  • Creating Tables
  • Formatting Tables
Pivot Tables
  • Preparing data for a Pivot Table
  • Create Pivot Tables
  • Format Data
  • Group Data in Pivot Tables
  • Refresh Data
  • Slicers
Charting
  • Creating Charts Using a Function Key
  • Creating Pivot Charts
  • Changing the Chart Type
  • Formatting Charts
  • Adding Titles and Customising
  • Sparklines
Advertisement

Event Venue & Nearby Stays

Centurion House, 129 Deansgate, Manchester, United Kingdom

Tickets

GBP 250.00

Sharing is Caring:

More Events in Manchester

Blowout
Tue Dec 07 2021 at 11:00 pm Blowout

42nd Street Nightclub

International Winter Party
Tue Dec 07 2021 at 11:00 pm International Winter Party

Ark Deansgate Locks

Sorebae, Family Time
Wed Dec 08 2021 at 12:00 am Sorebae, Family Time

The Castle, Manchester

Van Gogh Alive
Wed Dec 08 2021 at 12:00 am Van Gogh Alive

Media City UK

Pyncher +Splitter and more!
Wed Dec 08 2021 at 07:30 am Pyncher +Splitter and more!

Aatma

Installer Training Day
Wed Dec 08 2021 at 08:00 am Installer Training Day

Manchester Central Convention Complex

International sisters meet and greet!
Wed Dec 08 2021 at 10:00 am International sisters meet and greet!

The University Of Manchester Islamic Society ISoc

Silcock's Winter Wonderland Manchester 2021-2022
Wed Dec 08 2021 at 10:30 am Silcock's Winter Wonderland Manchester 2021-2022

EventCity Manchester

Meet the Manager
Wed Dec 08 2021 at 11:00 am Meet the Manager

Nuffield Health (Didsbury)

Toddler Christmas Party
Wed Dec 08 2021 at 11:15 am Toddler Christmas Party

Cheeky Cherubs Community learning centre

Second Year Law Social Event
Wed Dec 08 2021 at 12:00 pm Second Year Law Social Event

Williamson Building

Manchester is Happening!

Never miss your favorite happenings again!

Explore Manchester Events