![TEKNISHA](/img/default-banner.jpg)
- 161
- 7 254 177
TEKNISHA
United States
Registrace 12. 10. 2011
My Name is Bharath and I have created this channel to share helpful Tutorials and Tech Reviews. Things you can expect by subscribing to this channel are tutorials on Productivity tools like Microsoft Excel, Powerpoint and Google Sheets. You will also see Tech reviews of Gadgets and Apps from time to time.
I'm currently based in India. I'm always open to connect and answer any questions. Feel Free to reach me on Social media, and if you want to contact me for business purposes, you can reach me and my team at bharath@teknisha.com!!
Cheers
Bharath
I'm currently based in India. I'm always open to connect and answer any questions. Feel Free to reach me on Social media, and if you want to contact me for business purposes, you can reach me and my team at bharath@teknisha.com!!
Cheers
Bharath
How to use IFS Function in Excel instead of Nested IF
The IF function is one of the most popular functions in Excel. But writing nested Excel IF formulas in situations when more than 1 condition has to be checked can become cumbersome. If you have Excel 2019 or Microsoft 365 you can use the Excel IFS function instead.
Software Tools/Products by Teknisha:
🔷 gumroad.com/teknisha🔷
Recommended Gadgets/Products:
www.amazon.in/shop/teknisha
Must Watch Playlists..
Excel Tutorials:
czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html
Excel Chart Tutorials:
czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html
Excel Pivot Table Tutorials:
czcams.com/play/PLYgkGmaySmNPsV-UGWNrQ_qajppDj4eDc.html
Excel Gsuite Tutorials:
czcams.com/play/PLYgkGmaySmNNTF378MP6c_ZMUKnF1DgIS.html
Excel Tips & Tricks:
czcams.com/play/PLYgkGmaySmNPnRMwHZvdWqB4eGN8NwL1O.html
Powerpoint Tutorials:
czcams.com/play/PLYgkGmaySmNO_UKJrd0UD--uEQjWD8okB.html
App Reviews: czcams.com/play/PLYgkGmaySmNNxgNXZMDkjdL3judwIjwBy.html
Gadget Reviews:
czcams.com/play/PLYgkGmaySmNPeBw0TPZmySVQaTz4dojhA.html
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: Teknisha/
👉Instagram: teknisha_
Software Tools/Products by Teknisha:
🔷 gumroad.com/teknisha🔷
Recommended Gadgets/Products:
www.amazon.in/shop/teknisha
Must Watch Playlists..
Excel Tutorials:
czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html
Excel Chart Tutorials:
czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html
Excel Pivot Table Tutorials:
czcams.com/play/PLYgkGmaySmNPsV-UGWNrQ_qajppDj4eDc.html
Excel Gsuite Tutorials:
czcams.com/play/PLYgkGmaySmNNTF378MP6c_ZMUKnF1DgIS.html
Excel Tips & Tricks:
czcams.com/play/PLYgkGmaySmNPnRMwHZvdWqB4eGN8NwL1O.html
Powerpoint Tutorials:
czcams.com/play/PLYgkGmaySmNO_UKJrd0UD--uEQjWD8okB.html
App Reviews: czcams.com/play/PLYgkGmaySmNNxgNXZMDkjdL3judwIjwBy.html
Gadget Reviews:
czcams.com/play/PLYgkGmaySmNPeBw0TPZmySVQaTz4dojhA.html
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: Teknisha/
👉Instagram: teknisha_
zhlédnutí: 307
Video
Excel Tutorial to Clean Calculation Errors!!
zhlédnutí 1,3KPřed 3 měsíci
Check this super simple tutorial to clean your calculation errors Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Pivot Table Tutorials: czcams.c...
Excel Conditional Formatting with Formula. Highlight Rows based on a cell value
zhlédnutí 257Před 4 měsíci
This tutorial shows you how to dynamically format cells and rows based on other cell values Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Pivot...
Create an Organizational Chart in less than 5 mins!!
zhlédnutí 754Před 6 měsíci
In this easy tutorial, Learn how to create an organizational chart quickly!! 🔶 Get the Practice Excel File Here : 🔶 Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8...
Excel, Easily Create Dependent Drop Down Lists using Xlookup. Tutorial
zhlédnutí 641Před 6 měsíci
A Quick Excel Tutorial of Dependent Drop down list (The options in the DROP DOWN list changes based on the cell value) 🔶 Get the Practice Excel File Here : 🔶 Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: c...
Excel FILTER Function TRICK for Non Adjacent Columns
zhlédnutí 2,9KPřed 11 měsíci
Want to learn a cool Excel trick? I'll show you a simple way to use Excel's Filter Function. This trick lets you display items from columns that aren't next to each other. Imagine you have a table with 8 columns, but you're only interested in info from columns 2 and 5 - they're not next to each other. You don't want everything from these columns, just specific things that meet certain rules. An...
Add Borders Automatically to Cells in Excel
zhlédnutí 685Před rokem
In this tutorial video, learn a quick and easy way to automatically generate borders in cells in excel. Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html...
Excel Number Formatting: Thousands & Millions
zhlédnutí 404Před rokem
Demystifying Numbers: Displaying Thousands and Millions Made Easy! Watch as we guide you step-by-step through techniques to present large figures clearly. Whether you're dealing with finances, data analysis, or simply want to enhance your Excel skills, this tutorial will empower you to skillfully format numbers for maximum impact. Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Rec...
Excel Data Magic: From 1D to 2D with a Single Formula!
zhlédnutí 822Před rokem
Discover the power of a single Excel formula that effortlessly converts 1D data into insightful 2D visualizations. Unveil hidden patterns and trends by watching this tutorial. Elevate your data manipulation game and create impactful presentations with ease. Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists...
Easy Excel: Filter by Cell Color Tutorial 🎨🔍
zhlédnutí 396Před rokem
Learn how to filter data by cell color in Excel! Our step-by-step tutorial makes it easy to sort and analyze information with colorful precision. Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/pl...
Excel VSTACK & HSTACK Tutorial: Combine Data from Multiple Sheets
zhlédnutí 785Před rokem
In this comprehensive Excel VSTACK/HSTACK tutorial, you'll learn how to become a data manipulation master! Discover the power of VSTACK and HSTACK functions to efficiently organize and combine data vertically and horizontally. Explore step-by-step examples and practical use cases to enhance your spreadsheet skills. Unlock Excel's true potential and optimize your data handling today! Software To...
Excel TAKE Function: Master Data Extraction
zhlédnutí 316Před rokem
Learn how to leverage Excel's powerful TAKE function in this comprehensive tutorial! Discover how to efficiently extract data from your spreadsheets, filter specific elements, and optimize your workflow. Unlock the potential of TAKE in just a few minutes and streamline your data analysis tasks like a pro! Don't miss it! Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Ga...
Excel Dynamic Charts : Top 5 Values & Others
zhlédnutí 477Před rokem
In this tutoiral learn how to plot Top n items along with Others (remaining items) on a chart Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: czcams.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Piv...
Excel Forecasting: Data Analysis & Predictive Modeling Tutorial
zhlédnutí 584Před rokem
Learn Excel forecasting and predictive modeling in this comprehensive tutorial. Master data analysis techniques and unlock the power to make accurate predictions using Excel's functions and tools. Software Tools/Products by Teknisha: 🔷 gumroad.com/teknisha🔷 Recommended Gadgets/Products: www.amazon.in/shop/teknisha Must Watch Playlists.. Excel Tutorials: czcams.com/play/PLYgkGmaySmNPu0Ur4iURVCEe...
Create Dynamic Charts in Excel Easily, using a New Formula/Function
zhlédnutí 3,5KPřed rokem
Excel Chart Tutorials: Learn how to create dynamic chart ranges in Microsoft Excel. This way you can create a perfect chart even when the data range gets bigger or smaller based on criteria. No more white space or empty spaces in your chart. If you have this in place, and you create an Excel chart based on this range, the chart will automatically adjust as the range gets smaller or longer. This...
Excel Tutorial to Sort Data Automatically using a Function
zhlédnutí 12KPřed rokem
Excel Tutorial to Sort Data Automatically using a Function
Excel Dynamic FILTER Function to Return Multiple Values
zhlédnutí 2,3KPřed rokem
Excel Dynamic FILTER Function to Return Multiple Values
New TEXTSPLIT Function in Excel to Separate words and lists
zhlédnutí 656Před rokem
New TEXTSPLIT Function in Excel to Separate words and lists
Create Dynamic Target Line for Excel Charts
zhlédnutí 760Před rokem
Create Dynamic Target Line for Excel Charts
How to use the New Excel TEXTBEFORE & TEXTAFTER Functions to split Names
zhlédnutí 2,2KPřed rokem
How to use the New Excel TEXTBEFORE & TEXTAFTER Functions to split Names
SAT Exam Prep Tool with 1000 Words List
zhlédnutí 315Před 2 lety
SAT Exam Prep Tool with 1000 Words List
Excel Sum based on multiple conditions using 1 formula
zhlédnutí 1,7KPřed 2 lety
Excel Sum based on multiple conditions using 1 formula
Excel Countif with wildcard (*) character
zhlédnutí 3,1KPřed 2 lety
Excel Countif with wildcard (*) character
How to Create QR Codes in Excel without VBA (Free & Simple)
zhlédnutí 1,1KPřed 2 lety
How to Create QR Codes in Excel without VBA (Free & Simple)
Progress Circle Chart Infographics in Excel Dashboard
zhlédnutí 25KPřed 2 lety
Progress Circle Chart Infographics in Excel Dashboard
Split Cells Diagonally in Excel - (Two Headers in Same Cell)
zhlédnutí 64KPřed 2 lety
Split Cells Diagonally in Excel - (Two Headers in Same Cell)
How to Calculate Hours Worked in Excel
zhlédnutí 545KPřed 2 lety
How to Calculate Hours Worked in Excel
Difference in Find() and Search() Functions in Excel
zhlédnutí 1KPřed 2 lety
Difference in Find() and Search() Functions in Excel
i still dont get this ...
mi hai salvato. grazie. mi serviva proprio per il lavoro e comparare due elenchi con migliaia di nomi e far uscire fuori solo i diversi. grazie mille
How to autohide hyperlinked buttons and show it again for full screen preview?
This is great! I wish I could add notes to it.
how can we do it? lets get to it! love it, mucho gracias good sirrr
what if the check out time was the next day?
Thanks for this. Very helpful.
It Doesnt Work
NOT AUTOMATIC, BUT MANUAL FIX IT
Is there any system which can display the birthday on tv
Formula is ok .but pls explain the terms cells values for identification .as that is times or minutes or seconds..
Vba code ela tisukovali mana syste
Just a quick question, hopefully you see this. What happens if there was no check in details EG if the cells are black? Applying your formula gives me a 24 result as no hours are calculated. Is there a If OR IsBlank function to make it a zero?
Love it! thank you sir! i love learning about excel and various new techniques from your channel please do not stop making this content!! it is so helpful!!
Teaching clearly, very well!
Thank you sooo much! Greetings from Suriname
From beginning to end really simple to understand, thank you, subscribed. amazing for finance tracking
How come the total hours from 8am-5:15pm is 9:25 and 8:15am-5pm is 8.75?
Very helpful ! Thank you so much !
thank you sir i almost failed my fomputer fclaxss
Great video!
Do you know how to match name and amount to another name and amount that has duplicate transaction and sometimes same amount.
Do you have a sheet I can download?
How to send massages to particular group ?
Hi - I have a data set in which the year 2023, 2024 in every alternative columns and products in rows. I wanted to sum basis of the number of days (when days get change) in both of the year. Can you advise which formulae to be used for this. I tried sum+offset + index + match formula but the total is not matching when I checked manually.
Thank you very much helpimg us
Just what I needed. thank you so much 🙂
What if we want to exclude cells having 0 values as min?
Thank you It's helpful and very easy to understand :)
Please check the table manually 8:00AM - 5:15PM = 9.15 8:15AM - 5:00PM = 8.45 7:30AM - 2:00PM = 6.30 I'm still waiting for the perfect formula or function 💯
Thank you
This can send image from gsheet to wa sir?
excellent
That’s very simple
Thanks
Very simple and straight to the point, Thank you!
Thank you so much !! Very helpful
How come 75? when minute counting by 60?
Hats off to you!
Can we use it on different sheets?
what if I have to find common item from more than 2 columns?
THANK YOU
08.75 75 Is Wrong my dear
thank you so much sir. your video really solved my issue as i was struggling for hours.
I was not founding sequence, i just saw this, absolutely fine❤🎉
Wow very usefull for me as a teacher thanx
Is it possible to connect different sheet data to make marksheet
If i put b5 it gives error, if i add b6 it shows exact match.(In array)
I don't know why did you put background music in this video. Anyways, thanks for the video.
Friday 8:75 how😂