Home
About Us
Services
MusiBingo
Videos
Downloads
Contact Us
Home
About Us
Services
MusiBingo
Videos
Downloads
Contact Us
Master Your Skills: Explore Our Tutorials, Tips & Tricks
Housie Game in Excel
Select and Copy Visible cells 4 ways
COUNT CELL WORD AND CHARACTER
DATA VALIDATION in Excel
FILL SERIES | Generate Series
COUNT ODD AND EVEN NUMBER
Record Macro in Excel | Macro | How to Record Macro in Excel
Number in words in excel | Add-ins of Number in words
SUMPRODUCT with filter
Long footer in Excel | Footer more then 255 character in excel (1103)
Highlight active cell row column and both (1102)
Sumifs with Date Range (1100)
Numbers Lakh Crore in Excel | Number Format with condition | Number Lacs | Number in Crores (1099)
HIGHLIGHT BLANK AND FORMULA CELLS (1098)
EMI CALCULATION | MATURITY / FUTURE VALUE OF FD / RD / SIP (1097)
SUMIF WITH COLOUR (1096)
TIME ROUND IN 10/15/30 MINUTES (1095)
AVERAGE AND WEIGHTED AVERAGE (1094)
WATERMARK IN EXCEL | Watermark Image or Logo in Excel (1093)
SUM HOUR MINUTES || Right way to SUM hour:Minute (1092)
PERCENT || PERCENTRANK || PERCENTILE
SUM SQUARE function in Excel
TYPE FILE NAME / SHEET NAME IN CELL WITH OR WITHOUT PATH
Create PDF of Selected Range
COUNT UNIQUE ENTRIES
SUM POSITIVE AND NEGATIVE NUMBER SEPARATELY
PICK RANDOM NAME FROM THE LIST
Sum even if ERROR in data
Sort Data | Alphabetically | Automatically | using Formula in MS Office
Insert Blank Row between Two Data Rows
Find last value | Vlookup
Convert Number from Text Format into Number Format
Find whether Number or Text in the Cells | Three Tricks
Auto Transfer Data from Master to Individual Sheets | Amazing Trick
Hide ZERO Value in Excel | 4 Tricks to Hide Zero
TRANSPOSE with Data Linked
MINUS SIGN AND PRINT ZERO WITH COLOUR
CUSTOM DATA VALIDATION
Highlight Row with other reference | Conditional Formatting
SEAT BOOKING without VBA | Multiple Conditional Formatting | Drop Down List | CountIF
SPLIT WORKSHEETS INTO SEPARATE FILE
ISNUMBER | DOUBLE VLOOKUP
Google Sheet | Work in one Excel file at different locations and different USERS at a time
CHOOSE FUNCTION
SEGREGATE MIS-MATCH DATA
Age / Tenure Calculation | DATEDIF Function in Excel
FIXED AND ROUND FUNCTIONS IN EXCEL
Picture Lookup | Create ID Card
INVENTORY MANAGEMENT IN EXCEL | Stock Register in Excel
FIND UNIQUE NAMES
Time Calculation | Working Hour and Overtime Calculation
DGET | VLOOKUP | INDEX+MATCH
HIGHLIGHT ALTERNATE ROW | Conditional Formatting with ROW + MOD
D-FUNCTIONS | DSUM | DAVERAGE | DCOUNT | DMIN | DMAX
OFFSET \ Offset Function with COUNTA SUM AVERAGE MATCH
SUMPRODUCT in Excel
REVERSE THE NAME | IF | CONCATENATE
DATA SOLVER in Excel |Data Solver add-in
RIGHT WAY TO FIND PROPER RANK
SHEET FUNCTIONS | Create Multiple sheet from List
SORT | DATA SORTING
Advanced Filter with Searchable key | Data Filter in another Sheet
Add and Remove Prefix Mr Mrs Ms before Name
Data Consolidation | Multiple Sheets & Multiple Files | 3-D Formulas
Holiday Calendar | Conditional Formatting with Vlookup and weekday Formulas
Count Net working days | Count Actual Working Days Excluding Weekly Off and Holiday
Multiple row in single cell
Text to Column
Flash Fill
Find Number from TEXT | Get Number from TEXT
Filter with correct serial number and SUM
Goal seek | Find Desired Value | What If Analysis
Mail Merge | Excel | Word
Text Functions | LEFT RIGHT MID LEN TRIM PROPER UPPER
Blank Fill | Repeat Data
Generate Random Number/ RAND & RANDBETWEEN
BAR CODE | BAR CODE IN EXCEL
CHECKBOX | Conditional Formatting
TICK SYMBOL | ICON SET | CONDITIONAL FORMATTING
IF AND OR MIN MAX | MULTIPLE IF
COUNT FUNCTIONS | COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS
Paste Special in Excel | Paste Value | Copy Paste
Vlookup Formula in Excel | Best Video for Vlookup
Custom Format in Excel | Display Number Lakh into Crores in Excel
Measurement conversion in excel | Search | MID MOD ABS LEFT INT CONVERT IFERROR
Link and Hyper link in Excel | Button In Excel | How to use Link in excel
1020 : Due Date diary in excel | Birthday diary in Excel
1016 : Password in Excel | Password in Excel Sheet and range | protection in Excel sheet and Range
1019 : Slicer and Filter in Excel | Filter from Slicer in Excel
1018 : Pivot Table in Excel | Auto Refresh in Pivot Table | Pivot Table with Auto Refresh
1015 : Hand written or typed image or PDF convert in Word | Translate PDF file in other Language
1014 : Speech to TEXT and translate | Hindi me bole and type in English me
1013 : GST Invoice free download excel file | Automatic GST Invoice in Excel
1012 : GST Invoice | Searchable Drop Down List for multiple sheet | Number convert in word
1011 : Searchable drop down list for multiple cells in excel in Hindi | Drop down list in Excel
1010 : Subtotal Functions in Excel in Hindi | Sum when Filter active
1007 : Date Function and DATEDIF Function | Find Age in Excel | Calendar in Excel
1006 : Advanced Multiple Conditional Formatting in Excel | Learn Conditional formatting in excel
1005 : Advanced Multiple Conditional Formatting in Excel | Learn Conditional Formatting in Excel
1004 : Round Mround Roundup Rounddown ceiling floor | Learn All functions of round in excel
1003 : Add ZERO before number in Excel | convert TEXT to VALUE | Convert Value to TEXT in Excel
1002 : Vlookup and Reverse Lookup | Index+Match | GST Invoice in Excel
1001 : Powerful SUMIFS formula in Excel | Effective MIS through Sumifs in Excel
