Taught in a classroom setting, at a Glasgow city centre venue.

This course is for those people who really want to find out how Excel can help them perform better! Gain the skills to use pivot tables, create macros, collaborate with others, upload data sources and import and export data. Upon successful completion of this course, students will be able to:

Course Content

  • Creating multiple conditions using IF with AND and OR

  • Naming and using ranges, and using them in formulas

  • Advanced Conditional Formatting – e.g., using ‘Conditional If Formulas’

  • Other Features: Conditional Formatting: Data Validation

  • Manipulating Data within Lists: Data Filtering: Advanced Data Sorting Techniques: Data Analysis with Subtotals:

  • Pivot Tables and their uses

  • Using IFERROR to tidy up your page

  • Macros explained: Working with Macros to speed up your coding

  • A look at VBA and how too go forward

  • Further Functions and Formulas, including some really helpful advanced formulas

The course is delivered using our purpose-built Excel workbook, which is yours to keep.


All attendees also have free access to an online Excel helpdesk for six months, where we will be happy to provide online refreshers, or help with any issue you have.


This Excel training can be delivered as an in-house session.

We will be happy to arrange an online or classroom session of this course for up to 12 of your staff, at a time that suits best for you.

For a no-commitments chat please contact training@civicostrainig.org or call us on 07415 652 522

Getting GREAT at Microsoft Excel - Level Three

"Great course. i finally have a handle on Pivot Tables!"



"Enjoyed the course very much. The free workbook and helpdesk will be very useful going forward"




VENUE

Robertson House, 152 Bath Street, Glasgow G2 4TB

Wednesday, 30 March 2022

09.30 - 16.30

£146

If you would like to chat with us about a course before booking email us at training@civicostraining.org or call us on 07415 652 522

ZOOM LOGO smaller.png
App Screens

Public Relations and Communication

Civicos has thirty years experience of public relations and communication work and we are available to help your organisation to polish your  image and get your message across.

Electronic Devices on Table

Web Design and Social Media 

Civicos can help  you to write all of the 'copy' for your new website, and then build the actual site for you.  We'll also help you to maintain your new site, and train your staff in its different functions, if needed. 

Business Team

Training Needs Analysis

FREE from Civicos:  A Training Needs Analysis report for your organisation

Find out your staff training needs – and save £££s on cost. We will be delighted to perform a FREE, absolutely no-commitment Training Needs Analysis for your organisation.