Excel Training Course

Table of Contents

Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course

Course Overview

This Microsoft Excel Intermediate  training course is designed for  users  with some experience working with Excel wanting to broaden their knowledge, our Excel Intermediate course focuses on unleashing the power of Excel formulas and functions to manipulate worksheet data and includes a brief guide to summarising data with filters, subtotals and tables.

Delegates will leave feeling a new confidence in their Excel experience and ready to take on challenges with financial data.

Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course

Five Key Topics

Using Range Names in formulas & navigating spreadsheets 
Absolute and Relative addressing
Create calculations based on condition
Summaries data using Subtotals
Restricting data entry using Validation rules

Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course

Course Details

Course Duration: 1 day
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability: Monday – Saturday

Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course

Course Location: This Microsoft Excel intermediate training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultant service to help tailor your course to meet your requirements.

Rate: £200 + VAT

Next Public Course: 22nd January 2020 – 11th March 2020

Days
Hours
Minutes
Seconds

Back to Contents

Centre and Services

Comfortable & modern facilities
Unlimited access to out online trining manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

At Course Completion

Excel Intermediate Course Outline

  • Use Excel formulas confidently
  • Manipulate data with text functions
  • Use Logical and Lookup functions
  • Link Worksheets
  • Analyse Worksheet Data
  • Protect Excel documents
  • Save time formatting worksheets
  • Restrict data entry using rules and drop down lists

Course Outline

  • Entering and copying formulas quickly and easily
  • Using Absolute references in formulas
  • Date calculations
  • TODAY, NOW and NETWORKDAY functions
  • Using named ranges in formulas
  • Concatenation; joining data together
  • Fixing formula results using Paste as Values
  • Splitting data using Text to Columns
  • Changing case using UPPER, LOWER and PROPER
  • Extracting data using LEFT, RIGHT and MID
  • Dealing with space characters using LEN and TRIM
  • Using FlashFill to manipulate data
  • Aggregate data using the COUNTIFS and SUMIFS functions
  • IFERROR and IFNA functions for correcting error values
  • Using the IF function for decision making
  • AND, OR, XOR and NOT functions
  • VLOOKUP and HLOOKUP functions
  • Moving the cell pointer from one worksheet to another
  • Copying data from one worksheet to another
  • Entering formulas to link related worksheets
  • Linking Excel workbook files
  • Formatting multiple worksheets in one operation
  • Moving and copying worksheets
  • What is a Table?
  • Tables or Ranges?
  • Sorting ranges and tables
  • Filtering lists and tables using AutoFilter
  • Adding Subtotals and nested Subtotals
  • Creating a Pivot Table report
  • Changing the summary function in a Pivot Table report
  • Use spreadsheet compare
  • 3D Maps 
  • Locking and Unlocking cells
  • Worksheet protection
  • Workbook protection
  • Excel styles
  • Modify Normal Style to format all the worksheet cells
  • Create custom number and date formats
  • Excel workbook template files
  • Creating and using Templates
  • Restricting data entry for ranges using validation rules
  • Setting the input message and error alert
  • Creating drop down lists

Back to Contents

Related Courses

 

What is Power Bi – Business intelligence like never before

Excel Advanced Training Courses in London, either held at your workplace or at our Excel training London centre or Nationwide.

Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course
Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course
Excel Intermediate Training Courses, Microsoft Excel Intermediate Training Course