Microsoft Excel Fundamentals

Do you know you can spend less than 2% of your time to complete that repetitive task with the mastery of Microsoft Excel?

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%?

Stop stressing yourself, Learn the efficient way. Let our experts show you the way; We have helped over 2,000 professionals achieve the Mastery of Microsoft Excel.

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
• Souvenirs
• Tea break and Lunch
• Discussion session
• Practical Examples
• Certificate

Course Outline

Creating basic worksheet

• 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

Performing calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions

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

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

Managing large workbooks

• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets

Calculating data and advanced formula

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

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

Creating data using charts

• Create a Chart
• Modify Charts
• Format Charts

Analyzing tables using pivot tables

• Create a PivotTable Report
• Analyze Data Using Pivot Charts

Inserting graphic objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects

Functions and formulas

• Formulas with multiple operators
• Inserting and editing a function
• Defining and tracing formulas
• Using data and time function

Printing workbook contents

• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks