+971 56 731 2942 , +971 04 298 9926

MS Excel 2010 - Basic

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.

 

MS Excel – Intermediate

Excel 2010 – Level 2 (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

MS Excel - Advance Level 

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

 

Online Assessment Test

Testimonials

Download Here


download_profile