MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pandemic Relief Excel Course Features 26 Instructors


May 13, 2020 - by Bill Jelen

Many of us are stuck at home during the CoVid-19 quarantine. For a very limited time, you can enroll in a unique online Excel course called “Excel Tips by the Experts”. Twenty-six Excel experts from around the world each contributed a 10-to-15 minute lesson to the course.

This is a great chance to brush up on your Excel skills. By watching a few lessons, you can learn some new Excel skills. You will also have a chance to see the teaching style of some Excel experts who are new to you, and you might subscribe to their blog or YouTube channel.

The course enrollment is only open through May 19, 2020. Once you enroll, you have access to the videos for six months. The 25 lessons include over five hours of instruction. The enrollment fee is either $10 or $20. The course is the same whether you pay $10 or $20. You choose what you can pay.

“This is a once in a lifetime global pandemic and a once in a lifetime Excel course. Your enrollment fee will be used in the fight against CoVid-19 in the places that it is needed most,” according to Paula Guilfoyle, an instructor at The Excel Club who organized the course.

All of the money raised through the course is going to given to GOAL. What is GOAL? Founded in 1977, GOAL has responded to almost all of the world’s major humanitarian crises since, working with vulnerable communities in more than 60 countries.

continue reading »

More Reading


Free Excel Tickmarks Add-in »

April 1, 2020 - by Bill Jelen


A seminar student of mine recently wrote: “Given our team’s migration to working from home and trying to maintain our effectiveness working remotely, we’ve been researching ways to drive consistent audit / review documentation through use of standard electronic audit tickmarks. Do you have any way that we can add tickmark icons to a cell through the Ribbon?”

LET: Storing Variables Inside Your Excel Formulas »

March 31, 2020 - by Bill Jelen


Formulas in Excel are already a programming language. When you build a model in Excel, you are essentially writing a program to calculate a set of outputs from a set of inputs. The Calc team Redmond have been working on a couple of enhancements to the Excel formula language to make Excel a bit more like a programming language.

read more articles »


Supercharge your career with training from MrExcel

Featured Products


Microsoft Excel 2019 VBA and Macros

Microsoft Excel 2019 VBA and Macros »


Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

MrExcel 2020 - Seeing Excel Clearly

MrExcel 2020 - Seeing Excel Clearly »


This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.

Excel Dynamic Arrays Straight to the Point 2nd Edition

Excel Dynamic Arrays Straight to the Point 2nd Edition »


Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »


This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »


Learn Power BI Dashboarding Techniques by Watching A Pro!

Power Excel With MrExcel - 2019 Edition

Power Excel With MrExcel - 2019 Edition »


This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

see more products »