Your colleague just handed you a complex spreadsheet for you to maintain. The first thing you need to know is which cells contain formulas. The easiest way to display all formulas is to press CTRL + ~ (tilde). The tilde is on the key to the left of ‘1’. Display Formulas – CTRL + ~
Category Archives: Uncategorized
Slicers — Making Pivot Tables Easier
You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table. Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data. To insert: Click …
Technical Disruption – Target Corp
Imagine — the busiest shopping day of the week and all of the systems to checkout customers are shutdown. Imagine you are one of the largest retailers nationwide. Target Corporations experience an outage on Saturday of all stores nationwide due to a software outage. It seems the software outage was caused by routine maintenance — …
Accounting and Football?
Love sports? Good at Data Analytics? There may be a new job for you. The Southeast Conference (SEC) recently hired Deloitte to review their football officiating program. The firm is to review play by play reports and using a statistical analysis, determine if there are any outliers or exceptions. They are also to compare to …
New to Analytics? — Start here
Think you are new to analytics? You may have a start. Most of us in business, and especially accounting are quite adept in Excel. This makes the tool a perfect place to start. You cannot use the largest data sets, but with new Excel tools such as PowerPivot, that is constantly increasing. Analyzing data in …
I Teach Accounting Information Systems 