Learn Something New Beyond Excel

Hoffmaster 119999 CaterWrap Cater-to-Go Singles Individually-Wrapped Dinner Napkin and Heavyweight Cutlery, White (Case of 100)
Caddx.us Turbo Micro S1 PAL NTSC 2.1 2.3mm UAV Aerial Photography Racing FPV Camera PCB Predect 1 3 CCD Sensor Cam for RC Hobby NTSC 2.3mm YEL

If you love Excel, and want to expand your horizons a bit, there are a couple of great opportunities for you to learn something new, beyond Excel features and formulas. Are you ready for an adventure?

Continue reading "Learn Something New Beyond Excel"

Your Top Excel Tips For Beginners

On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the content ready, but wanted ideas from other people who have taught similar courses. What are your top Excel tips for beginners?

Disney Yoda Plush - Star Wars - Small - 12''

List All Excel Files with Dates

Generic 50pcs Starwars Super Heroes Marvel Comics Thor Ragnarok Series Models Building Blocks Bricks Friends Model Hobby Toys for boy 658

Last week, someone asked if I could stop zipping the sample Excel files that you can download from my website. Well, I thought about it carefully, and decided to leave things as they are. Excel helped me decide, and you can get the macro that I used, to list all Excel files with dates and sizes.

Continue reading "List All Excel Files with Dates"

Show Excel UserForm Automatically When Workbook Opens

Apollo Inc. 1053 Piece Jigsaw Puzzle Super Utter Ex Amalfi Coast Iv [] Super Small Piece (26 X 38 Cm) (japan import)

You can add a UserForm to your Excel file, so it's easy for people to enter data, without going to the table where the historical data is stored. Usually, I add a worksheet button that opens the form. But, with a simple macro, you can show Excel UserForm automatically, when workbook opens.

Disney Easter Bunny Rabbit in Egg Minnie Mouse NEW by Disney

Mitsubishi Lancer Evo X Rally Edition (2009) Diecast Model Car

In the good old days of Excel, you could change a workbook setting, and see a preview picture of the file contents, before you opened it. That feature was available in Excel's Open window, but has disappeared in newer versions of Excel. Here's how to see Preview Pictures, and a warning about using them.

Continue reading "Preview Picture Problems in Excel"

Excel UserForm Builder Add-in

If you've purchased a copy of my UserForms for Data Entry kit, there's a new bonus for you -- the UserForm Builder (UFB)  add-in. Watch the video below, to see how it works, and download the latest version of the kit, to try it out.

GSDZN - Sport Balance Bike Pneumatic Wheel EVA Wheel With Predective Gear 110 Lbs Capacity Ages 2 To 6 Years