Course Content Expand All | Collapse All Modules Status 1 Module 1: Getting Started Understanding the Excel screen Navigating in a spreadsheet Understanding worksheets, columns, rows and cells Saving, opening, and closing workbooks 2 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 3 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 4 Module 4: Editing Features Using cut , copy, and paste operations Using paste special with values Selection techniques Navigation techniques 5 Module 5: Working with Large Worksheets Freezing and unfreezing panes Splitting windows Inserting page breaks for printing 6 Module 6: Working with Charts Creating charts using Chart Wizard Creating different types of charts Including titles and values in charts Formatting of charts 7 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 8 Module 8: Simple Database Operations Sorting tables Filtering data with auto filter Referring data from other worksheets