Excel Intermediate - Online (Instructor-led)
5 Star Rated | Microsoft Certified Trainers | Virtual Course
KEYS TRAINING
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This one-day instructor-led course is designed to develop the practical skills of Excel users. By the end of the course, participants will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.
- This online course will be presented using Microsoft Teams.
Certificates
Certificate of completion
Hard copy certificate - Included
Course media
Description
Outcome / Qualification etc.
- Use advanced formulas and functions
- Define names for individual cells and ranges
- Use the database tools in Excel
- Work effectively with large spreadsheets
Training Course Content
Functions
- IF functions
- VLOOKUP and HLOOKUP
- Function to combine data from multiple cells
- Data functions
- Nested functions
Tools
- Naming cells and ranges
- Protecting cells
- Linking workbooks
- Linking applications (Excel with Word or PowerPoint)
Database tools
- Sorting data – ascending, descending, left to right
- Sorting data in custom sequences
- Filtering data with AutoFilter
- Creating customised and advanced filters
- Using data forms to enter, delete and search for data
- Using subtotals to calculate subsets of data
Formatting
- Hiding columns, rows and formulas
- Grouping columns and rows
- Applying conditional number formatting
Who is this course for?
This training course is recommended for individuals that are looking to improve their knowledge and skill level when using Excel. The skills learned will help the delegates be more effective and efficient in their roles.
Requirements
This course is designed for participants who have completed the Excel Level 1 course or have equivalent knowledge. Participants should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT and also be aware of the difference between relative and absolute references.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.