Basic Pivot Table Example

Basic Pivot Table Example
Microsoft describes PivotTables as “A PivotTable report is useful to summarize, analyze, explore, and present summary data. A PivotChart report can help you visualize PivotTable report summary data so that you can easily see comparisons, patterns, and trends. Both reports enable you to make informed decisions about critical data in your enterprise. The following sections ...

Excel COUNTIF Condition Examples

Excel COUNTIF Condition Examples
Excel COUNTIF is one of these functions that are simple enough to understand the concept but make you scratch your head when you try to do something less trivial with the condition part. Sure, simple cases are simple enough: How to count all the cells in a range A1:A100 that have a specific value called ...

Excel Icon Sets – Simple Example

Excel Icon Sets – Simple Example
They say that picture is worth a thousand words and that is even more accurate when dealing with numbers. Sometimes in Excel you want to show Icons that provide quick meaningful indication for the value of the rows. A simple way to do that is by using Excel’s icon sets conditional formatting. For a simple ...

Excel VLookup – Simple Example

Excel VLookup – Simple Example
VLookup is an Excel search function. See the official definition at the Microsoft Office site. It is part of a family of search functions that includes Lookup, VLookup, HLookup and Match. Each one with a slightly different behavior. The VLookup syntax seems abstract and complex so instead of explaining the syntax let’s focus on a ...

How to clean Excel Cells from extra blanks

Simple problem: Importing external data to Excel Cell with values that include extra spaces either at the front or at the back of the values. I.e. Instead of having values like “My Value” the actual value is ”   My Value   “. So how do we normalize the values? Excel provides a function called Trim for this purpose ...