Profile cover photo
Profile photo
Patricia McCarthy
810 followers -
Relevant CPE at a Great Price
Relevant CPE at a Great Price

810 followers
About
Posts

Post has attachment
Month End is just so much fun. This might make it a bit easier.
Chatting about Excel and More
Chatting about Excel and More
excel-diva.blogspot.com

Post has attachment
**
This is a guest post from Joseph Helstrom, CPA. Adding VLookup as a Control for Your
Month-End Workpapers When closing for the month, many use an Excel workbook to
reconcile balances to the general ledger.   As the general ledger changes, do you have a proc...
Chatting about Excel and More
Chatting about Excel and More
excel-diva.blogspot.com

Post has attachment
If you need to string text together, forget about CONCATENATE and try TEXTJoin if you have Excel 2016.

Post has attachment
TextJoin - An Excel 2016 Text Function
If you need to join a lot of text together in a string, check out TEXTJOIN. It   is a text function that was introduced in Excel 2016 to join text in cells together. Initially, you might think that the function is not worth investigating. After all, we alre...

Post has attachment
If you are not as organized you would like, using keywords when you create your file will help you find them. Consider it a New Years' resolution!
Searching for Files with Keywords
Searching for Files with Keywords
excel-diva.blogspot.com

Post has attachment
Searching for Files with Keywords
Using Keywords to Find Your Excel Files If you have lots and lots of files, you know how difficult it can be to locate one, particularly if you did not name it well. Plus, let's face it, memories don't improve with age. So, here is a solution. When you crea...
Searching for Files with Keywords
Searching for Files with Keywords
excel-diva.blogspot.com

Post has attachment
I use this shortcut every day.

Post has attachment
Check out Chris Chau's blog on VLOOKUP vs INDEX MATCH. What's your preference? It's kind of like choosing between Superman or Batman as best superhero!

Post has attachment
VLOOKUP versus INDEX MATCH! Which is Better?
VLOOKUP versus INDEX MATCH! Which is Better? Chris Chau of Defeatexcel.com asked twenty-seven (27) Excel MVPs and community experts their preference  on the ongoing controversy of VLOOKUP vs. INDEX MATCH. it is great reference material and some suggest choi...

Post has attachment
When Average doesn't do it. Use Median and Mode.
Wait while more posts are being loaded