Excel Shortcuts: Build A Quick Weekday Date List in Excel
Now that the holiday season is over (almost 2 weeks ago now) I've finally got myself back into a routine and I wanted to start off the year with a quick tip for those of you looking on how to build a list of weekday dates for your planning purposes and to get the...
Excel Tables: Using Excel Tables to Summarize, Filter and Autofill formulas Like a Boss
This is a guest post by CPA David Ringstrom from Accounting Advisors, Inc. David covers some functionality from Excel tables in 60 seconds. His video shows you how to expand tables, add total rows, autofill data and shows us how the filter option becomes immediately...
Excel Tables: How to Create Built in Summary Formulas
A How To Video Tutorial For Using Formulas in Excel Tables The idea to provide a quick tutorial on how to use summary formulas within Excel Tables came from Joe Stephens. Joe commented the other day on my blog mentioning that you could use the built in header...
Excel Shortcut: Create Quick Name Ranges From Large Tables of Data Using Ctrl+Shift+F3
Build a Quick Set of Name Ranges for your Fields Using This Excel Shortcut Let's keep this short and sweet and under 60 seconds. Type Ctrl+A to highlight your range of cells/table. Once all cells including the column headers are...