Office Excel Pro

Office Excel Pro beginner vs expert,
Microsoft excel, Microsoft Word and Microsoft PowerPoint

29/05/2026

Excel Expert Trick | Auto Serial Number in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to insert automatic serial numbers in a Microsoft Excel sheet using formulas and shortcuts instead of typing one by one.
Beginners often enter serial numbers manually, which is slow and repetitive.
Expert Way (Excel Shortcut)
Method 1: Drag Fill Handle
1️⃣ Type:
Excel Formula
1
2️⃣ Type next cell:
Excel Formula
2
3️⃣ Select both cells and drag down
✔ Excel automatically creates serial numbers instantly
Method 2: ROW Formula
Excel Formula
=ROW()-1
✔ Automatically generates serial numbers
Example:
Row 2 → 1
Row 3 → 2
Row 4 → 3
Method 3: SEQUENCE Function (New Excel)
Excel Formula
=SEQUENCE(10)
✔ Creates 1 to 10 automatically
Method 4: Fill Series Shortcut
Go to:
Excel Formula
Home → Fill → Series
✔ Generate serial numbers quickly
This trick helps you:
✔ Create serial numbers instantly
✔ Save time
✔ Avoid repetitive typing
✔ Work like an Excel expert
Perfect for:
✔ Employee lists
✔ Student records
✔ Invoice sheets
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel auto serial number
excel sequence function
excel row formula
excel fill series
excel expert tips
office excel pro
#️⃣ Hashtags






28/05/2026

Excel Trick | Sum Only Positive Numbers in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn a smart Excel trick to sum only positive numbers in a Microsoft Excel sheet using formulas instead of calculating manually.
Beginners often add all numbers together, including negative values, which gives incorrect results.
Expert Way (Excel Formula)
Method 1: SUMIF Formula
Excel Formula
=SUMIF(A2:A10,">0")
✔ Adds only positive numbers
✔ Ignores negative and zero values
Example:
Values:
10
-5
20
-2
✔ Result = 30
Method 2: SUMPRODUCT Formula
Excel Formula
=SUMPRODUCT((A2:A10>0)*A2:A10)
✔ Advanced method for positive totals
Method 3: AutoSum Shortcut
Press:
Excel Formula
Alt + =
✔ Quickly insert formulas
This trick helps you:
✔ Calculate positive totals accurately
✔ Save time
✔ Avoid calculation mistakes
✔ Work like an Excel expert
Perfect for:
✔ Profit reports
✔ Sales analysis
✔ Financial sheets
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel sum positive numbers
excel sumif formula
excel positive values only
excel expert tips
microsoft excel tutorial
office excel pro
#️⃣ Hashtags






27/05/2026

Excel Expert Trick | SUM, COUNT, AVERAGE, MAX & MIN in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn essential Excel Expert formulas to calculate SUM, COUNT, AVERAGE, MAXIMUM, and MINIMUM in a Microsoft Excel sheet using shortcuts instead of manual calculations.
Beginners often calculate totals and averages manually, which takes time and can cause mistakes.
Expert Way (Excel Formulas)
SUM Formula
Excel Formula
=SUM(A2:A10)
✔ Adds all numbers instantly
Example:
10 + 20 + 30 = 60
COUNT Formula
Excel Formula
=COUNT(A2:A10)
✔ Counts how many cells contain numbers
AVERAGE Formula
Excel Formula
=AVERAGE(A2:A10)
✔ Finds the average value instantly
MAX Formula
Excel Formula
=MAX(A2:A10)
✔ Finds the highest number
MIN Formula
Excel Formula
=MIN(A2:A10)
✔ Finds the lowest number
AutoSum Shortcut
Press:
Excel Formula
Alt + =
✔ Automatically inserts formulas instantly
This trick helps you:
✔ Analyze data quickly
✔ Save time
✔ Avoid manual calculation errors
✔ Work like an Excel expert
Perfect for:
✔ Student marksheets
✔ Employee salary sheets
✔ Sales reports
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel sum formula
excel average formula
excel count formula
excel max min formula
excel expert tips
office excel pro
#️⃣ Hashtags






26/05/2026

