- Start Date - 10/04/2019
- End Date - 10/04/2019
- Start Time - 09:30
- End Time - 16:30
- Location -
- Interested -
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, subtotalling 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
- Getting external data into Excel
- 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
- Data Filters
- Sorting
- Sub-totalling
- Consolidating multiple data sets
- Removing Duplicates
- Working with the fill handle and Flash fill
- Using Excel Tables