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
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