Excel Tips

Data Tips

Copying Data from Word to Excel

Formula / Function Tips

Basic Functions/Formulas
searching for functions, sum, average, minimum, maximum
writing your own formulas

Date / Time Functions/Formulas

'How to Calculate Markup Percentage (based on cost)'

More Complex Functions/Formulas / Order of Operation
decimals to percent, decimal places

Absolute and Relative Cell References in Formulas

Formulas using Multiple Worksheets (consolidation)

 1)  VLOOKUP using a range   

   2)  VLOOKUP Function w/relative & absolute cell referencing

IF Function ~ IF Examples

Using Named Ranges

Drop Down Menus / Lists

Worksheet Formatting / Error Checking Tips

Worksheet Tabs

Sorting a Worksheet

Simple Cell Formatting

Column & Row Sizes, Alignment Wrap

Conditional Formatting - The Format Painter

Merge & Center, Titles, Borders, Backgrounds

Adding Shapes

Comment Feature

Error Checking

Protecting a Worksheet

Formula View

Chart Tips

Charts - Basic Chart Formatting

Chart Formatting #2
selecting non-adjacent cells, titles that change, data values, font colors & size,
gradients, background colors/pictures, border styles/colors/corners/shadows

PIVOT Table / Chart Tips

Basic Pivot Table & Charts (Excel 2007/2010)

There are Excel 2003 Pivot Table Demos available at
http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033&pid=CR061831141033
and
http://office.microsoft.com/en-us/excel/HA010346321033.aspx
or as part of the Excel 2003 Help feature.
BUT... they are so easy to do in 2007 & 2010,
that if you have an old version of Excel, you might want to
come into a lab on campus to work with pivot tables/charts.

Macros Tips

Basic Macros & Buttons

General Tips on Copying Files / Showing File Extensions