Overview

Course Content Getting Started Enter data in a worksheet Edit data Change the appearance of data Save a workbook Editing Your Worksheet Moving data to other cells Copy data to other cells Fill cells with a series of data Insert and delete rows and columns Undo and Redo an entry Find and replace numbers Enter data in a range Verify data in a range Performing Calculations Sum a Range of Data Use a Built-in Function Copy a Formula Create an Absolute Reference Formatting Number Formats Custom number formats Font Size and Type Styles Borders and Colours to cells Column Width and Height Align Cell Contents Merge and Center Cells AutoFormat Working with multiple worksheets Format worksheets Tabs Reposition Worksheets in a workbook Copy Worksheets Customising layout Split a worksheet Arrange worksheets Freeze and unfreeze rows and columns Hide & Unhide worksheets Page Display & Printing Options Freeze rows and columns Print Title Set Page Margins Headers and Footers Page Orientation Insert and remove page breaks Print a range