- Courses/
- Microsoft Excel/
- Excel Intermediate/
Microsoft Excel Training Courses For Intermediate
Excel Intermediate
Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.
Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.
Virtually Online Or On-Site
1 Days
Next Running:
6th November
UPCOMING COURSES
Course Information
This 1-day Excel Intermediate training course is designed for learners who already have foundational knowledge and skills in Microsoft Excel.
Want to take you Excel skills to the next level?
We will teach you how to take advantage of some higher-level functionality in Excel in order to analyse and present data more effectively.
After just one day, you’ll be able to leverage the power of data analysis and presentation to make informed and intelligent decisions for your organisation.
Choose from our online public courses dates to book your course today.
Alternatively, contact us to arrange on-site training tailored to your needs!
Course requirements
Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.
Still need to grasp the basics? Get started with our 1-day Excel Introduction course.
What you will learn
After completion of the Excel Intermediate training course you be will be able to:
- Create advanced formulas
- Work with named ranges
- Analyse data by using functions and conditional formatting
- Organise and analyse datasets and tables
- Manipulate worksheets
By the end of this 1-day instructor-led Excel Intermediate course, you’ll know how to use things like conditional formatting, prepare and format all manner of Excel tables. Whats more, you will have an in-depth understanding of the most used Excel functions and formulas.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
1
Excel Setup & Printing Issues
- Headers and Footers
- Scaling Your Worksheet to Fit Page(s)
- Printing Titles on Every Page
- Previewing a Worksheet
2
Excel Functions and Formulas
- Getting Help with Functions
- Nested Functions
- Consolidating Data Using a 3-D Reference Sum Function
- Mixed References within Formulas
3
Excel Most Used Functions
- Inserting the Current Time and Date
- Today Function
- Now Function
- Round Function
- Sumif Function
- If Function
- Trim Function
- Concatenate Function
- Vlookup Function
4
Excel Named Ranges
- Naming Cell Ranges
- Removing a Named Range
- Named Cell Ranges and Functions
5
Excel Cell Formatting
- Conditional Formatting
- Custom Number Formats
6
Manipulating Worksheets within Excel
- Copying or Moving Worksheets between Workbooks
- Hiding Rows
- Hiding Columns
- Un-Hiding Rows
- Un-Hiding Columns
7
Paste Special Options within Excel
- Using Paste Special ‘Values’
8
Tables
- Preparing data for a table
- Creating a table
- Formatting a table
- Display the table total row
- Adding a row to a table
- Deleting a row from a table
- Inserting a column in a table
- Deleting a column in a table
- Renaming a table
- Advantages of a table
Private courses.
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!
Tailored
Post Course Support
Cost Effective
Reviews
- Microsoft Excel
Excel VBA Introduction
Boost your Excel skills with our Future Savvy 2-day Excel VBA course. Learn to automate spreadsheets, record macros, edit VBA code, and create custom forms. Perfect for gaining control and developing dynamic applications. Unlock the potential of workbooks and worksheets with hands-on guidance. Ideal for simplifying repetitive tasks and enhancing your Excel capabilities.
Virtually Online Or On-Site
2 Days
- Microsoft Excel
Excel Introduction
Gain essential Excel skills with our 1-day beginner course. Learn how to use Excel efficiently for business, perform calculations, create and use formulas, modify and format worksheets, and style data for greater impact. This training course is ideal for understanding and analysing your organisation's data to make informed business decisions.
Virtually Online Or On-Site
1 Days
- Microsoft Excel
Excel Advanced
Elevate your Excel prowess in our 1-day Excel Advanced training course. Master task automation, complex formulas, PivotTables, and data visualisation. Suited for experienced users, this course boosts your ability to analyse and present data.
Virtually Online Or On-Site
1 Days
© 2024 - All Rights Reserved.
All trademarks are owned by their respective owners.
