Course description
SquareOne Training - Excel: Intermediate | In-House
SquareOne Training's Excel Inermediate In-House training course is offered anywhere in your offices or as a closed course from our training centres in Merseyside or Manchester. We also offer this online to any company in Europe
This course is designed for users who want to deepen their understanding of this powerful programme. You will learn some of Excel's advanced functions, data manipulation techniques, and effective strategies for improving productivity and efficiency in your spreadsheet work.
Throughout the course, you will explore key topics such as advanced formulas, data validation, conditional formatting, and the use of pivot tables. Hands-on exercises will guide you through real-world scenarios, allowing you to apply your knowledge and gain practical experience.
By the end of the course, you'll be equipped with the skills to analyse data more effectively, create sophisticated reports, and streamline your workflow. Perfect for business professionals, analysts, and anyone looking to enhance their Excel capabilities, this course will empower you to work smarter and make data-driven decisions.
Upcoming start dates
Suitability - Who should attend?
SquareOne Training - Microsoft Level 2 Excel: In-House training course is suitable for existing Excel users at an intermediate level and who wish to further their understanding and create powerful and well presented spreadsheets.
Ideal for those who are comfortable with Excel basics, our Excel Intermediate course is a fantastic two-day option for individuals aiming to analyse data and build spreadsheets for the workplace. You will learn to use Excel to present data in a graphical form, enhancing your business skills.
Outcome / Qualification etc.
Objectives
Designed and delivered by industry-leading trainers, this course covers features such as IF statements, VLOOKUP, PivotTables, and techniques for working with and manipulating large datasets and linked sheets. Upon completion, all delegates will receive a certificate of attendance, an extensive manual, and the confidence to advance to higher levels of Excel proficiency.
Training Course Content
Overview of Shortcuts
Recap of everyday features, Tips and Tricks, Customising the Ribbon.
Formula and Copying Refresh
AUTOSUM, COUNT, %, AVERAGE, Absolute Cell Referencing.
Range Names
Create, Navigate using Range Names, Print Areas, Formulas using Range Names.
Creating Spreadsheets
Creating 3D Spreadsheets, Print and Design for all Sheets, Copy, Move, Rename, Colour Sheet Tabs, Hide and Unhide Sheets, Link data from one Sheet to another with Formulae, Group and Edit all Sheets
Linking Data
Linking Data from other Workbooks.
Advanced Functions
IF Statements, VLOOKUP, XLOOKUP, COUNTIF, SUMIF.
Conditional Formatting
Apply Shading, Icon Sets, and Data Fills based on criteria. Use Format Painter to copy Formats, Calculations.
Working with Large Data
Use AutoFilter and related tricks, perform Sorting and Custom Sorting, remove Duplicates., Creating SubTotals, Outline View.
Text Functions
TRIM, PROPER, LEFT, RIGHT, CONCATENATE, Convert text to Columns, Flash Fill.
Data Validation
Creating Dropdown Lists, Input Messages, Error Alerts, Limiting Input of Length and Formats.
Protection
Protecting Cells, Sheets and Workbooks.
Tables
Create, Format, Table Calculations.
Pivot Tables
Prepare Data, Create and Format PivotTables, Group Data, Refresh Data, PivotCharts, Slicers and Timelines.
Charting
Create charts using Function Keys, Change Chart Types, Format, Titles, Sparklines.
Top 10 Awards
Top 10 Winner - 2024
We're delighted to announce that SquareOne Training is a winner of our Top 10 Courses 2024 in Top 10 Digital Skills Courses.
Each year, Findcourses select the top 10 most popular courses in some of the most popular categories to make it easier for our users to find the right course for them - so you can book with confidence.
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 4.9
Favourite Topic: Table creation and changes. Comments: no additional feedback, session was great and interesting
Favourite Topic: Pivot tables & lookups. Comments: Very well taught with lots of patience
Request info
Top 10 Awards
Top 10 Winner - 2024
We're delighted to announce that SquareOne Training is a winner of our Top 10 Courses 2024 in Top 10 Digital Skills Courses.
Each year, Findcourses select the top 10 most popular courses in some of the most popular categories to make it easier for our users to find the right course for them - so you can book with confidence.
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
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.
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.
Favourite Topic: all sections interesting . Comments: no