|
|||||
  |
Just as a GPS is a handy gadget for a stubborn guy who refuses to ask for directions, Excel’s Go To Special feature quickly finds and selects cells in a spreadsheet without all of the U-turns and dead ends. The Go To Special window can be launched under the Find and Replace button in Excel 2010 and it offers a plethora of options to choose from. One of the most useful abilities of Go To Special is selecting blank cells. For … Wave Accounting, a free online accounting software, has a very easy interface for non-accountants to automatically import and classify bank transactions. Accountants who primarily use other accounting programs might need some time to get used to Wave Accounting’s interface. I recently needed to make some adjusting journal entries in Wave Accounting and the screen to enter them wasn’t quite where I expected to find it. To make an adjusting journal entry, click on the Settings tab. That seems strange to me … Continue reading Adjusting journal entries in Wave Accounting For many years, I’ve used Excel as my 10 key adding machine. Since I can add and subtract numbers on my computer, I have never wanted clunky and noisy equipment taking up space on my desk. I have used the built-in Windows calculator occasionally, but it lacks a traditional 10 key tape that accountants love, so I’ve preferred using Excel. That may be changing, however, since I discovered Moffsoft FreeCalc in a discussion in the CPA Tech Connect LinkedIn group. … Continue reading Moffsoft – a desktop calculator with a tape Out of curiosity, I occasionally enter my name in Google to see how I am doing in my goal to dominate the first page of Google search results. Today, I decided to take a different approach and see how Google autocompletes searches for my name. According to Google, its algorithm predicts queries based on other users’ search activities. These searches provide some insight into what phrases people have used to search for me and other lucky guys out there that share … One of the most underrated Excel functions that I use often is the SUMIF function. On my Excel function tournament bracket, SUMIF ranks slightly behind the SUM, AVERAGE, IF, COUNT, PMT, and RATE functions. Still, it has a shot at upsetting one of the higher seeds on any given day. The SUMIF function adds the values in cells specified by a given condition or criteria. Tim Gavin, a fellow CPA blogger, wrote a great blog post last week for the Sikich … Continue reading Using the Excel SUMIF function to find that out-of-balance journal entry A coworker stopped by my office seeking a solution to a dilemma. She had received a large PDF document in reverse order (page 1 of the document was page 100 of the PDF, page 2 was page 99, and so on). Since backwards workpapers are the type of thing that can drive an accountant to the brink of insanity, there was a lot at stake here. We brainstormed a few possible ways to reverse the page order. In the past, I … |
||||
|
Copyright © 2013 Diving into the Details - All Rights Reserved |
|||||
Social Media