TEKNISHA
TEKNISHA
  • 161
  • 7 254 177
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_
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
How to Add Days to Dates in Excel
zhlédnutí 70KPřed 2 lety
How to Add Days to Dates in Excel
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
Automatic Serial Number in Excel
zhlédnutí 89KPřed 2 lety
Automatic Serial Number in Excel
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

Komentáře

  • @naughtyboy1500
    @naughtyboy1500 Před 4 hodinami

    i still dont get this ...

  • @antsco1email
    @antsco1email Před 21 hodinou

    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

  • @skiyer0120
    @skiyer0120 Před dnem

    How to autohide hyperlinked buttons and show it again for full screen preview?

  • @LifeinBrooklyn-lp8mj

    This is great! I wish I could add notes to it.

  • @jwink7795
    @jwink7795 Před 2 dny

    how can we do it? lets get to it! love it, mucho gracias good sirrr

  • @ZOMBOLO
    @ZOMBOLO Před 2 dny

    what if the check out time was the next day?

  • @jonaking3203
    @jonaking3203 Před 3 dny

    Thanks for this. Very helpful.

  • @saadsayed9025
    @saadsayed9025 Před 4 dny

    It Doesnt Work

  • @zulkarnaens
    @zulkarnaens Před 4 dny

    NOT AUTOMATIC, BUT MANUAL FIX IT

  • @umairahmed5171
    @umairahmed5171 Před 5 dny

    Is there any system which can display the birthday on tv

  • @sanjaykanna7310
    @sanjaykanna7310 Před 7 dny

    Formula is ok .but pls explain the terms cells values for identification .as that is times or minutes or seconds..

  • @surekhakatakam3523
    @surekhakatakam3523 Před 7 dny

    Vba code ela tisukovali mana syste

  • @teandreluta2039
    @teandreluta2039 Před 7 dny

    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?

  • @khushigupta6393
    @khushigupta6393 Před 9 dny

    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!!

  • @kattrinasuen
    @kattrinasuen Před 12 dny

    Teaching clearly, very well!

  • @zevoerakhodabaks5400
    @zevoerakhodabaks5400 Před 13 dny

    Thank you sooo much! Greetings from Suriname

  • @jasonsimmons4848
    @jasonsimmons4848 Před 14 dny

    From beginning to end really simple to understand, thank you, subscribed. amazing for finance tracking

  • @pakbet371
    @pakbet371 Před 15 dny

    How come the total hours from 8am-5:15pm is 9:25 and 8:15am-5pm is 8.75?

  • @nmlbajaj
    @nmlbajaj Před 15 dny

    Very helpful ! Thank you so much !

  • @adriel2nd
    @adriel2nd Před 16 dny

    thank you sir i almost failed my fomputer fclaxss

  • @tedmoy
    @tedmoy Před 16 dny

    Great video!

  • @Love-iv5vq
    @Love-iv5vq Před 20 dny

    Do you know how to match name and amount to another name and amount that has duplicate transaction and sometimes same amount.

  • @ewilner
    @ewilner Před 21 dnem

    Do you have a sheet I can download?

  • @anilreddy2415
    @anilreddy2415 Před 21 dnem

    How to send massages to particular group ?

  • @rasheednayakkan6750
    @rasheednayakkan6750 Před 23 dny

    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.

  • @UmarHassan-ez9el
    @UmarHassan-ez9el Před 23 dny

    Thank you very much helpimg us

  • @04095875
    @04095875 Před 24 dny

    Just what I needed. thank you so much 🙂

  • @norsazli71
    @norsazli71 Před 25 dny

    What if we want to exclude cells having 0 values as min?

  • @TeamCidroTV
    @TeamCidroTV Před 25 dny

    Thank you It's helpful and very easy to understand :)

  • @Nithiyananthan1
    @Nithiyananthan1 Před 25 dny

    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 💯

  • @ronnelmacompas1647
    @ronnelmacompas1647 Před 26 dny

    Thank you

  • @richi5389
    @richi5389 Před 26 dny

    This can send image from gsheet to wa sir?

  • @sunilyaadav72
    @sunilyaadav72 Před 27 dny

    excellent

  • @harvi7106
    @harvi7106 Před 28 dny

    That’s very simple

  • @rajeshdhawan1
    @rajeshdhawan1 Před 28 dny

    Thanks

  • @funmigbokoyi6185
    @funmigbokoyi6185 Před 29 dny

    Very simple and straight to the point, Thank you!

  • @farhadentertainmentltd.3946

    Thank you so much !! Very helpful

  • @srijansaha7212
    @srijansaha7212 Před měsícem

    How come 75? when minute counting by 60?

  • @Animesh_Goyal
    @Animesh_Goyal Před měsícem

    Hats off to you!

  • @caliwarebath
    @caliwarebath Před měsícem

    Can we use it on different sheets?

  • @letthemgth
    @letthemgth Před měsícem

    what if I have to find common item from more than 2 columns?

  • @Annie-vn3nx
    @Annie-vn3nx Před měsícem

    THANK YOU

  • @easypeasy7875
    @easypeasy7875 Před měsícem

    08.75 75 Is Wrong my dear

  • @AntiSocialAries
    @AntiSocialAries Před měsícem

    thank you so much sir. your video really solved my issue as i was struggling for hours.

  • @Arham-gk5sd
    @Arham-gk5sd Před měsícem

    I was not founding sequence, i just saw this, absolutely fine❤🎉

  • @jigneshram88
    @jigneshram88 Před měsícem

    Wow very usefull for me as a teacher thanx

  • @abhashtripathi9234
    @abhashtripathi9234 Před měsícem

    Is it possible to connect different sheet data to make marksheet

  • @syedahmad143
    @syedahmad143 Před měsícem

    If i put b5 it gives error, if i add b6 it shows exact match.(In array)

  • @dhananjaymalhotra7854
    @dhananjaymalhotra7854 Před měsícem

    I don't know why did you put background music in this video. Anyways, thanks for the video.

  • @ramijmullick4687
    @ramijmullick4687 Před měsícem

    Friday 8:75 how😂