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 .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Choose between 82 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
Based on 16904 reviews.
Write a review!
Reviews are published according to our review policy.
Sara
5/5
05 Aug 2024
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
Most useful topic: formulas and formatting and connect spreadsheets