Category Archives: General Update

Excel without a Mac

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 view mirror (finally) and will focus on Excel 2007 and 2010.

I would love to get Excel 2013 and test it out, but the Dell will need to be replaced this year so I’ll wait until I have a new … Read the rest

Brain

Blog Comments and Inspiration

I’d like to thank everyone who has left a comment on this blog within the past year. It’s been a privilege to interact with some of you.

When I started this blog a couple of years ago, I was partially employed. Consequently I had lots of time to spend learning how to write blog posts about a topic that I am relatively good at, and a desire to share my knowledge.

Brain

My big problem is that I am a perfectionist. I want to express myself clearly, about topics that can be quite complicated.

About a … Read the rest

Excel 2010 icon

An Excel Crossroads – Mac and Windows

Excel 2010 iconI 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.

MacBook ProI love my MacBook Pro, which I consider my computer of the future. It’s great for dealing with Photos, Movies, Music, and all of my iOS devices.

I purchased the Mac versions of Excel (2008 and 2011) but they seem like a mixture of the three Excel versions mentioned … Read the rest

Microsoft Office on the iPad

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 with Excel and then tried Numbers. Well, it’s unique. And not Excel.

DocsToGo Premium Spreadsheet on iPadI have the Documents To Go Premium – Office Suite universal app for the iPad and iPhone that works with Excel files, but this Premium version is required … Read the rest

My Short Hiatus

I broke with my usual posting frequency this week because I’ve been dealing with some plagiarism on my other website. I found out there’s such a thing as content scraping, which of course can be defeated. However, all of that took time and energy away from this blog, which was regrettable.

Plagiarism Today Tagline

Every Excel blog I’ve visited or subscribe to has always given other Excel blogs proper attribution for content. That’s how it’s supposed to work. There’s enough Excel traffic on the web for everyone. It’s not a zero-sum game.

If you subscribe by RSS … Read the rest

Putting Windows 7 on a Mac to Run Excel for Windows

I bought my first Mac almost 11 months ago and now comes the moment of truth. I need to go on the road and take my MacBook Pro with me, but also need to take several versions of Excel for Windows (2010, 2007, 2003) to validate and tweak an Excel reporting package.

Note: Cross posted at vLatte Tech Life

The Boot Camp Assistant allows me to partition hard drive space on my MacBook Pro and install Windows. So when I got the following message to create a partition for Windows on my Mac it just … Read the rest

The Rest of the Booty

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.

Books from Spreadsheet Challenge

Everyone please have a safe and Happy New Year!

Read the rest

Top 10 Articles for 2010

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.

  1. Become the OFFSET Function and Tell a Short Story
  2. Excel 2011 for Mac – Installation, Preferences, and VBA
  3. Excel Files on the iPad or iPhone
  4. Start a New Line Inside a Spreadsheet Cell in Excel
  5. Convert Seconds to a Time Format in Excel
  6. Stock Price Formula in a Spreadsheet
  7. Microsoft Excel Date Systems for
Read the rest

Excel Semi-Pro Microblog Started

I’ve started Excel Semi-Pro Microblog on Tumblr to share Excel related stuff in a slightly different format. Each post is broadcast on my Twitter account @ExcelSemiPro so you can pick up the link there, or if your have a Tumblr account you can subscribe, and then there’s always the ever popular RSS feed, or an email subscription.

Anyway, below is what Feedburner calls a Buzz Boost, which is to say the three most current articles from Excel Semi-Pro Microblog are shown below. Click on a link to check it out. I just purchase … Read the rest

My Spreadsheet Challenge Picture

Here’s the picture I entered for the Spreadsheet Challenge.

ESP Spreadsheet Challenge Picture

I’ll point out the obvious and not so obvious stuff in this picture.

  • Me
  • Two monitors showing Excel 2007, Excel 2003, and Excel 2010 spreadsheets, and
  • PDF versions of Excel 2007 Formulas, Excel 2003 Power Programming with VBA, and Excel 2010 Bible
  • A MacBook Pro showing Excel 2011 and Excel 2008 spreadsheets
  • An iPad showing the Documents To Go® Premium App with a spreadsheet open

And hopefully that’s going to get me a prize. 🙂 o_O

Read the rest

Feed Problems

Tech ManI normally like to have the entire post show up in the Feed or email you get, but here recently they’ve been truncated and I’m not sure why. This, of course, requires you to click through to my site to read the rest of the article.

I subscribe to many, many feeds and abhor having to click through to read the entire article (see LifeHacker) so this is not my intention. Bear with me while I try and figure this out.

Feedburner or Plugins? That’s the Question

I’ve checked all my Feedburner settings like five … Read the rest

Excel for Mac 2011 Available for Pre-Order

Excel for Mac 2011 will be released October 26th and is available for pre-order on Amazon now. I’m excited about the return of VBA.

Pre-order your copy of Excel for Mac 2011 now. (affiliate link)

In the video below they discuss Office for Mac 2011, but at one point they mention a beta tester generating a chart in Excel 2008 that took 28-29 seconds, yet in Excel 2011 took less than one second.

Read the rest

Save Time Entering Decimal Points in Excel

When your stuck entering a lot decimal places, have Excel make your life a little easier by entering them for you automatically.

To set a fixed number of decimal places, go to Excel Options, Advanced tab, check Automatically Insert a Decimal Point, and set the Places box to the proper number of decimal places, then click OK. (In Excel 2003 and in Excel 2008 for Mac go to the Edit tab to find this option)

The current data in the worksheet will not be affected.

Advanced Options Decimal Points

Once this option is turned on entering 4836 becomes 0.4836 … Read the rest

Number Format Shortcut in Excel

I must be dense. All these years I’ve had one main gripe about Excel and that’s always having to format numbers with a thousands separator and two decimal places, and no easy way to do it.

Numbers-Raw

Now I find out there’s been a shortcut for it all along.

Ctrl+Shift+!

Numbers-Formatted

I found the shortcut in Excel 2010 Bible, but it’s even in Excel 2003 books.

What a moron I’ve been!

Read the rest

Excel Files on the iPad or iPhone

Documents To Go® Premium lets me open and modify Excel files from my Dropbox folder right on my iPad or iPhone. I can also access and modify spreadsheets from my Google Docs account.

DocsToGo Premium Spreadsheet on iPad

Excel email attachments can be downloaded, viewed and edited. This is a big plus when traveling with the iPad, or iPhone for that matter.

I have an Excel file in Dropbox that serves as a reference and is password protected. Docs To Go® Premium opens this file and is the reason I purchased it.

The app has 111 functions and while this … Read the rest