Excel Tips

Note: sound quality may vary by TIP - sorry!  Will be redoing many of them soon for Excel 2013.

Some of these tips are done using Excel 2013, some with Excel 2010. 
If you need additional tips / help you can check out  http:// www.gcflearnfree.org/excel2013 or
http://www.gcflearnfree.org/excel2010 or you use your old friend, Google :)

If you are using USF's apps.usf.edu - here are the 'save' instructions:
Apple users: apps.usf.edu/content/mac.xensavingfiles.pdf
Windows users: apps.usf.edu/content/pc.xensavingfiles.pdf

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

Percent Formulas (including Markup) - Examples

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

3)  Using VLOOKUP to join worksheets (PDF version)

IF Function ~ IF Examples

Using Named Ranges

IFERROR Function

Drop Down Menus / Lists

Worksheet Formatting / Error Checking Tips / Filtering

Worksheet Tabs

Sorting a Worksheet

Simple Cell Formatting

Column & Row Sizes, Alignment Wrap

Conditional Formatting - The Format Painter

Shading Rows of a Worksheet using Conditional Formatting

Merge & Center, Titles, Borders, Backgrounds

Adding Shapes

Comment Feature

Error Checking

Protecting a Worksheet

Formula View

Filtering

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 - **Note - this tip shows 2 ways to group fields, watch the whole tip :)

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-2013,
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.
If you are working on an Apple system you may have to do a little 'Google' work if the Tips don't match exactly, but pivot tables are straight forward in both environments. 

Macros Tips

Basic Macros & Buttons

General Tips on Copying Files / Showing File Extensions