These tips for EXCEL 2010 cover some of the spreadsheet tasks I use often in my classes and research.  Please note that an EXCEL file with a .xlsx extension may not contain macros and a file with a .xlsm extension may contain macros.  For information on 1 or 2 day EXCEL_LEnT on-site workshops or a self-guided EXCEL_LEnT online course please email: Darrell.Fontane@ColoState.Edu.
1.	EXCEL Shortcuts: This tip describes some of the shortcuts in EXCEL for selecting ranges, copying and pasting cells and creating formulas that I find useful.
	Description	Example Spreadsheet	Tutorial Video
	EXCEL Shortcuts	Download Example EXCEL File	Play the Video
2.	Dynamic Graphs:  These graphs are used to quickly explore a table of data with multiple columns or rows.  The basic concept is to use an extra column (or row) and display the information to be plotted in that column.  The example spreadsheet shows three options to create a dynamic extra column for plotting and one option to create a dynamic extra row for plotting.
	Description	Example Spreadsheet	Tutorial Video
	Creating Dynamic Graphs	Download Example EXCEL File	Play the Video
3.	Box and Whiskers Plot: A Box and Whiskers plot can be created by modifying EXCEL's Open-High-Low-Close stock graph.
	Description	Example Spreadsheet	Tutorial Video
	Creating Box and Whiskers Plots	Download Example EXCEL File	Play the Video
4.	Emphasis Series in Graphs: This tip describes ways to use one or more additional series to emphasize special conditions within a graph. For example, if a portion of a dataset is above or below a threshold value special colors or markers can be displayed. These changes are dynamic and will automatically adjust to changes in the dataset or threshold values.
	Description	Example Spreadsheet	Tutorial Video
	Using Additional Series to Emphasize a Graph	Download Example EXCEL File	Play the Video
5.	Recording EXCEL Macros: This tip describes the steps to record a simple EXCEL macro. Be sure the Macro Security setting is "Disable all macros with notification."
	Description	Example Spreadsheet	Tutorial Video
	Recording EXCEL Macros	Download Example EXCEL File	Play the Video
6.	Custom EXCEL Macros: This tip describes a custom VBA macro to save results.
	Description	Example Spreadsheet	Tutorial Video
	Custom VBA Macros	Download Example EXCEL File	Play the Video
7.	VBA Message Boxes: This tip describes VBA input and message boxes.
	Description	Example Spreadsheet	Tutorial Video
	VBA Message Boxes	Download Example EXCEL File	Play the Video