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. …
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 …
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 …
Recently, I had one of those “how did you do that?” moments with a tech-savvy client. This client, like me, set up his domain with Google Apps. During a meeting, he told me he wanted to show me a spreadsheet he created in Google Docs. In the web browser, he typed d.(his domain).com and the browser opened his Google Docs login page. Not long after that, as we were scheduling our next meeting, he typed c.(his domain).com in the browser, and his Google Calendar instantly appeared. I …
It’s frequently asked questions time on Diving into the Details! With this one, we’re not diving too deep.
Having your picture (a.k.a. avatar) appear in my blog comments takes only a couple of minutes. Go ahead, time yourself and let me know if I’m wrong.
Go to the Gravatar website.
Create an account.
Verify your e-mail address.
Upload a picture, and you’re done!
Gravatar associates your picture with your e-mail address whenever you leave a comment on a WordPress blog (and a few other blog platforms). If you have …
In addition to e-mail overload, I’ve been diagnosed with e-mail address overload syndrome. People usually say “whoa!” with their mouths wide open when I tell them that I have five e-mail addresses. Of the e-mail addresses I currently use, I created my first with Hotmail many years ago. Shortly afterwards, I tried Yahoo. A few years later, I created one with Gmail. After I add my work and school e-mail addresses to those, I’ve got five that I use somewhat regularly.
Last week, I attended the International Consumer Electronics Show (CES) in Las Vegas. It was tons of fun seeing and getting a hands-on experience with the latest technologies and gadgets. The hard part is that I’ve added about fifteen things to my wish list, but I’ll only be able to afford and have time to play with two or three.
During the show, I took notes of what I liked on Twitter. Below are my tweets (and some commentary):
Twenty, forty, sixty, eighty, one hundred, twenty, forty, sixty, eighty, two hundred, twenty, forty, sixty, eighty … aarrgh! Where was I?
In my previous post, I blogged about all the fun I am having in a Visual Basic class that I am taking at UNLV. My most recent project is a simple cash and coin counting program. I will use it for a position I hold in an organization in which I help count cash. Hopefully, this program will ease the occasional pain and frustration I feel …
This fall, I am taking a Visual Basic class at UNLV as one of the electives for my Masters Degree in Accounting. Projects for the class require application of the concepts learned, but allow for creativity because each student can create whatever design or function for the program he or she desires.
My latest project in this class is a form that estimates an amount of tax based on income, itemized deductions and dependents. It then returns a message to the …
One of my first blog posts was about how I use macros with QuickBooks reports exported from Excel. That post also contains a brief explanation of what a macro is, so please read it first if you are unfamiliar with macros.
In my work, I often find myself combining similar types of expenses provided by a client on a spreadsheet for a more condensed presentation on a financial statement or a tax return. The repetitive task of selecting cells, adding borders, and …
Social Media