Contextures Blog - Excel tips and tutorials

Time 2020-07-17 18:03:42

Web Name: Contextures Blog - Excel tips and tutorials

WebSite: http://blog.contextures.com

ID:27375

Keywords:

Excel,Blog,Contextures,

Description:

Do you remember the number grids from your schools days, where you filled in the multiplication answers? What's 4 times 8? Or 9 times 7?  If you need a refresher, or you're helping someone learn them, I've got an Excel multiplication table practice workbook for you. Continue reading "Excel Multiplication Table Practice Workbook" There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product before. In version 4.08 you can create a form with either 2 or 4 search boxes. Previously, there were only 2. Continue reading "Excel Search Form Builder Update 2020-06" Since you love Excel, you probably already noticed that today (June 15, 2020), is Excel day 44000. You'll see that if you type today's date in a worksheet cell, and then change the number format to General, because Excel stores dates as numbers. Continue reading "Happy Excel Day 44000" The golf courses aren't too crowded here this summer, because of the social distancing rules. So, if you're trying to spread out the players at your course, use this Excel workbook for golf tee off times. Continue reading "Excel Workbook for Golf Tee Off Times" Do you spend lots of time in Excel tables, filtering the data, then clearing those filters later? If so, this free add-in from AlexJ will help you save time. The add-in will add filter commands at the top of right-click menus, where they're easy to use. Continue reading "Add Filter Commands at Top of Right-Click Menus" If you create Excel formulas that include table references, and then try to copy those formulas to adjacent columns, you might get incorrect results. See why that happens, and how to avoid those problems, when you copy Excel formulas with table references. Continue reading "How to Copy Excel Formulas with Table References" When you create a named table in Excel, you can colour the alternating rows with one of the built-in Table Styles. But how could you colour alternating groups of information, such as dates? This example shows show to create colour bands, based on dates, so it's easy to see where each day's data begins and ends. Continue reading "Colour Bands in Excel Table Based on Dates" Here's an Excel formula challenge for you, based on an email question that someone sent to me. They wanted help with an Excel formula to sum for odd and even weeks. See my solution, and let me know how you'd solve the problem. Continue reading "Excel Formula to Sum for Odd or Even Weeks" If we're sitting at home, with little to do but eat, watch TV and sleep, we might get a bit slow and bloated, which isn't a great feeling. Nobody wants slow, bloated Excel files either, so Charles Williams just released a new, improved version of his FastExcel tools, to help you fix them! Unfortunately, it only works on Excel files, not people. Continue reading "Fix Slow Excel Files with FastExcel Tools" There's an Excel weekly meal planner on my website, to help you organize your meals, and create a shopping list. Now that we're staying home for a while, with very little shopping, I updated the file, to include an inventory of the food we have on hand. Continue reading "Excel Weekly Meal Planner Update 20200402"

TAGS:Excel Blog Contextures 

<<< Thank you for your visit >>>

Easy to follow Microsoft Excel tips and tutorials, with videos, screen shots, samples files and written steps

Hot Websites