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)…

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…

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…

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…

How do you delete all non-formula data?   We’re getting back to basics with Excel – the tool we all love and hate. Below is a sample Balance Sheet that contains both numeric and formula cells. The following steps outline how you can eliminate all the data while still keeping…

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…