Advanced Excel

Posted by: Galaxy Computer Education, 22 Sep, 2018

Ad Detail

AD ID 4311384
Locality Abu Dhabi, Emirate
Ad Type Offering
Posted by Company

Advanced Excel - Course Overview

Microsoft Office Excel is widely used in businesses across all industries and this powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually, and present summary information in a consumable and professional format.

Course Contents

- Working with data
- Manipulate worksheets
- Working with formulas
- Format worksheet contents
- Using built-in functions
- Sorting and filtering
- Subtotals
- Working with charts
- Page setup and Printing worksheets
- Scenarios
- Pivot Reports and Pivot Charts
- Goal seek and Solver
- Absolute Cell References and Cell naming
- Working with Macros
- Visual Basic Application