Course description
SquareOne Training - Excel: Intermediate (In-House)
This Microsoft Level 2 Excel: In-House training course is offered to your company as a closed course tailored to your company's business needs. Our experienced Microsoft Certified Trainers will help all users gain the skills needed to work more effectively in Excel and improved their understanding of the software to produce powerful, well presented spreadsheet models.
Useful content will include how to create dynamic spreadsheets, create 3D workshops that are linked, use essential advanced formulas such as VLOOKUPs and IF statements, manipulate large data within Excel tables and analyse data through Pivot Tables and Charts. We will provide you with the tips and shortcuts to change the way you use Excel, saving you valuable time and improving your efficiency.
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
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: all sections interesting . Comments: no