Ms. Excel Fundamentals I

Do you know that the mastery of Microsoft Excel can cut time spent in data entry, data analysis and manipulation and data reporting by up to 99%?



Training Objectives

Understand Ms. Excel Fundamentals

Acquire skills in data entry, data analysis, and data reporting

Learn how to work with large data

Learn how to make sense of large data

Acquire Skills for Data presentation etc.

 

Methodology

Instructor guided presentation

Case studies

Discussion session

Scenario and Case study sessions

 

 

Course Content  

- Creating a basic worksheet

- Performing calculations

- Modifying a worksheet

- Formatting a worksheet

- Managing large workbooks

- Calculating data and advanced formula

- Organizing worksheet and table contents

- Creating data using charts

- Analyzing tables using pivot tables

- Inserting graphic objects

- Functions and formulas

- Printing workbook contents