Tech Sessions
Tech Sessions
  • Видео 218
  • Просмотров 211 993
Top 10 important functions in Excel
In this video you will learn top 10 important functions in Excel.
1. SUM
2. SUMIFS
3. COUNTIFS
4. IF
5. XLOOKUP
6. TEXT
7. TEXTJOIN
8. FILTER
9. UNIQUE
10. DATEDIF
#ExcelSessionsbySaurabhJain
Просмотров: 412

Видео

Auto Fill Feature in Excel
Просмотров 4228 дней назад
Auto Fill Feature in Excel
Master MAXIFS and MINIFS in Excel: Powerful Examples
Просмотров 50Месяц назад
Master MAXIFS and MINIFS in Excel: Powerful Examples
How to Use the GETPIVOTDATA Function in Excel - Step-by-Step Tutorial
Просмотров 81Месяц назад
How to Use the GETPIVOTDATA Function in Excel - Step-by-Step Tutorial
LAMBDA - Create your own custom functions in Excel without VBA
Просмотров 87Месяц назад
LAMBDA - Create your own custom functions in Excel without VBA
Forget Deadlines? Automate Task Reminders with Excel VBA
Просмотров 158Месяц назад
Forget Deadlines? Automate Task Reminders with Excel VBA
How to create fully automated Quiz in Excel using VBA
Просмотров 2422 месяца назад
How to create fully automated Quiz in Excel using VBA
How to insert image in Excel cell
Просмотров 912 месяца назад
How to insert image in Excel cell
Master the DGET function in Excel 365
Просмотров 1992 месяца назад
Master the DGET function in Excel 365
How to use DROP function in Excel 365
Просмотров 832 месяца назад
How to use DROP function in Excel 365
How to use TAKE function in Excel 365
Просмотров 1443 месяца назад
How to use TAKE function in Excel 365
What are Row/ Rows/ Column/ Columns function in Excel
Просмотров 2833 месяца назад
What are Row/ Rows/ Column/ Columns function in Excel
How to show Task Status in Excel using dynamic Progress Bar
Просмотров 1923 месяца назад
How to show Task Status in Excel using dynamic Progress Bar
How to highlight every Nth row in Excel using conditional formatting
Просмотров 3823 месяца назад
How to highlight every Nth row in Excel using conditional formatting
How to Create a Dynamic Pivot Table Using OFFSET and COUNTA in Excel
Просмотров 3053 месяца назад
How to Create a Dynamic Pivot Table Using OFFSET and COUNTA in Excel
How to Split First, Middle, and Last Name in Excel Using TEXTBEFORE & TEXTAFTER
Просмотров 1554 месяца назад
How to Split First, Middle, and Last Name in Excel Using TEXTBEFORE & TEXTAFTER
Dynamic Dropdowns in Excel using offset: Automate Your Data Entry!
Просмотров 1614 месяца назад
Dynamic Dropdowns in Excel using offset: Automate Your Data Entry!
How to create Dynamic chart in Excel using Offset function| Auto-Updating Excel Charts
Просмотров 2904 месяца назад
How to create Dynamic chart in Excel using Offset function| Auto-Updating Excel Charts
SUMIFS in 2D data with INDEX and XMATCH
Просмотров 1544 месяца назад
SUMIFS in 2D data with INDEX and XMATCH
Dynamic Search using Index and XMatch in Excel
Просмотров 1074 месяца назад
Dynamic Search using Index and XMatch in Excel
Master XMATCH in Excel: The Ultimate Lookup Tool!
Просмотров 3664 месяца назад
Master XMATCH in Excel: The Ultimate Lookup Tool!
Highlight all keywords using Excel VBA
Просмотров 1885 месяцев назад
Highlight all keywords using Excel VBA
Quick Tip: How to center aligned text without merging the cells
Просмотров 4565 месяцев назад
Quick Tip: How to center aligned text without merging the cells
How to search keyword using Conditional Formatting and wildcard character
Просмотров 1365 месяцев назад
How to search keyword using Conditional Formatting and wildcard character
Quick Tip: How to Fix column width of a pivot table in Excel
Просмотров 1185 месяцев назад
Quick Tip: How to Fix column width of a pivot table in Excel
How to search keywords using Vlookup|| Vlookup and wildcard Characters
Просмотров 3955 месяцев назад
How to search keywords using Vlookup|| Vlookup and wildcard Characters
How to Merge Filtered Data from Multiple Excel Tables
Просмотров 3965 месяцев назад
How to Merge Filtered Data from Multiple Excel Tables
How to combine data from Multiple Sheets using VSTACK
Просмотров 1747 месяцев назад
How to combine data from Multiple Sheets using VSTACK
Excel Tutorial: Fill Blank Cells Fast with Formulas or Above Values
Просмотров 1737 месяцев назад
Excel Tutorial: Fill Blank Cells Fast with Formulas or Above Values
Data Analysis - Count Total Cells with Values in a Given Range Using CountIFS | Excel Tutorial
Просмотров 1367 месяцев назад
Data Analysis - Count Total Cells with Values in a Given Range Using CountIFS | Excel Tutorial

