My boss asked me to find out which customers paid via Credit Card 💳

@easysheets0

211.1K followers · usually 3.6K views a post

Views

865.8K

Likes

32.2K

Comments

1.6K

Shares

2.3K

SoundTikTok sound · original sound - easysheets0

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

26 videos13 creators

Why it worked

The video provides quick, actionable tips for common Excel tasks, appealing to users looking to improve their data analysis and project management skills. The use of clear visuals and concise instructions makes the content easily digestible and shareable.

Summary

The video demonstrates how to use Microsoft Excel's pivot table slicers to filter data, specifically showing how to isolate customers who paid by credit card. It then transitions to showing how to create a progress tracker in Excel using checkboxes and a formula.

Structure

1Introduce the problem: finding credit card payments
2Demonstrate filtering data using a pivot table slicer
3Showcase the result of the filter
4

Original caption

Pivot Table Slicer in Excel‼️ #excel

More from @easysheets0

Product placement

Microsoft Excel: ACTs - The interface is operated to demonstrate how to use pivot table slicers and filters. Removing it would change what happens in the video. It is the primary tool used in the video. @easysheets0: APPEARS - This is the creator's handle, shown at the bottom of the screen. Removing it would not change what happens in the video.

On-screen text

My boss asked me to find out which customers paid via Credit Card 💳 I told him that'd take me hours to figure out but I really did this 🤯 Insert Slicers Payment Method OK Bank Transfer Credit Card PayPal Just click the "Credit Card" button BAM! Look at that! 💥🤯 Click the icon in the upper right corner to remove all filters How cool is that? 😎👍 How to Create a Progress Tracker in 30 seconds ‼️ Alt + N + C + B Check the boxes Type in this formula

Transcript

My boss asked me to find out which customers paid via Credit Card. I told him that'd take me hours to figure out but I really did this. Insert Slicers. Payment Method. OK. Bank Transfer. Credit Card. PayPal. Just click the "Credit Card" button. BAM! Look at that! Click the icon in the upper right corner to remove all filters. How cool is that? How to Create a Progress Tracker in 30 seconds. Alt + N + C + B. Check the boxes. Type in this formula.

Show report filter pages in Excel‼️ #cheatsheets #excel #tutorial

21.0

75.6K2.3K8

Microsoft Excel

75.6Kviews@easysheets0