December 2010

The Rest of the Booty

December 31, 2010 General Update

For taking a picture of myself with some Excel stuff I won a runner-up prize in the Spreadsheet Challenge, which was a $50 VISA gift card AND some books from Mr. Spreadsheet himself. The books were delivered just before Christmas and will keep me busy in 2011. Everyone please have a safe and Happy New [...]

Get the full story …

The TRIM Function in Excel and VBA

December 29, 2010 Formulas

Excel’s TRIM Function is a great way to remove extra spaces before, after, and within text in a spreadsheet. However, if you think the identically named VBA function does the same thing you’d be sadly mistaken, as I was once upon a time. Here’s a normal sentence. Here’s a sentence with extra spaces – two [...]

Get the full story …

Top 10 Articles for 2010

December 27, 2010 General Update

The year started for Excel Semi-Pro with my first article on 15 June, 2010. Thanks to you all for visiting my site to see what’s cooking with Excel. According to my Site Stats, here are the top 10 articles this year. Become the OFFSET Function and Tell a Short Story Excel 2011 for Mac – [...]

Get the full story …

Apple Keyboard Symbols in Excel

December 23, 2010 Beginner
Thumbnail image for Apple Keyboard Symbols in Excel

One key to understanding Excel 2001 for Mac is knowing the keyboard shortcuts, but to communicate them requires displaying the symbols that are specific to a Mac keyboard. The Media Browser has a nice area for Symbols that gave me what I needed. There are a few different ways to access the Media Browser. One [...]

Get the full story …

Automatically Expand a Named Range in Excel

December 22, 2010 Advanced

I usually put a name to each data table created for referencing information in in Excel, as in a Named Range. If you add data to the bottom of the table, the Named Range isn’t modified and any reference to it will fail to include the new information. Here’s a table of data I stuck [...]

Get the full story …

Keyboard Shortcuts in Excel 2011

December 21, 2010 Beginner

Sorry if I get transfixed by shortcuts in Excel 2011, but they are a vital part of how I use Excel and so much different than Excel for Windows, so anything that helps the learning curve is worth the effort. In looking for something else, I discovered you can change the keyboard shortcuts in Excel [...]

Get the full story …

The VLOOKUP Function in Excel

December 20, 2010 Formulas

VLOOKUP is an Excel Function that’s used to look up something. It takes four arguments. The first argument is the Something. The second and third arguments are the Look Up part. And the last argument is optional, but the most important, and is either TRUE or FALSE. Technically the first argument is the lookup_value, but [...]

Get the full story …

Recently Used File List in Excel

December 17, 2010 Beginner

How many files will Excel show in the Recently Used File List? Well, it depends on the version of Excel you’re using and vary between 9 and ninety-nine files. Here is a list of Excel versions, menu navigation to the recent file list, and the max files allowed. Excel 2010, 2007 File>Options>Advanced tab>under the Display [...]

Get the full story …

Use Function Keys Normally in Excel 2011

December 16, 2010 Beginner

Since I’m relatively new to the world of Mac but an old hand with Windows, making an effort to discover Excel 2011 for Mac comes with some adjustments. Using the Function keys is one such irritation adjustment. You see, using Excel on a Windows machine allows you to use the function keys, like F1, F2, [...]

Get the full story …

Logical Operations in Excel

December 15, 2010 Beginner

Every once in a while you get fixated on something and the only way to let it go is to share it with others. So …. while reviewing the logical IF function and nested IF statements, I came up with a chart or table, that sort of evolved out of curiosity. It started by looking [...]

Related Posts Plugin for WordPress, Blogger...
Get the full story …

← Previous Entries