Even a normal day of working with Excel can be lots of fun (or not!), but today we’ll see a couple of different ways to enjoy fun and games with Excel. Or, at least, fun that mentions Excel!
Excel Filter for Date Range 2 Ways
In Excel, you can use the drop down arrows in the table headings, to sort or filter the data. In this example, we’ll filter for dates that fall within a specific date range. The video shows two ways to accomplish that task.
Printable Excel Weekly Planner
Even if you love Excel, there might be times when you want to work on paper, instead of on the screen. I’ve made a printable Excel weekly planner, and you can customize the sections, and then print it out.
Excel Chart with Dynamic Date Range
Someone asked me how to create a chart where there could select a date range, and the chart would update automatically, to show results for those dates. Here’s a quick look at the chart with dynamic date range setup, and there’s a download link at the end.
Learn Something New Beyond Excel
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?
Excel Roundup 20190711
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.
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?
List All Excel Files with Dates
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.
Show Excel UserForm Automatically When Workbook Opens
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.
Continue reading “Show Excel UserForm Automatically When Workbook Opens”
Excel Lookup Formula for Last Item in Column
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”