00:00Your boss might fire you for not knowing this Excel trick.
00:0360 rows of data.
00:05Now what?
00:06You could use Sunif, but there's a faster way.
00:09Click any cell.
00:11Insert tab.
00:12Pivotable.
00:13Hit OK.
00:14Drag salesperson to rows.
00:17Drag amount to values.
00:20Done.
00:2260 rows summarized in 5 seconds.
00:25This is what Excel proficient actually means.
00:28Full course in my bio.
00:30And thenφ.
00:30Ready?
00:30What the hell are my 시간 with Schopiner?
00:30Let's look forward to that PRO tellement with your friends.
Comments