TOLL FREE: 1 855 TRUE SKY (878 3759)

Blogs about Excel Tips

Excel for Budgeting Excel Tips

Tips for Budgeting in Excel

Most companies today are using Excel as their primary tool for budgeting. It’s familiar and easy to use, and can be applied to companies of all sizes, from different industries.  We are always looking for ways to help our clients make budgeting in Excel an easier process, so we have…

Read More
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

Finding Complete List of Keyboard Shortcuts

Excel Tip #12 – Where can I find a Complete List of Keyboard Shortcuts? We’re getting back to basics with Excel- the tool we all love and hate. 1)      Click the Question Mark at the top right of your book (or F1) 2)     In the Excel Help Menu, search for…

Read More
Excel Tips

A guide to isolate data within text string in excel

We’re getting back to basics with Excel- the tool we all love and hate. 1)  Locate the data that you want to isolate in your Excel string. 2)  On another column insert the Excel text function =mid(Cell #, Start #, Length of Sequence) Cell #: Refers to the cell of the data you are dealing…

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