HOME
 

Excel Best Practice

STL
Course summary
1 day
English
Nationwide
Company-Specific / In-House
STL courses

Excel Best Practice



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... • 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 ;

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 Organisation
Is Excel the right tool for the job?
Do’s and Don’ts

Planning a Workbook

Identifying the audience and co-users
Recognise inputs, workings and outputs
Creating consistency and durability

Designing a Workbook

Including a welcome and introduction sheet
Creating clear organisation of worksheets
Organising source data
Keeping it simple by choosing easy to use tools

Best Practices

Best practice when writing functions and formulas
Formatting 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 workbooks
Managing external links

Distributing Reports

Best practice for sharing reports
Using Shared folders versus sending attachments

Protection

When to protect worksheets and workbooks
Making a workbook read only

Version control

Naming of workbooks and folders
Workbook version control
Excel version control

Tips and suggestion

For keeping down the file size of workbooks
Making workbooks easy to amend

Expenses



Prices from £748. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Best Practice.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

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.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.stl-training.co.uk

Request information

Find out more about this Excel Best Practice course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here