Microsoft Excel makes it easy to import data from other sources, such as Access and Oracle databases. Doing so, however, may result in poorly formatted data that is difficult to analyze, sort or ...

Studies, including those by spreadsheet researcher Raymond Panko, estimate that up to 90% of all spreadsheets contain at ...

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

If you use Microsoft Excel at all to make and edit spreadsheets, you have probably heard of Excel worksheets and workbooks. An Excel workbook is an Excel file that can contain multiple, somewhat ...

Excel workbooks are the next step after you’ve mastered the single Excel spreadsheet. Going back to the ledger idea we used in our Excel spreadsheets guide, think of the workbook as the ledger (or ...

Open an Excel worksheet, and then suddenly you notice that the tabs are missing, with no idea how to fix this issue. In this tutorial, we will discuss the cause of missing tabs in an Excel worksheet ...

Working with multiple worksheets can be quite tough for Excel users, especially if there is a lot of work. In Microsoft Excel, there are several tricks that individuals can use to switch between Excel ...

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...

If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites. We all have features and commands that we use more than others.

When you have a lot of data in an Excel worksheet it often becomes necessary to summarize the information to get to the crux of what it is telling you. There are a number of ways to do this in Excel, ...