Award winning conference meeting and training venue in North Wales


Microsoft Excel - Tricks & Tips

Microsoft Excel - Tricks & Tips

Date: Tuesday, 17/09/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