- 232
- 1 014 287
Excel Dose
India
Приєднався 29 січ 2019
Welcome to Excel Dose channel. We upload Videos from Beginner to Advance for Excel and VBA regularly. You can learn Excel from our Learn Excel For Beginner - Season 1 playlist. Where you will learn basic of Excel.
Facebook: ExcelDose/
Website: exceldose.com/
Instagram: exceldose
Email: info@exceldose.com
Facebook: ExcelDose/
Website: exceldose.com/
Instagram: exceldose
Email: info@exceldose.com
5 Google Sheets Tricks & Tips to Improve Productivity 2024
5 Google Sheets Tricks & Tips to Improve Productivity 2024
Want to save time with Google Sheets? In this video, we have demonstrate 5 time-saving tips that will have you working both faster and smarter. These tips and tricks will help you save so much time and effort!
00:00 - Introduction
00:18 - Clean up your data
01:26 - Check change history
02:33 - Tag the person
03:03 - Use AI in Google Sheets (Ask Gemini)
03:57 - Use IMPORTRANGE to Import the data from another sheet
------------------------------------------
Daily Hot Deals : exceldose.com/todays-deals/
***************************
Subscribe: ua-cam.com/users/exceldose
Follow us on Facebook: ExcelDose/
Website: exceldose.com
Follow us on Instagram: exceldose
Want to save time with Google Sheets? In this video, we have demonstrate 5 time-saving tips that will have you working both faster and smarter. These tips and tricks will help you save so much time and effort!
00:00 - Introduction
00:18 - Clean up your data
01:26 - Check change history
02:33 - Tag the person
03:03 - Use AI in Google Sheets (Ask Gemini)
03:57 - Use IMPORTRANGE to Import the data from another sheet
------------------------------------------
Daily Hot Deals : exceldose.com/todays-deals/
***************************
Subscribe: ua-cam.com/users/exceldose
Follow us on Facebook: ExcelDose/
Website: exceldose.com
Follow us on Instagram: exceldose
Переглядів: 48
Відео
Build a Stock Watchlist with Live Data in Google Sheets
Переглядів 78814 днів тому
About Video - Transform your stock tracking experience with this quick tutorial on creating a dynamic stock watchlist in Google Sheets. Learn how to efficiently organize key data, including Stock Name, Open, High, Low, Prev. Close, LTP, and more, all in one accessible sheet. What you can do in this sheet - ➟ Techniques for fetching real-time stock information using formulas. ➟ Tips for integrat...
Useful Google Sheets Query Function Explained | Query Function With Multiple Criteria
Переглядів 5521 день тому
Useful Google Sheets Query Function Explained | Query Function With Multiple Criteria Struggling to filter your spreadsheet with complex criteria? This video unveils the power of the QUERY function with multiple conditions in Google Sheets. Buy me a coffee: buymeacoffee.com/exceldose We'll show you how to: Craft powerful queries: Unravel the secrets of filtering by text, numbers, and dates usin...
Tired of Copy - Pasting data across Sheets? VSTACK to the rescue!
Переглядів 97Місяць тому
Discover the power of VSTACK in Google Sheets to dynamically combine data from multiple sheets into one. Combining or appending data from multiple sheets is a common task in Google Sheets. In this video I'll show you how you can stack multiple data sets vertically with a single formula. We'll use Google Sheet's new VSTACK function. Buy me a coffee: buymeacoffee.com/exceldose Daily Hot Deals : e...
Learn How to do VLOOKUP in Google Sheets from Another Sheet
Переглядів 71Місяць тому
Learn How to do VLOOKUP in Google Sheets from Another Sheet VLOOKUP is one of the most essential and powerful functions in Google Sheets. In this tutorial for beginners you'll learn how to use VLOOKUP. Buy me a coffee: buymeacoffee.com/exceldose Daily Hot Deals : exceldose.com/todays-deals/ Subscribe: ua-cam.com/users/exceldose Follow us on Facebook: ExcelDose/ Website: exceldose.c...
Visualize Data Like a PRO - Update Graph Based on the Selected Date Range
Переглядів 106Місяць тому
Visualize Data Like a PRO - Update Graph Based on the Selected Date Range Sheet Link: docs.google.com/spreadsheets/d/1biA5x9KqHBluW-tKStUC_fTg16Pmvrt3WNvxT9MqRAA/edit#gid=0 Buy me a coffee: buymeacoffee.com/exceldose Topics Covered: update graph based on date range excel graph change date range excel update graph range automatically excel update graph with new data excel update chart data range...
How to Convert PDF to Excel (Easiest Way 2024)
Переглядів 2362 місяці тому
Learn how to convert PDF to excel in just a few simple steps with this PDF converter. It has never been easier to convert PDF files with Lido’s PDF to Excel converter. Help support the channel - sign up for Lido using this link!: www.lido.app/link/vishal Topics covered: convert pdf to Excel pdf to excel converter how to convert pdf to excel convert a pdf to excel how to convert a pdf to excel p...
Automatically generate multiple offer letters in PDF Format
Переглядів 1092 місяці тому
Automatically generate multiple offer letters in PDF Format Sheet Link: docs.google.com/spreadsheets/d/1ZCcsBYr9pyjKWjQz1CX-72v6SmOD60bkg1FtMuMXKFU/edit#gid=0 Buy me a coffee: buymeacoffee.com/exceldose generate offer letter, how to generate offer letter in zoho recruit, how to generate offer letter in workday, how long does it take to generate offer letter, generate offer letter clayhr, how to...
Count Only Unique Values in Dataset - COUNTUNIQUE
Переглядів 1152 місяці тому
Count Only Unique Values in Dataset - COUNTUNIQUE
Advanced VLOOKUP - Get Data Based on the Column Header #vlookup
Переглядів 1953 місяці тому
Advanced VLOOKUP - Get Data Based on the Column Header #vlookup
Advanced XLOOKUP Trick - Only 1% Data Analyst Know #xlookup
Переглядів 4173 місяці тому
Advanced XLOOKUP Trick - Only 1% Data Analyst Know #xlookup
Learn How to Use Index-Match Formula with Multiple Conditions
Переглядів 1423 місяці тому
Learn How to Use Index-Match Formula with Multiple Conditions
Automatically Send Reminder Email Using Google AppScript
Переглядів 3124 місяці тому
Automatically Send Reminder Email Using Google AppScript
Advanced VLOOKUP Trick - Only 1% Data Analysts Know #vlookup
Переглядів 2154 місяці тому
Advanced VLOOKUP Trick - Only 1% Data Analysts Know #vlookup
Lookup Multiple Criteria & Return Value in Excel & Google Sheets (Easy Formula)
Переглядів 2464 місяці тому
Lookup Multiple Criteria & Return Value in Excel & Google Sheets (Easy Formula)
Advanced XLOOKUP Techniques Revealed (R.I.P. VLOOKUP & INDEX-MATCH)
Переглядів 1984 місяці тому
Advanced XLOOKUP Techniques Revealed (R.I.P. VLOOKUP & INDEX-MATCH)
Build Fully Automatic Project Management Tracker using Google Sheets & AppScript
Переглядів 2255 місяців тому
Build Fully Automatic Project Management Tracker using Google Sheets & AppScript
Creative Google Slides Ideas - How to make a Google Slides Presentation #jaishreeram
Переглядів 2165 місяців тому
Creative Google Slides Ideas - How to make a Google Slides Presentation #jaishreeram
Learn How to Highlight Duplicates in Google Sheets
Переглядів 1975 місяців тому
Learn How to Highlight Duplicates in Google Sheets
FILTER Data with SEARCH Box - Creating a Powerful Advanced Search Box in Google Sheets
Переглядів 4225 місяців тому
FILTER Data with SEARCH Box - Creating a Powerful Advanced Search Box in Google Sheets
Google Slides: The Intro Slide for Marketing You NEED in 2024 #GoogleSlideHacks
Переглядів 475 місяців тому
Google Slides: The Intro Slide for Marketing You NEED in 2024 #GoogleSlideHacks
7 Stunning Infographic Charts You NEED in 2024 - Download for FREE - Christmas OFFER
Переглядів 636 місяців тому
7 Stunning Infographic Charts You NEED in 2024 - Download for FREE - Christmas OFFER
Learn How to Highlight Unique Values in Excel / Google Sheets
Переглядів 5917 місяців тому
Learn How to Highlight Unique Values in Excel / Google Sheets
Can you SOLVE these MS Excel Interview Questions? - Excel Interview Tips and Tricks
Переглядів 1607 місяців тому
Can you SOLVE these MS Excel Interview Questions? - Excel Interview Tips and Tricks
Automatically Send Work Anniversary Email to your Employee using Google AppScript
Переглядів 3498 місяців тому
Automatically Send Work Anniversary Email to your Employee using Google AppScript
Create an HR Recruitment Dashboard Using LookerStudio | Step-by-Step Tutorial
Переглядів 1,7 тис.9 місяців тому
Create an HR Recruitment Dashboard Using LookerStudio | Step-by-Step Tutorial
Automate Birthday Email to Employee Using Google Sheets & App Script
Переглядів 4,3 тис.11 місяців тому
Automate Birthday Email to Employee Using Google Sheets & App Script
Excel Tutorial: Create a Timeline Slicer in Excel
Переглядів 1,2 тис.Рік тому
Excel Tutorial: Create a Timeline Slicer in Excel
Get Data From Selected Columns Only in Excel
Переглядів 542Рік тому
Get Data From Selected Columns Only in Excel
FILTER Function: Search List of Specific Text in String
Переглядів 266Рік тому
FILTER Function: Search List of Specific Text in String
Thanks
@@amitkolekar1458 you are welcome 🙏
How can I use xlookup working wit different sheets?
@@JohnDoekhi that is have not tried yet. Let me find out the way and will upload video on same
@@ExcelDose please let me know
How to change an image
To change the image you need to replace the existing image URL which is mentioned in Cell E2.
How many emails we can put in BCC , and where its column mentioned
@@SaifAly0786 bcc email ids will be automatically get added based on the email ids mentioned in the google sheets
For more great content, please subscribe to our channel! www.youtube.com/@ExcelDose
can you provide sample file?
Please share your email ID or send a test email on info@exceldose.com
I’d suggest using VSTACK instead
Yes VSTACK is also good option
Adam gibi adam👍🏼👍🏼👍🏼
🙏 hope you have subscribed to our channel 🙏
For more great content, please subscribe to our channel! www.youtube.com/@ExcelDose
can i copy your code mrs?
You can make a copy of the sheet and code will automatically be added
Awesome it worked. Thank a lot.
Glad to hear 🙏😎 hope you have subscribed to our channel
Sharing the the the
🙏
It works 😊. Thank you so much
Thank you 🙏 hope you have subscribed to our channel 🙏
For more great content, please subscribe to our channel! www.youtube.com/@ExcelDose
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
For more great content, please subscribe to our channel! shorturl.at/ToDL4
📣📣 For more great content, please subscribe to our channel! shorturl.at/ToDL4
it looks great but it seems to want access to my entire google sheets. help?
Yes you have to grant permission to access the sheet
You need to give access to run the script
Can i have copy on this, thankyou
Main sheet link is mentioned in the video description. Please make a copy and start using it. Thank you 🙏
Worked . Thanks.
Glad to hear 🙏
thanks so much!
You’re welcome ☺️
Best video on this topic.
Glad to hear!
Huge Help..this video is great!
Glad to hear 🙏
Help support the channel - sign up for Lido using this link!: www.lido.app/link/vishal
What if I want to create a chart that could change according to the date range. I mean I can do the same process as above. It won't tell me about any specific date range I want to see. Please help.
This is interesting let me check how we can achieve this. Will post a video on same
@@ExcelDose Actually, I found a way in a similar video. The method was similar to yours. In that, they took a long method but it's effective, but where they name ranges that I want to add for separate charts and make a dropdown. Then, use =IFERROR(INDIRECT(dropdown cell), "")
We created a video on the topic you have requested Visualize Data Like a PRO - Update Graph Based on the Selected Date Range ua-cam.com/video/MhkJ9HEUJ4U/v-deo.html
Thank you for this, I am having trouble recording accurate times for all the employees. It works fine for the first employee entered, but the second one I enter doesn't work. When I try to login the second employee, it only updates the time for the first employee on the sheet. Do you know how I can fix this issue?
Make a copy of the tab for each employee and then see if it works. Ideally this should not happen
Can I have a copy of this for my small business? Thank you.
Sheet link is mentioned in video description docs.google.com/spreadsheets/d/1MzkMbQBpjbN2cAICc8O4vgRF0AiBHjhO_BpAr1nFX0g/
Thanks for this! Great work! Do you think it is possible to use with multiple people? I was hoping to list 4 employee names in the main sheet
In that case you need to make a multiple copy of Vishal tab and then use it
Hi! Thanks for the tutorial. Apps Script says the trigger has been executed, and yet the "email sent" column doesn't change and I am not receiving any emails. Do you know why?
Hey, you need to add your email ID where I have mentioned my email ID. As I have received new entry email in my inbox 📨
Thanks a lot….🎉
Most welcome!
Hello is it possible to export this dynamic with the drop down into google slides or pdf?
That we have not tried yet if it work or not. But I believe it wont work as data source is in trix format
How to apply this formula to whole table? Where we can't set one by one number.
In excel we do not have that functionality but we tried something similar let’s see if it helps you ua-cam.com/video/tyDJ2v0Fe_w/v-deo.html
Many thanks 🎉🎉🎉🎉
Thank you 🙏
Many thanks for this video. It saved me a lot of time and efforts.
Great to hear! Hope you have subscribed to our channel.
Thank a lot brother. Served my purpose
Glad to hear 🙏
I want to make this automated email things on my office but i don't think so we are authorized to use google sheet or app script. due to corporate policy. i created VBA code in excel but everyday i have to open this file and have to run the code, is there anything we can run this file automatically?
Hi, this is not feasible through Excel that’s why I have developed in AppScript
You can do it using power automate
Hi I am not able to see excel sheet which is available in google drive to connect with looker studio.what would be the reason for that,could you please guide how to sort out this issue.
You need to convert Excel to Google Sheets then only it will be available in looker studio
Nice one
Thank you 🙏
😻 *Promo sm*
🙏