TEKNISHA
TEKNISHA
  • 161
  • 7 235 751
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:
ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html
Excel Chart Tutorials:
ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html
Excel Pivot Table Tutorials:
ua-cam.com/play/PLYgkGmaySmNPsV-UGWNrQ_qajppDj4eDc.html
Excel Gsuite Tutorials:
ua-cam.com/play/PLYgkGmaySmNNTF378MP6c_ZMUKnF1DgIS.html
Excel Tips & Tricks:
ua-cam.com/play/PLYgkGmaySmNPnRMwHZvdWqB4eGN8NwL1O.html
Powerpoint Tutorials:
ua-cam.com/play/PLYgkGmaySmNO_UKJrd0UD--uEQjWD8okB.html
App Reviews: ua-cam.com/play/PLYgkGmaySmNNxgNXZMDkjdL3judwIjwBy.html
Gadget Reviews:
ua-cam.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_
Переглядів: 253

Відео

Excel Tutorial to Clean Calculation Errors!!
Переглядів 1,3 тис.3 місяці тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Pivot Table Tutorials: ua-cam.c...
Excel Conditional Formatting with Formula. Highlight Rows based on a cell value
Переглядів 2534 місяці тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Pivot...
Create an Organizational Chart in less than 5 mins!!
Переглядів 7535 місяців тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8...
Excel, Easily Create Dependent Drop Down Lists using Xlookup. Tutorial
Переглядів 6356 місяців тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: u...
Excel FILTER Function TRICK for Non Adjacent Columns
Переглядів 2,9 тис.11 місяців тому
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
Переглядів 671Рік тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html...
Excel Number Formatting: Thousands & Millions
Переглядів 404Рік тому
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!
Переглядів 812Рік тому
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 🎨🔍
Переглядів 395Рік тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/pl...
Excel VSTACK & HSTACK Tutorial: Combine Data from Multiple Sheets
Переглядів 774Рік тому
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
Переглядів 316Рік тому
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
Переглядів 466Рік тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEeVS5tqb2ve.html Excel Chart Tutorials: ua-cam.com/play/PLYgkGmaySmNP9YC2fKOOdZm3u8DbKivac.html Excel Piv...
Excel Forecasting: Data Analysis & Predictive Modeling Tutorial
Переглядів 576Рік тому
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: ua-cam.com/play/PLYgkGmaySmNPu0Ur4iURVCEe...
Create Dynamic Charts in Excel Easily, using a New Formula/Function
Переглядів 3,4 тис.Рік тому
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
Переглядів 12 тис.Рік тому
Excel Tutorial to Sort Data Automatically using a Function
Excel Dynamic FILTER Function to Return Multiple Values
Переглядів 2,3 тис.Рік тому
Excel Dynamic FILTER Function to Return Multiple Values
New TEXTSPLIT Function in Excel to Separate words and lists
Переглядів 653Рік тому
New TEXTSPLIT Function in Excel to Separate words and lists
Create Dynamic Target Line for Excel Charts
Переглядів 760Рік тому
Create Dynamic Target Line for Excel Charts
How to use the New Excel TEXTBEFORE & TEXTAFTER Functions to split Names
Переглядів 2,2 тис.Рік тому
How to use the New Excel TEXTBEFORE & TEXTAFTER Functions to split Names
How to Add Days to Dates in Excel
Переглядів 69 тис.2 роки тому
How to Add Days to Dates in Excel
SAT Exam Prep Tool with 1000 Words List
Переглядів 3152 роки тому
SAT Exam Prep Tool with 1000 Words List
Excel Sum based on multiple conditions using 1 formula
Переглядів 1,7 тис.2 роки тому
Excel Sum based on multiple conditions using 1 formula
Excel Countif with wildcard (*) character
Переглядів 3 тис.2 роки тому
Excel Countif with wildcard (*) character
How to Create QR Codes in Excel without VBA (Free & Simple)
Переглядів 1,1 тис.2 роки тому
How to Create QR Codes in Excel without VBA (Free & Simple)
Progress Circle Chart Infographics in Excel Dashboard
Переглядів 25 тис.2 роки тому
Progress Circle Chart Infographics in Excel Dashboard
Automatic Serial Number in Excel
Переглядів 88 тис.2 роки тому
Automatic Serial Number in Excel
Split Cells Diagonally in Excel - (Two Headers in Same Cell)
Переглядів 63 тис.2 роки тому
Split Cells Diagonally in Excel - (Two Headers in Same Cell)
How to Calculate Hours Worked in Excel
Переглядів 541 тис.2 роки тому
How to Calculate Hours Worked in Excel
Difference in Find() and Search() Functions in Excel
Переглядів 1 тис.2 роки тому
Difference in Find() and Search() Functions in Excel

