Ms. Excel Fundamentals

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

What to Expect

Expert facilitation

Conducive Training Environment

Discussion session

Practical Examples

 

Course Content

A. Creating basic work sheet

    Explore the User Interface and the Ribbon Navigate and Select in Excel 

    Obtain Help

    Enter Data and Save a Workbook

    Customize the Quick Access Toolbar 

B. Performing calculations

    Create Basic Formulas 

    Calculate with Functions 

    Copy Formulas and Functions 

C. Modifying a worksheet

    Manipulate Data 

    Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet 

    Spell Check a Worksheet 

    Sorting

    Filtering data

    Formatting table

    Using data validation

    Advanced filter

D. Formatting a worksheet

     Modify Fonts 

    Add Borders and Color to Cells 

    Change Column Width and Row Height 

    Apply Number Formats 

    Position Cell Contents 

    Apply Cell Styles 

E. Managing large workbooks

    Format Worksheet Tabs 

    Manage Worksheets in a Workbook 

    Manage the View of Large Worksheets 

F. Calculating data and advanced formula

    Manage Cell and Range Names 

    Calculate Data Across Worksheets 

    Use Specialized Functions

    Analyze Data with Logical and Lookup Functions 

G. Organizing worksheet and table contents

    Create and Modify Tables 

    Format Tables Sort or Filter Worksheet or Table Data 

    Calculate Data in a Table or Worksheet 

H. Creating data using charts

    Create a Chart 

    Modify Charts 

    Format Charts

H. Analyzing tables using pivot tables

    Create a PivotTable Report

    Analyze Data Using Pivot Charts 

I. Inserting graphic objects

    Insert and Modify Pictures and ClipArt 

    Draw and Modify Shapes 

    Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects 

J. Functions and formulas

    Formulas with multiple operators

    Inserting and editing a function

    Defining and tracing formulas

    Using data and time function

K. Printing workbook contents

    Print Workbook Contents Using Default Print Options 

    Set Print Options 

    Set Page Breaks