Excel Data Analysis: Sort, Filter, Tables, PivotTables and Conditional Formatting
50 000 Kz + VAT
Six short lessons on sorting (by colour, custom orders, reversing, randomising, the SORT function) followed by full units on filtering and data tools, tables and PivotTables, and conditional formatting.
- FieldIT & Digital Productivity
- Level2 · Intermediate
- Duration1 h 30 min
- Course languageEnglish
- IncludesNarrated videos, interactive activities, final assessment and a verifiable certificate
Instant course access as soon as payment is confirmed.
Turn lists into information. Short screen-recorded lessons cover sorting data, sorting by colour, custom sort orders, reversing and randomising lists and the SORT function; three full units, each with practice files and a quiz, then cover filtering and data tools, tables and PivotTables, and conditional formatting. Recorded in Microsoft 365. Based on UK best practice. Course in English. Permanent access to the course. Trident Academy certificate on completion of all nine units.
Modules
- Sorting Data4 min
- Sort by Colour3 min
- Custom Sort Order3 min
- Reversing a List3 min
- Randomising a List3 min
- The SORT Function4 min
- Excel Filtering & Data Tools24 min
- Excel Tables & PivotTables25 min
- Excel Conditional Formatting29 min
Only logged in customers who have purchased this product may leave a review.
Related products
-
New
-
New
-
New
-
New
Reviews
There are no reviews yet.