Excel Expert Trick | Add .com Automatically in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to automatically add .com in a Microsoft Excel sheet using formulas and shortcuts instead of typing manually.
Beginners often type email addresses one by one, which is slow and repetitive.
Expert Way (Excel Formula)
Method 1: Add .com Automatically
Excel Formula
=A2&".com"
✔ A2 = Username or Name
✔ Automatically creates Gmail ID
Example:
A2 = rahim123
✔ Result = [email protected]
Method 2: Using CONCAT Function
Excel Formula
=CONCAT(A2,".com")
Method 3: Flash Fill Shortcut
Press:
Excel Formula
Ctrl + E
✔ Excel auto detects email pattern instantly
This trick helps you:
✔ Create emails quickly
✔ Save time
✔ Avoid repetitive typing
✔ Work like an Excel expert
Perfect for:
✔ Employee email lists
✔ Student records
✔ Office work
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel add gmail
excel email formula
excel concat email
excel flash fill shortcut
excel expert tips
office excel pro
#️⃣ Hashtags






25/05/2026

Excel Expert Trick | Enter Name & ID Data Fast in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to enter large amounts of Name and ID data quickly in a Microsoft Excel sheet using shortcuts instead of typing one by one.
Beginners often enter employee names and IDs manually, which is slow and repetitive.
Expert Way (Excel Shortcut)
Method 1: Flash Fill Shortcut
Press:
Excel Formula
Ctrl + E
✔ Automatically fills patterns for Name & ID data
Method 2: Fill Down Shortcut
Press:
Excel Formula
Ctrl + D
✔ Copy data downward instantly
Method 3: Enter Data in Multiple Cells
Select multiple cells and press:
Excel Formula
Ctrl + Enter
✔ Enter data in all selected cells together
Method 4: Auto Number IDs
Excel Formula
=ROW()-1
✔ Automatically generates serial IDs
Example:
Name: Rahim
ID: EMP101
✔ Auto fill remaining rows instantly
This trick helps you:
✔ Enter bulk data quickly
✔ Save time
✔ Reduce manual work
✔ Work like an Excel expert
Perfect for:
✔ Employee records
✔ Student databases
✔ Office work
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel bulk data entry
excel name id shortcut
excel flash fill
excel auto id formula
excel expert tips
office excel pro
#️⃣ Hashtags






24/05/2026

Excel Expert Trick | Auto Fill ABCD in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to automatically enter ABCD (alphabet series) in a Microsoft Excel sheet using shortcuts instead of typing one by one.
Beginners often type A, B, C, D manually, which is slow and repetitive.
Expert Way (Excel Shortcut)
Method 1: Auto Fill Alphabet Series
1️⃣ Type:
Excel Formula
A
2️⃣ Type next cell:
Excel Formula
B
3️⃣ Select both cells and drag the fill handle down
✔ Excel automatically fills:
C
D
E
and more instantly
Method 2: Flash Fill Shortcut
Press:
Excel Formula
Ctrl + E
✔ Auto detect alphabet pattern
Method 3: Fill Series Option
Go to:
Excel Formula
Home → Fill → Series
✔ Create custom alphabet sequences
This trick helps you:
✔ Fill alphabets quickly
✔ Save time
✔ Avoid repetitive typing
✔ Work like an Excel expert
Perfect for:
✔ Lists
✔ Student records
✔ Office work
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel auto fill alphabet
excel abcd shortcut
excel fill series letters
excel flash fill
excel expert tips
office excel pro
#️⃣ Hashtags






23/05/2026

Excel Expert Trick | Convert Date to Day in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to convert dates into day names in a Microsoft Excel sheet using formulas and shortcuts instead of checking calendars manually.
Beginners often search dates in calendars one by one, which takes more time.
Expert Way (Excel Formula)
Method 1: Convert Date to Day Name
Excel Formula
=TEXT(A2,"dddd")
✔ A2 = Date cell
✔ Returns full day name
Example:
Date: 22/05/2026
✔ Result = Friday
Method 2: Short Day Name
Excel Formula
=TEXT(A2,"ddd")
✔ Result = Fri
Method 3: DAY Function
Excel Formula
=DAY(A2)
✔ Extracts only the day number from date
Example:
22/05/2026 → 22
This trick helps you:
✔ Convert dates quickly
✔ Identify weekdays instantly
✔ Save time
✔ Work like an Excel expert
Perfect for:
✔ Attendance sheets
✔ Schedules
✔ Reports
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel date to day
excel text function
excel weekday formula
excel convert date
excel expert tips
office excel pro
#️⃣ Hashtags






