| Course 1: Basic 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 | ||||
| ~ Navigating and operating in excel through shortuts | |||||
| 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 agg. functions (Sum, Count, Average, Min, Max) | ||||
|
| ~ Copying formulas |
| |||
|
| ~ 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 |
| |||
|
| ~ Referring data from other worksheets |
|
| ||
The classes for the Combo Course is conducted on Weekends- Saturday- Sunday.
Check our batch details
Certified
You have successfully registered
