€90

Microsoft Excel Evening Class: "The Best of Excel" (10 classes x 2 hours)

Event Information

Share this event

Date and Time

Location

Location

Ballinasloe Area Community Development

Creagh Road

Ballinasloe

Ireland

View Map

Event description

Description

This course is guaranteed to increase your proficiency in Excel.

It takes place at the Ballinasloe Enterprise Centre (Training Room) for 10 Wednesday evenings (7 p.m. – 9 p.m.) on the following dates:

21/02/18, 28/02/18, 07/03/18, 14/03/18, 21/03/18, 28/03/18, 04/04/18, 11/04/18, 18/04/18, 02/05/18

Course Contents:

1. Cell referencing - relative, absolute & structured

2. Formulas & Functions I - SUM, AVERAGE, COUNT, MAX, MIN & IF

3. Formulas & Functions II - VLOOKUP & SUMIF

4. Charts I - embedded / sheet chart, change chart type & data series

5. Charts II - chart elements & more chart types

6. Pivot Tables I - purpose & set up area

7. Pivot Tables II - filter-ins, slicers & drilldowns

8. Power BI Desktop - download this free Microsoft software - introducing business intelligence

9. Vba Macros - If, Loop & interaction

10. Formulas & Functions III - INDEX MATCH & SUMPRODUCT


Note: Please bring your own laptop with Excel to follow along and also to do the exercises.

Share with friends

Date and Time

Location

Ballinasloe Area Community Development

Creagh Road

Ballinasloe

Ireland

View Map

Save This Event

Event Saved