Blog Feed

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

Dealing with Conflict: Keeping an Open Mind to Understand Other Points of View

Put a group of people into a closed system, add a dollop of diversity and a dash of deadlines, sprinkle in some stress, and voila – you have a perfect recipe for conflict. In the workplace, conflict is practically an inevitability. That’s unfortunate, because conflict is destructive and counter-productive to…
Read More

Excel Dynamic Charts: A Great Time Saving Tool

If you use Excel for reporting on results each month, you have probably needed to adjust your charts automatically to add a new month, state, or sales rep. Typically, that means clicking on each chart and adding a new data series or expanding the range of the current series. Unfortunately,…
Read More

Automatically Stop Duplicate Values on Input

Preventing duplicate values from being entered in a range of cells may be a requirement in some of your worksheets. Although not obvious, enabling this capability in Excel is very easy. You can prevent duplicate values from being entered in a range of cells through Data Validation. 1) Select the…
Read More

Basic Formula Series: The Excel® Average Formula

Let’s say that you’ve been given a new set of projects to work on, and you’re being asked to calculate how long you think your team will need to complete various pieces of each project.  The best way to obtain those numbers is probably to look at other projects you’ve…
Read More

Motivating and Inspiring Employees

Working on a project and everyone is burnt out? Get them excited again with these tips. Employees are a vital component to company success. While other factors influence organizational gains, your workforce is a sustainable entity that maximizes productivity and progress.  Create an ideal atmosphere to improve employee engagement and…
Read More

Managing through Company Changes: Helping Employees with Office Transitions

When you manage an organization – any organization – through a period of change, there are four main stages to navigate. Preparation The End The Transition The New Beginning The firm I worked for divided the change as many organizations do: They rightfully spent time on preparation, but forgot to…
Read More

Building an Effective Team – Choosing the best candidates to get the job done.

As a company leader, your time is as valuable as it is limited. You depend on your teams to take care of day to day business and make effective decisions in line with your organization’s purpose and best interest. The key is an autonomous, powerful team that works effectively without…
Read More
< >