Data Tables – part 1
|

Data Tables – part 1

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…

Goal Seek
|

Goal Seek

“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…

Excel Principles

Excel Principles

In December, there were some conversations in LinkedIn about Excel and what best practices should be. That was the first time I learned about Excel Principles being promulgated by a British and Wales Accounting Group in Europe. I’m not sure the US has a similar set of principles other than maybe Sarbanes Oxley’s financial rules,…

Microsoft Ignite

Microsoft Ignite

[I thought my WordPress was working now because yesterday some plug-ins, WordPress and maybe theme was updated yesterday and when I went in to check, I saw I could get the block editor style when I went to start a new blog. Today, I’m back to having issues after updating the Kadence starter plug in….