Working in Partnership with Glasdir Skills Academy, Plas Yn Dre, Station Road, Llanrwst, LL26 0DF
Tuesday, 2 April 2018 – 09:30 – 16:30
Only £59 +VAT – this cost includes lunch, refreshments throughout the day and full email helpline after the training. Laptops provided, if needed.
You can book now – visit Glasdir’s Booking Form to secure your place
Would you like to improve your Excel skills? This one day Excel 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 is a pick and mix course and will suit anyone who is self-taught or who attended 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 or 2016.
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 interface and Backstage View
- Customise the Quick Access Toolbar (QAT)
- Quick ways to do all 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 create 3D formulae
- Work with Conditional Formatting
- Use the IF function
- Work with lists of data effectively
- Sub Totals
- Pivot Tables & Pivot Charts
- Headers and footers
- Printing titles on each page
The course outlines are not written in stone and each course will vary slightly to meet the needs of the group attending.
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
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 the full course outline for this course, or 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.