22/05/2026

Pro vs Expert | Ctrl + E, TRIM & PROPER Formula in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn smart Pro vs Expert Excel tricks using:
✔ Ctrl + E (Flash Fill)
✔ TRIM Function
✔ PROPER Function
These tools help you clean, format, and organize text automatically in Microsoft Excel sheets instead of editing manually.
Beginners often fix names and spaces one by one, which wastes time.
Pro Way – Flash Fill Shortcut
Press:
Excel Formula
Ctrl + E
✔ Automatically detects patterns
✔ Combines or separates text instantly
Expert Way – TRIM Function
Excel Formula
=TRIM(A2)
✔ Removes extra spaces from text
Example:
Excel Formula
" rahim khan "
✔ Result:
Excel Formula
"rahim khan"
Expert Way – PROPER Function
Excel Formula
=PROPER(A2)
✔ Converts text into proper case
Example:
Excel Formula
"rahim khan"
✔ Result:
Excel Formula
"Rahim Khan"
This trick helps you:
✔ Clean messy data
✔ Format names professionally
✔ Save time
✔ Work like an Excel expert
Perfect for:
✔ Employee records
✔ Student data
✔ Office work
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel ctrl e shortcut
excel trim formula
excel proper function
excel flash fill
excel text formatting
office excel pro
#️⃣ Hashtags






21/05/2026

Excel Expert Trick | Combine First & Last Names in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to combine first names and last names in a Microsoft Excel sheet using formulas and shortcuts instead of typing manually.
Beginners often write full names one by one, which is slow and repetitive.
Expert Way (Excel Formula)
Method 1: Using Ampersand (&)
Excel Formula
=A2&" "&B2
✔ A2 = First Name
✔ B2 = Last Name
✔ Combines names with space
Example:
A2 = Rahim
B2 = Khan
✔ Result = Rahim Khan
Method 2: Using CONCAT Function
Excel Formula
=CONCAT(A2," ",B2)
Method 3: Using TEXTJOIN Function
Excel Formula
=TEXTJOIN(" ",TRUE,A2:B2)
✔ Combines multiple names easily
Method 4: Flash Fill Shortcut
Press:
Excel Formula
Ctrl + E
✔ Auto combine names instantly
This trick helps you:
✔ Create full names quickly
✔ Save time
✔ Avoid manual typing
✔ Work like an Excel expert
Perfect for:
✔ Employee records
✔ Student data
✔ Office work
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel combine names
excel concat function
excel textjoin formula
excel merge first last name
excel expert tips
office excel pro
#️⃣ Hashtags






20/05/2026

Excel Expert Trick | Add Minutes to Time in Excel | Office Excel Pro

Welcome to Office Excel Pro.
In this video, you will learn an Excel Expert trick to add minutes to time in a Microsoft Excel sheet using formulas and shortcuts instead of calculating manually.
Beginners often count time manually, which can cause mistakes.
Expert Way (Excel Formula)
Method 1: Add Minutes to Time
Excel Formula
=A2+TIME(0,30,0)
✔ Adds 30 minutes to the time in A2
Example:
A2 = 10:15 AM
✔ Result = 10:45 AM
Method 2: Add Dynamic Minutes
Excel Formula
=A2+(B2/1440)
✔ B2 contains minutes value
✔ Excel converts minutes into time automatically
Example:
Time = 09:00
Minutes = 45
✔ Result = 09:45
Method 3: Quick Fill Shortcut
Press:
Excel Formula
Ctrl + Enter
✔ Apply formula to multiple cells instantly
This trick helps you:
✔ Calculate time quickly
✔ Save time
✔ Avoid manual calculation errors
✔ Work like an Excel expert
Perfect for:
✔ Employee schedules
✔ Attendance sheets
✔ Shift timing
✔ Excel learners
Learn more Excel shortcuts, formulas, Microsoft Word tricks, PowerPoint tips, and Microsoft Office productivity tutorials on Office Excel Pro.
🔎 Keywords
excel add minutes to time
excel time formula
excel time calculation
excel expert tips
microsoft excel tutorial
office excel pro
#️⃣ Hashtags






Address

Dhaka

Website

Alerts

Be the first to know and let us send you an email when Office Excel Pro posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category