Corporate Training for Teams
4.9 (22 Reviews)

Excel Best Practice

STL, Nationwide
Length
1 day
Length
1 day
Leave your details so the provider can get in touch

Excel Best Practice

STL courses


  • • 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 201,571 people .
  • Over 13,967 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 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 on application. Contact us for quote.

Request information - obligation free

Contact course provider

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

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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.

Reviews by course attendees

Average rating 4.9

Based on 22 reviews.
Write a review!
5/5
Matthew
20 Jan 2021

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.

5/5
Ronak
20 Jan 2021

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...

Show more
5/5
Richa
20 Jan 2021

Most useful topic: Index Match

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

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...

Read more and show all courses with this provider

Ads