2011 May | Excel Semi-Pro

May 2011

A Dynamic Dependent Drop Down List in Excel

May 25, 2011 Formulas

The other day I was reading a post over at the Contextures blog about Dynamic Dependent Excel Drop Downs and realized that using an Excel Table would provide an alternative method that is both simple and flexible. Tables are available in Excel versions 2007, 2010, and 2011. In this post I’ll create a Table to […]

Get the full story …

Pivot Tables in Google Docs

May 19, 2011 Product Review

Mark my words, “This is the beginning of the end for Excel.” To be sure this is a long way off and I probably won’t see this in my lifetime, but make no mistake Pivot Tables in Google Docs spreadsheets marks the eventual decline of Microsoft Excel. Of course, part of me will refute this […]

Get the full story …

Where is the Insert Tab in Excel 2011?

May 17, 2011 Features

Switching to the Mac platform finds you with certain disappointments challenges. One of these is finding no Insert Tab on the Excel 2011 Ribbon. Windows versions of Excel (2007 and 2010) both have the Insert Tab on the Ribbon. So when you start using the new Mac version of Excel 2011, you can quickly become […]

Get the full story …

Worksheet Tab Protection Icon in Excel 2011

May 11, 2011 Features

There are times when you see something new and immediately know what it means. That’s what happened to me when I opened a file from a colleague and realized the padlock icon on the worksheet tab meant that the worksheet was protected. I was right. Since I had opened this file in Excel 2011 (Mac) […]

Get the full story …

Ribbon Home Tab Comparison – Excel 2010 Windows and 2011 Mac

May 5, 2011 Features

I’ll review each hard-to-find item on the Ribbon’s Home Tab in Excel 2010 (Windows) and let you know where they are located in Excel 2011 (Mac). I’ve even got some nifty pictures to speed along that understanding. Note: The Ribbons in Excel 2010 and 2007 (Windows) are interchangeable, but I’ll only refer to 2010 below. […]

Get the full story …

Select One Column of Data with VBA

May 4, 2011 Advanced

Let’s assume you aren’t using an Excel Table, List Object, or List for your data table and you want to select the data in only one column, which means the Header row is excluded. This can be simple if there’s data in every row of the column, but what if that’s not the case? And […]

Get the full story …

Create a List in Excel 2008

May 3, 2011 Features

I was surprised to find a List Wizard in Excel 2008 (Mac) because Excel 2007 (Windows) has Tables, and had already been out for nearly a year when Excel 2008 was released. Here I’ll walk you through the process of setting up a List in Excel 2008 but won’t go into every detail because, as […]

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