Introduction

This training empowers participants to convert their data in Excel into a consumable and professional format.

Course Objective

After completing this course, participant will be able to manage data in a table format, and sort or filter it according to their needs. Moreover, participants will be able to perform data clean up using various formulas, identify and eliminate duplicate data, and successfully extract information from their raw data.

Training Methodology

This is an instructor led training, fully interactive with practical hands-on. Personal interaction ensures participants are engaged throughout the session.

Day 1

9:00am - 10:30am

Managing Data

1. Structure data for optimum usage
2. Create a directory or table of contents with internal links
3. Convert into table and range
4. Formulas

10:30am - 10:45am Morning Break

10:45am - 12:30pm

5. Conditional formatting
6. Sort by cell colour, font colour, cell icon, column
7. Sort data in random order
8. Setup Single and Multiple level subtotal

12:30pm - 1:30pm Lunch Break

1:30pm - 3:30pm

Course Outline :: Microsoft Excel for Data::

9. Expand and collapse display with grouping and outlining symbols
10. Filter Single and Multiple Columns (Filter text, Date, Numeric, Top 10 filters)
11. Custom Filters and Wildcards

3:30pm - 3:45pm Afternoon Break

3:45pm - 5:00pm

12. Filter table data interactively using slicers
13. Count cells using count(),counta() and countblank()
14. Simple Excel Function
15. Quick Access Bar

DAY 2