Details
This course is 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.
A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction course.
- 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
Outline
Working with Large Worksheets
Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
Hiding and displaying data
- Hiding rows and columns
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets
Working with Multiple Worksheets and Workbooks
Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links
Working with dates
Entering date functions
- TODAY function
- NOW function
Date and time formats
Using dates in formulas
Conditional formulas and formatting
The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats
List Management
Working with lists
- Structure of a list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter
Adding subtotals to a list
Documenting and Auditing
Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection
- Protecting a worksheet
- Protecting cell ranges
Using Templates
Built-in templates
- Accessing and using Excel’s templates
Creating and managing templates
- Creating, using and modifying a custom template file
Best STL seeks to provide unrivalled value and quality service, enabled by our unique business model.
We offer a wide range of business application and management training courses. Best STL (formerly Best Training) have been offering Microsoft training courses since 1992.
We are the number 1 provider for MS Office training and consultancy in the UK offering London's largest schedule of genuine dates (414 as of 7:50pm Wed).
Our 98%+ recommendation rate endorses our approach to long-term mutually beneficial relationships.
We offer training at all levels from assisting with rollouts & upgrades to Office 2013, Office 365 & Office 2010 and all skill levels, from beginners to advanced and beyond. If that's not enough we're happy to offer tailored training sessions to meet your needs precisely.
Our training team are also experienced in running Training Needs Analysis (TNA), bespoke course development for performance led training, project managed Training Rollouts and consultancy services.
We don't just train Microsoft Office, we also offer VBA, Data analysis & reporting, as well as Excel financial modelling courses, and more besides. So browse our schedule to see what we can do for you. If you don't see what you're after, get in touch. ...
Related Courses
