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
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Upcoming start dates
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
List price £330, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
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.
Reviews by course attendees
Average rating 4.8
Good service not too stressful; learned a lot a very nice lunch too and an enjoyable day overall - explained with patience. Would come back!
I thought the course was great! It was a little slow paced for my preference but that was probably just me; and I'm really looking forward to the Advanced training next week.
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...
Thought Mike was extremely engaging and his teaching style was good; no death by powerpoint and really interactive; liked how we were doing the tasks at the same time as him and...