Комментарии

  • @MuniWalia
    @MuniWalia 2 дня назад

    Best way of describing ❤

  • @enuarora
    @enuarora 3 дня назад

    Very easy to comprehend sir

  • @enuarora
    @enuarora 3 дня назад

    Sir these shorts are amazing concepts 😊. I am surprised about the reach of these. 😢

  • @diponchakma630
    @diponchakma630 7 дней назад

    Your videos are top-notch, but they're not getting the attention they deserve in search results. 😕 I can help you optimize your videos for better search visibility. Let me know if you'd like my assistance!

    • @SessionsbySaurabh
      @SessionsbySaurabh 6 дней назад

      Thanks for your feedback! Can you share some insights on how you think my videos can be optimized for better search visibility?

    • @diponchakma630
      @diponchakma630 6 дней назад

      @@SessionsbySaurabh You're very welcome! I’d be happy to help. To optimize your videos for better search visibility, consider focusing on these key areas: 🔹 Keyword Optimization - Use relevant keywords in your title, description, and tags. Research trending and high-ranking keywords in your niche. 🔹 Compelling Thumbnails & Titles - Eye-catching thumbnails and engaging titles increase click-through rates. 🔹 Engagement Metrics - Encourage likes, comments, and shares, as RUclips favors videos with high engagement. 🔹 Video SEO - Add timestamps, closed captions, and a detailed description with relevant links. 🔹 Consistency & Playlists - Regular uploads and well-structured playlists help improve watch time and channel authority. Let me know if you'd like a more in-depth analysis or specific recommendations!

  • @BurkenProductions
    @BurkenProductions 13 дней назад

    All dates were backwards

    • @SessionsbySaurabh
      @SessionsbySaurabh 13 дней назад

      @@BurkenProductions “Thank you for the comments. The date format displayed in the video follows the DD/MM/YYYY format.. To ensure dates are interpreted correctly in Excel, please specify the appropriate date format in the ‘Text to Columns’ wizard during conversion. This will align the dates with your regional settings.”

  • @philipdesautels262
    @philipdesautels262 Месяц назад

    Thank you! Nice overview!!

  • @---Jaime-MEXICO-1962
    @---Jaime-MEXICO-1962 Месяц назад

    Great explanation !!!!!!

  • @ahmedseddiq9236
    @ahmedseddiq9236 2 месяца назад

    Thank you.

  • @arunk5517
    @arunk5517 2 месяца назад

    Thanks sir

  • @enuarora
    @enuarora 2 месяца назад

    This one's amazing sir. Thank you😊

  • @vishwajitchoondawat778
    @vishwajitchoondawat778 2 месяца назад

    How to send mails with excel sheet as attachment

  • @enuarora
    @enuarora 2 месяца назад

    Helpful video sir. The image never used to be even in size when I would insert it.

  • @enuarora
    @enuarora 2 месяца назад

    Sir, I was never familiar with this function. Returns something like a scaler value just as a measure does in a power query?

    • @SessionsbySaurabh
      @SessionsbySaurabh 2 месяца назад

      Yes, the DGET function in Excel does return a single (scalar) value, similar to how a measure works in Power Query or Power BI.

  • @alisonmitchell6891
    @alisonmitchell6891 2 месяца назад

    Really helpful and clear thank you

  • @cis232
    @cis232 2 месяца назад

    Thank you so much. I have been chasing my tail trying answers to vba and tables. You made it quick, easy to follow and understand.

  • @JeromeAnusencion-b6j
    @JeromeAnusencion-b6j 3 месяца назад

    The file is no longer working. No formula also

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      Hi, thanks for highlighting. I have modified the sheet and updated the link in the description. Please download the sheet and check. Also, suggest in comments section if further improvements can be made.

    • @jeromeanusencion342
      @jeromeanusencion342 2 месяца назад

      @@SessionsbySaurabh Can you share link here with no password.

    • @SessionsbySaurabh
      @SessionsbySaurabh 2 месяца назад

      Hi, you can use below passwords to unprotect the sheet or VBA to Unprotect the Sheet: Exc3lSess!0ns VBA project password: Exc3!S3ss!0ns Logs sheet password: L0gsp#d

    • @SessionsbySaurabh
      @SessionsbySaurabh 2 месяца назад

      drive.google.com/file/d/1Xj4dcY4uD51xCEUJWSPqh4xL8eQ41pNB/view?usp=sharing

  • @sportsbesthighlightschanne1052
    @sportsbesthighlightschanne1052 3 месяца назад

    I'd like to refresh google sheet from excel cells automatically? Do you have any examples ? thx

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      If your Excel sheet is saved locally on your desktop instead of in a cloud environment like Google Drive or OneDrive, it won’t automatically update in Google Sheets unless you re-upload it each time.

  • @sportsbesthighlightschanne1052
    @sportsbesthighlightschanne1052 3 месяца назад

    Can you refresh google sheet from excel sheet every second automatically ? thanks

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      If your Excel sheet is saved locally on your desktop instead of in a cloud environment like Google Drive or OneDrive, it won’t automatically update in Google Sheets unless you re-upload it each time.

  • @tommyharris5817
    @tommyharris5817 3 месяца назад

    Brilliant, just what I was looking for 👍

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      @@tommyharris5817 Glad you like the video. Thanks.

  • @pandoravex4791
    @pandoravex4791 3 месяца назад

    Thank you! So easy to understand!

  • @SeanFHoward
    @SeanFHoward 3 месяца назад

    Do you know if there a similar was to delete rows of data in the GoogleSheets using VBA code in an Excel workbook?

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      To delete a row in a Google Sheet from Excel using VBA, we can use the Google Sheets API. Since Excel VBA doesn’t directly support the Google Sheets API, we usually rely on Google Apps Script as a workaround.

    • @SeanFHoward
      @SeanFHoward 3 месяца назад

      @@SessionsbySaurabh thanks for that. So there is no way to delete rows from BEFORE uploading data from Excel using your code WITHOUT having processes running in two different place?

  • @kevindob
    @kevindob 3 месяца назад

    Excellent video. Thank you.

  • @enuarora
    @enuarora 3 месяца назад

    This was much needed, sir. Thank you

  • @arunk5517
    @arunk5517 3 месяца назад

    Sir power bi and power query both are same?

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      Power BI and Power Query are related but not the same. Power BI is a business analytics tool from Microsoft used for creating visual reports, dashboards, and data analysis. Power Query is a tool within Power BI, Excel, and other Microsoft products that helps users to import, clean, and reshape data.

    • @arunk5517
      @arunk5517 3 месяца назад

      @@SessionsbySaurabh thanks sir

  • @emmadeane7362
    @emmadeane7362 3 месяца назад

    Thank you for this tutorial! It was a huge help.

    • @SessionsbySaurabh
      @SessionsbySaurabh 3 месяца назад

      @@emmadeane7362 You’re very welcome! I’m glad the tutorial was helpful.

  • @saharshtiwari5557
    @saharshtiwari5557 4 месяца назад

    this is the one i was looking for

  • @arunk5517
    @arunk5517 4 месяца назад

    Hi sir can you please create a video on how to create questions answer quiz with pictures in Excel VBA code?

    • @SessionsbySaurabh
      @SessionsbySaurabh 4 месяца назад

      @@arunk5517 sure. What exactly you want in the quiz? Do you need All questions of picture type? Should be these objective type questions ?

    • @arunk5517
      @arunk5517 4 месяца назад

      ​@@SessionsbySaurabhall questions should be in picture with 4 option

  • @tarunsen4855
    @tarunsen4855 4 месяца назад

    fab Saurabh ...great to know offset function though i have using Dynamic dropdown for sometime. Also its been ages since we spoke last time. Cheers

    • @SessionsbySaurabh
      @SessionsbySaurabh 4 месяца назад

      @@tarunsen4855 Thanks Tarun. Sincerely appreciate your kind words.

  • @enuarora
    @enuarora 4 месяца назад

    Very useful,sir. Thank you

  • @enuarora
    @enuarora 4 месяца назад

    I needed this used case. Thank you, sir. 😊

  • @mehtacomputer
    @mehtacomputer 4 месяца назад

    👍

  • @mukulp8708
    @mukulp8708 4 месяца назад

    Thank you so much

  • @hometips3641
    @hometips3641 4 месяца назад

    Thanks for sharing

  • @enuarora
    @enuarora 4 месяца назад

    I wasn't aware of this function sir. Thank you 😊

  • @jazam9244
    @jazam9244 4 месяца назад

    You, sir, are a scholar and a gentleman.

    • @SessionsbySaurabh
      @SessionsbySaurabh 4 месяца назад

      @@jazam9244 thanks a lot. Your words make my day.

  • @omkarjadhav7104
    @omkarjadhav7104 5 месяцев назад

    Thank you best explaination

  • @enuarora
    @enuarora 5 месяцев назад

    It was much needed, sir. Thank you 😊 Happy teacher's day, sir 😊

  • @Jamie-ub2dr
    @Jamie-ub2dr 5 месяцев назад

    Thank you! 🙏

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      @@Jamie-ub2dr Thanks for watching. Glad you enjoyed it.

  • @Micuamacu1
    @Micuamacu1 5 месяцев назад

    HI.... IT IS POSSIBLE TO REFERENCE COLUMNS DATA USING TABLE HEADERS INSTEAD USING COLUMNS NUMBERS? THANKS

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      Yes, you can. mytable.ListColumns(“Age”).Range.Select will select the column having header name “Age”.

  • @paperbacky
    @paperbacky 5 месяцев назад

    can the conditional formatting be applied in the Master List as well

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      Absolutely yes. Select the master list and apply the formula =countif($D$2:$D$18,$A2)>0

  • @enuarora
    @enuarora 5 месяцев назад

    Just a quick question. What could be tha logic behind greater than 0. Because per me, it ensures to find the row number greater than C1.

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      @@enuarora formula in conditional formatting should return TRUE/ FALSE. Hence, doing comparison. We can use ISNUMBER function too instead of “>0” Hope this answers your question.

  • @enuarora
    @enuarora 5 месяцев назад

    I was looking for this one, sir. Thank you!

  • @muhammadsadiq8885
    @muhammadsadiq8885 5 месяцев назад

    Very nice

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      @@muhammadsadiq8885 thanks a lot for your appreciation.

  • @enuarora
    @enuarora 5 месяцев назад

    Good shortcut 😊 Thank you, sir

  • @IrfanAhmedFarooqui
    @IrfanAhmedFarooqui 5 месяцев назад

    What to modify to work for Text search instead of data?

  • @enuarora
    @enuarora 5 месяцев назад

    Sir, I faced a challenge in a filter function. The request was as follows- I had a parent table with three columns - Employee name (contained unique employee name), Attendance Performance (contained grades between A+ and E), Production Performance(contained grades between A+ and E). Now, the requirement was to populate the names of the employees who got the same grade(A+) in Attendance Performance & Production Performance both, at the same time. For instance, Enu, Anita, Shubham scored A in both Production Performance and Attendance Performance.Thus all the three names should populate along with their grade A. Though I understood that filter function could be helpful but I took help from someone who used filter function with multiplication * for this. Though we handled this, logic didn't get clear to me. Can you please make a video on this filter function with multiplication so that logic could be connected easily. thank you

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      @@enuarora Hi Enu, please Send the excel file to Saurabhjainpersonal@ gmail.com. Will be easy to understand the problem.

  • @enuarora
    @enuarora 5 месяцев назад

    Very helpful sir

  • @GoldenbanjoDJ
    @GoldenbanjoDJ 5 месяцев назад

    perfect. thanks

  • @shivanijain6021
    @shivanijain6021 5 месяцев назад

    Excellent video. Saved lots of time. Earlier I was doing manually.

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      Thank you. Glad you found the video helpful.

  • @enuarora
    @enuarora 5 месяцев назад

    Sir, sometimes i think these basic usage of Excel is so helpful! Thank you for this formula 😊

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      @@enuarora Hi Enu, I’m glad you found the video helpful! Thanks for the feedback.

    • @enuarora
      @enuarora 5 месяцев назад

      @SessionsbySaurabh Sir please try to create one video on vlookup wildcards

    • @SessionsbySaurabh
      @SessionsbySaurabh 5 месяцев назад

      Thanks for this suggestion, Enu. I have added it to my list of upcoming videos. If you have any other ideas, feel free to share!