+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


Download Here