This site under reconstruction.
“They do VLOOKUPs all day long. That’s all they do on Excel.” I was helping a friend learn how to use Excel functions, one of which was the VLOOKUP. I was trying to get a sense of how her boss and colleagues approached using Excel so I could train her in the way they did…
Can you use ChatGPT to do your Excel work? Well, ChatGPT can’t actually go out and open up Excel itself and build whatever spreadsheet you want it to build. You still have to do the work. BUT, it can show you how to set up formulas, especially for simple situations. The problem is most of…
More and more, people are coming to me for help with Excel or related digital tools, even those who never had to use those digital tools. About a decade ago, I read articles saying that employees in all kinds of jobs will need to be able to do data analysis, not just the data scientists….
I did another post on LinkedIn on data tables but this time with two variables. I started out showing Goal Seek to show how to reverse engineer into the numerical results you want. Then I did a post on data tables with one variable and now this post will be with two variables. This post…
Here’s a really useful tool for generating various results based upon multiple inputs. It’s a quick way of seeing what happens to results when you vary the input. I usually try each input manually, but I really should set up these data tables to see the results. I’m attaching a PowerPoint that shows in a…
“I wish you could reverse engineer the answer.” When we do the forecasting, pricing or some kind of modeling, we move forward in spreadsheets by inputting the values for the variables and letting the formulas calculate the end results such as net income or gross margin. However, sometimes, we know what kind of end results…
You must be logged in to post a comment.