Excel (Level I) Topics Covered
Excel (Level I) 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 ~ 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 |