- 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:
8th January
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 and Power BI Data Modelling
Master the essentials of data modelling with our Excel and Power BI Data Modelling Training Course. This comprehensive course covers Power Query, Power Pivot, and Power BI, equipping you with the tools to clean, structure, and visualise your data effectively. Gain the skills to build powerful data models, create impactful reports, and make smarter decisions for your business.
Virtually Online Or On-Site
2 Days
- Microsoft Excel
Excel Power Query Introduction
- 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
© 2024 - All Rights Reserved.
All trademarks are owned by their respective owners.
