![Computorism](/img/default-banner.jpg)
- 85
- 252 235
Computorism
India
Приєднався 28 бер 2019
Dear Friends,
Is channel mai aapko MS Office se jurre huye tutorial videos dikhai jaaygi, jisse aap bohut kuch sikh sakhte ho, apka skill bara sakhte ho.
Agar aapko mera kaam pasand aay to channel ko SUBSCRIBE jarur karna aur BELL ICON ko dabana mat vuliye ga ..
Contact Details :
Only for business purpose - easy01excel@gmail.com
Is channel mai aapko MS Office se jurre huye tutorial videos dikhai jaaygi, jisse aap bohut kuch sikh sakhte ho, apka skill bara sakhte ho.
Agar aapko mera kaam pasand aay to channel ko SUBSCRIBE jarur karna aur BELL ICON ko dabana mat vuliye ga ..
Contact Details :
Only for business purpose - easy01excel@gmail.com
reverse countifs | remove previous data & keep only updated data | excel tricks
In this video we will learn how to use countifs function in different way.
#reverse_countifs
#computorism #excel #exceltrick #excelfunction
#reverse_countifs
#computorism #excel #exceltrick #excelfunction
Переглядів: 279
Відео
Excel week number of the month | Get week number from date in excel
Переглядів 40 тис.2 роки тому
In this video we will learn how to find week number of the month, how an excel formula to get the week of the month #computorism #excel #exceltrick #excelfunction
Excel getpivotdata function | Use getpivotdata function to pull data from a pivot table
Переглядів 2762 роки тому
In this video we will learn how to use getpivotdata function to pull data from a pivot table. @computorism1508 #pivot_table #excel #function #getpivotdata
Dynamic Calendar || create calendar in excel || dynamic excel calendar
Переглядів 1852 роки тому
In this video we will learn how to create a dynamic calendar in excel. @computorism1508 #excel #dynamiccalender #calendarinexcel Weekday function - ua-cam.com/video/pSTNfADzwIs/v-deo.html Drop down list - ua-cam.com/video/qQ_9jYiXjgA/v-deo.html Custom data validation - ua-cam.com/video/4urHloxt82E/v-deo.html Data validation - ua-cam.com/video/8lDM9AjMnbo/v-deo.html
How to transpose excel data | transpose function | how to rotate half data in excel
Переглядів 3682 роки тому
In this video we will learn how to transpose excel data !! how to rotate half data in excel ?? @computorism1508 #excel #inexcel #transposefunction #convertrowstocolumns
Distinct count in pivot table | how to find unique count in pivot table
Переглядів 7883 роки тому
In this video we will learn how to apply distinct count in pivot table, how to find unique count in pivot table in excel. @computorism1508 #distinctcount #pivottable #excel
Auto refresh pivot table | Refresh pivot table automatically
Переглядів 1043 роки тому
In this video we will learn how to auto refresh pivot table or refresh a pivot table automatically @computorism1508 #excel #pivottable #autorefresh
pivot table wizard in excel | how to create a pivot table from multiple data
Переглядів 1,7 тис.3 роки тому
In this video we will learn what is pivot table wizard in excel, how to create a pivot table from multiple data range @computorism1508 #pivottable #wizardpivottable #excell
Paste special in excel | columns to rows excel | data transpose | remove formula in excel
Переглядів 1,3 тис.3 роки тому
In this video we will learn what is paste special in excel, what is data transpose, how to convert columns to rows excel, how to remove formula. how to create link how to add/subtract/multiply/divide a value how to remove formula how to delete all the notes or comments at a time how to paste format only how transpose the data (Columns to rows // row to columns) how to paste a data with skip bla...
Aggregate function in excel || How to apply aggregate function in excel in hindi
Переглядів 1,8 тис.3 роки тому
In this video we will learn how to apply aggregate function in excel in hindi which is one of the most useful functions in excel . @computorism1508 #aggregate #function #formula #excel Google sheets Introduction - ua-cam.com/video/9TKg7zOxkBw/v-deo.html
Subtotal function in excel || subtotal formula in excel in hindi
Переглядів 1,3 тис.3 роки тому
Subtotal function in excel || subtotal formula in excel in hindi
Flash fill in excel | flash fill not working | how to enable or disable flash fill [Hindi]
Переглядів 18 тис.3 роки тому
Flash fill in excel | flash fill not working | how to enable or disable flash fill [Hindi]
Delete blank rows and columns in excel (Hindi) | Delete all blank rows | Delete all blank columns
Переглядів 10 тис.3 роки тому
Delete blank rows and columns in excel (Hindi) | Delete all blank rows | Delete all blank columns
Google sheets | offline google sheets | share google sheets | version history in google sheets
Переглядів 2233 роки тому
Google sheets | offline google sheets | share google sheets | version history in google sheets
Iferror with vlookup in excel in hindi | Multiple vlookup with multiple iferror in excel
Переглядів 2,3 тис.3 роки тому
Iferror with vlookup in excel in hindi | Multiple vlookup with multiple iferror in excel
Weekday function in excel | Calculate day wise total | Restriction on date | If with Weekday
Переглядів 5333 роки тому
Weekday function in excel | Calculate day wise total | Restriction on date | If with Weekday
Custom data validation in excel | how to restrict special characters in excel
Переглядів 4,2 тис.3 роки тому
Custom data validation in excel | how to restrict special characters in excel
Concatenate multiple cells in excel || how to merge a large data in excel || computorism
Переглядів 1,4 тис.3 роки тому
Concatenate multiple cells in excel || how to merge a large data in excel || computorism
Data validation with vlookup || Drop down list with vlookup || Computorism
Переглядів 1,6 тис.3 роки тому
Data validation with vlookup || Drop down list with vlookup || Computorism
Pivot chart in excel (Part 2) | Link chart title to cell | Save chart template & use again
Переглядів 1,5 тис.3 роки тому
Pivot chart in excel (Part 2) | Link chart title to cell | Save chart template & use again
Pivot chart in excel (Part 1) || Computorism
Переглядів 9753 роки тому
Pivot chart in excel (Part 1) || Computorism
How to insert an object in excel || MS excel insert object || Computorism
Переглядів 1,2 тис.3 роки тому
How to insert an object in excel || MS excel insert object || Computorism
EazyExcel is now Computorism (NAME CHANGED)
Переглядів 1503 роки тому
EazyExcel is now Computorism (NAME CHANGED)
Data validation in excel || Create restrictions by using data validation
Переглядів 1 тис.3 роки тому
Data validation in excel || Create restrictions by using data validation
Drop Down List in Excel || Create A Drop Down List That Automatically Updates With New Data
Переглядів 4734 роки тому
Drop Down List in Excel || Create A Drop Down List That Automatically Updates With New Data
Date picker in excel (Hindi) | how to add a calendar in excel
Переглядів 2,3 тис.4 роки тому
Date picker in excel (Hindi) | how to add a calendar in excel
Wildcard with IF function | Excel IF function with partial match (Hindi)
Переглядів 2,4 тис.4 роки тому
Wildcard with IF function | Excel IF function with partial match (Hindi)
Search function in excel | Excel search function in hindi.
Переглядів 1434 роки тому
Search function in excel | Excel search function in hindi.
IS logical function in excel in hindi , Excel logical function
Переглядів 9984 роки тому
IS logical function in excel in hindi , Excel logical function
Delhi - 4000 Unit
Text wala formula use krne ke baad bhi * aur ~` ye special characters allow ho rahe hain to ise kaise remove kre pls reply ?
Thankyou so much 👍
Sir is video main Jo ap nay apply kaya good usay bad data adjustment kasay karay us pay bhi video share karay
Apply HLOOKUP Function with range_lookup FALSE or True for the above data. First Last DOB Age Segment Sophia Collins 23-09-1978 43 Mature Evelyn Bennett 14-02-1967 54 Mature Geneva Allen 06-06-1990 31 Young Silvia Walsh 30-05-1983 38 Young Katrina Rodriquez 23-12-1998 23 Young Sandy Day 24-07-1973 48 Mature Dallas Roberts 12-06-1952 69 Senior Jamie Harrington 22-08-1958 63 Senior Jermaine Shelton 23-10-1977 44 Mature Freddie Baker 12-05-1968 53 Mature Nattie Pearson 03-01-2002 20 New ONNU HELP CHEYYO
Great
Thanks a lot , me bhohot silly mistake karaha tha is video ne meri problem solve kardi
Thank you soo much
If i need to 1st April - 7th April as week 1 ...what us formula
Flash fill agar ho option😮😮😮😮
Automatically flash fill option is not visible.
thansk bro for saving my time
Very helpful video
thanks for this
very good
nice explanation, thanks
File clos karke fir open karne par vo nahi chalta vapas add karna padta hai
Perfect
Ek number thank you 🙏
Iss function ko apne teb mai se kaise hataye
😮😮
Very useful
❤very helpful
😊
very useful & explained excellently! Thanks !!
you are great sir your all videos are very important, you have very exelent knowledge of ms office
Very very helpful 😊
Row delete ho gyi h , columns delete nhi ho rhe
Very nicely explained and in detail
Superb ❤
Great information
HI SIR HOW TO DO RECONSILATION IF IN THIS FORMAT FOR EG... BTR/20-21/1234 BTR1234 HOW TO MATCH THIS EXXON MOBILE EXON MOBILE DFG/FY18-19/B12345 DFG/18-19/12345 PLS LET ME KNIOW HOW TO DO RECO...
excellent 👏👌
Thank you so much. You saved me today on my office presentation.
Hello, I wanted week of the year information. eg Jan 1st to 7th week-1 and Dec 25th - 31st week-52 .how to get that ?
Did you get an answer? Coz even I had the same doubt
@@shruteekhot1483 Nope
Hi, you can use "Week "& before the formula. for example ="Week "&WEEKNUM(A2), and the results is Week 1. Don't forget to put space between week and ". Hope it helps!
Weeknum function might help
Thanks used in office today
This option is not there in office 2010
This option was present from 2013 version onwards
hamara nhi hora h split data ,, CTRL E se😔
Sir aap bahut fast btate ho kuch samjh nhi aata hai
Apart from IF formula? How to do
Sir, I have one doubt, I want next date with respect to week from today..how can we put that formula For example...Today date, I will mention only weeks (like 24 weeks) it should count next date ...
Please guide me
But words aur sub kuch ekjitna hoga tohi wild card use hoga bill no ke case me .8 9 lag laga row me data hoga to kaise hoga ?? Mark se please explain
Bhai thank you yaar
Thank you for this vedio it'd saved my time
Thank you for watching.
Very nice 👌👌👌👌
Ossome brother
Thank you for watching. 😊
plz share this file for practice
You can use "Left or Right" in lookup if the look up has same number of digits
Thankyou. This is helpful
Very much informative video sir No one in UA-cam has cleared this concept so beautifully and conceptually
Thank you for watching. Keep supporting 😊
Nice