by DerekHenry | Jan 15, 2025 | Efficiency, Excel Tips
Overview Most Excel users are quite familiar with PivotTables (if not, add that to your to-do list!). But have you ever needed to take a report where the data is already pivoted – spread horizontally across several columns – and stack it vertically...
by DerekHenry | Jan 8, 2025 | Efficiency, Excel Tips
Overview The SEQUENCE function is one of the newer dynamic array functions (DAFs) and it’s extremely versatile – whether by itself, when combined with other functions, and when built into custom functions via LAMBDA. It returns an array of sequential...
by DerekHenry | Dec 11, 2024 | Efficiency, Excel Tips
Overview Is there anything more annoying than opening up an Excel file and seeing a ton of ######## characters? Or cut-off text? Or text that takes up so much space you can’t see any other columns? Resizing Excel columns is a really common task – and there...
by DerekHenry | Dec 4, 2024 | Excel Tips
Overview If you’re looking for a great gift to give to that special someone for Christmas or another special occasion, we’ve got you covered! Check out the 20 items below. If nothing else, they’ll give you some ideas for your search! The 20 Gift...
by DerekHenry | Nov 20, 2024 | Efficiency, Excel Tips, XLEV8 Add-ins
Overview If you’ve worked with Excel long enough, chances are you’ve made some errors. Although it’s a fabulous application – many say the most important ever built – its power and wide array of features make it highly likely that...
by DerekHenry | Nov 13, 2024 | Efficiency, Excel Tips
Overview If you haven’t tried the LET function in your Excel formulas yet, you’re really missing out, especially if you work with a lot of formulas! LET is a unique function that lets you define reusable variables in your formulas. It’s a key...
Recent Comments