MS Excel – Data Management
This One Day Training course is focused on bringing users through the array of tools, options and methods available to them when working with lists of data in MS Excel
Participants should be familiar with the basics of Excel in entering and editing data, basic number formatting and standard formulas and functions (as covered in the Getting Started in Excel sessions)
The course will work through setting up and using Excel effectively with lists of data both added directly to Excel itself and/or imported in from other applications and systems. It will guide the participants through cleaning, formatting, filtering, validating, sorting, sub-totalling and calculating data in lists and through the use of Excel Tables.
This course is essential study for anyone struggling to setup, handle and manage large lists of records in an MS Excel workbook.
Topic List and Course Structure
-Creating a list – best practice and techniques
o Header rows
o Data Types and number formatting
o Data Validation
-Getting external data into Excel
o Using Text to Columns to split up data
o Working with Text Functions to break apart data or produce new data
-Using Data Validation to control the quality of data being entered into Excel
-Working with Named Ranges to update validations and functions
-Using Conditional Formatting
o Format cells based on their values
o Format cells based on functions
o Sort by Colour
-Data Filters
o AutoFilters
o Custom filtering
o Advanced Filters
-Sorting
o Single and multi-level sorts
-Sub-totalling
-Consolidating multiple data sets
-Removing Duplicates
-Working with the fill handle and Flash fill
-Using Excel Tables
o Formatting
o Adding Records
o Tables Names and referencing
o The Table total row and SUBTOTAL functions
Duration: 1 day
All courses are bookable on the Upcoming Courses page
6 CPD credits awarded. Please contact staff_l&d@rcsi.com if you need a certificate of attendance.