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