Excel Auto Fill and Flash Fill

Why to Use Auto Fill and Flash Fill in Excel Auto fill is an awesome feature that helps you quickly fill data in Excel.  You can fill single values or formulas (basically copying and pasting), or fill a series of common list values, such as numbers, dates, days of the...

My Top 10 Favorite XLEV8 Macros

People often ask me which macros in the XLEV8 Excel add-in are my favorites.  As you can imagine, I use a lot of them, but the ones below stand out, and below I explain why.  It helped to run the Macro Usage report to show which ones I use the most frequently and...

XLEV8 Custom Macro Files

Why to Use XLEV8 Custom Macro Files You may have some personal macros that you want to be able to run from the ribbon, keyboard shortcuts, or the search macros box, just like the XLEV8 add-in macros.  You may also want to be able to easily share these macros with your...

XLEV8 Excel Add-in Popular Macros

XLEV8 Excel Add-in Popular Macros With 250+ macros and growing, we could spend all day demonstrating the features included in the XLEV8 Excel add-in.  But to give you a sense of what some of them can do, we’ve created the video below that demonstrates some of...

Recording and Editing Excel Macros

Why to Use Macros There are several reasons to use macros but the obvious answer is that they can save you a tremendous amount of time.  From creating shortcuts for common tasks to automating large, complex, or repetitive processes, macros are probably the most...

Excel PivotTables and PivotCharts

Why to Use PivotTables and PivotCharts in Excel PivotTables and PivotCharts are powerful tools that let you quickly summarize and analyze your structured data.  They are so powerful and full of features that there are full-day courses dedicated to them!  We’ll...

Excel Conditional Formatting

Why to Use Conditional Formatting in Excel Conditional formatting is a powerful feature that gives your reports a very polished look, and can also help identify exceptions in your data, such as blanks, differences, or variances outside tolerable thresholds. ...

Excel Data Validation

Why Use Data Validation in Excel Data validation is a great way to ensure your data is entered accurately and consistently by adding a validation check – by restricting the type and/or content of data that can be entered – as well as an optional input...

Excel INDIRECT Formula

Why to Use The INDIRECT formula is a powerful formula that lets you build dynamic references.  Any part of the range address – the file path, file name, sheet name, column letter, or row number – can be in a cell that is referenced within the INDIRECT...

Excel Absolute and Relative References

Excel Reference Types There are four types of references in Excel – relative, absolute, row-absolute, and column absolute.  This is all about how the formula references move when you copy and paste. The reference types are indicated by $ symbols before the...

Don't miss great tips, tricks, news, and events!

  • Get our 105 Excel Tips e-book free!
  • Get monthly insights and news
  • Valuable time-saving best practices
  • Unlock exclusive resources

Almost there! We just need to confirm the email address is yours. Please check your email for a confirmation message.