Microsoft Office on the iPad

November 30, 2011 General Update

Over the past two days there has been talk of Microsoft coming out with a version of Office for the iPad in 2012. I for one would happily purchase the Excel part of this package, assuming the price point is similar to that of Apple’s Numbers app at $9.99 USD. If, like me, you started […]

Get the full story …

Pay Periods and Funky PivotTable Controls

October 31, 2011 Intermediate

I like to use a PivotTable to figure out simple problems in Excel. So for this post I’m going to use Excel 2011 (Mac), where PivotTable controls look funky when compared to their Windows counterpart. Since I get paid every two weeks, certain months in a year will contain three pay periods. Planning future vacations […]

Get the full story …

Fill Down a Formula with VBA

September 6, 2011 Formulas

I commented on a post that brought to light, the fact that, using the cell fill-handle to “shoot” a formula down a column doesn’t always work when the adjacent column(s) have blank cells. So I decided to share some Excel VBA code that’s used to copy a formula down to the bottom of a column […]

Get the full story …

Zoom to 125 Percent – Excel 2011 Default Workbook

August 29, 2011 Features

I want to have Excel 2011 (for Mac) open to a blank worksheet that is zoomed to 125% and it has taken a very long time to figure this out. It involves saving a template to a buried location, then manipulating the file in Finder to remove the extension. Simple, once you know the trick. […]

Get the full story …

Settings and Shortcuts for Excel 2003

August 23, 2011 Beginner

I recently found myself with a new, loaner laptop and a brand new copy of Excel 2003 as my default spreadsheet program. This was fine until I realized there were a number of things “missing.” Like shortcuts and settings that I’ve changed over the years to make Excel serve me, instead of the other way […]

Get the full story …

Microsoft Query Incompatible with Mac OS X Lion [Updated]

July 12, 2011 Advanced

The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post. So I followed the instructions to […]

Get the full story …

International Short Date Formatting for the TEXT Function

July 7, 2011 Advanced

I have an Excel workbook that is used in two different regions where the date format is entirely different, the US and the UK. At the top of a report worksheet I use a TEXT function to inform the user of the date range. Here’s what a US user sees: From: 6/6/2011 to 6/10/2011 Here […]

Get the full story …

That Damn Delete Key in Excel for Mac

June 27, 2011 Beginner

I have no earthy idea why it took me so long to figure out how to delete the contents of a cell or range in Excel for Mac. Ever since I bought my MacBook Pro I’ve known the Delete key on a Mac isn’t really a Delete key. I mean, since my background is with […]

Get the full story …

Regional Date Formats in Excel

June 21, 2011 Beginner

I recently returned from two weeks in Ireland where I installed a couple of Excel reporting systems and came across the dreaded regional date settings. My computer is set for the US region, whereas the client’s computers were set for the UK region. When I mention regional settings on my computer, I’m talking about Windows […]

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

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