Excel Videos
Watch these training videos on various aspects of Microsoft Excel. Through live screencasts, experts will show you how you can use a variety of features in Excel. A full transcript is provided so you can follow the training videos on your own.
IF Function in Excel
One of the most useful functions in Excel is the IF function. What this function does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. Watch this video on how to write an Excel IF function.
One of the most useful functions in Excel is the IF function. What this function does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. Watch this video on how to write an Excel IF function.
Create Excel Pivot Tables
A pivot table is a reporting tool that sorts, counts, and sums the data from a spreadsheet, database, or other external data source. The pivot table is a second table that displays the summarized data.
A pivot table is a reporting tool that sorts, counts, and sums the data from a spreadsheet, database, or other external data source. The pivot table is a second table that displays the summarized data.
Find and Replace in Microsoft Excel
Get some help navigating large spreadsheets with the find and replace function in Microsoft Excel. You can also use it to check for duplicates.
Get some help navigating large spreadsheets with the find and replace function in Microsoft Excel. You can also use it to check for duplicates.
Create Borders and Shading in Excel
Borders and shading not only add aesthetic presentation to your spreadsheet data, but they can help make your spreadsheets easier to read.
Borders and shading not only add aesthetic presentation to your spreadsheet data, but they can help make your spreadsheets easier to read.
Hide Information in Microsoft Excel
In some cases, you may not want to display certain information on your Excel spreadsheet. You can simply hide information in specific rows, columns, and even cells. See how it's done!
In some cases, you may not want to display certain information on your Excel spreadsheet. You can simply hide information in specific rows, columns, and even cells. See how it's done!
Headers and Footers in Microsoft Excel Spreadsheets
Headers and footers are useful tools to add to Microsoft Excel spreadsheets. Learn how to create and adjust headers and footers, including ones with automatically updated dates and times.
Headers and footers are useful tools to add to Microsoft Excel spreadsheets. Learn how to create and adjust headers and footers, including ones with automatically updated dates and times.
Export Data From an Excel Sheet to a Word Document
Copying Excel cells into a Word document is just one way to transfer data between the two programs. Find out how to easily export data from Microsoft Excel to Word.
Copying Excel cells into a Word document is just one way to transfer data between the two programs. Find out how to easily export data from Microsoft Excel to Word.
How to Add Comments in Excel
Adding comments is a great way to add extra information about the data in a spreadsheet. This video will show you how to insert comments into a Microsoft Excel spreadsheet.
Adding comments is a great way to add extra information about the data in a spreadsheet. This video will show you how to insert comments into a Microsoft Excel spreadsheet.
Excel Auto SUM Function
Learn how to use the SUM and Auto SUM functions in Microsoft Excel. These features help you to easily add up rows or columns of data.
Learn how to use the SUM and Auto SUM functions in Microsoft Excel. These features help you to easily add up rows or columns of data.
Excel Lists- Remove Duplicates
Use Conditional Formatting to find Duplicate Data in Excel database files and other long lists of data.
Use Conditional Formatting to find Duplicate Data in Excel database files and other long lists of data.
Merge Spreadsheets in Excel
Learn how to merge spreadsheets and automatically update them when you change the individual files.
Learn how to merge spreadsheets and automatically update them when you change the individual files.
How to Adjust Tabs in Microsoft Excel
One way to make your multi-page spreadsheets easier to work with is to format the sheet tabs. Formatting options for sheet tabs include renaming a tab, changing the tab color as well as adding, deleting and reordering sheets.
One way to make your multi-page spreadsheets easier to work with is to format the sheet tabs. Formatting options for sheet tabs include renaming a tab, changing the tab color as well as adding, deleting and reordering sheets.
Excel Sort - How to Sort Information in Microsoft Excel
Learn how to manage large amounts of data. Sorting data not only helps you to keep it organized, but it makes it easier to find exactly the data you are looking for.
Learn how to manage large amounts of data. Sorting data not only helps you to keep it organized, but it makes it easier to find exactly the data you are looking for.
Goal seeking AV Tutorial
Goal Seeking is a useful Excel command for asking "what if" type questions by varying the data in a formula to achieve different results. This site has a very clear and straightforward Audio Visual tutorial that takes you through a step by step example of using Goal Seeking.
Goal Seeking is a useful Excel command for asking "what if" type questions by varying the data in a formula to achieve different results. This site has a very clear and straightforward Audio Visual tutorial that takes you through a step by step example of using Goal Seeking.