Home     Articles     Document Gallery     Services     About This Site     About Rafael

Tuesday, October 17, 2006

How Microsoft Excel 2007 Will Set You Free


 by Rafael Van Dyke
 

Well, not completely free; but when you see the new Microsoft Excel limits, it may as well be unlimited. Most of the limits mentioned in this blog never bothered me, because I never needed anymore than what Excel gave me; but there were a couple that always bothered me and that I'm looking forward to taking advantage of:

Number of conditional format conditions on a cell:
Old Limit: 3 conditions
New Limit: Limited by available memory

The total number of available rows in Excel:
Old Limit: 64k  (2^16)
New Limit: 1M  (2^20)

The number of levels of nesting that Excel allows in formulas:
Old Limit: 7
New Limit: 64

27 Limits That Microsoft Excel 2007 Scaled Up

Of course, at some point someone's gonna test even these limits with something; but in that case, they should be programming something. As far as all the sane people like me, these new limits are gonna be more than enough. Enjoy!



# Send mail to the author(s)   10/17/2006 5:24:46 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Microsoft Excel | Office 2007
Tuesday, October 03, 2006

Play Pacman in Microsoft Excel - Yes, PACMAN!


 by Rafael Van Dyke
 

OK, I can't decide whether this download demonstrates the great power of Microsoft Excel, or if this is the supreme example of someone with incredibly too much time on his hands. Either way, this is probably the coolest Microsoft Excel file ever! I mean, I was playing one of my childhood favorite arcade games, Pacman, but in Microsoft Excel. Did you hear what I said? Pacman, in Excel!

I always knew that you could do over a million things (so it seems) with Excel; but this accomplishment takes it up a notch for me. The credit belongs to Nobuya Chikada, known as the "Japanese Excel Crazy Guy", who basically wanted to see if it could be done. After two years, I guess he found out he could. Here's his reason for doing it:

I'm very happy if you feel Excel & VBA has an infinite possibility! For all I know, It must be meaningful that makes the program works on Excel!!

Excuse the broken English, but you know what he's trying to say. Seeing this Excel file will definitely open you eyes to how you can take advantage of Microsoft Office; because if he can recreate Pacman with Microsoft Excel, what could you do with it?

However, you will have to enable macros on this file for the game to work; you'll also notice the hour glass working harder than normal - which is due to the file refreshing the screen to make everything move. Other than that, here's to childhood memories! Nice work, Nobi!

Download Pacman for Excel



# Send mail to the author(s)   10/3/2006 7:41:14 AM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Free Excel Spreadsheets | Microsoft Excel

 




   Subscribe to Feed





Subscribe in NewsGator Online

Add to Google

Subscribe in Bloglines

Add BetterDocuments to Newsburst from CNET News.com


Powered by Text-Link-Ads

Automating a Microsoft Word Mail Merge in .NET 2.0
How Much Do You Really Know About Microsoft Word?
BetterDocuments.com gives Microsoft Office 2007 Two Thumbs Way Up!
A Microsoft Access Database Pop Quiz!
Giving Thanks to Martin Luther King, Jr.
Where in the world have I been?
How Microsoft Excel 2007 Will Set You Free
Play Pacman in Microsoft Excel - Yes, PACMAN!
You Should Learn How To Share ... Your Google Spreadsheets
The Key to Great PowerPoint Slides
Heading 1, Heading 2, Heading 3. What are they good for?
Info on Zero-day PowerPoint Trojan Virus
Helpful Shortcuts For Showing PowerPoint Presentations
Creating Gantt Charts in Excel (without Microsoft Project)
How to Create Wedding Monograms in Microsoft Powerpoint



 Sign In

Computers Blog Top Sites





Blog Directory & Search engine

feedNuts Feed Profile

Blog Flux Directory