Blog Feed
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? Excel can do these or any other data lookup using the VLOOKUP function. This function’s precise parameter requirements can seem intimidating at first, and…
Read More
Excel Date Formula
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…
Read More
Excel Gantt Chart Template
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…
Read More
Organize Projects and Count the Time between Dates with the Help of Excel Date Formulas
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…
Read More
Don’t Lose Another Caller – Critical Communication Skills for the Phone
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…
Read More
How to Manage Time (Especially When You Don’t Have Any)!
“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…
Read More
Excel Offset Formula
How do you find a single value in a table? How do you find, say, the number in the fifth column of the third row? Try out the Excel offset formula! The OFFSET function finds a cell (or range of cells) that is a specific number of cells away from…
Read More
Excel Formula Count
Are you trying to count values in your worksheet and don’t understand why the result is too high? Or are you looking for a method that excludes blank cells? Maybe you want to count only values which are greater than 1,000. Excel gives you the power to count only the…
Read More
How to Create a Report in Excel: The PivotTable
Excel is a powerful reporting tool, providing options for both basic and advanced users. One of the easiest ways to create a report in Excel is by using the PivotTable feature, which allows you to sort, group, and summarize your data simply by dragging and dropping fields. First, Organize Your…
Read More
Constructive Conflict: Chaos to Collaboration
Conflict, at its heart, is the clash of viewpoints. Conflict is not inherently bad. Good clash leads to innovation and progress. Bad conflict can nosedive into negativity and undermine productivity. An environment that fosters good conflict provides opportunities to find common ground while one that fuels negativity tends to eliminate…
Read More