Microsoft
Excel
Introduction

COURSE OUTLINE

Home   Back   Disclaimer  

Introduction

Getting Started

• what is Excel? starting Excel, the Excel application window
• using the Excel menu system, using the Excel toolbars
• displaying help information
• exiting from Excel

Modifying an existing worksheet

• resetting the working folder
• moving the cell pointer, changing data in a worksheet
• reversing an edit operation, saving a workbook
• adding data to a worksheet
• entering a formula into a worksheet
• adjusting column width in a worksheet
• printing a worksheet

Building a new worksheet

• opening a new workbook, using the spelling checker

Using worksheet shortcuts

• using autofill
• copying, moving and clearing cell entries
• using autosum
• inserting and deleting rows and columns
• inserting and deleting a range of cells

Enhancing worksheet appearance

• working in edit mode
• adjusting row height in a worksheet, realigning cell entries
• resetting the font of cell entries and numeric format of cell entries
• adding a border and shading to a worksheet
• using autoformat

Enhancing printed output

• changing the page setup of a worksheet
• previewing a worksheet
• printing selected worksheet entries

Using Excel functions

• what is a function? using the SUM function
• using the AVERAGE, MAX and MIN functions
• using the COUNT function, using the paste function button

Final case study

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer