Using VLOOKUP in an Excel Formula

Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer?
Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer?
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them.
Manage Your Projects with Our Excel Gantt Chart Template Are you required to manage project timelines when dates for dependencies are shifting? Do you need to know how the latest resource adjustment will affect the project deliverable dates? Then you need a Gantt chart. Some managers can’t function without expensive project management software such as…
Read More
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them. Fortunately, Excel has all the functions to do the date arithmetic for you.
Have you ever called a business and your first impression was your last impression of that business? Just the other day I called a computer repair company to schedule an appointment (and hopefully fix) a computer that went crazy. The person answered my call with, “Yeah.” Hmm, I thought to myself, did I misdial?
“The phone rings, my list of unread email grows, someone is standing at my desk, and I’m trying to finish the report due by 10:00. Of course I want to manage my time, but look at my day! I have so much going on between organizing my schedule, dealing with interruptions, putting out fires…there is…
Read More