Microsoft Excel Tutorials, Help, Forum, and more

Search TeachExcel

Featured Excel Content

How to open a PDF file from a clickable button, link, or image in Excel. This allows you to seamlessly link PDF files with a spreadsheet. Sections: Steps to Open PDF from Excel Open a PDF when an Image or Button is Clicked Notes Steps to Open PDF from Excel Right-click the cell that contains the text that you want to use to open the PDF when it i ...

View Excel Tip

Add Image Background to a Chart in Excel

How to use an image for the background of a chart in Excel. Simple but fun way to spruce up charts. Click the desired chart, go to the Layout tab which should have appeared, click Plot Area and then click More Plot Area Options In the Fill section click Picture or texture fill and it should look like this: Click the button File to choose an image ...

View Excel Tip

Filter While Leaving Original Data Intact in Excel

How to filter in Excel by copying the filtered data to a new location without doing anything to the original data set. This method leaves the original data set intact without changing it or hiding any rows in order to perform the filter. Steps to Copy Filtered Data Set to New Location While Leaving Original Data Set Intact We need to first figure ...

View Excel Tip

Combine Data from Multiple Worksheets in Excel

The easiest way to combine and consolidate data in Excel. Simple method to combine data from multiple worksheets into one worksheet. This method has Excel do all the work for you so that you don't have to insert any formulas or functions yourself. Sections: Steps to Combine and Consolidate Data in Excel How to Consolidate Data while Keeping Links ...

View Excel Tip

Make Professional Looking Rounded Buttons in Excel

How to make professional looking rounded buttons in Excel. This allows you to avoid using basic buttons and also to style the buttons to your content so they better blend-in with everything. Steps to Make Nice Buttons in Excel Go to the Insert tab and click the Shapes button: From the drop down menu that appears you will have many options. To crea ...

View Excel Tip

Change the Name of a Chart in Excel

How to change the name of a chart in Excel. This allows you to use a more intuitive chart reference when organizing charts using the Selection Pane or within VBA and macros. Rename a Chart Select the chart. This should cause three new tabs to appear: Design, Layout, and Format. Go to the Layout tab and look all the way to the right where it says ...

View Excel Tip

Make a Transparent Chart in Excel

How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mouse over the chart and it will tell you if you are over the Chart Area or the Plot Area etc. Right-click the background of the chart when you are over the Chart Area and click Format Chart Area... A window will open. In the Fill section ...

View Excel Tip

Add, Manage, & Remove Trendlines in Charts in Excel

How to add, manage, and remove trendlines in Excel Trendlines allow you to show trends in charts that might be otherwise difficult to notice. Basically, this is mostly used as a visual aid to illustrate an upward, downward, or flat trend over varying data points in a chart. Sections: Add a Trendline to a Chart Manage a Trendline Remove a Trendlin ...

View Excel Tip

Create Gantt Chart in Excel Easily

Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it should take no more than 5 minutes to make a Gantt Chart. Setup your data. For a Gantt chart, you need to have one column of data that states when a task will begin and one column next to it that states how long that task will take or last. Go to the Insert tab ...

View Excel Tip

Error bars in Charts in Excel

How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance of a data point in a chart. Maybe the values on the chart are an estimate and are within a 5% margin of error, this technique allows you to show that. Sections: Add Error Bars to Charts in Excel Change the Error Bars Size/Calculation ...

View Excel Tip

Search TeachExcel

New Excel Help Service!

Featured Excel Content