КОМЕНТАРІ

  • @saadsayed9025
    @saadsayed9025 14 годин тому

    It Doesnt Work

  • @zulkarnaens
    @zulkarnaens 19 годин тому

    NOT AUTOMATIC, BUT MANUAL FIX IT

  • @umairahmed5171
    @umairahmed5171 День тому

    Is there any system which can display the birthday on tv

  • @sanjaykanna7310
    @sanjaykanna7310 3 дні тому

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

  • @surekhakatakam3523
    @surekhakatakam3523 4 дні тому

    Vba code ela tisukovali mana syste

  • @teandreluta2039
    @teandreluta2039 4 дні тому

    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 6 днів тому

    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 8 днів тому

    Teaching clearly, very well!

  • @zevoerakhodabaks5400
    @zevoerakhodabaks5400 10 днів тому

    Thank you sooo much! Greetings from Suriname

  • @jasonsimmons4848
    @jasonsimmons4848 11 днів тому

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

  • @pakbet371
    @pakbet371 11 днів тому

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

  • @nmlbajaj
    @nmlbajaj 11 днів тому

    Very helpful ! Thank you so much !

  • @adriel2nd
    @adriel2nd 12 днів тому

    thank you sir i almost failed my fomputer fclaxss

  • @tedmoy
    @tedmoy 13 днів тому

    Great video!

  • @Love-iv5vq
    @Love-iv5vq 17 днів тому

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

  • @ewilner
    @ewilner 17 днів тому

    Do you have a sheet I can download?

  • @anilreddy2415
    @anilreddy2415 18 днів тому

    How to send massages to particular group ?

  • @rasheednayakkan6750
    @rasheednayakkan6750 20 днів тому

    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 20 днів тому

    Thank you very much helpimg us

  • @04095875
    @04095875 20 днів тому

    Just what I needed. thank you so much 🙂

  • @norsazli71
    @norsazli71 21 день тому

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

  • @TeamCidroTV
    @TeamCidroTV 21 день тому

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

  • @Nithiyananthan1
    @Nithiyananthan1 22 дні тому

    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 22 дні тому

    Thank you

  • @richi5389
    @richi5389 23 дні тому

    This can send image from gsheet to wa sir?

  • @sunilyaadav72
    @sunilyaadav72 23 дні тому

    excellent

  • @harvi7106
    @harvi7106 24 дні тому

    That’s very simple

  • @rajeshdhawan1
    @rajeshdhawan1 24 дні тому

    Thanks

  • @funmigbokoyi6185
    @funmigbokoyi6185 26 днів тому

    Very simple and straight to the point, Thank you!

  • @farhadentertainmentltd.3946
    @farhadentertainmentltd.3946 26 днів тому

    Thank you so much !! Very helpful

  • @srijansaha7212
    @srijansaha7212 26 днів тому

    How come 75? when minute counting by 60?

  • @Animesh_Goyal
    @Animesh_Goyal 26 днів тому

    Hats off to you!

  • @caliwarebath
    @caliwarebath 28 днів тому

    Can we use it on different sheets?

  • @letthemgth
    @letthemgth 29 днів тому

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

  • @Annie-vn3nx
    @Annie-vn3nx Місяць тому

    THANK YOU

  • @easypeasy7875
    @easypeasy7875 Місяць тому

    08.75 75 Is Wrong my dear

  • @AntiSocialAries
    @AntiSocialAries Місяць тому

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

  • @Arham-gk5sd
    @Arham-gk5sd Місяць тому

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

  • @jigneshram88
    @jigneshram88 Місяць тому

    Wow very usefull for me as a teacher thanx

  • @abhashtripathi9234
    @abhashtripathi9234 Місяць тому

    Is it possible to connect different sheet data to make marksheet

  • @syedahmad143
    @syedahmad143 Місяць тому

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

  • @dhananjaymalhotra7854
    @dhananjaymalhotra7854 Місяць тому

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

  • @ramijmullick4687
    @ramijmullick4687 Місяць тому

    Friday 8:75 how😂

  • @manojvishwas6062
    @manojvishwas6062 Місяць тому

    thank you

  • @EdukasiAktif
    @EdukasiAktif Місяць тому

    I want to make this dynamic calendar fill in notes for each row, how do I do that?

  • @MuhammadKamran12345
    @MuhammadKamran12345 Місяць тому

    Nicely explained. ❤

  • @Nicecomputertutorial
    @Nicecomputertutorial Місяць тому

    Excellent bro

  • @kvamsisrinivas
    @kvamsisrinivas Місяць тому

    Not working

  • @BosGaurus05
    @BosGaurus05 Місяць тому

    This is amazing

  • @AbdulHafeezMohammad-l2z
    @AbdulHafeezMohammad-l2z Місяць тому

    Exact working hours not showing instead of 15 mins it's showing 25 mins