Using TextJoin
TextJoin() TEXTJOIN is a text function that was introduced in Excel 2016 to join text in cells together. Initially, you may think that the function is not that worthwhile. After all, we already have the ampersand (& ) as well as...
Economic Nexus – South Dakota Supreme Court Case
Economic Nexus Update: Looks like many states are now moving forward with out-of-state sales tax. My guess is that many states are going to set minimum revenue amounts so the small entrepreneurs and small EBay sellers won’t be impacted. Let’s hope....
Find Files Easily
Are you an organized person? Is everything at your fingertips? If so, good for you. I, unfortunately, am a bit more unorganized and can spend quite a bit of time looking for a specific Excel file. I have found that adding keywords to a file when I create it, can help...
Passwords & Lucy the Retriever
Tips for Strong Passwords Do you use strong passwords? Are you sure? They are the key to keeping your information safe and secure. Since strong passwords are so important, a basic understanding of what constitutes a difficult to hack, strong password is essential....
Current Expected Credit Loss (CECL) Standard
Summary of the Current Expected Credit Loss (CECL) Standard On June 16, 2016, the Financial Accounting Standards Board issued Accounting Standards Update 2016-13, Financial Instruments – Credit Losses (Topic 326) Measurement of Credit Losses on Financial Instruments. ...
SUBTOTAL() and AGGREGATE() -TimeSavers
Many people are only aware of the Subtotal icon and have never looked at the Subtotal function itself. After all, the icon, lets you add, average and count a list so who needs more? Well if you are one of the people who subtotal data a lot then you may want to look at...DockDogs at Fair
We went to the Indiana State Fair this weekend and had a blast as usual. It is a family tradition. So much to see and do and eat. Ducks, Goats, Cows, 4H Exhibits, Scavenger Hunts, Gardens, Soybeans, Corn hole, Giant Pumpkins, Tractors, Train Dairy barn milk shakes,...
Sort Left to Right
Who knew how many different ways there are to sort? Let’s talk about changing the Sort Option Orientation. Typically you don’t have to change the orientation of sorting as the default works just fine. However, everyone in awhile, you have that one...