Excel is ideal for individuals interested in or aiming to build a career as an accountant, financial analyst, or data analyst. 

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