Microsoft Excel is an indispensable tool that has become an integral part of most business organizations across the globe. Excel is used for various purposes by different business establishments, from the micro to the large enterprises. No report is really complete without a few Excel based graphs or charts.

The course is to equip the participants with the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.

• Create pivot tables and charts
• Learn to trace precedents and dependents
• Convert text and validate and consolidate data
• Collaborate with others by protecting worksheets and workbooks
• Create, use, edit, and manage macros
• Import and export data

WORKING WITH FUNCTIONS

• Using the Paste Function tool
• Absolute and relative cell references
• Using range names in functions
• Creating nested functions
• Logical functions (SUMIF, COUNTIF)
• The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
• Financial functions (PMT, NPV)

WORKING WITH DATA

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool
• Database functions
• Using the Data Form to enter data
• Creating subtotals

WORKING WITH EXTERNAL DATA

• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web

CHARTING WITH EXCEL

• Selecting the data to chart
• Creating a chart
• Choosing the right chart for the job
• Moving and re-sizing charts
• Customizing charts
• Saving and copying a chart’s design

TABLES

• Creating an Excel table
• Table formatting
• Adding rows and columns
• Automatic calculation in tables

COLLABORATION TOOLS

• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks
• Tracking changes

AUDITING WORKBOOKS

• Viewing formulas
• Tracing precedents and dependents
• Error checking

• Management Trainee
• Specialist Staff
• Managers