TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

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

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
Excel Tips

How to Insert a Symbol in Excel

How do you quickly insert a Symbol? We’re getting back to basics with Excel- the tool we all love and hate. Have you ever had to add a symbol into a cell in Excel? Sometimes it can be difficult to copy and paste, but luckily, you can quickly add in your…

Read More
News Release

3 Essential Elements of a Budget

A successful budget must bring together three major pillars – people, data and process. Gaps in any of these areas will decrease the accuracy of the final budget numbers. The People This element is pretty self-explanatory – you cannot create a budget without the people! You should always consider the…

Read More
News Release

4 Reasons You Need to Budget

Let’s state the obvious, budgeting isn’t sexy, nor is it fun. It’s an ongoing process, and companies need to do it on an annual basis. If you’ve ever stopped to ask yourself, why am I doing this budget report, then this article is for you… 1. “Because we have to” So…

Read More
Excel Tips

Combine Data From Multiple Cells to One

We’re getting back to basics with Excel- the tool we all love and hate. How do you combine data from multiple cells into one cell? Select the desired cell you want the combined data to appear in Enter in =[First Cell]&&[Second Cell] If necessary, add any additional characters to separate…

Read More
True Sky How-to's

Pivoted line item detail template

In our first post in the Detail Budgeting series, we noted that a common issue among budgeters was an inability, in traditional budgeting systems, to enter enough explanatory detail.  True Sky Budgeting and Planning provides a number of solutions to this issue, including how Line Item Detail can be used…

Read More