3 Reasons It’s Important to Continuously Train Your Staff Microsoft programs such as Excel, Access, and Power Bi are powerful tools that can help your team get organized, save time, and achieve your aims and goals. However, despite being user-friendly and easy to understand, investing in continuously training your team on these programs [...]
VBA: Move executing line anywhere Summary Okay, so this may be a bit weird for a blog post, but my mind was blown when I saw this. An extremely nice gentleman by the name of Jordan Webb of EXOS showed me this. More proof that you can learn anything, anywhere, anytime, from anybody. Thank you [...]
Formula to check if table is filtered Maybe you'll never have the need for this, to use a formula to see if a range is filtered. Maybe you will. There are a few indicators we have already to tell if a range is filtered or not. We can look at the row headers [...]
Table Slicers in Microsoft Excel 2013 Slicers were introduced in Excel 2010 for PivotTables. What are slicers you ask? If you don't know, well, you're in for a treat. Here is some background information to bring you up to speed. Introducing Excel 2010 Slicers Use slicers to filter PivotTable data PivotTable Slicers by Jan Karel [...]
