Toll Free: 1 855 878 3759 (TRUE SKY)

Blogs about Excel Tips

Accounting Excel Tips

Final Version of an Excel Workbook

So you’ve worked long and hard to complete an Excel workbook. You have gathered input from multiple sources, incorporated changes from high-level management and finally, you have arrived at the final version. Hooray! But wait! Someone in your company missed the deadline on their changes and decided to access the…

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