Excel Essentials

Formatting Text and Printing a Document

• What is a worksheet and a workbook?
• Identifying parts of the screen and ribbon components
• Getting help
• Using selection techniques
• Entering data and values
• Quickly adjusting column width
• Saving a named workbook
• Saving the workbook in HTML format
• Printing a worksheet
• Closing a workbook and exiting from Excel.

• Opening a workbook and creating a new workbook
• Creating simple formulas
• Using functions
• Using the AutoSum button
• Using the formula palette
• Editing data in the worksheet
• Editing the data in a cell
• Editing a formula
• Clearing the contents from a cell or range
• Using undo and redo.

Managing and Printing the Worksheet/Book

Formatting the Worksheet

• Navigating in and changing worksheets
• Deleting cells, rows and columns
• Performing a simple sort
• Printing and using print preview
• Creating headers and footers
• Removing the grid
• Using advanced printing techniques
• Working with page breaks
• Setting and removing print titles.

• Copying data and formulas
• Copying data and creating a series with AutoFill
• Defining relative, mixed, and absolute references
• Changing the appearance of data
• Applying fonts and formatting data and cells
• Adding enhancements
• Merging and centring cells
• Rotating and indenting text.