MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Back into an Answer by Using Goal Seek

October 21, 2019 - by Bill Jelen

Back into an Answer by Using Goal Seek. Photo Credit: Jason Wong at

Do you remember from “Discover New Functions by Using fx?

If you are about the same age as me and spent your summers watching TV, you might remember a crazy game show called The Price Is Right. Long before Drew Carey, the venerable Bob Barker would give away prizes using a variety of games. One that I recall is the Hi Lo game. Bob would give you the car if you could state the price of the car. You would guess. Bob would shout “Higher” or “Lower.” I think you had 20 seconds to narrow your guesses to the exact price.

A lot of times, I feel like those summers watching Bob Barker trained me to find answers in Excel. Have you ever found yourself plugging in successively higher and lower values into an input cell, hoping to arrive at a certain answer?

continue reading »

More Reading

Excel Protect All Formula Cells. Photo Credit: Stéphan Valentin at

Excel 2019: Protect All Formula Cells »

October 17, 2019 - by Bill Jelen

It seems unusual, but all 16 billion cells on a worksheet start out with their Locked property set to True. You need to unlock all of the cells first.

Speed Up VLOOKUP. Photo Credit: Alex Eckermann at

Excel 2019: Speed Up VLOOKUP »

October 16, 2019 - by Bill Jelen

VLOOKUP is a relatively expensive function. When you are looking for an exact match, Excel has to look through the lookup table one row at a time.

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

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!

MrExcel LIVe

MrExcel LIVe »

A book for people who use Excel 40+ hours per week. Illustrated in full color.

Excel 2019 Business Basics & Beyond

Excel 2019 Business Basics & Beyond »

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.

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.

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

see more products »