In a few short weeks, the Sage Summit 2014 will have the True Sky team shouting Vegas Baby! Held in the beautiful Mandalay Bay Resort, this year’s Sage Summit will feature some high-profile speakers such as actress and entrepreneur Jessica Alba and NBA basketball legend Earvin “Magic” Johnson. Whether you are…
Read MoreThe following article is from guest blogger, Gary Cokins. Can you imagine accountants as American cowboys of the Wild, Wild West in the 1800s? I can. And they can be dangerous. Yeehaw! Yippee-i-o-i-a! In place of guns in their belt holsters the cowboy accountant may be carrying a smartphone. Their…
Read MoreThe whole point of doing a budget is so you can prepare for the future. Don’t forget this! Budget analysis is the process of turning data into information; and it is information that you need to make informed business decisions. The following are key analysis takeaways. Analysis is Strategy not…
Read MoreLet’s face it, budgeting is not fun, especially when you’re the one tasked with reviewing the spreadsheets. Here are some important budgeting process steps to consider during the review process! 1. Take the time you think you need and double it! Reviewing takes more than five minutes. Ideally, most…
Read MoreExcel 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 MoreMost companies favor Excel when it comes to the budgeting process. One of the biggest pains of working from Excel is merging the data. Keep reading for some helpful financial budgeting tips on how to merge all your data! 1) Storage and Retrieval Having a structured naming and distribution method…
Read MoreExcel is a great tool and over 80% of companies are using Excel as their budgeting solution. However, in our 20+ years of experience working with financial systems, we’ve seen some challenges in using Excel. So we’ve compiled our Top 5 and what you can to do about them. 1) Budget…
Read MoreWe’re getting back to basics with Excel- the tool we all love and hate. 1) Select the list that you want to summarize. 2) Under the Insert tab, select PivotTable. 3) Make sure the correct table is selected, then choose a destination for your new list. 4) Select OK. 5)…
Read MoreWe’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 MoreHow 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
