- 180
- 570 198
Excel Sirji
India
Приєднався 19 кві 2019
Free Excel Training Videos and Tutorials. Tune the channel to start learning Excel Now. Get new Excel Training Episodes every Tuesday and Thursday. You can become an Excel Expert as this channel contains most of the excel training materials from Beginner to advanced. Also we cover Excel VBA Training.
Don't waste your time and learn excel productivity Tips and subscribe the channel now to learn More.
You can also get this training and more resources here www.excelsirji.com.
Explore all Excel Training Materials:
ua-cam.com/channels/LOh3AQDLXoYFcB0lUbrk5g.htmlplaylists
If you wanna support us and want us to write more. You can buy us a coffee from here:
www.buymeacoffee.com/excelsirji
Don't waste your time and learn excel productivity Tips and subscribe the channel now to learn More.
You can also get this training and more resources here www.excelsirji.com.
Explore all Excel Training Materials:
ua-cam.com/channels/LOh3AQDLXoYFcB0lUbrk5g.htmlplaylists
If you wanna support us and want us to write more. You can buy us a coffee from here:
www.buymeacoffee.com/excelsirji
Write Your First Macro in Excel
In this video, we'll explore how to write your first macro in Excel and automate your data formatting tasks! We'll guide you through the process of creating a VBA macro step by step. From recording your actions to fine-tuning the code, you'll learn how to automate repetitive tasks and save valuable time.
Learn how to:
Record the Macro
Use Shortcuts for Efficiency
Add Formula
Format Headers and Borders
Test and Debug
Refine Macro
Learn more at www.excelsirji.com.
00:00 Introduction
00:12 Explanation of Scenario
01:18 Approach to Solution
01:57 Tricks for good recording
03:56 Record the macro
07:52 Understand what got recorded
12:28 Run the code
13:02 Fix code issues
15:32 Add patches in the code
20:02 Conclusion
Learn how to:
Record the Macro
Use Shortcuts for Efficiency
Add Formula
Format Headers and Borders
Test and Debug
Refine Macro
Learn more at www.excelsirji.com.
00:00 Introduction
00:12 Explanation of Scenario
01:18 Approach to Solution
01:57 Tricks for good recording
03:56 Record the macro
07:52 Understand what got recorded
12:28 Run the code
13:02 Fix code issues
15:32 Add patches in the code
20:02 Conclusion
Переглядів: 216
Відео
How to Sort Data Using Power Query in Excel
Переглядів 4415 місяців тому
In this video, we'll explore how to effectively sort data using Power Query in Excel. Sorting data is crucial for organizing information and gaining insights into your datasets. We'll walk through the process step by step, ensuring clarity and simplicity. Learn how to: Sort data by one or multiple columns Arrange your information in ascending or descending order Create layered sorts for complex...
Filter Data in Power Query in Excel - A Beginner's Guide
Переглядів 2815 місяців тому
Upgrading your Excel data analysis? This step-by-step tutorial empowers you to leverage Power Query's robust filtering capabilities. Learn to filter by date, text, numbers, and more in Power Query, streamlining your workflow and unlocking deeper insights from your data. Watch now and elevate your Excel expertise! Learn more at www.excelsirji.com. Chapters: 00:00 Introduction 00:10 Explanati...
Merge Columns using Power Query
Переглядів 2976 місяців тому
Welcome to our comprehensive tutorial on mastering Power Query! In this video, Kailash Sharma guides you through the process of merging columns effortlessly using Power Query. If you've ever struggled with combining data from different columns into a single, more usable format, this tutorial is for you. Follow along step by step as Kailash demonstrates the entire process, from converting your d...
Splitting Data Using Power Query in Excel
Переглядів 1466 місяців тому
This video is about splitting data using Power Query in Excel. In the video, Kailash Sharma demonstrates how to split a column containing full names into separate first name and last name columns using Power Query. The video first covers converting an Excel data range into a table. Then, it dives into using Power Query to split the name column based on a delimiter (space). After splitting the d...
Get List of File Names from a Folder and Sub-Folders using Power Query in Excel
Переглядів 1,2 тис.6 місяців тому
This video is about how to get a list of file names from a folder and subfolders using Power Query in Excel. In the video, Kailash Sharma demonstrates how to achieve this by following these steps: Create a new Excel file and go to the data tab. Click on "Get data from file" and then "From folder" Select the folder that contains the files you want to list. Click on "Transform data" to load the d...
Progress Chart (KPI Tracking) in Excel - Half Donut Chart in Microsoft Excel
Переглядів 1,3 тис.9 місяців тому
👏Progress Charts in Excel👏 Creating stunning Excel Dashboard is one of the key metric for the Excel Expert. So here I am talking about how you can add Progress Chart in Excel. It includes step by step guide about this. Great job! finally you took first step to excel at work!! 🙌 You’re one step away from becoming an Excel pro! 🎉 Explore Advanced Excel Courses and Productivity Templates on my web...
Quickly Combine Excel Files into one File - Append Data From Folder
Переглядів 2382 роки тому
Quickly Combine Excel Files into one File - Append Data From Folder
Step by Step Guide to use Time and Motion Study Template Professional Version
Переглядів 15 тис.2 роки тому
Step by Step Guide to use Time and Motion Study Template Professional Version
How to Use Time and Motion Study to Improve Your Productivity - Free Download for 2023
Переглядів 6 тис.3 роки тому
How to Use Time and Motion Study to Improve Your Productivity - Free Download for 2023
How to insert Checkboxes in Excel - Way of Awesome Excel Reporting
Переглядів 1,4 тис.3 роки тому
How to insert Checkboxes in Excel - Way of Awesome Excel Reporting
Histogram in Excel Explained (Office 365 Method and Older Excel Version Method)
Переглядів 7413 роки тому
Histogram in Excel Explained (Office 365 Method and Older Excel Version Method)
Group By and Summarize By with Power Query in Excel (Explained with Sales Data Example)
Переглядів 9573 роки тому
Group By and Summarize By with Power Query in Excel (Explained with Sales Data Example)
Extracting Data Based On Criterias in Excel - Excel Filter Function
Переглядів 4,1 тис.3 роки тому
Extracting Data Based On Criterias in Excel - Excel Filter Function
Excel 3D Referencing Formulas: Use Same Excel Ranges From Multiple Excel Sheets in Excel Formulas
Переглядів 8133 роки тому
Excel 3D Referencing Formulas: Use Same Excel Ranges From Multiple Excel Sheets in Excel Formulas
Join Tables - Combine Multiple Excel Tables by Matching Column Headers (Power Query Advanced Trick)
Переглядів 9 тис.3 роки тому
Join Tables - Combine Multiple Excel Tables by Matching Column Headers (Power Query Advanced Trick)
Multiply Matrices in Excel with Excel MMULT Function - Concept Explained
Переглядів 2,4 тис.3 роки тому
Multiply Matrices in Excel with Excel MMULT Function - Concept Explained
Quickly Combine Multiple Excel Files into One from folder (Merge and Append Multiple Excel Files)
Переглядів 2,2 тис.3 роки тому
Quickly Combine Multiple Excel Files into One from folder (Merge and Append Multiple Excel Files)
Quickly Hide and Unhide Sheet and Turn Off the Unhide Option (Bonus Pro Tip)
Переглядів 3,1 тис.3 роки тому
Quickly Hide and Unhide Sheet and Turn Off the Unhide Option (Bonus Pro Tip)
Excel Unique Function to extract unique values from Excel Datasets (Quick Guide)
Переглядів 4643 роки тому
Excel Unique Function to extract unique values from Excel Datasets (Quick Guide)
Hide Excel Ribbon and Excel Tabs | Hide Headings and Formula Bar | Hide Gridlines (Quick Guide)
Переглядів 11 тис.3 роки тому
Hide Excel Ribbon and Excel Tabs | Hide Headings and Formula Bar | Hide Gridlines (Quick Guide)
How to Group or Ungroup Rows and Columns in Excel? (Quick Guide)
Переглядів 1 тис.3 роки тому
How to Group or Ungroup Rows and Columns in Excel? (Quick Guide)
Nice explanation.
you said is free but is not
😂😂😅😅😅😅😅
I don't have unique function what to do.
Useful info, very short and precise
Great Video ! Crystal clear instructions and guidance !! Bahut Badhiya !!!
Thanks buddy :-)
i am not getting as the way u shown
It is the latest version. Which version you are using?
docs.google.com/spreadsheets/d/1xKkLyEZgau7OGIlYU_xb-gXjQPHwE3QIdRvf_0u_hX4/edit?usp=drivesdk
The only video that helped me
Thanks :-)
Helpful
Glad you think so!
how do i download the tool? your site is not showing the download button
We recently migrated to new platform. You may use downloads.excelsirji.com
Thanks
Welcome
Lovely work❤
Thanks a lot 😊
Great tutorial, informative, perfect for the vba programing level I am at currently.
Glad it was helpful!
Which version is this ?
Office365
Can you merge data based on multiple unique identifiers?
Use TextJoin Function
Use TextJoin Function
Thank you so much
Thank you for your great and quick way to change the date.
You're welcome!
Thnkw so much I was trying it from 2 days but your vedio takes 2 sec to sought the prblm
thank you
Make like this all picture right? i have one document that has a lot of pictures When I filter I always see things like this. Thank you for your Clip.
Dhanya sir ji. Gave move options than expected. Now I am sure that my team will curse you. By the way thanks for this.
Hope you found it useful
Thank you 💻💻Excellent 🧰Tech-Heads-Up✅ === ✍🏽 PPPPPP= Proper Planning Prevents Poor Project Performance... ✍🏽Watching👁👁 👩🏾💻 through your eyes ...Excellent video 🗞 📰 One Journey🗺🌎🌍🌏 Let's Make It Count❗ ====
Thank you sir
Thank u so much found the one & which needed 😊
You're welcome 😊
But how to change the Formula Bar, the date is still in the center
nice explanation sir
Thank you! Exactly the steps that I needed to find!!!
Wow! Everything you ever wanted to know about mail merge label printing in one short video! And mad props for the closed captioning; between my partial deafness and our guru's goofy accent (the way he says A-May-Zon cracks me up), I was definitely in need of the very nice captioning. Thank you, thank you, THANK YOU.
Glad you enjoyed it!
But how to use it in power query? It doesn't work the same
I tried this and got a #Spill! Error
Can i do it on windows 10
magnificence DZ
This video was perfect, helped me get done exactly what I was trying to get done with making labels for inventorying chemicals. With some small adjustments to your instructions, you were able to help me turn a job that wouldve taken up to a month into just 5 minutes on Microsoft Word. Thank you so much for putting up this video and being so clear and concise.
Glad it helped!
Thank you❤️ Date format in excel is changing when it converting into pdf.. Only this technic worked
Thank you
Thank u
Tutorial po
Why I am not getting unique function in my excel
only work in new version
Still cannot
Thankyou for your solution
Thank you so much
You're most welcome
Thank you
You're welcome
Hi Sirji, I left a comment on your website regarding after support hrs and further collab for improvents - hopeful to receive any feedback and reply from you regarding that comment. Thanks!
Thank you for making the purchase. Please share the requirememts over email. Our developer will connect with you. Hope this answers your query.
Sir, how to keep font colors intact while after sorting in excel🤔
Can you please share how to create this sir
You may purchase this tool via our website courses.excelsirji.com.
what if I have more than 2 sheets?
Savior....YOU'RE A SAVIOR!
Thanks
Welcome
I need help regarding excel how to contact you
I have used a unique function at row level and there is no outcome however I used transpose to convert row data to column and then applied unique with transpose, voila, unique function has been worked. question: does a unique function work on row level data or not?