Would you like to improve your Excel skills? This course is packed full of Tricks & Tips! You will discover some amazing features that will allow you to fly through setting up your business spreadsheets. The course is designed for those who already use Microsoft Excel in the workplace and who wish to consolidate their knowledge and make the most of Microsoft Excel’s many features.
This course will suit anyone who is self-taught or who attended Excel Training years ago. We will find out what you need to know to maximise your efficiency and skills using Microsoft Excel. The training can be delivered in Excel 2007, 2010, 2013, 2016 & 2019.
The Excel Tricks & Tips course can be delivered as a one day or a half a day depending upon your needs.
Who is this course suitable for?
This one day course is intended for those who are already using Excel and would like to consolidate their knowledge and be able to work more efficiently with Excel.
- Understand the Excel interface and Backstage View
- Customise the Quick Access Toolbar (QAT)
- Quick ways to do the basics
- Work with Flash Fill
- Understand, create and use formula
- Change the order of calculation (BODMAS)
- Replicate formula
- Use Autosum effectively
- Work with relative and absolute cell address
- Show and hide formula
- Create a series and custom series
- Work with multiple worksheets and create 3D formulae
- Work with Conditional Formatting
- Use the IF function
- Work with lists and tables effectively
- Create Headers and footers
- Create Pivot Tables and Charts
- Create a simple interactive Excel Dashboard
The course outlines are not written in stone and each course will vary slightly to meet the needs of the group attending. If you would like a particular topic included on the course please let us know and we will do our best to oblige.
What People Say About the Microsoft Excel Tricks & Tips Course
A few comments from previous attendees
Brilliant course – well presented & I’ve learned so much! Thank you Sue – Vicki Thorpe, Betsi Cadwaladr ULHB
The time flew by – David Lloyd
Best course I have ever had! Very Interesting
More Excel please! Great Session
Brilliant, Bubbly and Enthusiastic trainer. Many Thanks ;o) – Sonia Pritchard
Exceptionally well delivered
Trained at a really good speed and made sure you understood
I would like to revisit Excel and learn more Tips & Tricks from Sue – Lucy Brooks
Fantastic, could do with another 2 to 4 hours
Considering the wide range of abilities present, Sue covered everything everyone wanted / needed
ByteBack Training Satisfaction Guarantee
If at the end of the training course you feel you have not met the stated learning outcomes above, we will be happy to discuss how best we can put this right.
Experienced and knowledgeable Trainer – Sue has been delivering Microsoft Excel training for over 20 years
Help in selecting the right course for you
Certificate of Completion
Lunch & Refreshments throughout the day (Open courses)
Pre and post course email/telephone helpline and support
We welcome your enquiries and would like to help to make your training easy and fun. If you would like a friendly chat about your training needs, do give us a call. You can phone on Sue on 01492 532937 or 07770 472488, email or visit our Contact Page.