Excel pivot table

How to Aggregate MS Excel Daily Data with Pivot Table

Introduction If you have daily data that still makes sense when aggregated into weekly or monthly data, then you can accomplish that very easily in Microsoft Excel, thanks to the pivot table. You can apply this method to, for example, a data of “trucks arrived” or “shirts bought” per day since the total aggregate amounts…

Read More
Excel running average

How to Calculate Running Average in Excel

Introduction Knowing how to calculate running average in Excel can save you a lot of time and energy. Sample Data Imagine your Microsoft Excel data consists of “Days of Accidents”. For each day on this list there has been one accident: As you can see, not all days are listed. There have been no accidents…

Read More

How to Convert Non Editable PDFs into Excel Sheets

By Paulina Gibson Special for TCC As PDF is the dominant format for corporate document sharing, it is no wonder there is a wide selection of complimentary tools that can help you get more done when working with this file format. Even though Adobe also has its set of additional tools and extensions, at times…

Read More

How to Use SUMIF Conditional SUM Function in Excel

Microsoft Excel SUM Functions: SUMSQ – Square and Add Cell Values SUMPRODUCT – Multiply and Add Two Arrays SUMIF – Add with a Condition SUMIFS – Add with Multiple Conditions SUMX2PY2 – Add Sums of Squares of Two Arrays SMX2MY2 – Add Differences of Squares of Two Arrays SUMIF(), Conditional Sum, is a wonderful function that allows you to find the sum…

Read More

How to Line Up Numbers on Decimal Points in Excel

© Ugur Akinci Did you have a column of numbers in MS Excel that looked ugly like this: You can have a really nice looking column of numbers by centering them on the DECIMAL POINT — even if some of them do not have a decimal point. The first thing to do is to define…

Read More

How to Use Excel NESTED IF Function

To reward the customer with quantity discounts for bulk purchases is a common practice in business. Consider the below situation: There are FOUR different IF statements here illustrated by the above table: (1) Here the seller is charging $10 per item if the customer purchases 100 or less items. (2) If the customer buys more…

Read More

How to Calculate Average Number of Items Sold and Average Revenue Generated by a Salesperson in a Transaction by Using MS Excel’s AVERAGEIF Function

How to Calculate Average Number of Items Sold is an important task to perform in many MS Excel projects. Imagine you have the following sales data: How can we find the average number of items sold by a salesperson in an average sales transaction? The formula is: AVERAGEIF = ([RANGE_NAME],”Name”,[AVERAGE_RANGE]) This formula will find the…

Read More