Excel Best Practice
- • Work efficiently with Excel by setting standards and best practices
• Save time by setting standards for workbook planning and design
• Learn how to best organise Excel source data for reporting and analysis
• Learn how to make tables and lists dynamic
• Build worksheets that are easy to understand and amend
• Learn to use the right Excel tool for the task
• Learn tips for how to fine tune and speed up workbooks
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 207,983 people .
- Over 14,157 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?
All Excel users who want to save time and be more productive throughout their organisation by learning best practice standards and techniques. Courses can be delivered at client sites UK wide, also at our Excel course Bloomsbury and Limehouse venues.
Training Course Content
Setting standards and best practices
The FAST Standard OrganisationIs Excel the right tool for the job?
Do's and Don'ts
Planning a Workbook
Identifying the audience and co-usersRecognise inputs, workings and outputs
Creating consistency and durability
Designing a Workbook
Including a welcome and introduction sheetCreating clear organisation of worksheets
Organising source data
Keeping it simple by choosing easy to use tools
Best Practices
Best practice when writing functions and formulasFormatting and use of colours
Conditional formatting best practice
Use of tables and lists
When to use range names
Making tables dynamic
Working with Links
Best practice with linking worksheets and workbooksManaging external links
Distributing Reports
Best practice for sharing reportsUsing Shared folders versus sending attachments
Protection
When to protect worksheets and workbooksMaking a workbook read only
Version control
Naming of workbooks and foldersWorkbook version control
Excel version control
Tips and suggestion
For keeping down the file size of workbooksMaking workbooks easy to amend
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.
Reviews by course attendees
Average rating 4.9
WOW ! Simply fantastic; Jens is a fantastic trainer. My knowledge was at a good level but I felt I learnt soo much with Jens today. This course is a fantastic way to learn how t...
Most useful topic: Index Match
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...
Jens was extremely passionate about Excel and helped us to get to grips with some basic techniques to make us more efficient with our time.