![Tech Sessions](/img/default-banner.jpg)
- Видео 158
- Просмотров 163 173
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!
Quick Tip: How to Fix column width of a pivot table in Excel
Struggling with column widths in your Pivot Table constantly changing? In this quick tutorial, I'll show you a simple trick to lock the column width in place so you don't have to adjust them every time you update your data. Watch this video to learn how to easily fix this issue and keep your Excel Pivot Tables looking neat and professional! 🚀
✅ Subscribe for more Excel tips and tricks!
#Excel #PivotTable #ExcelTips #QuickFix #PivotTableColumns #ExcelTutorial
✅ Subscribe for more Excel tips and tricks!
#Excel #PivotTable #ExcelTips #QuickFix #PivotTableColumns #ExcelTutorial
Просмотров: 2
Видео
How to search keywords using Vlookup|| Vlookup and wildcard Characters
Просмотров 437 часов назад
"Mastering VLOOKUP with Wildcard Characters to Search Keywords in Excel" Welcome to another Excel tutorial! In this video, we're diving deep into how you can leverage the power of VLOOKUP with wildcard characters to search for keywords within your data. What You'll Learn: 1. VLOOKUP with Approximate match 2. Understanding Wildcards: Learn how wildcard characters work (* for any number of charac...
How to Merge Filtered Data from Multiple Excel Tables
Просмотров 73День назад
Title: How to Merge Filtered Data in Excel from multiple tables with VSTACK and FILTER functions Are you looking to combine data from multiple tables or sheets in Excel efficiently? In this tutorial, we'll show you how to merge filtered data using the powerful VSTACK and FILTER formulas. Whether you're working with large datasets or just want to streamline your data management, these formulas w...
Mastering Excel: Merging Data From Multiple Sheets Like A Pro
Просмотров 140Месяц назад
Mastering Excel: Merging Data From Multiple Sheets | Handling #NA Error Welcome to Tech Sessions! In this quick tutorial, you'll discover how to seamlessly merge data from multiple sheets in Excel within just 2 minutes. Additionally, we'll cover effective strategies to handle the #NA error, ensuring your data analysis remains smooth and error-free. Key Learnings: Step-by-step guide to combining...
Excel Tutorial: Fill Blank Cells Fast with Formulas or Above Values
Просмотров 952 месяца назад
Excel Tutorial: Fill Blank Cells Fast with Formulas or Above Values Welcome to Tech Sessions! In this tutorial, you'll learn a fast method to populate empty cells in Excel using either a formula or the value from the cell above. This technique can save your time and streamline your data entry process significantly. Key Points Covered: Using formulas to auto-fill blank cells in Excel Applying th...
Data Analysis - Count Total Cells with Values in a Given Range Using CountIFS | Excel Tutorial
Просмотров 992 месяца назад
Count Total Cells with Values in a Given Range Using CountIFS | Excel Tutorial Welcome to Tech Sessions! In this tutorial, you'll master the CountIFS function in Excel to efficiently count cells with values within a specified range. CountIFS is a powerful tool for advanced data analysis, allowing you to apply multiple criteria and retrieve accurate counts from your spreadsheets. Key Learnings: ...
How to skip dates without values in Excel chart
Просмотров 682 месяца назад
In this video we will learn how to skip dates without values in Excel chart. WhatsApp Channel: whatsapp.com/channel/0029VaBhT7zGpLHOhsbk0B0K #ExcelSessionsbySaurabhJain
Data analysis - How to create group of days in Excel
Просмотров 7003 месяца назад
How to use IFS function in Excel: ruclips.net/video/Kwv8pKwI7ko/видео.html How to use LET function in Excel: ruclips.net/video/y40vj6YJnhg/видео.html How to create Pivot table in Excel: ruclips.net/video/li_M_IG4Vhg/видео.html Basics of charts in Excel: ruclips.net/video/NMOg5raiQP8/видео.html WhatsApp Channel: whatsapp.com/channel/0029VaBhT7zGpLHOhsbk0B0K #ExcelSessionsbySaurabhJain
What If analysis in Excel
Просмотров 1103 месяца назад
WhatsApp Channel: whatsapp.com/channel/0029VaBhT7zGpLHOhsbk0B0K #ExcelSessionsbySaurabhJain
How to add % of total for each row in Pivot Table
Просмотров 1183 месяца назад
In this video, we will learn how to add calculated field or % of total for each row in pivot table. After learning this you dont need to add calculated field manually in pivot table. WhatsApp Channel: whatsapp.com/channel/0029VaBhT7zGpLHOhsbk0B0K #ExcelSessionsbySaurabhJain
How to import Name and Email IDs from outlook to excel
Просмотров 1243 месяца назад
Learn in 2 minutes - How to import Full Name and Email IDs used in outlook to excel. This will help to separate name and Email IDs and to use email IDs for other purpose. WhatsApp Channel: whatsapp.com/channel/0029VaBhT7zGpLHOhsbk0B0K #ExcelSessionsbySaurabhJain
How to merge multiple worksheets into one sheet in Excel
Просмотров 3619 месяцев назад
How to merge multiple worksheets into one sheet in Excel
How to Combine multiple workbooks into single workbook
Просмотров 33310 месяцев назад
How to Combine multiple workbooks into single workbook
How to export data from website to Excel
Просмотров 54610 месяцев назад
How to export data from website to Excel
Mail Merge - How to send Personalized email to multiple users
Просмотров 1,6 тыс.10 месяцев назад
Mail Merge - How to send Personalized email to multiple users
How to view multiple worksheets of a workbook side by side
Просмотров 54511 месяцев назад
How to view multiple worksheets of a workbook side by side
How to use TextSplit function in Excel 365
Просмотров 9111 месяцев назад
How to use TextSplit function in Excel 365
How to download AIS from Income tax website
Просмотров 19311 месяцев назад
How to download AIS from Income tax website
How to skip Conditional Formatting for blank Cells
Просмотров 8 тыс.Год назад
How to skip Conditional Formatting for blank Cells
How to use CHATGPT to solve excel problems
Просмотров 352Год назад
How to use CHATGPT to solve excel problems
How to use AUTOFILTER method to Filter and copy data in Excel VBA
Просмотров 1 тыс.Год назад
How to use AUTOFILTER method to Filter and copy data in Excel VBA
How to use double lookup values in VLOOKUP function
Просмотров 294Год назад
How to use double lookup values in VLOOKUP function
How to count Distinct Values in a list in Excel
Просмотров 725Год назад
How to count Distinct Values in a list in Excel
How to concat text from multiple cells in a single cell
Просмотров 635Год назад
How to concat text from multiple cells in a single cell
How to Increment Excel cell reference by any number
Просмотров 16 тыс.Год назад
How to Increment Excel cell reference by any number
Use of F8 key in Excel | Short cut key F8 in Excel
Просмотров 6602 года назад
Use of F8 key in Excel | Short cut key F8 in Excel
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!
Thank you very much, this helped a lot 🙏
@@AlexPakendorf-sh5xw so happy to hear that you found the video helpful. Thanks.
thank you for this valuable information sir... just want to know if this code still working.
Thank you for asking. The issue was in version 2, but I’ve modified the file, and it’s now working perfectly. 👍
What if there is password
Thank you!
You saved my life! Thank you!
Thank you for your words; they really brightened my day.
Apparently this does not work for cells with drown down selections
Very Good, thanks please file example archive
doesnt work, trash video
It does work for a table. If whole column is formated than Excel makes no diference between 0 and blank cell -> this doesnt work, blank cells are marked as same as 0. Any idea how to simply aply this for whole column? Thx
Hi, if you select $B:$B, it will work for a column. Please share what formula are you using and the problem you are facing. I will surely help. Thanks.
Thank you for this video, I am new to VBA and this explained how the objects and properties work! I have an issue though with MultiColumn list box multi select. The code runs but only Column A is visible with Heading; columns B and C are not visible? When I make a selection the MsgBox will show either column B or C cell content, whichever I select . I cannot see an issue with the code I copied from you, see below. ListBox2.RowSource = "Data!A2:C" & totalRows 'Not working column A only visible? Column B and C loaded not visible? Can explain why this is happening? There are no error messages.
I discovered the issue, ListBox2 column widths were not set!
Great. Let me know if you need any support.
super useful. thanks!
Thanks for appreciating.
Thank you Sir!
Informative video, sir. Thank you
Thanks sir for sharing video
Much required, sir. Thanks for this.
Thanks a lot man! You saved a lot of time.
Just a starter in VBA. I am finding it difficult to copy the filtered rows from all the excel files in a folder. Kindly help
Hi Suvendu, are you trying to copy filtered rows from multiple files to a common file? You can open all files of a folder, read the file, apply the filter, copy the content and paste in another excel file. Can you please share your code to check at sjexcelsessions@gmail.com? I will modify the code if required.
Thanks a lot!!
Sir how to create bucket list in Excel for salary
Hi Arun, you can create the buckets in similar way as we did for date. If you can share the sample file, I can help you. You can send your file to sjexcelsessions@gmail.com
@@SessionsbySaurabh sure saurabh sir
I have sent you Excel can you please create a video on the same
@arunk5517 Thanks. Sure, I will.
@@arunk5517 Thanks for sharing sheet. Check video and share your feedback: ruclips.net/video/iFOzcUWWW3s/видео.html
Excellent Dear Sir You will get all the blessing in your life
Thank you very much for your blessings. It’s really made my day.
I was losing it, thanks for the explanation... It was exactly the error I was running into.
You're welcome!
Good Explanation, Can you show if JSON has multiple records, how it works for the data extraction? I do get only single row, maybe i am missing something, Can you please guide?
Very useful pivot hacks! Thank you sir :)
Thanks Enu
Quality work
Thanks a lot.
Worked wonderfully, hat's off to you sir. 👍
Glad to hear that. Thanks for your words.
Thank you for clearly explaining some of the mysteries of tables! How do you go about finding which column “Age” is as a variable and then using the variable in the code?
Hi, use below code to find “Age” column Dim mytable As ListObject Dim col_no As Integer Set mytable = ActiveSheet.ListObjects("myTable") 'To get the column number of "Age" column col_no = mytable.HeaderRowRange.Cells.Find("Age").Column 'To select the age column mytable.ListColumns(col_no).Range.Select
Dear Sir i am having problem in in line it says variable not define can u help me in this matter ie BlankRow = Worksheets("Database").Range("A" & Rows.Count).End(x1Up).Row + 1 in this line "x1Up" not define and what can i do please
It’s xlup. This is vba defined constant. Seems you used number 1 instead of alphabet l. XLUP is used in VBA code to replicate the action of the “Up Arrow” key in Excel.
@@SessionsbySaurabh yes now it is working thank you for your masalas reply
Trust me, you are doing amazing work brother...May God bless you more knowledge to share with us.
Thanks a lot for your words. You Made my day.
Very useful, thank you 🙂
Thanks a lot for your words.
Thank you!
Thanks for your kind response.
Thanks, I was really struggling to find a way to make Excel distinguishing between blank cells and cells with zero values!
Happy to help and thanks for appreciating.
OP bro🎉
OP bro
How do u get all data accurate..show in detail how to build this dashboard bcz there are many formulae used in all column I guess..tis video is only show the general info..kindly make a video or share a link which can say indetail in building tis dashboard
Thank you very much, Mister. This video truly supports me a lot on my work!!
Fine❤❤❤❤❤❤❤❤❤❤
Thanks
Simple and short. Thank you.
Thanks
Hi, thank for this video it helped me a lot, I need to fill up more txt boxes with other data and once I finished, I need to transfer all the information to a worksheet, can you please show me how can i do that ?
Amazing. Thanks a lot
interesting! thanks
Thanks
I am not able to see vba window for 1st assignment it is popping the msg of unhide workbook
Sir kindly let me know how to highlight same value in each row .....?