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 Intermediate Outline
View the topics below or click here to download a PDF
 

Revision of Basics:                   

· Entering & Formatting Data

· Basic Formulas & Functions

· Creating Basic Charts

· Page Setup & Printing

 

Advanced Formatting:

· More Borders & Shading

· Conditional Formatting

· Indenting Labels

· Worksheet AutoFormat

· Adding, Editing & Deleting Comments

 

Charts & Graphics: 

· Formatting Charts

· Modifying Charts

· Inserting ClipArt & Pictures

· Working With Text Boxes

 

More Formulas:      

· Absolute & Relative Formulas

· Formula Precedents

· Errors in Formulas

 

Protecting & Hiding:               

· Protecting a File

· Protecting Cells

· Hiding Data

 

Multiple Worksheets:

· Inserting & Deleting Worksheets

· Moving & Copying Worksheets

· Linking Worksheets

· Grouping Worksheets

· Calculating Across Worksheets

 

Database:                

· Creating a List

· Sorting & Filtering a List

· Subtotals in a List

· Freezing Worksheet Titles

· Printing Worksheet Titles

 

Advanced Functions:

· Conditional Functions (IF, AND, OR)

· Lookup Functions (VLOOKUP)

· Date & Time Functions

· Text Functions

 

Using Ranges:          

· Creating Range Names

· Ranges in Formulas

· Go To a Range

 

Linking:   

· Linking With Other Applications

· Using Hyperlinks