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 |