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
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.
My big problem is that I am a perfectionist. I want to express myself clearly, about topics that can be quite complicated.
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 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
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.
I 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
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.
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.
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.
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
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.
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
I 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.
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.
Once this option is turned on entering 4836 becomes 0.4836 … Read the rest