Dolity Flysky FS-NV14 14CH 2.4G AFHDS 2A RC Transmitter Controller w iA8x Receiver
Dry Erase Dungeon Tiles, Set of Nine 10 interlocking squares for role-playing and miniature tabletop games
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"
Draculaura is turning 1600 and is throwing the party of the millennium
All the ghoul kids will be there in their most fabulous party fashions
Includes exclusive skeleton key invite, scary cool outfit, and a birthday present
Fans of Monster High won't wait to get their claws on these dolls
Collect all your favorite Monster High Sweet 1600 dolls
Diamond 6-Gallon Ball Bucket with 30 Sports White Plastic Baseballs Hollow Balls for Wiffle Practice
It's been a long time since the last Excel roundup, so here's a new one! Check out these Excel links and articles, and I'm sure you'll find a few interesting things to read.
Continue reading "Excel Roundup 20190711"
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"
Anchor Hocking Pint Mixing Glass - Rim Tempered - 16 Oz (4)
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.
YD Pet Travel Carrier Pet Stroller 3-wheel Pet Trolley Multifunctional Folding Large Dog Pet Cart Scooter Outdoor Travel Pet Supplies & (color RED)
How can you get the last number in an Excel column? I needed to do that in one of my sample files, so here's the formula that I used. Then, someone asked me how to get the last item (text or number) from a column, so there's a formula for that too.
Continue reading "Excel Lookup Formula for Last Item in Column"
Set up a Master sheet in your workbook, and add month sheets automatically, based on that Master sheet. The new sheets will be named for the month and year, in yyyy_mm format.
Continue reading "Add Month Sheets Automatically in Excel"
Pivot tables are a quick and easy way to summarize a table full of data, without fancy formulas. Occasionally though, things can go wrong. Today we'll figure out why you might see errors in pivot table totals or subtotals, when all the item amounts look fine. Continue reading "Errors in Pivot Table Totals"
TongT16 No Pedal Two-wheeled Training Bicycle Kids Bullet Balance Bikes Adjustable Height 12 Inch Aluminum Alloy Lightweight Body Design Girls Boys Aged 1-5 Years Birthday Present W-16
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"
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.
gold Legacy New Year's Eve Party Assortment for 10