This site under reconstruction.
A couple of posts ago I wrote about helping someone learn how to do VLOOKUPS and during that training, I learned how her peers at work were using Excel. Now, I do not know how many people in relative terms do not know how to use Excel: a lot of people or very few people…
So, I’ve been puzzling over this for a while. Sometimes you go to zoom meetings where people are asked to sign into the chat with some information about themselves and add in the LinkedIn URL and/or email address. This is kind of a networking thing. I had created an Excel file that is clunky. The…
“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…
You must be logged in to post a comment.