Microsoft Excel Advanced

Microsoft Excel is the MS Office spreadsheet and analysis program. It gives professionals the tools they need to manage critical business data, and everyday users the power to get the most out of their information. It provides an impressive array of tools for planners, engineers, accountants and operations staff to handle and analyze data

This Excel Advanced course aims to show the participants how to create more sophisticated worksheets, incorporating advanced formatting options, charts and graphics.

Contents

-Working with complex Formulas & Functions
-Data Manipulation & Pivot Tables
-Outlining & Consolidation Features
-Data Sorting & Filtering
-Linking Spreadsheets
-Publishing Worksheets as HTML & Email Collaboration