Boss: Create sequential numbers from 1 to 1000

@dataanalytics.07

138.4K followers · usually 2.1K views a post

Views

54.5K

Likes

1.9K

Comments

6

Shares

179

SoundTikTok sound · original sound - dataanalytics.07

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.

15 videos8 creators

Why it worked

The video effectively uses a relatable "beginner vs. pro" format to showcase a valuable Excel shortcut, appealing to users looking to improve their efficiency.

Summary

The video contrasts two methods for creating sequential numbers in Excel: a beginner's manual approach and a pro's efficient use of the SEQUENCE function. It demonstrates how the SEQUENCE function can quickly generate a list of numbers from 1 to 1000.

Structure

1Boss requests sequential numbers from 1 to 1000
2Beginner manually enters numbers and uses a series function
3Pro uses the SEQUENCE function for instant results
4

Original caption

Nobody’s talking about this better alternative 🤯 #exceltips #spreadsheets #office

More from @dataanalytics.07

Product placement

Microsoft Excel: ACTS - it is used to create a list of sequential numbers. Removing it would change what happens in the video. It is the primary tool used in the video. SEQUENCE function (Microsoft Excel): ACTS - it is a function within Excel used to generate a sequence of numbers. Removing it would change what happens in the video.

On-screen text

Boss: Create sequential numbers from 1 to 1000 S. No. Employee Department Experience (Years) Monthly Salary 1 Beginner Alt H F I S Ctrl + ↓ Pro =SEQUENCE(1000)

Transcript

Alt H F I S Ctrl + ↓ =SEQUENCE(1000)