Blog Feed
Create Outstanding Pie Charts in Excel
Once you have gone to the effort of collecting, organizing and processing your data, you probably want to show it off! Tables do a nice job of presenting raw information, but a chart can bring your data to life. Charts create visual impact that conveys not only the data itself,…
Read More
Create a PivotTable Calculated Item in Excel
Excel's PivotTable feature allows you to organize information in such a way that you can answer many questions about your data that would otherwise require lots of formulas, functions and "IF" statements. To get even more answers out of your data, PivotTables offer Calculated Fields and Calculated Items. Calculated Fields…
Read More
How to Improve Emotional Intelligence
If you want to know how to improve your skill at shooting hoops or playing the guitar, you practice. If you want to learn more about how to use Microsoft® Excel®, you take a class and complete examples that help you with your tasks. Can you improve your social, interpersonal…
Read More
What’s Your Emotional Intelligence?
Have you run across someone recently who is not familiar with the term “Emotional Intelligence,” sometimes referred to as EQ? It’s a term heard more frequently in business environments. Yet, do you know your EQ score? If you are the curious type, there are many ways – online and off…
Read More
Developing Emotional Intelligence
As a business leader, you are constantly looking for ways to improve yourself. You take courses and read the top business publications to increase your knowledge. You stay abreast of technological advancements in your industry and look for ways to improve your communication and presentation skills. However, what if someone…
Read More
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