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…

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…