Microsoft Excel

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