This course is aimed to provide the advanced Excel data analysis knowledge for ETC cluster partners to enhance their data analysis and data reporting skills. During this training course, the iMMAP trainer will guide you through the following:

1. Getting Started with Excel
   • What is excel used for?
   • Using the quick access toolbar and ribbon menu.
   • Shortcut menus and the mini toolbar.
   • Understanding workbooks and worksheets.
   • Using excel help.
2. Data in Excel
   • Exploring data entry and editing.
   • Autofill and lists in Excel. .
   • Working with dates and times.
3. Formulas and Functions
   • Using formulas.
   • Copying a formula into adjacent cells.
   • Lookup functions.
4. Formatting
   • Exploring font style and effects .
   • Applying borders and color background.
   • Adjusting row heights and column widths.
5. Adjusting Worksheet Layout and Data
   • Rows and columns insets, delete, hide, and unhide. .
   • Moving, copying, and inserting data.
   • Finding and replacing data.
6. Charts
   • Creating charts .
   • Exploring chart types.
   • Working with Excel ideas. .
7. Adjusting Worksheet Views
   • Freezing and unfreezing panes.
   • Splitting screens horizontally and vertically.
8. Multiple Worksheets and Workbooks
   • Renaming, inserting, and deleting sheets.
   • Moving, copying, and grouping sheets.
9. Data Management Features
   • Sorting data.
   • Using filters.
   • Creating pivot Tables.
   • New data types are coming to excel. .
10. Power Query
    • Data cleaning in power Query.
    • Transform data. .
    • Combine multi sheets/workbooks. .
11. Automation Using Macros and VBA.