Excel Intermediate Training Course
Excel Intermediate Training Course
Table of Contents
Microsoft Excel Intermediate Training Course Overview
Our Microsoft Excel Intermediate training course is designed for users with some experience working with Excel who want to broaden their knowledge. The 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 confident in their use of Excel and ready to take on new challenges with their data.
Microsoft Excel Intermediate Training Course Five Key Topics
- Learn Logical and Lookup functions
- Manipulate text data
- Link worksheet data
- Pivot Table reports
- Restricting data entry using Validation rules
Microsoft Excel Intermediate Training Course Details
Course Duration : 1 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Training Times : Our courses run run from 09:30 to16:30, course registration 09:00 – 09:30, refreshments available throughout the day. A buffet lunch is available – please discuss with the team.
Facilities : A relaxed environment, air conditioned training rooms, note pads, pens and unlimited access to our online course materials.
Microsoft Excel Intermediate Training Course Details
Course Location : Face to face group / public & onsite training available. Virtual training courses available.
Class Size : As a guide we recommend class sizes to be no more than eight.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our Intermediate to Excel courses can be tailored to your requirements – Get In Touch
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
Centre and Services
Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available
Our Trainers
Steve, one of our lead Excel trainers, has over 25 years of delivering Excel from basics to development levels. All our trainers are encouraged to become Microsoft Accredited within their first year of working at Mouse Training
Our instructors are very approachable, making the driest subject matter fun.
Microsoft Excel Intermediate Training Course Video
On Completion of Excel Intermediate
- Use Excel formulas confidently
- Manipulate data with text functions
- Use Logical and Lookup functions
- Link Worksheets
- Analyse Worksheet Data
- Create Pivot Table reports
- Restrict data entry using rules and drop down lists
Microsoft Excel Intermediate Training Course Outline
- Entering and copying formulas quickly and easily
- Using Absolute references in formulas
- Date calculations
- TODAY, NOW, EOMONTH and NETWORKDAY functions
- Concatenation; & operator and CONCAT function
- Fixing formula results using Paste as Values
- 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
- New array functions: ARRAYTOTEXT, TEXTJOIN, TEXTSPLIT, TEXTAFTER and TEXTBEFORE
- Aggregate data using the COUNTIFS and SUMIFS functions
- Using the IF, IFS and SWITCH functions for decision making
- AND, OR, XOR and NOT functions
- VLOOKUP, HLOOKUP and XLOOKUP functions
- Entering formulas to link related worksheets
- Linking Excel workbook files
- Controlling and maintaining workbook links
- Sorting and filtering using array formulas FILTER, SORT and CHOOSECOLS
- Remove Duplicates
- Calculating distinct data with the UNIQUE function
- Tables or Ranges as source data
- Create a Pivot Table report
- Refreshing data
- Formatting Pivot tables
- Using Timelines and Slicers
- Restricting data entry for ranges using validation rules
- Setting the input message and error alert
- Creating drop down lists
Is this Intermediate Excel Course for You?
Attendance of either our Excel basics or a good working knowledge of navigating Excel workbooks, formatting and functions.
Give us a call, our admin team will be delighted to assist in making sure you are on the correct course level.
Related Courses
Excel Intermediate Training Course