If you are preparing an Excel form that requires users to input data from certain specified options, you will need to create a drop-down list to choose from. Excel 2010 has a feature called Data Validation that lets you create a drop-down list with ease. While it is not too … [Read more...] about How to Create a Drop Down List in Excel 2010
excel
How to Navigate to Any Worksheet Quickly in Excel 2010
When you create several worksheets in Excel, all the worksheets names are not displayed on the worksheet tab. This may make navigation to a worksheet that’s not visible a little bit annoying. You will have to use keyboard shortcuts such as the Ctrl+Page Up, Ctrl+ Page Down or the … [Read more...] about How to Navigate to Any Worksheet Quickly in Excel 2010
Microsoft Excel Web App Gets New Features and Updates
Windows Live SkyDrive is a useful platform for a number of reasons. You can store, send, and share your documents, photos, and videos with others. What works great for me is the fact that I can upload and share Microsoft Office documents with users who don't have Microsoft … [Read more...] about Microsoft Excel Web App Gets New Features and Updates
Excel 2010: How to Match Two Lists of Items in Microsoft Excel
This is a guest post written by Yoav Ezer. If you would like to write for theapptimes, check our Guest blogging guidelines. When you work with Microsoft Excel for long enough inevitably you will be presented with two lists of items that you need to work with or match. Everything … [Read more...] about Excel 2010: How to Match Two Lists of Items in Microsoft Excel
The Excel R1C1 Reference Explained
This is a guest post written by Yoav Ezer. If you would like to write for theapptimes, check out our Guest blogging guidelines. Have you ever come across a Microsoft Excel spreadsheet that looked like the one below? Not noticing anything different? Look again. Yes, rather than a … [Read more...] about The Excel R1C1 Reference Explained
Excel 2010: How to Freeze Rows and Columns in a Worksheet
Working with large worksheets becomes tiresome if you have to keep scrolling up and down the worksheet multiple times to look for specific data. The Freeze Panes command in Excel 2010 allows you to freeze certain rows and columns so that they remain static while you scroll … [Read more...] about Excel 2010: How to Freeze Rows and Columns in a Worksheet
How to Cross-Find Similar Product Codes in Microsoft Excel
This is a guest post written by Yoav Ezer. Many people use Microsoft Excel to work with external data sources, but of course in the real world data is not supplied in a clean, easy to use format. What can you do if you have multiple sources of data? For example, what about … [Read more...] about How to Cross-Find Similar Product Codes in Microsoft Excel
How to Activate the Developer Tab in Excel 2010
If you have been using Office 2003 and upgraded to Office 2010, you may have noticed that the Excel interface has been transformed into a much more user friendly one. However, in the initial stages finding your most commonly used commands may take a bit of time. For instance, if … [Read more...] about How to Activate the Developer Tab in Excel 2010