Excel for Fleet Management

General objectives:

This course allows giving its participants the necessary knowledge to make the Fleet Management of an Organization .

Specific objectives:

At the end of this course the participants will know:

• Create Spreadsheets, based on pre - defined templates , optimizing fleet management in the Organization;
• Automate Data Management, building Linked Models in analyzing Fleet and the full range of situations Management Chain of Fleet;
• Using Databases in support of fleet management;
• Learn to find solutions to support fleet management through Excel;
• Optimize the implementation of formulas, savings calculations and creation of alternative scenarios;
• Obtain clear results by analyzing tables.

CONTENTS

Module I - Functions and formulas commonly used in Fleet Management (Tables Analysis and Treatment)

Module II - Analysis and Comparison of Bids with Excel

Module III - The Excel as Instrument Support Reporting of Fleet Management

Module IV - Implementation Reports exporting and importing information to and from Excel

Module V - Forms and Templates