Subscribe to MrExcel Videos on YouTube

Featured Product

The Absolute Guide to Dashboarding & Reporting with Power BI

Power Excel Newsletter

Subscribe for new Excel Tips »
1 - 2 times per month

Featured Product

Excel Function Wall Clock

Excel Daily News

with Bill Jelen

Products

About These Products

The books, CDs and DVDs here are published by QUE or Holy Macro! Books. Written by Bill MrExcel Jelen and other Microsoft MVPs, they cover every aspect of Excel, including Power Query, Power Pivot, and Excel. If you use Excel 40 hours per week, you will find these titles concise and useful.

The Absolute Guide to Dashboarding & Reporting with Power BI

Cleaning Excel Data With Power Query Straight To The Point

MrExcel LX – The Holy Grail of Excel Tips

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 VBA and Macros

Excel Dynamic Arrays Straight to the Point

Excel JavaScript UDFs Straight to the Point

Supercharge Excel When You Learn to Write DAX For Power Pivot

Upcoming Event

Half Day Power Excel Seminar
JACKSONVILLE, FL - 05/24/2019

More Events »

Hot Topics

Efficient ways to copy row based on condition

10/02/2018

(13 responses) I have data stored on main sheet [Sheet1]. There are 4 other sheets on the spreadsheet. [Sheet 2] [Sheet 3] [Sheet 4] [Sheet 5] I would lik

Excrutiatingly slow insert/delete times using table and defined names

10/03/2018

(11 responses) I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I h

VBA for checking to see if fields in a form are not empty when 'close form' button is executed

10/02/2018

(10 responses) my form has 2 command buttons at the bottom. One is named cmdAdd for adding the data to the worksheet, and the other is named cmdClose for u

Can the default Cursor in 2016 be change back to an Arrow?

10/04/2018

(9 responses) I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow. Does anyone here know if

Sort by value then delete rows underneath

10/03/2018

(8 responses) I have a column with either a value of 1 or blank. The sheet has a header. Is there code that can sort by value in column "Z", find the last

Your One Stop for Excel Tips & Solutions

Products

About These Products

Let's Connect