Learn IT

What’s new with Office 2013?

Question: I have started using Office 2013 and noticed many differences between Office 2013 and Office 2010, particularly with Outlook and Calendar.  Are you aware of any summaries describing the differences? Answer: The differences don’t seem to be extensive, but there are some changes. In particular, you now have the ability to save directly to the cloud (although Office 365 has limited features compared to 2013). There are some really nice new features with Excel such as flash fill and quick analysis too. This handout provides… Continue Reading

Excel file keeps getting bigger

Question: I have an Excel file  I filtered and then copied “visible cells only” to a new worksheet, so that I could maintain formulas. However, the smaller file size increases to an enormous file size, making it very slow for working with and impossible to email. What is causing this? Answer: It appears that when you copy visible cells to a new worksheet that it pasted in the blank columns and rows also. You can tell this by noticing the scroll box along the vertical… Continue Reading

Updating Outlook Groups from Excel Lists

Question: I created contact groups some time ago with around 100 names each, since Outlook won’t allow personal group with 300 names (1A, 1B, 1C) I keep the master list in Excel but it has been quite a long time since I updated the groups, and I can’t remember how I can get them updated. Answer: The easiest way to do this is to have your Excel list open, along with your Outlook contacts. Open the first group 1A, and remove the names (use Ctrl… Continue Reading

Looking up and replacing massive Excel data

Question during a “drop in” session: I have an Excel Workbook with several large worksheets. Three worksheets contain over 100,000 rows, one contains over 80,000 and another 23,000 rows. I need to match up the IDs and place the information from two massive worksheets into the one with 23,000 rows and I can’t figure out how to do it without having to search for each record manually. Answer: I was possible to use a VLookup formula, however by the time I got to the third… Continue Reading

Comparing data from two Excel worksheets

Question: I need some help analyzing some data from two different spreadsheets and was wondering if you would guide me on what the best way to do it is. I have two spreadsheets and one contains costs from 2013 and one for 2014 and I need to match the two codes on each spreadsheet so we can do a comparison of the costs from 2013 to 2014. Answer: It is possible, but in looking a your spreadsheets, you need to do a few things first. I basically brought… Continue Reading