Microsoft Excel

Lesson 1: Getting started

Lesson 1: Getting Started with Microsoft Excel 2010

• 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.

Microsoft Excel - Intermediate

Lesson 1: Creating Advanced Formulas

• Apply Range Names
• Use Specialized Functions

Lesson 2: 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 3: Organizing Worksheet Data with Tables

• Create and Modify Tables
• Sort and Filter Data
• Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts

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

• Create a PivotTable
• Filter Data Using Slicers
• Analyze Data Using Pivot Charts

Lesson 6: Inserting Graphics

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

Lesson 7: Enhancing Workbooks

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

Microsoft Excel- Advance

Lesson 1: Automating Worksheet Functionality

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

Lesson 2: Auditing Worksheets

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

Lesson 3: Analyzing Data

• Create Spark lines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis Tool Pack

Lesson 4: Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells In Different Workbooks
• Merge Workbooks

Lesson 5: Building a PivotTable

• Insert a PivotTable
• Create a PivotTable Based on External Data
• Categorize PivotTable Data
• Customize a PivotTable

Lesson 6: Analyzing Data Using Pivot Tables

• Create Custom Calculations in a PivotTable
• Restructure a PivotTable

Lesson 7: Presenting PivotTable Data Visually

• Format a PivotTable
• Present a PivotTable in a Pivot Chart
• Print PivotTables and Pivot Charts
• Lesson 8: Exporting Excel Data
• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query

Lesson 9: Examining Data Using Math Functions

• Analyze Sales Data Using Math Functions

Lesson 10: Manipulating Data Using Text and Information Functions

• Manipulate Data Using Text Functions
• Validate Data Using Information Functions

Lesson 11: Working with Templates and Charts

• Create Advanced Templates
• Create Advanced Charts

Lesson 12: Managing Data in Workbooks

Retrieve and Paste Data

Clean Data in Workbooks

Courses:

Language Training

Exam Test Preperation

Management Courses

Soft Skills

Medical Training Courses

IT Courses

Banking & Finance Courses

Free Consultation

Enter Your Name*

Enter Your Email*

Enter Your Phone Number*

Microsoft Excel - Basic