Description

Introduction

Microsoft Excel allows you to manipulate, manage and analyze data, helping assist in decision-making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal databases and expenses, Microsoft Excel gives you the right tools to enable you to accomplish all your needs..

Goal of Course

• Identify the different components of the Excel worksheet.
• Differentiate between an Excel workbook & worksheet.
• Open an existing workbook and create a new workbook
• Enter text and formulas into an Excel spreadsheet
• Enhance alpha and numeric data in an Excel worksheet
• Move & copy alpha and numeric data
• Construct formulas to manipulate numeric data in an Excel Worksheet
• Create a spreadsheet to tabulate and record numeric values
• Change the appearance of an Excel spreadsheet
• Use the print function to create a printable copy of data stored on an Excel spreadsheet.
• Set up the chart function of Excel to represent numeric data in multiple formats.
• Differentiate between formulas and functions in Excel.
• Use at least four functions that are stored in Excel.
• Access and manipulate data using the database functions of Excel.

Key Modules

• MS Excel Formulas
• Data Summarization with Pivot
• MIS Reporting with MS Excel
• Understanding of VBA/Macro Programming