Course Overview

MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros and this application performs very effectively on arithmetic solution.

Designer for

This course is designed for those who want to familiar with the Microsoft Office Package. Specially designed for the professionals to create business and flash reports to senior management, spreadsheets, performing calculations on data andother features of the excel package.

Prerequisites

To ensure your success, you have some basic knowledge about computers and basic calculations.

Course Objectives

Upon successful completion of this course, students will be able to:

  • Present spreadsheet data using Microsoft Office Excel
  • Creating reports and analyzing data
  • Perform logical calculations and evaluations
  • Analyzing Data with Logical and Lookup Functions
  • Visualizing Data with Charts

Course Contents

Working with Microsoft Excel

  • Formatting a Worksheet and modifying worksheet
  • Sorting
  • Filtering Data&Subtotals
  • Working with pivot table
  • 'What if' analysis
  • Managing Windows
  • Grouping and outlining data
  • Shortcut keys and references
  • Analysis tool pack
  • Multiple Windows
  • Splitting Windows
  • Freezing Panes
  • Linking Data
  • Recording and editing Macros
  • Printing Excel files
  • Managing Excel files
  • Analysis by pivot tables
  • Creating spakline graphics
  • Data consolidation

KHDA Certificate

Course completion certificate attested by KHDA(Knowledge and Human Development Authority), UAE.

Candidates who want to acquire expertise in advanced excel should get enrolled themselves