Download the featured file here:[ Ссылка ]

In this Microsoft Excel video tutorial I explain how to create a summary table. I explore two methods. The first method uses the following functions: SORT, UNIQUE, SUMIF and COUNTIF. The second method uses a PivotTable. Which is the best method to use?

00:00 Introduction
00:37 House your data in a table
01:13 Formula method
04:26 PivotTable



#exceltutorial #exceltips

свернуть