- Видео 218
- Просмотров 211 993
Tech Sessions
Новая Зеландия
Добавлен 28 сен 2019
Welcome to Tech Sessions! Here, you'll find step-by-step tutorials and tips to master Microsoft Excel, Word, PowerPoint, Outlook, and more. Whether you're a beginner or looking to enhance your skills, our easy-to-follow videos will help you become proficient in these essential tools. Subscribe and start your learning journey today!
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
1. SUM
2. SUMIFS
3. COUNTIFS
4. IF
5. XLOOKUP
6. TEXT
7. TEXTJOIN
8. FILTER
9. UNIQUE
10. DATEDIF
#ExcelSessionsbySaurabhJain
Просмотров: 412
Видео
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
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
Best way of describing ❤
@@MuniWalia thanks a lot for appreciating.
Very easy to comprehend sir
Sir these shorts are amazing concepts 😊. I am surprised about the reach of these. 😢
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!
Thanks for your feedback! Can you share some insights on how you think my videos can be optimized for better search visibility?
@@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!
All dates were backwards
@@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.”
Thank you! Nice overview!!
@@philipdesautels262 thanks for appreciating,
Great explanation !!!!!!
Thanks a lot for appreciation.
Thank you.
Thanks sir
This one's amazing sir. Thank you😊
How to send mails with excel sheet as attachment
Helpful video sir. The image never used to be even in size when I would insert it.
Sir, I was never familiar with this function. Returns something like a scaler value just as a measure does in a power query?
Yes, the DGET function in Excel does return a single (scalar) value, similar to how a measure works in Power Query or Power BI.
Really helpful and clear thank you
@@alisonmitchell6891 Thanks. Glad you like the video.
Thank you
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.
The file is no longer working. No formula also
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.
@@SessionsbySaurabh Can you share link here with no password.
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
drive.google.com/file/d/1Xj4dcY4uD51xCEUJWSPqh4xL8eQ41pNB/view?usp=sharing
I'd like to refresh google sheet from excel cells automatically? Do you have any examples ? thx
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.
Can you refresh google sheet from excel sheet every second automatically ? thanks
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.
Brilliant, just what I was looking for 👍
@@tommyharris5817 Glad you like the video. Thanks.
Thank you! So easy to understand!
@@pandoravex4791 Thanks a lot.
Do you know if there a similar was to delete rows of data in the GoogleSheets using VBA code in an Excel workbook?
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.
@@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?
Excellent video. Thank you.
Glad you liked the video. Thanks a lot.
This was much needed, sir. Thank you
Sir power bi and power query both are same?
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.
@@SessionsbySaurabh thanks sir
Thank you for this tutorial! It was a huge help.
@@emmadeane7362 You’re very welcome! I’m glad the tutorial was helpful.
this is the one i was looking for
Hi sir can you please create a video on how to create questions answer quiz with pictures in Excel VBA code?
@@arunk5517 sure. What exactly you want in the quiz? Do you need All questions of picture type? Should be these objective type questions ?
@@SessionsbySaurabhall questions should be in picture with 4 option
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
@@tarunsen4855 Thanks Tarun. Sincerely appreciate your kind words.
Very useful,sir. Thank you
I needed this used case. Thank you, sir. 😊
👍
Thank you so much
Thanks for sharing
I wasn't aware of this function sir. Thank you 😊
You, sir, are a scholar and a gentleman.
@@jazam9244 thanks a lot. Your words make my day.
Thank you best explaination
@@omkarjadhav7104 thanks a lot.
It was much needed, sir. Thank you 😊 Happy teacher's day, sir 😊
Thanks Enu
Thank you! 🙏
@@Jamie-ub2dr Thanks for watching. Glad you enjoyed it.
HI.... IT IS POSSIBLE TO REFERENCE COLUMNS DATA USING TABLE HEADERS INSTEAD USING COLUMNS NUMBERS? THANKS
Yes, you can. mytable.ListColumns(“Age”).Range.Select will select the column having header name “Age”.
can the conditional formatting be applied in the Master List as well
Absolutely yes. Select the master list and apply the formula =countif($D$2:$D$18,$A2)>0
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.
@@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.
I was looking for this one, sir. Thank you!
Very nice
@@muhammadsadiq8885 thanks a lot for your appreciation.
Good shortcut 😊 Thank you, sir
What to modify to work for Text search instead of data?
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
@@enuarora Hi Enu, please Send the excel file to Saurabhjainpersonal@ gmail.com. Will be easy to understand the problem.
Very helpful sir
Thanks Enu
perfect. thanks
Welcome. I’m glad you found it useful.
Excellent video. Saved lots of time. Earlier I was doing manually.
Thank you. Glad you found the video helpful.
Sir, sometimes i think these basic usage of Excel is so helpful! Thank you for this formula 😊
@@enuarora Hi Enu, I’m glad you found the video helpful! Thanks for the feedback.
@SessionsbySaurabh Sir please try to create one video on vlookup wildcards
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!