Excel – Handling Data

Learn the ways to manage and wrangle sets of data quickly and accurately in Excel.

Excel spreadsheets can be an incredibly powerful tool for analysing data. Many office-based roles provide dozens of opportunities to employ Excel to make sense of muddled data, whether it be removing duplicates from disparate lists or creating powerful management reports from lengthy tables of numbers.

This practical session aims to help people who are familiar with Excel but want to improve their knowledge around data handling.

This session will cover smart ways to efficiently use Microsoft Excel and provide a deeper look into the most effective methods and tactics for handling large sets of data.

During the session we will run through brief illustrative examples of several of the tools, functions and techniques which can be used to manage unwieldy sets of data, including;

• Introduction
• Variable names, range names and layout considerations
• A brief look at conditional formatting
• Flash fill
• Three major data tools:

• Sort
• Filter
• Removing Duplicates

• Two useful functions for handling data:

• If
• Vlookup

• Pivot Tables (and why they are not perfect!)
• Q&A

Please note that the demonstration will be given using Excel for Office 365. However, the version of Excel used in the webinar itself is of very limited importance as the points made extend to all versions.

We are also running another session prior to this – Excel Fundamentals

Learning Outcomes:

Attendees will gain knowledge, by example, of many of the tools offered by Excel for managing data. They will also understand the application of several of those techniques in a small case study.

Suited to:

Anyone who uses Excel and wants to improve their skills. Attendees should have reasonable familiarity with excel prior to the session, but this session is not targeted at highly advanced users.

This On Demand recording Includes: 

• Recording of the Live Webinar, which can be viewed multiple times, for as long as required 
• Presenters contact details for follow up questions 
• CPD Quiz
• CPD Certificate 
• CPD Report – Logged automatically 
• PowerPoint Presentation
• Verbatim Transcript, with Searchability
• Supporting Documentation