MODULE 1: 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 2: 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 3: EDITING FEATURES
• Using cut, copy, and paste operations
• Using paste special with values
• Selection techniques
• Navigation techniques
MODULE 4: WORKING WITH LARGE WORKSHEETS
• Freezing and unfreezing panes
• Splitting windows
• Inserting page breaks for printing
MODULE 5: WORKING WITH CHARTS
• Creating charts using Chart Wizard
• Creating different types of charts
• Including titles and values in charts
• Formatting of charts
MODULE 6: PREVIEWING AND PRINTING
• Previewing worksheets
• Page setup
• Printing of worksheets in multiple pages
• Repeating rows and columns for multiple pages
• Printing multiple worksheets
MODULE 7: SIMPLE DATABASE OPERATIONS
• Sorting tables
• Filtering data with auto filter
• Referring data from other worksheets