![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2018/01/bigstock-223435180xsm.jpg)
![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2018/01/bigstock-223435180xsm.jpg)
![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2017/07/sortleftright.png)
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...![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2017/05/bigstock-stacks-of-old-dirty-pennies-b-114602264sm-150x150.jpg)
Using TRUNC()
This is an excerpt from our Excel CPE course – Must Know Excel tips Tricks and Tools for CPAs. TRUNC() No Decimals If you don’t want the pennies in your calculation you can use =TRUNC(), short for TRUNCATE, or =INT(), short for INTEGER, to turn your data into...![](https://d3r6e3g6.rocketcdn.me/wp-content/uploads/2017/04/bigstock-Time-Is-Money-99249893sm-202x135-150x135.jpg)