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…

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…

How do you round to the nearest whole number? Sometimes as accountants, we become so dependent on our pre-built budgeting templates, that we forget how to use Excel from scratch. So we’re getting back to basics with Excel- the tool we all love and hate. Today, we’re looking at rounding…

We’re getting back to basics with Excel- the tool we all love and hate. Over the next few weeks, I’ll be posting different Microsoft Excel tips and tricks that will hopefully make your life easier. How do I quickly sum up a row of numbers? 1. Select the cell where…

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, Planning, Budgeting and Forecasting, provides a number of solutions to this issue. This post will examine the Standard Data…

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, Planning, Budgeting and Forecasting, provides a number of solutions to this issue, including how Line Item Detail can be used…

Remembering the basic philosophy of True Sky as Budget in Excel; Manage in SharePoint; Store in SQL Server, let’s walk through the basic process of Budgeting and Forecasting in this tool. Input numbers in Excel   First, a budgeting template is designed in Excel. A template is a multi-use document…

This is our first post to this blog – a blog dedicated to the True Sky Planning, Budgeting and Forecasting solution.  We hope to use this forum to promote learning, sharing and discussions about True Sky.  We will offer tips and tricks, how-to’s and provide a place for friendly discourse…

Budgeting Best Practices Webinar   Most companies spend four to five months on planning and budgeting with managers spending up to 20% of their time on this process. Where does your company stand?   Those involved in the budgeting, planning and forecasting process are burdened with the administration tasks, when they…