Introduction to Excel
Course Overview
Introduction to Excel is a training course designed to teach individuals the basic functions and features of Microsoft Excel, a spreadsheet program widely used for data analysis, organization, and visualization. The course may cover topics such as creating and formatting worksheets, entering and editing data, using formulas and functions, creating charts and graphs, and managing large data sets. It is intended for those who are new to Excel or have limited experience with the program.
At the end of the training, participants will be able to:
- Explain the concept of Microsoft Excel
- Discuss the use of Formulas, charts, pivot table and also to secure the document
- List the essential features of Excel
Pre-requisite
Foundational Knowledge on Microsoft Excel or only know what is Microsoft Excel
Duration
2 days
Course Outline
- What is Excel?
- Why Excel?
- Workbook
- Worksheet
- Editing workbook data
- Formatting data
- Quick access toolbar
- Steps to customize Quick Access toolbar
- Cell Referencing
- Shortcut keys and uses
- Formatting tools
- Advance Formatting tools
- Conditional Formatting
- Formula
- Function
- Types of Function
- Mathematical functions
- Logical functions
- Analyzing data with excel
- Vlookup and Hlookup Function
- Match Functon
- Index Function
- Array Format
- Reference Format
- Offset Function
- Formula of Offset Function
- Date and time Function
- Formula of Date
- What is Chart and types?
- How to create an Excel Chart
- Modifying Charts
- Sparklines
- Template and steps to create it
- Pivot table
- Steps to create a Pivot table
- Pivot table tools
- Filtering data in Pivot table
- Sorting data in Pivot table
- What is power pivot?
- External data and its types
- Import Access data in excel
- What is data validation?
- How to use data validation
- Use of Document inspector
- Securing Worksheet