Excel: analysing data (stage 2)

Course Dates: 23/03/19
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutor: Nick Brown

Develop further skills to tackle complex data sets and create conclusions and recommendations for non-data minded stakeholders in your organisation. Focus on pivot tables, look ups, formulas and perfecting your commentary skills. Intermediate/advanced excel skills covered.

Description

What is the course about?

The course will be split into a mix of revising some intermediate/advanced excel skills that data analysts would need to demonstrate, before applying these to different data sets. There will be a mixture between learning and then directly applying these skills with a range of exercises.

The last part of the final session will be a chance to bring in your own problem or a chance to work through a scenario and data commentary and presentation to add meaning and insight. Skills directly relevant to many different jobs.

What will we cover?


Shortcuts
-Review of a list of shortcuts to use and apply to work quickly and efficiently

Pivot tables
-Revision, review of basics
-Refresh and change for new data sources with new and updated datasets
-Calculated Fields (Add your own field to a pivot table)
-Pivot Charts
-Working with more complicated scenarios and datasets

Look Ups
-vlookups
-h look ups
-Index and Match

Formulas
-IF statements
-SUM IF/ Count IF/ Average IF

Scenarios and application
-Revision: audience, impact, delivering information effectively
-Utilise the skills for scenarios.

What will I achieve?
By the end of this course you should be able to...

Take a random set of data, process the information using more advanced excel skills, and find some key points to create conclusions, recommendations and next steps relevant for a range of stakeholders.

What level is the course and do I need any particular skills?

A basic knowledge of excel (at least intermediate user). The course will be split into a mix of revising some intermediate/advanced excel skills that you would need to demonstrate, before applying these to different data sets and inferring conclusions and next steps.

How will I be taught, and will there be any work outside the class?

Teaching, exercises, applying the skills taught.

Are there any other costs? Is there anything I need to bring?

No.

When I've finished, what course can I do next?

Excel: advanced, excel: expert, Data analysis with Power BI, introduction to VBA, Excel: financial modelling for further data analysis.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

Reviews

Book your place

Course Code: CEXAD07

Sat, day, 23 Mar - 23 Mar '19

Duration: 1 session

Full fee: £99.00
Senior fee: £79.00
Concession: £50.00

Note: Course starts today, check start time

Add to Basket

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.