peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Excel Calorie Counter

On Monday I described the horrible side effects of Christmas cookies, and posted an Excel Weight Loss Tracker workbook.

As Dick Kusleika pointed out in the comments, simply downloading the workbook doesn't have any effect on your weight. Apparently it takes a bit of effort, including dietary changes and maybe some <gasp> exercise. Can't Microsoft invent something to make weight loss easier? I don't even care if it has menus or a Ribbon!

The Calorie Counter Food Data

Bill Gates isn't answering my phone calls, so I created an Excel Calorie Counter that I can use in the meantime. As soon as Bill sends me something better, I'll let you know.

To start, I copied some food data from the Health Canada website. I created a list of foods in an Excel workbook, with categories, food items, measurements and calorie counts.

You can add items to the list, and sort

Continue reading Excel Calorie Counter

January 6th, 2010 | Category: Excel Data Validation, Excel Templates | 29 comments

Excel Weight Loss Tracker

Uh-oh! I finally remembered where all the Christmas cookies went, and maybe some of the chocolates. And it's not pretty. Apparently, when you sit at your keyboard for hours, with the occasional cookie break, it puts the "spread" in "spreadsheet."

Time to get things under control, and I'll use an Excel weight loss tracker. It can store weekly weight records, calculate the weight loss, and show the progress in a weight loss chart.

With some fancy programming, it could probably create some healthy menus, and zap me if I reach for a cookie, but I'll work on those features later.

There's a link at the end of this post, where you can download the Excel Weight Loss Tracker sample file. I'm not a trained medical professional, so use the Excel Weight Loss Tracker at your own risk, and for entertainment purposes only, etc.

[Update] The latest version of this workbook

Continue reading Excel Weight Loss Tracker

January 4th, 2010 | Category: Excel Formulas, Excel Templates | 44 comments

Happy New Year in Excel

Happy New Year! All the best in 2010, and I hope you're looking forward to the release of Office 2010.

I thought about creating some fireworks in Excel, then discovered that Andy Pope already made some, based on an xy scatter chart. Here's a screen shot that shows one of the bursts. And there's no noise, so if your head hurts a little today, the fireworks won't make it worse.

Andy also has a sample Excel workbook with scrolling text, so you can combine the workbooks to show Happy New Year, and a fireworks display.

_________________

Related Posts Plugin for WordPress, Blogger...
January 1st, 2010 | Category: Excel charts, Excel Formatting, Excel VBA | Leave a comment
« Newer Entries