Hackszine.com: Excel Archives

Archive: Excel

March 6, 2008

Microsoft Excel 3D engine

Peter Rakos wrote an article for Gamasutra today which demonstrates how to hack yourself a simple 3D engine by subverting an Excel worksheet. It's not going to win any FPS awards, but the fact that you can even get Excel to draw raw shapes blows my mind.

In his demo, the worksheet is used to calculate values for all the polygon vertices and a very small macro loop draws the resulting mesh to the screen.

After downloading the source XLS, run the demo by hitting alt-F8 (option-F8 in Mac Excel). You'll find the code under the "Tools->Macro->Macros" menu.

Microsoft Excel: Revolutionary 3D Game Engine - Link
Peter's Example 3D Excel files - Link

February 28, 2008

Excel Hacks: Display a "please wait" message

Excel Hacks, 2nd Edition Cover

Here's Hack #111, Display a "Please Wait" Message, from David and Raina Hawley's Excel Hacks, 2nd Edition. Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. Yet there are many ways to take advantage of Excel's sophisticated capabilities without spending hours on advanced study. In Excel Hacks, you'll learn how to:

Reduce workbook and worksheet frustration--manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
Analyze and manage data--extend and automate these features, moving beyond the limited tasks they were designed to perform.
Hack names--learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
Get the most out of PivotTables--avoid the problems that make them frustrating and learn how to extend them.
Create customized charts--tweak and combine Excel's built-in charting capabilities.
Hack formulas and functions--subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
Make the most of macros--including ways to manage them and use them to extend other features.
Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

Hack #111: Display a "Please Wait" Message - Link

Related:

Excel Hacks, 2nd Edition @ the Maker Store - Buy now
Excel Hacks, Second Edition--New from O'Reilly: Hook Up with Excel Expert Hackers - Press Release

February 27, 2008

Excel Hacks: Display negative time values

Excel Hacks, 2nd Edition Cover

Here's Hack #87, Display Negative Time Values, from David and Raina Hawley's Excel Hacks, 2nd Edition. Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. Yet there are many ways to take advantage of Excel's sophisticated capabilities without spending hours on advanced study. In Excel Hacks, you'll learn how to:

Reduce workbook and worksheet frustration--manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
Analyze and manage data--extend and automate these features, moving beyond the limited tasks they were designed to perform.
Hack names--learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
Get the most out of PivotTables--avoid the problems that make them frustrating and learn how to extend them.
Create customized charts--tweak and combine Excel's built-in charting capabilities.
Hack formulas and functions--subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
Make the most of macros--including ways to manage them and use them to extend other features.
Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

Hack #87: Display Negative Time Values - Link

Related:

Excel Hacks, 2nd Edition @ the Maker Store - Buy now
Excel Hacks, Second Edition--New from O'Reilly: Hook Up with Excel Expert Hackers - Press Release

February 26, 2008

Excel Hacks: Highlight alternating rows and columns

Here's Hack #21, Highlight Every Other Row or Column, from David and Raina Hawley's Excel Hacks, 2nd Edition. Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. Yet there are many ways to take advantage of Excel's sophisticated capabilities without spending hours on advanced study. In Excel Hacks, you'll learn how to:

Reduce workbook and worksheet frustration--manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
Analyze and manage data--extend and automate these features, moving beyond the limited tasks they were designed to perform.
Hack names--learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
Get the most out of PivotTables--avoid the problems that make them frustrating and learn how to extend them.
Create customized charts--tweak and combine Excel's built-in charting capabilities.
Hack formulas and functions--subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
Make the most of macros--including ways to manage them and use them to extend other features.
Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

Hack #21: Highlight Every Other Row or Column - Link

Related:

Excel Hacks, 2nd Edition @ the Maker Store - Buy now
Excel Hacks, Second Edition--New from O'Reilly: Hook Up with Excel Expert Hackers - Press Release

February 25, 2008

Excel Hacks: Reduce workbook bloat

Here's Hack #15, Reduce Workbook Bloat, from David and Raina Hawley's Excel Hacks, 2nd Edition. Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. Yet there are many ways to take advantage of Excel's sophisticated capabilities without spending hours on advanced study. In Excel Hacks, you'll learn how to:

Reduce workbook and worksheet frustration--manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
Analyze and manage data--extend and automate these features, moving beyond the limited tasks they were designed to perform.
Hack names--learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
Get the most out of PivotTables--avoid the problems that make them frustrating and learn how to extend them.
Create customized charts--tweak and combine Excel's built-in charting capabilities.
Hack formulas and functions--subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
Make the most of macros--including ways to manage them and use them to extend other features.
Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

Hack #15: Reduce Workbook Bloat - Link

Related:

Excel Hacks, 2nd Edition @ the Maker Store - Buy now
Excel Hacks, Second Edition--New from O'Reilly: Hook Up with Excel Expert Hackers - Press Release

July 31, 2007

Excel Hacks, Second Edition is out!

The second edition of Excel Hacks is out now, and it's our biggest hacks books yet, with over 130 hacks covering many versions of Excel: Excel 2004 for the Mac, as well as Excel XP, 2003, and 2007. David and Raina Hawley's new edition provides a resourceful, roll-up-your-sleeves guide that gives you nonobvious solutions to a whole pile of interesting Excel problems.

It's available now from bookstores, and you can also find it in the Make store.

Resources

O'Reilly FYI: Have fun with Excel - Link
Sample Chapter - Link

April 3, 2007

Games Developed in Excel

Mark Danburg-Wyld sent a link to a site devoted to games developed entirely in Excel.

Are you limited in what games your company's IT/IS department will leave installed on your work machine? Well, it seems very unlikely they will take Excel away from you. And Excel, among other things, is an interesting development platform for some fairly amusing programs.
So, enter Excel Games -- the site for games and play inside a program they'll never uninstall. Try them out, and you will find that the Excel version is often as good as any stand alone application!

There are really two hacks here: 1) The Excel/VB engine is completely subverted into a platform for game development and 2) since Excel is an essential business tool, identifying it as a game engine ensures that cubicle occupants everywhere can get their fix, despite the most heinous of firewall and software installation restrictions.

Excel Games - non-productive use of essential software! -Link

February 15, 2007

Use Microsoft Office Excel to read live RSS stock news feeds

Fpgvbn71Uney6E3B22.Medium
I didn't try this out yet (and it scares me a little, it's an EXE) but if you're looking to get live RSS feeds and stock quotes -in- Excel, here's an add-on (and how-to) to do just that...

You can easily get Excel to act as a live stock RSS news reader with a free add-on. What's cool about this, as opposed to using a regular news reader, is that you can have it update the news depending on the stock symbol you are interested in. Plus, you can also add live stock quotes as well.
And simply by pressing F9, your news will udpate to the latest news about your stocks!

instructables : Hacking Microsoft Office Excel to read live RSS stock news feeds - Link.

More:

Esquotes - Link.