Data Management
What you will be able to do
- Work with Excel tables and structured references
- Sort, filter and remove duplicates
- Control input with data validation
- Highlight what matters with conditional formatting
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Tables
- Excel Tables
- Structured references
- Table Total Row
Module 2: Sort and filter
- Multi-level sorting
- Filtering
- Number, date and colour filters
Module 3: Cleaning data
- Remove Duplicates
- Text to ColumnsReal Excel
- Flash FillReal Excel
- Find & Replace
- Go To SpecialReal Excel
Module 4: Controlling and highlighting
- Data Validation: drop-down lists
- Data Validation: number and date rules, input messages
- Conditional Formatting: highlight rules
- Conditional Formatting: data bars, colour scales, icons
- Conditional Formatting with formulas
Project: clean and control an expense-claims register
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free