Getting GREAT at Microsoft Excel - Level Three

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

FAQs

Do I have to book using Eventbrite?

No. You can simply contact us at training@civicostraining.org with your name, organisation, billing address and a note of any access issues. We will issue an invoice in advance of your attendance.
What refreshments are served at the training?
Two free rounds of tea, coffee and biscuits are served on arrival and at mid-morning. There is also a sandwich and wraps lunch served as part of the ticket cost.
Is there disabled access?
The venue is fully accessible, although wheelchair entry has to be from the rear of the building, as there are steps at the front. Please let us know in advance of any access requirements.
What can/can't I bring to the event?
No need to bring equipment or laptop unless we specifically ask in the training descriptor. Pen and paper may be handy for notes.
Is my registration/ticket transferrable?
If you want to transfer to another training course, please contact us with five or more days’ notice at training@civicostraining.org
Do I have to bring my printed ticket to the event?
No need
What is the refund policy?
Civicos Training requires five working days' notice of cancellation. We will always attempt to place you on a later version of the same course, or transfer your booking to another course at no extra cost. However, if you cancel with less than the required notice, we do resrve the right to charge for the full cost of the course

Getting GREAT at Microsoft Excel - Level Three

Follow this organiser to stay informed on future events

Events you might like

Three The MusicalThree The Musical

Digital Skills Bootcamp Week Three: An Introduction to OutlookDigital Skills Bootcamp Week Three: An Introduction to Outlook

Digital Skills Bootcamp Week Two: An Introduction to ExcelDigital Skills Bootcamp Week Two: An Introduction to Excel

Three The Musical

Digital Skills Bootcamp Week Three: An Introduction to Outlook

Digital Skills Bootcamp Week Two: An Introduction to Excel