Excel Magic Tricks
- 158.5K likes on YouTube
- 7.9M views
Created by Sirf Excel on YouTube
What you'll learn
- Creating a blank workbook
- Find dialog (Ctrl+F)
- AutoFilter
- Sheet protection
- Consolidate tool
- Paste Special Add
- Custom number formats
- Customizing the Ribbon
Explore related topics
Course content
01Excel One Click में सारा Data Enter Without Typing 😲🔥 #viral #excel #exceltips #computerPreview00:54
This short chapter shows how to fill an Excel sheet with data without typing it by hand, using a phone app. The method is to open the Excel app on a mobile phone, create a blank workbook, and use the picture option to capture the table from an image. After choosing the picture, the user adjusts the selection, taps continue, and waits while the app converts the picture into cell data. The data then appears in the sheet and can be opened and saved as a file.
- Creating a blank workbook
- Inserting data from a picture
- Converting image data into cells
- Saving and opening the workbook
02Excel Advance Find Option in just 10 sec #viral #excel #exceltips #computer #sirfexcelPreview00:48
This chapter shows a quick way to find a name across an entire Excel workbook, not just the current sheet. The usual Ctrl+F search only looks in the active worksheet, so if you have many sheets and want to locate a value such as the name Radhika, you need a different approach.
- Find dialog (Ctrl+F)
- Searching within a sheet vs. workbook
- Find All results list
- Sheet names and cell references
03Excel की ये Trick केवल Expert जानते है 😲🔥 #viral #excel #computer #exceltipsPreview01:01
This chapter shows how to use Excel's filter to fill in a column of gender labels for a long list of names, instead of typing each one by hand. The method starts by turning on the filter arrow on the Name column, then opening Text Filters and choosing Custom Filter.
- AutoFilter
- Text filters and custom filter
- Autofill on filtered data
- Clearing filters
04Excel Sheet Triple Lock Protection in just 5 sec🔥😲 #viral #excel #exceltips #computerPreview00:59
This chapter shows three ways to protect an Excel sheet with passwords. The first is sheet protection. Right-click the sheet tab, choose Protect Sheet, enter a password, pick which actions to allow, and confirm. Once protected, typing into the locked cells is blocked. However, sheet protection does not stop someone from deleting the whole sheet with a right-click.
- Sheet protection
- Workbook protection
- Password to open a file
- Save As and General Options
05Excel Consolidate Most Useful Trick🔥😲 #viral #excel #exceltips #computerPreview01:00
This chapter shows how to use the Consolidate tool in Excel to combine sales data from several separate ranges into one summary report. The example is a sales report that records daily sales for each person. The goal is to find out, at the end of the month, how much each person sold in total.
- Consolidate tool
- Sum function in Consolidate
- Selecting references and labels
- Using the Left column option
06Excel Most Useful Tricks For All Excel Users #viral #excel #sirfexcelPreview00:44
This chapter shows how to add the same bonus amount to every employee's salary in a long salary report in Excel. The report lists many employees, each with a salary in its own cell. Instead of typing a new formula for each person, you type the bonus amount into any empty cell on the sheet, such as ₹5000.
- Paste Special Add
- Applying one value to a range of cells
- Entering and copying numeric values
- Working with salary data
07Excel +91 Phone Number से पहले Automatic आएगा 5 Sec में 🔥😲 #viral #excel #exceltipsPreview00:44
This chapter shows how to make Excel automatically add the country code (+91) to phone numbers entered in a column, so the user does not have to type it each time. The data set has employee names, salaries and phone numbers, and the phone numbers must include the country code. When a plain 10-digit number is typed, the +91 is missing, so the fix is to change the cell format rather than retype every number.
- Custom number formats
- Format Cells dialog (Ctrl + 1)
- Placeholder digits in number formats
- Displaying phone numbers with country codes
08Excel Me Apne Name se TAB Create Kro 😲🔥#viral #excel #exceltips #computerPreview01:00
This chapter shows how to create a custom tab in Excel's ribbon and give it your own name. You start by opening Excel Options through the Quick Access Toolbar's More Commands, or by right-clicking any ribbon item. In the Customize Ribbon section, choose All Commands so every command is listed. Then add a New Tab. Excel places it in the ribbon, and you can rename it to whatever name you like.
- Customizing the Ribbon
- Creating a new tab
- Groups and commands in a tab
- Renaming tabs and groups
- 33Boys Punjabi Mashup ft.Sukha,Shubh,Sidhu,Karan & More | DJ BKS & Sunix Thakor | LATEST PUNJABI SONGSPreview07:46
- 43Attendance Sheet Overtime & Total Hours Find in 5 sec #viral #excel #exceltips #computerPreview01:01
- 66Excel Age Calculator kisi ka bhi age nikalo 5 second me 🔥😱 #excel #exceltips #computerPreview01:27
- 72Excel Me Kisi Bhi Month Ke Days Kaise Nikale 😱 | Simple Excel Trick #excel #exceltips #computerPreview00:56
- 87Name + Surname Ko ek click me Merge Karein🔥#sirfexcel #computereducation #computer #excelPreview00:50
- 88😱2 Excel Tricks, 1 Short! 💯 #excel #computereducation #computer #exceltips #gurmeetsirPreview01:00
- 91Excel Print Me Page Number Kaise Add Kare😳#sirfexcel #excel #computereducation #gurmeetsirPreview01:06
- 92EXCEL PRINT HACK Ye Trick Sabko Nahi Pata😱#sirfexcel #excel #computer #computereducation #gurmeetsirPreview00:45
- 93EXCEL AUTO FILTER 🔥Find Data in 1 Click😍#sirfexcel #computereducation #computer #excel #gurmeetsirPreview00:54
About the creator
- YouTube channel
- 31.3K subscribers
- 1 course on Studyio
The videos in this course are made by Sirf Excel and play from YouTube, credited to them. Studyio adds the chapters, notes, quizzes and a certificate around them.
More courses like this

Barbara O'Neill Part 1. DNA and The True Cause of Disease

Claude – Full Course 2026 (How to use Claude AI for beginners)

How to Speak

Gilbert Strang lectures on Linear Algebra (MIT)

ROYAL ENFIELD HIMALYAN 450 INSTRUMENT CLUSTER FULL DETAIL ALL SETTING PHONE CONNECTION TRIPPER DASH
