LeaseCrunch hosted a webinar on the topic of GASB 87 to address the various nuances to consider for clients adopting the new lease standards.

If you were unable to attend, HERE is a recording of the webinar which you can access at your convenience and also share with any colleagues that deal in GASB accounting.

What Does GASB 87 Do? Everything You Need to Know

As the apparent need for new accounting guidelines arise, accounting organizations work around the clock to craft rules that address the grumbles of the people; the gaps in the current standing principles that need to be addressed. One of these organizations is GASB, or the Governmental Accounting Standards Board. They work to develop standards in financial accounting and reporting that foster visibility and clarity.

This is the first post in a series where we’ll be exploring various add-ins that enhance and extend the capabilities of Excel. There are different types of add-ins and in this series, we’ll focus on those available in the Excel app store. Excel app store? Yep! Well, it isn’t technically an Excel app store … it provides Office Add-ins. But, since I’m an Excel geek I like to think about it as an Excel app store.



The first add-in we’ll examine is People Graph. 

In addition to the standard Copy and Paste commands, Excel offers a variety of options for pasting values and formulas. In this post, I’ll chat about one of those options … Paste Special Add. It works with values AND formulas. Let’s dig in.

https://www.excel-university.com/paste-special-add/

In this post, we’ll talk about how to Pivot text values with Power Query. We would like to do this even if there are a variable number of fields per record. This can be REALLY hard to visualize based on a short text description, so I think it is best to show screenshots of the before and after. Let’s just jump right in.

https://www.excel-university.com/pivot-text-values-with-power-query/