This program introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.

This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel as follows:

Creating and editing worksheets
Formatting and printing of worksheets
Commands for managing data such as sorting, filters, subtotals, pivot tables
Working with charts
Working with in-built functions of Excel

Executives and managers from various functions (such as Finance, Sales, HR, etc.) who need to work with lots of calculations and analyze data for their day-to-day operations.

Day

Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers
Clearing formats
Applying borders to cells
Merging cells

Entering formulas
Copying data and formulas
Using AutoSum
Understanding functions
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Copying formulas
Types of cell referencing: relative and absolute
Applying conditions in a formula (The IF function)
Working with ranges

Using cut , copy, and paste operations
Using paste special with values
Selection techniques
Navigation techniques

Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing

Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts

Previewing worksheets
Page setup
Printing of worksheets in multiple pages
Repeating rows and columns for multiple pages
Printing multiple worksheets

Sorting tables
Filtering data with auto filter
Generating subtotal reports
Creating pivot tables
Referring data from other worksheets