### MS Excel 2010- Basic Level Training in Sharjah

###### Module 1- EXCEL BASICS (for Beginners)

Lesson 1 - Getting Started with Excel
Lesson 2 - Data Entry, Data Editing, and Number Formatting
Lesson 3 - Data Formatting
Lesson 4 - Working with Cells and Ranges in Excel
Lesson 5 - Managing Worksheets

###### MODULE 2 - EXCEL ESSENTIALS

Lesson 1 - Introduction to Excel Tables
Lesson 2 - Auto-fill, Custom Lists, and Flash Fill
Lesson 3 - Number Formatting in Excel

###### MODULE 3 - EXCEL FORMULAS

Lesson 1 - Excel Formula Basics
Lesson 2 - Logical Formulas in Excel
Lesson 3 - Math Formulas in Excel
Lesson 4 - Lookup and Reference Formulas in Excel
Lesson 5 - Stats Formulas in Excel
Lesson 6 - Text Formulas in Excel
Lesson 7 - Date and Time Formulas in Excel
Lesson 8 - Formulas Mix and Match (10 Examples)

###### MODULE 4 - DATA ANALYSIS

Lesson 1 - Named Ranges in Excel
Lesson 2 - Data Validation in Excel
Lesson 3 - Data Sorting and Filtering in Excel
Lesson 4 - Using Conditional Formatting in Excel

###### MODULE 5 - INTRODUCTION TO EXCEL CHARTING

Lesson 1 - Introduction to Excel Charting
Lesson 2 - 10 Advanced Excel Charting Examples
Lesson 3 - Dynamic Charts in Excel

###### MODULE 6 - PIVOT TABLE

Lesson 1 - Overview of Excel Pivot Table

###### MODULE 7 - EXCEL EXTRAS

Lesson 1 - Protection in Excel
Lesson 2 - Introduction to Macros and VB Editor

### MS Excel Advance Level Training in Sharjah

###### MODULE 1: AUTOMATING WORKSHEET FUNCTIONALITY

Lesson 1 - Update Workbook Properties
Lesson 2 – Create and Edit a Macro
Lesson 3 – Apply Conditional Formatting
Lesson 4 – Add Data Validation Criteria

###### MODULE 2 : AUDITING WORKSHEETS

Lesson 1 – Trace Cells
Lesson 2 - Troubleshoot Invalid Data and Formula Errors
Lesson 3 – Watch and Evaluate the Formulas
Lesson 4 – Create a Data List Outline

###### MODULE 3 – ANALYZING DATA

Lesson 1 – Create Spark Lines
Lesson 2 - Create Scenarios
Lesson 3 – Perform a What-If Analysis
Lesson 4 - Perform a Statistical Analysis with the Analysis Tool Pack

###### MODULE 4 – WORKING WITH MULTIPLE WORKBOOKS

Lesson 1 – Create a Workspace
Lesson 2 – Consolidate Data
Lesson 3 – Link Cells in Different Workbooks
Lesson 4 – Merge Workbooks

###### MODULE 5 – BUILDING A PIVOT TABLE

Lesson 1 – Insert a PivotTable
Lesson 2 – Create a Pivot Table Based on External Data
Lesson 3 – Categorize PivotTable Data
Lesson 4 – Customize a PivotTable

###### MODULE 6 – ANALYZING DATA USING PIVOT TABLES

Lesson 1 – Create Custom Calculations in a Pivot Table
Lesson 2 - Restructure a Pivot Table

###### MODULE 7 – PRESENTING PIVOT TABLE DATA VISUALLY

Lesson 1 – Format a Pivot Table
Lesson 2 – Present a Pivot Table in a Pivot Chart
Lesson 3 – Print Pivot Table and Pivot Charts

###### MODULE 8 – EXPORTING EXCEL DATA

Lesson 1 – Exporting Excel Data
Lesson 2 – Import a Delimited Text File
Lesson 3 Integrate Excel Data with the Web
Lesson 4 – Create a Web Query

###### MODULE 9 – EXAMINING DATA USING MATH FUNCTIONS

Lesson 1 – Analyze Sales Data Using Math Functions

###### MODULE 10 – MANIPULATING DATA USING TEXT AND INFORMATION

FUNCTIONS
Lesson 1 – Manipulate Data Using Text Functions
Lesson 2 – Validate Data Using Information Functions

###### MODULE 11 – WORKING WITH TEMPLATES AND CHARTS

Lesson 1 – Create Advanced Templates