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.
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.
To ensure your success, you have some basic knowledge about computers and basic calculations.
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
Working with Microsoft Excel
- Formatting a Worksheet and modifying worksheet
- 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
Course completion certificate attested by KHDA(Knowledge and Human Development Authority), UAE.