Prerequisites:

• Google Account

• Must have basic computer and internet skill.

Duration: 8 hours

Course outline

1. Getting Started with Google Sheet

2. Productivity Tools and Commands

   • Cell data entry and working with sheet

   • Organizing Cell data

     • Freezing

     • Autofit columns and rows

     • Deleting and Inserting cells

     • Sorting and custom sort

     • Filter set

   • Find and Replace values

3. Best Practices in using Spreadsheet

   • Recording data

   • Comments and Notes

   • Segregating Sheets

   • Using shortcut keys

4. Cell References and Basic Functions

   • Absolute References

   • Aggregate Functions

     • Sum, Average, Count, CountUnique, Max, Min

   • Array Functions

     • Unique, Filter, Transpose

   • ImportRange

5. Advanced Functions

   • XLookup, Sumifs, If

6. PivotTables

   • Inserting PivotTable

   • Filtering values in PivotTable

7. Inserting Chart and Publish Dashboard

   • Working with charts

   • Customizing Charts

   • Working Combo Charts

   • Scorecard

   • Scrollable table

8. Array Formula

   • Understanding Array Formula

   • Formula in Array

   • Functions in Array

9. Query Function

   • Rules of Query

   • Application of Query Function

10. Basic Macro

    • Absolute vs Relative

    • Application of Macro