Excel Tips and Video Tutorials

Common Excel Mistakes

Biggest Mistakes Everyone Makes in Excel Spreadsheets

Biggest Mistakes Everyone Makes with Excel Charts

Watch Videos

• How to Setup Your Data for Charting in Excel
• Format Data for Charting
• How to Protect an Excel Worksheet
• How to Hide/Unhide Workbooks, Worksheets, Columns and Rows in Excel
• Excel Data Selection Tips and Shortcuts
• Excel Formulas
• Excel Text Formulas

Read Descriptions

• No One Can Read Your Spreadsheet
• Format Data for Charting
• How to Organize Your Data in Excel
• What Do I Do With My Data?
• Excel Data Selection Tips and Shortcuts
• Excel Formulas
• Excel Text Formulas
• Excel's Most Popular Shortcut Keys

Data Presentation Tips

• Chart Junk
• Data Display Tips Using Airline Quality Data
• Dunce Charts - Are You Still Using Line, Bar and Pie Charts?
• Format Charts - Tips for Formatting Charts
• Save and Reuse Custom Chart Formats
• Graphical Excellence
• Say It With Charts
• Visual Presentation of Data
• Use Excel to Create an Improvement Story
• Tips for Using Excel and Powerpoint for Presentations
• Time Tracking with Excel to Reduce Cycle Time such as Patient Length of Stay (LOS)
• How to Copy, Paste and Move Charts in Excel, Word and Powerpoint

Excel Function Tutorials

• Excel's Autofilter Function
• Excel's COUNTIF Function to Count Words in Text
• Excel's Custom Fill Series
• Excel's Customize Ribbon to Format Cells
• Excel's Data Validation Functions and Features
• Excel's Data Validation Function to Gather Defect Data
• Excel's Find and Replace function to remove zeros from a worksheet
• Excel Formula to Convert Date and Time Format to Decimal Numbers
• Excel's Tables -Running Charts on Data in Tables
• Excel's Text to Columns and Concatenate Functions to Separate and Combine Data into cells
• Excel's VLookup or Offset and Match Functions to Merge Worksheets
• Hacking Excel's RANK Function

Excel PivotTable Tutorials

• PivotTable Overview
• PivotTables for Breakthrough Improvement
• Pivot Tables - Is There an Improvement Project Lurking in Your Data?
• Reformatting Dates to Run PivotTables

Excel Drawing Tools

• How to Draw Flowcharts, Fishbones and Value Stream Maps in Excel
• Excel Drawing Toolbar and Select Objects - Excel 2003 vs Excel 2007 & 2010
• Flowcharts in Excel
• Fishbone Diagram in Excel
• Value Stream Mapping in Excel

Data Analysis Toolpak | Statistics

• Calculate 1st, 2nd and 3rd Order Regression
• Control Charts and Normal Data
• Use Charts to Explain Statistics