Excel Topics Covered |
| |
| |
| Module 1: Getting Started |
| |
~
~
~
~ |
Understanding the Excel screen
Navigating in a spreadsheet
Understanding worksheets, columns, rows and cells
Saving, opening, and closing workbooks |
| |
| Module 2: Formatting a Spreadsheet |
| |
~
~
~
~
~
~
~ |
Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers
Clearing formats
Applying borders to cells
Merging cells |
| |
| Module 3: Formulas and Functions |
| |
~
~
~
~
~
~
~
~
~ |
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 |
| |
| Module 4: Editing Features |
| |
~
~
~
~ |
Using cut , copy, and paste operations
Using paste special with values
Selection techniques
Navigation techniques |
| |
| Module 5: Working with Large Worksheets |
| |
~
~
~
|
Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing |
| |
| Module 6: Working with Charts |
| |
~
~
~
~ |
Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts |
| |
| Module 7: Previewing and Printing |
| |
~
~
~
~
~ |
Previewing worksheets
Page setup
Printing of worksheets in multiple pages
Repeating rows and columns for multiple pages
Printing multiple worksheets |
| |
| Module 8: Simple Database Operations |
| |
~
~
~
~
~
|
Sorting tables
Filtering data with auto filter
Generating subtotal reports
Creating pivot tables
Referring data from other worksheets |
+91-22-23676218 / 23671772