December 3, 2021 - by Bill Jelen
Problem: I’ve seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.
Strategy: Yes, you can assign names to constants. To do so, you follow these steps:
Create Easier-to-Understand Formulas with Named Ranges »
December 1, 2021 - by Bill Jelen
How can I create easier-to-understand formulas?
Learn R1C1 Referencing to Understand Formula Copying »
November 30, 2021 - by Bill Jelen
All of a sudden, the column letters along the top of my spreadsheet have been replaced by numbers. None of the formulas I enter will work. What’s wrong?
Simplify the Entry of Dollar Signs in Formulas »
November 29, 2021 - by Bill Jelen
It is a pain to type the dollar signs in complex formulas such as the formula in the previous topic. How can I make this job easier?
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 2019 Business Basics & Beyond
September 2019
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.
Excel Dynamic Arrays Straight to the Point 2nd Edition
January 2020
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.
MrExcel 2020 - Seeing Excel Clearly
January 2020
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.