PerCom Solutions

Spend a little - Learn a lot
Home     About Us     About our Courses     Course Prices     ByteSize Training     Course Outlines     Testimonials     Office Hints & Tips     Contact Us      
Excel Introduction Outline
View the topics below or click here to download a PDF
 

Introducing Excel:                   

· Spreadsheet Uses

· The Excel Screen

· Worksheets & Workbooks

· Menu Commands & Toolbars

· Excel Help

 

Creating a Spreadsheet:

· Using Different Data Types

· Entering & Deleting Data

· Editing Data

· Working With Dates

· Different Mouse Pointer Shapes

· Using AutoFill & Custom Lists

· Saving Files & Creating Folders

· Opening & Closing Files

· Using Undo & Redo

 

Working Within Spreadsheets:              

· Moving Around the Worksheet

· Selecting Cells

· Moving Data (Cut & Paste)

· Copying Data (Copy & Paste)

· Copying Between Spreadsheets

· Using the Office Clipboard

· Using Find & Replace

· Spelling & AutoCorrect

 

 

 

Using Formulas & Functions:

· Adding & Subtracting Cells

· Multiplying & Dividing Cells

· Copying & Moving Formula

· Absolute & Relative Formulas

· Using AutoSum

· Basic Functions

 

Formatting Cells/Worksheets:               

· Changing Fonts

· Aligning Data

· Merging Cells & Wrapping Text

· Adding Borders & Shading

· Inserting & Deleting Columns & Rows

· Changing Column Widths

· Formatting Numbers

· Using the Format Painter

 

Page Setup & Printing:

· Preview & Print a Worksheet

· Page Numbering

· Page Breaks

· Changing Orientation

· Changing Worksheet Size

· Using Gridlines

· Adding Headers & Footers

 

Creating Basic Charts:            

· Using the Chart Wizard

· Moving & Sizing Charts