Expand your Excel skills on this 1-Day Intermediate Excel training course.
Learn to use some of Excel’s more powerful features like sorting and filtering data and creating charts.
This hands-on course includes lots of time to try out what you are being taught and ask questions.
✔ An intermediate Excel course that will build on your existing Excel skills.
✔ Plenty of one-to-one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and CPD accreditation
What Will I Learn?
By the end of this course you’ll be a far faster, more confident Excel user.
You’ll learn how to:
- Create and format different types of charts.
- Work with multiple sheets in Excel workbooks.
- Copy and paste data in a variety of different data formats.
- Use quick analysis tools to visualise your data.
- Work with Excel’s list / database features to quickly sort data tables.
Course Details
Download full course details
Below is the typical timetable for this training course, although exact timings vary between training course.
Stop copying and pasting between tabs – let Excel pull the data for you automatically.
- Creating, copying, moving, renaming, grouping and hiding worksheets, and colour-coding tabs
- Hiding rows and columns, freezing panes and splitting windows to navigate large sheets
- Creating, updating and managing links between worksheets and workbooks
- Counting entries, blanks and matching values with COUNT, COUNTA, COUNTBLANK and COUNTIF
- Adding up only the values that meet your criteria with SUMIF and SUMIFS
- Combining text from separate cells with CONCATENATE
Build charts that communicate clearly, not just charts that exist.
- Choosing the right chart type, then creating, moving, resizing and printing it
- Working with embedded charts and separate chart sheets
- Applying chart layouts, styles and formatting
- Adding and formatting titles, axis titles, legends, labels and gridlines
- Enhancing charts with trendlines, error bars and data table
If you spend time manually sorting or formatting data, this session will help get that time back.
- Using Paste Special to bring across only what you need, whether that’s values, formulas, formats, comments, validations, links, pictures or column widths
- Performing calculations and transforming data with Paste Special
- Sorting alphabetically, numerically, across multiple columns and by rows
- Applying compound, multi-value, custom and wildcard filters to find specific information
- Creating and saving custom views so you can switch between worksheet displays quickly
Make your data easier to understand at a glance and let Excel do more of the analysis work.
- Highlighting values with value-based, ranking and custom formatting rules
- Visualising data with data bars, colour scales, icon sets and sparklines
- Creating, editing, managing and clearing conditional formatting rules
- Turning data into Excel tables, and managing records, columns and duplicates within them
- Using Quick Analysis to rapidly apply formatting, charts, totals, sparklines and tables
Online Training Requirements
To attend this Excel course online, you will need:
✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/