On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. Today we learn about bacon.
Today, I want to turn your attention to an amazing looking Apple and Bacon fritter recipe.
I want to jam six of these into my fat mouth.
» Read more: Apple Bacon Fritters with Maple Bourbon Glaze
On his blog, John Walkenbach announces that he hates cupcakes. He says:
"Cupcakes are a waste of effort, and a waste of paper. If I want to eat cake, I'll cut a man-sized piece from a real cake."
I couldn't agree more. I only eat the top part and throw the rest away.
I'll take John's lead and announce that I hate oranges.
» Read more: I Hate Oranges
A week ago, Dick Kusleika posted an excellent article outlining some Formula Tips. I've already made plans to steal and use his ideas in my training. But my plagiaristic habits are not the reason for this post.
?
.
» Read more: Excel Defunct Defaults
One of the hardest things to manage in Excel solutions is version control. You know, that embarrassing knowledge that there are orphaned versions of your application floating through your company. And that horrifying sense that these useless versions are actually being used. There is nothing more embarrassing than asking one of your users to try and catch the splash screen to read off the version number. That's just sad dude…sad.
In this post, I'll show you a couple of techniques that will help you hack your own version control for your Excel solutions (BTW: This works for Access too).
Over the last couple of days, the Dallas area has experienced a record-breaking snowfall. 12.5 inches at the DFW airport!
Needless to say, everyone here is in complete snow panic mode.
» Read more: Snow Panic in Texas
Being the complete nerd that I am, I work with lots of different technologies. But in the end, I always strive to make those technologies work with Excel. One of those is Xcelsius. Xcelsius is a dashboarding application that takes data and spices it up into slick looking flash presentations.
Those of you who have already been asked to create reporting in Xcelsius may have found it a bit difficult to use. No VBA, no easy way to get connections and no pivot tables.
Well for the upcoming Xcelsius Developer's Workshop, I've come up with a technique where you can embed Xcelsius dashboards into Excel and Access applications.
This allows you to get all the flashy benefits of Xcelsius, but still give users a familiar environment where they can use PivotTables, VBA, MSQuery, etc.
It's too complicated to show with pictures, so I cooked up this video. Enjoy!
» Read more: Integrating Xcelsius with Excel and Access
I was fiddling around with Custom Lists the other day, when I noticed that Microsoft prevents me from deleting any of their built-in Custom Lists.
Don't believe me? Just pull up the Custom Lists dialog box and try to delete that lame Sun – Sat list. You can't do it. The Delete button is disabled like this:
» Read more: Fun with Custom Lists
On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. Today we learn about bacon.
Take a look at this shiny recipe for Bacon-wrapped Grilled Kielbasa. I like to sneak these into the movies, and pull them out when the lights go dim. I sit back and watch everyone wonder from where that lovely smell is emanating.
Cut the kielbasa into one-to-two-inch chunks.
Simmer in some water for a few minutes.
Remove from the water and wrap each one with half a slice of bacon.
Impale with moistened bamboo skewers and commence grilling.
Combine maple syrup, mustard, and chili powder in a bowl.
Once the bacon is crisp, brush the meat on all sides with the glaze and grill for a few additional minutes.
I recently posted about creating a Zoom Box in Excel . Alan writes in the comments:
"One of the features in Access that I really like is the ability to set a font size. Older people are sometime vision impaired, but you will learn about that in time. Is it possible to increase the font in the zoom box or set a font option?"
Anything for one of my 12 fans Alan. The steps are outlined below.
It's been a busy week and I've been working hard. I think I'll reward myself by writing a blog post for people I've never met. Here we go.
Let's talk about getting Access Memo Fields into Excel.
