Excel 2010 | Excel Semi-Pro

Excel 2010

Excel without a Mac

February 8, 2013 General Update

I sold my 15″ MacBook Pro yesterday and am waiting on a 21.5″ iMac to arrive in 2-3 weeks. So no more adventures with Excel 2011 for a bit. Time to dust off the Dell desktop and reacquaint myself with the “real” Excel. That of the Windows variety. I’m putting Excel 2003 in my rear […]

Get the full story …

A Dynamic Dependent Drop Down List with a Horizontal Table Reference

April 9, 2012 Formulas

I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the “table headers were actually rows and not columns?” Since I’ve already detailed how this is done in the article mentioned above, I’ll keep this short. The screen shot below is what I’ll be referencing. At the […]

Get the full story …

How to Update a List or Range without OFFSET

March 22, 2012 Formulas

I avoid the use of Volatile Functions, especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook. For very large workbooks with lots of data, it can be significant and irksome. Worksheet cells that use Data Validation for a drop-down list can simplify the […]

Get the full story …

Microsoft Excel 2010 on the iPad with the OnLive Desktop

February 29, 2012 Product Review

The gold standard for Microsoft Excel is the latest Windows version, Excel 2010, and the gold standard for tablets is the iPad. The OnLive Desktop App brings them together. If you love Microsoft Excel and have an iPad, then this app is for you. I could go on and on and on about what a […]

Get the full story …

Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]

February 28, 2012 Advanced

I recently began using the NETWORKDAYS function in Excel 2007, yet my file was going to be widely used by people with Excel 2003 (both are Windows versions). The NETWORKDAYS function is a standard function in Excel 2007, but with 2003 you have to install the Analysis ToolPak, otherwise you get an error. The only […]

Get the full story …

An Excel Crossroads – Mac and Windows

January 5, 2012 General Update

I bought a MacBook Pro and installed Windows 7 with Boot Camp Assistant so I could access the “normal” Excel. This was important to me at the time because I was doing Excel development work in versions 2003, 2007 and 2010 on a Windows PC. I love my MacBook Pro, which I consider my computer […]

Get the full story …

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 …

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. […]

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