Award winning conference meeting and training venue in North Wales


Microsoft Excel - Tricks & Tips

Microsoft Excel - Tricks & Tips

Date: Tuesday, 19/02/2019

Time: 09:30 - 16:30

Venue: Glasdir, Plas yn Dre, Llanrwst

Would you like to improve your Microsoft Excel skills? Come along to this one day Microsoft Excel course – it’s packed full of Excel Tricks & Tips!

What does this Microsoft Excel course cover?
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.

What will I learn from this course?
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
Printing titles on each page

Who should attend this course?
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.

Cost: £59 + VAT.

To book your place on this workshop click here.

Categories:Training / Hyfforddiant

Some of Our Clients

clients1

 

Keep Updated

To register to receive our e-mail newsletter, please click here.

Contact

Glasdir
Plas yn Dre
Llanrwst
North Wales
LL26 0DF

Phone: 01492 640640
E-mail: info@glasdir.com.

Find Us

For full directions and a location map click here