Advanced Excel Skills what to brush up on?

@realtalkwithanna

6.0K followers · usually 828 views a post

Views

68.7K

Likes

6.5K

Comments

91

Shares

132

SoundTikTok sound · original sound - realtalkwithanna

Why it worked

The video taps into a common pain point for professionals transitioning into new roles: the need to brush up on essential software skills. By identifying specific, advanced Excel functions and soliciting audience input, the creator fosters engagement and positions the content as helpful and relatable.

Summary

The creator is preparing to go full-time and wants to improve their Excel skills. They identify Power Query, Pivot Tables, and Index Match as advanced skills they want to learn or practice before starting their new role.

Structure

1Introduction and goal setting
2Identifying Power Query as a skill to learn
3Discussing Pivot Tables and their perceived difficulty
4Introducing Index Match as another advanced skill
5Asking for audience input on which skills to prioritize

Product placement

Microsoft Excel ACTS - it is a software application used for data analysis and manipulation. Its features, such as Power Query, Pivot Tables, and Index Match, are discussed as skills to be learned. Removing Excel would change the entire topic of the video. Microsoft Excel APPEARS as the software being discussed, but its interface is not directly operated in this video. Its features are the subject of discussion.

Call to action

Let me know in the comments.

On-screen text

Advanced Excel Skills what to brush up on? I'm about to go full time 1. Power Query 1. Power Query 2. Pivot Tables 2. Pivot Tables 3. Index Match 3. Index Match

Original caption

#excel #exceltips #exceltricks #exceltutorial #finance101

More from @realtalkwithanna

More breakout videos from this creator.

Transcript

I'm about to go full time and I wanna brush up on my Excel skills. Excel skills that I'm thinking about learning and or practicing before I go. The first one is Power Query. Actually only used Power Query a couple times and I don't really know how to use it well. From a lot of my past videos though, a lot of people have been saying that it's a very advanced skill. The second one is pivot tables. Now I've used pivot tables many times, but always in the beginning it takes me a second to figure out how I wanna put my chart. For seasoned professionals, it would take them just a split second to think about it. Practicing pivot tables might help me visualize how my data before I even get it done. The third one that a lot of people is the index match. I don't know why, but I was never taught index match and I never really saw anyone use it. After seeing the comments, I feel like I should practice a little bit more on it. If you wanted to brush up on some harder Excel skills after some time off, which ones would you prioritize? Let me know in the comments.