Course description
Excel: Intermediate Express
SquareOne Training's Excel Intermediate Express course is perfect for those who already use Excel and want to work more efficiently. On this course, you will learn essential features needed to enhance your data management and analysis skills. You’ll also discover time-saving keyboard shortcuts to streamline your workflow.
While on this course you will master some of Excel's advanced functions like VLOOKUP and IF statements to streamline calculations and data retrieval. You'll also learn to efficiently sort, filter, and remove duplicates, apply conditional formatting to highlight trends and visualise data with effective charts and graphs. Additionally, you'll gain expertise in using PivotTables to analyse complex datasets and generate insightful reports.
This Excel Intermediate Express course includes hands-on exercises ensuring you can apply your new skills immediately in your workplace by using practical exercises and real-world scenarios.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
Learners will need to have a good working knowledge of creating/formatting simple Spreadsheets, everyday formulas for example AUTOSUM. You will be self taught or would of attended our Excel Introduction (Level 1) course.
Upon completion, all learners will received interactive training files, a PDF manual and a certificate of attendance.
We have been delivering this training for over 30 years - and this course can be customised to your business needs and delivered either online, at your offices, or from our training center. This is our top-selling course and has won several awards.
Training Course Content
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/XLOOKUP
- COUNTIF
Conditional Formatting
- Apply Shading, Icon Sets and Data Fills to cells based on criteria
- Format Painter
Working with Large Data
- Split your Worksheet
- Freeze Panes
- AutoFilter and useful tips
- Filtering by Colour, Dates, Numbers and Text
- Sort and Custom Sort
Text Functions
- Use the Trim, Proper, Left, MID and Right Functions
- Concatenate Text
- Text to Columns
- Removing Duplicates
- Flash Fill
Tables
- Creating Tables
- Formulas in 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
- Creating Pivot Charts
- Changing the Chart Type
- Formatting Charts
- Adding Titles and Customising
- Sparkline's
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Reviews
Average rating 5
Favourite Topic: Pivot. Comments: very knowledgably
Favourite Topic: Function formulas. Comments: N/A
Request info
Welcome to SquareOne Training – Where Your Learning Journey Takes Centre Stage! For over 30 transformative years, SquareOne Training has been the beacon of excellence in IT and personal skills training. We started our journey when computers were just making...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.
Favourite Topic: Pivot tables. Comments: Louise was extremely patient with staff questions and took the day at a very steady pace for all levels to keep up. I finished today ...