Excel Intermediate
- Quickly summarise multiple sheets of data into one
- Turn long lists and reports into easy to read tables
- Formulas to check whether cells pass or fail your rules
- Create links between cells so that they all update automatically
- Highlight targets, trends, duplicates and errors with Conditional Formatting
- Formatting and layout consistency by saving as a Template
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,432 people .
- Over 14,060 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.8% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
These intermediate Microsoft Excel courses are designed for delegates who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.
You may also wish to know we also deliver advanced Excel training courses.
Training Course Content
Working with Multiple Worksheets and Workbooks
Using multiple worksheets- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Working with dates
Entering date functions- TODAY function
- NOW function
Date and time formats
Using dates in formulas
Conditional Formulas and Formatting
The IF functionConditional formatting
Creating named ranges
Using named ranges in formulas
COUNTIF(s), SUMIF(s), AVERAGEIF(s)
List Management
Working with listsCreating dynamic ranges
Sorting and filtering lists
Sorting by multiple columns
Using AutoFilter
Tables
Documenting and Auditing
Best practice spreadsheet designViewing, adding, editing and deleting comments
Auditing features
Tracing formula errors
Protecting a worksheet
Protecting cell ranges
Creating Charts
Creating and modifying chartsAdding trendlines
Visualising multiple data sets
Using Sparklines
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads