Excel Tips Video Library
- - - - - - - - - - - - - -

Most people think of Excel as only an application for creating spreadsheets, but it’s an excellent tool for capturing each element of a complete root cause analysis. By changing the way details are documented, a facilitator can improve the entire investigation process. Learn to take advantage of Excel as a root cause analysis software to change the way you investigate and prevent problems within your company.

Quick Access Toolbar

Excel Settings

Text Boxes

Selecting Objects

Drawing Tools

Using Connectors

Align & Distribute

Date and Time

Photographs

Worksheets

Working in Cells

Charts & Graphs

Hyperlinks

Editing

Troubleshooting

Adding a Command to the Quick Access Toolbar From the Menu Ribbon

loading...

Selecting Commands for the Quick Access Toolbar

loading...

Changing the Order of Commands on the Quick Access Toolbar

loading...

Removing Commands from the Quick Access Toolbar

loading...

Move the Quick Access toolbar

loading...

ALT Key Shortcuts for the Quick Access Toolbar

loading...

Create a Quick Access Tollbar specific to a file

loading...

Return to the default Quick Access Toolbar

loading...

Remove a Menu Ribbon From Microsoft Excel

loading...

Undo Last Command(s)

loading...

Redo

loading...

Repeat the last action

loading...

Hide the ribbon

loading...

Save as Compatible File

loading...

Set a default save location

loading...

Save as template

loading...

Open a saved template

loading...

Password protect an Excel workbook

loading...

Add properties to a workbook

loading...

Print A Large Cause Map Using Tiling in Microsoft Excel

loading...

Two ways to work with text boxes

loading...

Move a Text Box

loading...

Move in a Straight Line

loading...

Copy a Text Box

loading...

Copy in a Straight Line

loading...

Change the font within a text box

loading...

Aligning Text Within a Text Box

loading...

Changing the Size of a Text Box

loading...

Changing the Internal Margins of a Text Box

loading...

Changing the Border of a Text Box

loading...

Changing the Default Text Box

loading...

Changing the Color of a Text Box

loading...

Changing the Font Color Within a Text Box

loading...

Changing the Orientation of Text in a Text Box

loading...

Prevent Drawing Objects from Resizing with Cells in Excel

loading...

Using the Select Objects Arrow Cursor

loading...

Select Multiple Objects Using the Shift Key

loading...

Group Multiple Objects

loading...

Paste a Linked Picture

loading...

Paste Cells into Word or PowerPoint

loading...

Paste Drawing Objects into Word or PowerPoint

loading...

Paste Text Only (No Formatting) in Excel

loading...

Accessing the Drawing Tools

loading...

Creating a Free-form Line (Scribble) Within Microsoft Excel

loading...

Resize an Object While Maintaining the Aspect Ratio

loading...

Send an Object in a Microsoft Excel Worksheet Behind Another Object

loading...

Inserting an Elbow Arrow Connector

loading...

Inserting Multiple Connectors

loading...

Changing the Color of a Connector

loading...

Changing the Arrow Type of a Connector

loading...

Setting the Default Connector Color

loading...

Straightening a Connector - Option 1

loading...

Straightening a Connector - Option 2

loading...

Create separate connector arrows from a text box

loading...

Create separate connector arrows from a text box

loading...

Align a vertical column of text boxes

loading...

Align a horizontal row of text boxes

loading...

Distribute (evenly space) text boxes

loading...

Bring to Front

loading...

Enter today's date

loading...

Enter the current time

loading...

Format a cell for the date

loading...

Format a cell for time

loading...

Skip weekends in a list of dates

loading...

Calculate the difference between two dates

loading...

Insert a Photo in Microsoft Excel

loading...

Compress photos within Excel

loading...

Label photos

loading...

Add an Arrow to a Photo in Microsoft Excel

loading...

Circle Parts of Photos

loading...

Insert a worksheet

loading...

Rename a worksheet in Excel

loading...

Change the tab color of a worksheet in Excel

loading...

Zoom in and out in Microsoft Excel

loading...

Zoom on Roll with intelliMouse

loading...

Move between worksheets in Microsoft Excel workbooks

loading...

Move a worksheet in Microsoft Excel

loading...

Copy a worksheet in Excel

loading...

Remove gridlines

loading...

Add a Comment

loading...

Freeze the Top Row of a Microsoft Excel Worksheet

loading...

Freeze the Left Column

loading...

Freeze Panes in a Microsoft Excel Worksheet

loading...

View Worksheets in a Microsoft Excel Workbook

loading...

Print Preview

loading...

View the Page Layout of an Excel Worksheet

loading...

Change the Orientation of an Excel Worksheet

loading...

View Excel Worksheets Side by Side

loading...

Set Worksheet Margins

loading...

Create a Header or Footer

loading...

Scale An Excel Worksheet to Fit on One Page

loading...

Find Text Within the Cells of a Worksheet

loading...

View and Adjust Page Breaks in Excel

loading...

Add a Page Break to a Worksheet in Microsoft Excel

loading...

Delete a Worksheet in Excel

loading...

Hide a Worksheet Within Microsoft Excel

loading...

Unhide a Worksheet Within Microsoft Excel

loading...

Arrange Workbooks in Microsoft Excel

loading...

Center a Printed Page in Microsoft Excel

loading...

Insert a Row of Cells Within a Worksheet

loading...

Insert a Column of Cells Within a Worksheet

loading...

Format a Cell in Excel for Currency

loading...

Add a New Line Within a Cell in Microsoft Excel

loading...

Move a Row of Cells Within Excel

loading...

Remove Zeroes from Showing in Cells Within Excel

loading...

Create a Numerical Sequence in Cells Within Excel

loading...

Create a Numerical Sequence in Cells Within Excel (Alternate Method)

loading...

Merge Cells Within Excel

loading...

Change Row Height or Column Width Within Excel

loading...

Hide a Column or Row Within Excel

loading...

Unhide a Column or Row Within Excel

loading...

Sum a Series of Numbers In Excel

loading...

Add Custom Text to a Numerical Cell in Microsoft Excel

loading...

Insert a Bar or Column Chart in Excel

loading...

Insert a Pie Chart in Excel

loading...

Insert a Line or Area Chart in Excel

loading...

Hyperlink a Cell in Excel to an Internet Page

loading...

Link Cell Contents to a Text Box in Excel

loading...

Link a Cell to a Worksheet in Excel

loading...

Remove A Hyperlink in a Cell in Excel

loading...

Insert a PDF Within Excel

loading...

Check Spelling Within Cells and Drawing Objects In a Worksheet

loading...

Track Changes in Microsoft Excel

loading...

Accept or Reject Changes from Track Changes in Microsoft Excel

loading...

Excel Troubleshooting: The Gridlines are Missing

loading...

Troubleshooting: My Text Boxes in Excel are Resizing

loading...

Troubleshooting: My text Doesn't Fit Within a Cause Box!

loading...

Troubleshooting: I Entered a Date in a Cell in Excel but Got a Number

loading...

Troubleshooting: I Can't Select a Drawing Object By Clicking On It in Microsoft Excel