Excel for Professionals: Practice File

Introduction to the Course
- Introduction
- Navigating the Excel user interface
Navigation and Basics
- Understanding worksheet (Insert, Rename, Delete, Move & Copy)
- Understanding Rows and Columns
- Row and Column operation (Insert & Delete)
Data Entry
- Text entry and customization
- Formatting Cells
- Fill Handle
- Different types of paste option
- Data validation
- Cell referencing
Data Cleaning
- Text functions for data cleaning
- Find and Replace
- Sort and Filter
- Table creation
- Remove duplicates and remove blanks
Basic Data Analysis
- Arithmetic operation
- Sum and Average
- Min and Max
- Count function
- Excel for Professionals: Practice File
Assessment and Certificate
- Assessment and Certificate