2011 January | Excel Semi-Pro

January 2011

Excel 2011 Keyboard Shortcuts on Your Desktop

January 31, 2011 Intermediate

My frustration level is high with the learning curve associated with keyboard shortcuts in Excel 2011 so I decided to import them into a spreadsheet and found out that’s not happening. Since there’s more than one way to skin a cat (sorry cat lovers, just an expression) I decided to import them from the Office:Mac […]

Get the full story …

Import Data From the Web in Excel

January 28, 2011 Intermediate

Excel 2010 and 2007 for Windows have the option to import data from the web. Excel for Mac users don’t. An integral part of working with Excel is using keyboard shortcuts. They make your life so much easier (in the Windows versions at least, in the Mac version I think they tend to shorten your […]

Get the full story …

Copy a Help Topic URL in Excel 2010

January 26, 2011 Beginner

Excel 2010 Help is normally connected to Office.com so each Help topic has a specific web address (URL) that can be easily copied. This is only for Windows computers running the latest Excel version 2010. You can check the connection status to Office.com by hitting the F1 key to bring up the Help screen, then […]

Get the full story …

INDEX and MATCH Functions Together Again in Excel

January 24, 2011 Formulas

The INDEX and MATCH functions are used together to perform lookups. The INDEX functions grabs a cell from an array, and the MATCH function contributes the row and/or column position. INDEX and MATCH Example Familiarity with the VLOOKUP function can cause you to restrict INDEX and MATCH to less than they can be. The example […]

Get the full story …

The INDEX Function in Excel

January 21, 2011 Formulas

The INDEX and MATCH functions working together are more flexible than using the VLOOKUP function. However, if you’ve never used INDEX and MATCH to perform a lookup it can get confusing. I’m going to cover the INDEX function here so you can learn it well and don’t have to think about it too much when […]

Get the full story …

The MATCH Function in Excel

January 19, 2011 Formulas

The MATCH and INDEX functions working together are more flexible than using the VLOOKUP function. However, if you’ve never used MATCH and INDEX to perform a lookup it can be confusing at first. I’m going to cover the MATCH function here so you can learn it well and don’t have to think about it too […]

Get the full story …

Goal Seek in Excel

January 17, 2011 Features

Formulas and Functions give you answers based upon input. If you know what a formula’s answer should be, but can’t derive the input value, Goal Seek is the tool for you. I have a simple formula from my last post that takes one input, a Date in “m/d/yyyy” format, and returns the Day of the […]

Get the full story …

What Day of the Year is It?

January 14, 2011 Formulas

Given the Date in this spreadsheet, a simple formula using the DATE Function will return the Day of Year. Go ahead and type a Date value in cell A2 to see how the formula works, the spreadsheet is embedded from my SkyDrive. (Date format is US, “m/d/yyyy”) Click here if you can’t see the embedded […]

Get the full story …

How Many Years, Months and Days Has it Been?

January 12, 2011 Formulas

The DATEDIF Function comes in handy when you want to know how many years, months, and days there are between two dates. And even though it may be slightly flawed, it still beats the alternatives. The following spreadsheet works well for birthdays or anniversaries. The DATEDIF Function is being used to generate the Years, Months, […]

Get the full story …

The Repeat Command in Excel for Mac

January 10, 2011 Intermediate

Adding the Repeat command icon to the Quick Access Toolbar in Excel for Windows is a simple process that I explained in a blog post last week. Excel for Mac — 2011 or 2008 — doesn’t have a Quick Access Toolbar, but you can customize the toolbars and menus. Add the Repeat Icon to the […]

Get the full story …