Course Methodology
In this practical workshop, participants will apply different Excel
techniques in real time to different sample datasets.
Course Objectives
By the end of the course, participants will be able to:
- Navigate Excel's interface and effectively manage
worksheets and workbooks
- Apply Excel formulas and functions for data
calculations and analysis
- Create and customize charts for visual data
presentation
Target Audience
This workshop is ideal for professionals who use Microsoft Excel to
enhance their proficiency in data management, analysis, and visualization.
Target Competencies
- Data analysis using Excel
- Data management using Excel
- Data cleansing using Excel
- Organizing data using Excel
- Developing Excel charts
Workbook and Spreadsheet Management
- Navigating the Excel interface
- Entering, editing, and organizing data
- Workbook and worksheet basics
- Introduction to basic formulas
- Relative and absolute cell referencing
Excel Formulas and Functions
- Exploring logical functions
- Finding data using lookup functions
- Working with date and time functions
- Formatting strings using text functions
- Error checking and data validation
Data Visualization and Analysis
- Creating and customizing charts
- Building and formatting tables
- Introduction to PivotTables
- Conditional formatting for dynamic data
- Exporting data and reports