Blog Feed

Learn How to Find Duplicates in Excel and Either Use or Remove Them

It's a common scenario: Data is combined from multiple sources, records are entered by multiple users or you simply have multiple transactions with the same information. The end result is that you need to find and manipulate duplicates. Excel gives you several ways to do this, depending on your data…
Read More

How to Unlock Specific Cells in Excel

When using a shared document you may only want to allow specific cells to be changed. Here are some steps to help you keep certain cells unlocked while the rest of the document is protected. Step 1: Select the cell(s) you would like to leave unlocked. Step 2: Go to…
Read More

Using the Excel Pivot Table Grouping by Month to View Data Differently

PivotTables have some useful "hidden" features that can make interpreting your data even easier. One such feature allows you to view data by date groupings (such as month, quarter, even week and hour of day). By grouping within the PivotTable itself, you avoid constantly changing your source data and creating…
Read More

Excel 2013: How to Create a PivotTable from Multiple Sheets

Once you become a PivotTable fan, you will start to see lots of uses for this powerful analysis tool. But what can you do when the data you want to use is in separate tables in multiple sheets across your workbook? Excel 2013 introduced a method – called the Data…
Read More

How to Add Calculated Fields to a PivotTable in Excel

PivotTables are great tools for grouping, summarizing and totaling information from raw data. Once you have created a table, then you are ready to get even more out of your information by using the summarized data in additional formulas or calculations. The way Excel does this is through Calculated Fields.…
Read More

Strategic Thinking Training, Generate Highly Effective Managers

Companies that have traditionally rewarded employees for productivity understand that there might be another factor that makes management more effective: Strategic thinking. In fact, the Management Research Group (MRG), an assessment design consulting company, found that a strategic approach to leadership is 10 times more important to the perception of…
Read More

Become A Strategic Thinker with Creative Thinking Games

You probably wear many hats as a leader in your organization. In fact, we’re sure it’s easy to get bogged down by all the different roles you play. Additionally, you may feel overwhelmed by the minutiae and repetitive tasks associated with your job. If this describes your situation, we encourage…
Read More

Strategic Thinking in the Workplace

What is Strategic Thinking? You answer hundreds of emails a week, attend hours of meetings and, like most people, you expend your effort on being as productive as possible. In short, you’re busy dealing with the day to day effort – or tactics – of work. Being a strategic manager…
Read More

Dressing Up Your PivotTable Design

Once you have a PivotTable created, you may find that Excel's default formatting is bland at best, unreadable at worst. Here are five formatting options you can adjust when you need to get a PivotTable ready for a presentation or report, but don't need to create something as visually elaborate…
Read More

Searching for Data in Excel

Are you looking for the "peanut butter and chocolate" of workplace efficiency: how to combine the power of Macros with the convenience of search? As of Office 2013, Excel does not provide an easy way to include a variable search term in the execution of a series of tasks recorded…
Read More
< >