Excel: Analysing & Summarising Data - Charts, PivotTable, What if Analysis (Live Online using MS Teams)

Prerequisites

Charts, pivot tables, data consolidation and what-if analysis are a quick an easy way to interrogate and visualise your data. Join me in this hands-on course taught online in three one-hour sections. During the course you have access to online learning materials, after the course we recommend that you consolidate your learning using LinkedIn Learning.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

Before the course

1) After booking you will receive an email containing the link to join the online meeting. At least a few days ahead of the session please click on this link to check that you can login on the day.

2) The course files must be downloaded and unzipped onto your computer before the day of the class.

3) On the day, open Excel on your computer and the file named: Charting_1.xlsx. Please join 5-10 minutes beforehand for a prompt start.

If you have any problems let the instructor know in advance. The course will start promptly at the given time, and regretfully any problems cannot be resolved at that time.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

• It is essential to be familiar with the basic features of Excel and concepts of spreadsheets such as those in the LinkedIn Learning course Excel 2019 Essential Training

Number of sessions: 3

09:30 - 10:30

• Charts

11:00 - 12:00

• Pivot Tables/Techniques/Charts

12:30 - 13:30

• Data Consolidation
• What If Analysis through:
  • Scenarios
  • Data Tables

Demonstration and self-paced practicals.

• Microsoft Office 365 Excel, but other versions of Excel will be suitable

• The course files must be downloaded before the course

• Three one hour sessions

• Office 365
• Spreadsheets