January 28, 2022 - by Bill Jelen
In the previous article, Why use the intersection operator, notice that the formulas in the last two figures were outside of the range B:I. Before Dynamic Arrays are introduced to Office 365, those formulas would not work in that area due to a feature called “Implicit Intersection”. Here is how it works.
Why Use the Intersection Operator? »
January 27, 2022 - by Bill Jelen
What is the purpose of the intersection operator?
January 26, 2022 - by Bill Jelen
I have a workbook that takes 3 minutes to calculate. I changed to manual calculation mode so I can enter data without waiting for a recalculation after each data entry. I just changed 10 cells and I only want to recalculate the 10 rows that rely on those cells. I don’t want to wait 3 minutes when there are only 10 cells that need recalculated.
You Change a Cell in Excel but the Formulas Do Not Calculate »
January 25, 2022 - by Bill Jelen
Sometimes when I change a cell in Excel, the formulas do not calculate. Below, cell C2 indicates that two plus two is not four.
Analyzing Data With Pivot Tables in Excel - Online Course
January 2022
Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.
Your Excel Survival Kit - Second Edition
March 2021
This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.
Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel
January 2020
There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.
Saving Time with Excel - Online Course
January 2022
Be more efficient in Excel with these time-saving techniques in Excel.