Here are some techniques for calculating percentages. For these examples, we have a simple sheet of travel expenses and you are after the percentage results of prices going up or down for the total and for the individual months. Percent increase Let’s say you anticipate more travel the following year…
Read More
Ongoing training results in engaged, flexible, and high-performing employees. The most successful organizations keep up-to-date on the latest software trends with robust education and development initiatives. The Disengaged Employee: Disengaged employees negatively impact the bottom line by generating less work and therefore less revenue than their engaged counterparts. Employee disengagement…
Read More
Organizations take many precautions to keep their data and systems safe and secure. Unfortunately, no number of firewalls protects your data from this potentially disastrous threat. Increase your staff's awareness and turn security leaks into additional protection. Security Concerns Metadata. As you may or may not be aware, your documents store…
Read More
If you are a business professional today, you are working with computers to be as efficient as possible. Businesses benefit from efficient use of technology. You and your fellow employees must be well-versed and well-trained on pertinent hardware and software to be efficient, solve problems and generate ROI. Computers =…
Read More
The Ins and Outs of Excel Percentage Formula
Read More
If you do any project management, you’ll eventually need to (or be asked to) create a Gantt chart
Read More
Use an array formula to attach an IF to a function that doesn’t have one
Read More
When presenting important information, a visual – such as a chart or graph – is worth a thousand lines of data. But communicating your message is not as simple as tossing in a pie chart. Visual representations of data must be carefully planned and crafted to present a clear and…
Read More
Have you been asked to create an Excel worksheet from scratch and had no clue on how to approach the process? Did you build a worksheet only to discover that you should have added elements in the beginning to save time and frustration? Below is a seven step guide that…
Read More
Integrating keyboard shortcuts into your daily routine saves you time and energy. We love finding new ways to avoid the mouse. For instance, you can edit a cell using the F2 key. Highlight the cell you want to edit. Then, press F2 and the cursor appears at the end of…
Read More