MS Office Training Sharjah

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
Lesson 2 –Create Advanced Charts

MODULE 12 – MANAGING DATA IN WORKBOOKS

Lesson 1 – Retrieve and Paste Data
Lesson 2 – Clean Data in Workbooks