=IF is a Tremendous Time Saver If ever you had a doubt whether Microsoft Excel’s =IF formula can save you time, here’s my favorite =IF formula story. Learn =IF, It Can Save You Hours of Work Each Week Be patient, read this entire article. You may save yourself hours of work each week. (=IF…
Learning Excel is what I call a tie-breaker that can absolutely help you get more interviews and possibly help you land a job at a job interview. But you need to do the work. When you’re finished reading this blog post, The World’s Shortest Excel Book can help you significantly improve your Excel skills in…
I am so grateful to my friends at WordStream for publishing my guest blog post on Using Excel for Google PPC in November 2011. If you’re serious about creating your own Google AdWords campaign spreadsheets, just read this blog post (and get a free Excel file for Google PPC). If you’re serious about learning Excel power…
It’s funny, I’ve never seen a tool on the Internet for writing Google AdWords ads easily without counting the letters. Maybe my Excel tool for writing AdWords ads is the first. Microsoft Excel is the Ultimate Utility Knife Software Everyone knows Excel is great for numbers and spreadsheets. But it’s so flexible that I found…
Based upon my experience in teaching Microsoft Excel to several thousand adult learners, here are the top ten Microsoft Excel mistakes that I have seen. They are in exact order that they occurred to me. My views on the major Excel mistakes may surprise you. Inheriting Someone’s Excel spreadsheet Without a Review I call this…
When your auditors catch a 6 million dollar error in your cash on hand out of $128.9 million, you’re having a bad day. That’s a 4.65 % error in cash on hand for Knox County, TN. I am Neutral I am not from Knoxville, Tennessee and couldn’t tell you whether they are Republican or Democrat. …
Someone searched Google for the phrase how to learn Microsoft Excel so I thought I would write a few paragraphs on this difficult topic. Use your strengths to learn Microsoft Excel When learning Excel, do not be negative in your approach. If you walk into an Excel class quietly telling yourself… I hate math. Learning…
Has your password ever been hacked? It’s not fun. Let’s use Excel to solve the problem. My Twitter Account was Hacked Twice in Two Days I’m not a password expert but I’ve never had a computer account hacked until this week. Twice in the past week someone or some program has stolen my Twitter password…
The first question you should ask when given a spreadsheet is… Who made this spreadsheet? Too bad spreadsheets aren’t like sidewalks I grew up in and around Skokie, Illinois, USA. When I was a little kid, we had many empty lots but we did have sidewalks. The company that laid the concrete for a sidewalk…
One of my website visitors wanted a simple Excel time sheet. Her husband wants to keep track of his hours and wages on a monthly basis. Here is TechSmith video of less than 5 minutes. It was made using Jing. To hear this Jing broadcast you will need to turn on your speakers. Just click…