Project Description

Course Details

Training Microsoft Excel (Customized)

Total Course Duration: 14 Hours
Each Class Duration: Two – Day Long

Overview

Lesson 1: Getting Started with Microsoft® Excel® 2013

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Lesson 2: Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

  • Customize General and Language Options
  • Customize Formula Options
  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by
  • Enabling Add-Ins
  • Customize Advanced and Trust Center Options

Lesson 8: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Lesson 9: Analyzing Data with Logical and Lookup Functions

  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions

Lesson 10: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data
Lesson 11: Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Lesson 12: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using PivotCharts

Lesson 13: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

Lesson 14: Enhancing Workbooks

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files

Lesson 15: Automating Worksheet Functionality

  • Update Workbook Properties
  • Create and Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Lesson 16: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Lesson 17: Analyzing and Presenting Data

  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View

Lesson 18: Working with Multiple Workbooks

  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks

Lesson 19: Exporting Excel Data

  • Export Excel Data
  • Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Create a Web Query

Resource Person

Mohammad Shihab Uddin
Mohammad Shihab UddinSenior Technical Trainer Programming