![How to Use Pivot Tables to Streamline Your Work](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2023/01/Blog-Post-Images-CPASS.png)
![How to Use Pivot Tables to Streamline Your Work](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2023/01/Blog-Post-Images-CPASS.png)
![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2018/03/v1.png)
Adding VLookup as a Control for Your Month-End Workpapers
VLOOKUP As a CONTROL 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 process in place to easily determine that balances previously reconciled still tie to the general...![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2018/01/bigstock-223435180xsm.jpg)
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...![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2017/09/bigstock-171714329-savetime-sm-300x200.jpg)