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:

  1. Explain the concept of Microsoft Excel
  2. Discuss the use of Formulas, charts, pivot table and also to secure the document
  3. 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

  1. What is Excel?
  2. Why Excel?
  3. Workbook
  4. Worksheet
  5. Editing workbook data
  6. Formatting data
  7. Quick access toolbar
  8. Steps to customize Quick Access toolbar
  9. Cell Referencing
  10. Shortcut keys and uses
  1. Formatting tools
  2. Advance Formatting tools
  3. Conditional Formatting
  4. Formula
  5. Function
  6. Types of Function
  7. Mathematical functions
  8. Logical functions
  9. Analyzing data with excel
  10. Vlookup and Hlookup Function
  11. Match Functon
  12. Index Function
  13. Array Format
  14. Reference Format
  15. Offset Function
  16. Formula of Offset Function
  17. Date and time Function
  18. Formula of Date
  1. What is Chart and types?
  2. How to create an Excel Chart
  3. Modifying Charts
  4. Sparklines
  5. Template and steps to create it
  1. Pivot table
  2. Steps to create a Pivot table
  3. Pivot table tools
  4. Filtering data in Pivot table
  5. Sorting data in Pivot table
  6. What is power pivot?
  7. External data and its types
  8. Import Access data in excel
  1. What is data validation?
  2. How to use data validation
  3. Use of Document inspector
  4. Securing Worksheet

 

Reviews