TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

Read up for news, tips and tricks about budgeting, planning and forecasting.

Budgeting Best Practices

Tips for Merging Budgeting Data

Most companies favor Excel when it comes to the budgeting process. One of the biggest pains of working from Excel is merging the data. Keep reading for some helpful financial budgeting tips on how to merge all your data! 1) Storage and Retrieval Having a structured naming and distribution method…

Read More
Excel Tips

Excel Tip #7 – How do I Split Columns?

How do I Split Columns?   We’re getting back to basics with Excel- the tool we all love and hate. 1) Identify the item that separates the columns (for instance, # in the example below) and highlight the range of cells you would like to split in your spreadsheet. 2)…

Read More
Excel Tips

Horizontal Totals in Excel

We’re getting back to basics with Excel- the tool we all love and hate. If you hate Excel sheet formulas, not to worry with this tip, since this one doesn’t use any. 1) Copy the data in the row that you want to total. 2) Paste the data below using…

Read More
Excel Tips

Asssigning a Name to a Constant in Excel

We’re getting back to basics with Excel- the tool we all love and hate. 1) Under the Formula tab, select Define Name. 2) Change the Name and Reference of your constant. 3) Select OK, and now you should be able to use your constant name in formulas. 4) If you…

Read More