Descriptions:
In this course, you will learn how to use Microsoft Excel and Google Sheets, two popular spreadsheet applications that can help you work with data in various ways. You will learn how to perform calculations, input and edit data, use conditional formatting, create charts and graphs, use formulas and functions, import and export data, work with macros, scripts, and add-ons, and protect and share your workbooks with others.
Course Objectives:
- Performing simple and complex calculations using formulas and functions
- Sorting, filtering, and formatting data
- Using conditional formatting, data validation, and data protection
- Creating charts, graphs, pivot tables, and dashboards
- Importing and exporting data from different sources and formats
- Working with macros, scripts, and add-ons
- Collaborating and sharing data with others
Delivery: Online – Weekdays & Weekends
Duration: 1 Month
Pre-requisite:
