- 46
- 23 430
MARS TRAINING & SOLUTION
India
Приєднався 20 сер 2020
We are basically focused to publish videos on Excel,advance Excel,VBA Excel,Macros,MS Office & MIS related learning.This will help users to learn lots of tricks and tips of these tools and ultimately it saves huge time.
How to remove duplicate rows in excel | How to remove duplicate records in excel
In order to extract unique records from your Excel data, this video will show the three most effective ways to eliminate duplicate rows in Excel.
Lecture by: Sabahat Yasmin (Khushbu)
Mars Training & Solution
Check out How To Reduce Excel File Size
ua-cam.com/video/onsF3Ln4nNk/v-deo.html
Check our other MS Excel videos:
ua-cam.com/play/PL5.html...
Check our Excel Vlookup Series:
ua-cam.com/play/PL5.htmlvkrKHzPz_Kt91oesJnNUEPZJZlX7DO9
For any training requirement contact us at
contactus@marstraining.in
rashidraj97@gmail.com
OR
visit our website
marstraining.in/
Follow us on
LinkedIn : in.linkedin.com/in/rashidrizwi
Facebook: MARS.TrainingSolutions
LIKE, SHARE, COMMENT AND SUBSCRIBE TO MY CHANNEL
#exceltips #advanceexcel #msexcel #exceltricks #excelhacks #exceltipstricks #removeduplicates
Lecture by: Sabahat Yasmin (Khushbu)
Mars Training & Solution
Check out How To Reduce Excel File Size
ua-cam.com/video/onsF3Ln4nNk/v-deo.html
Check our other MS Excel videos:
ua-cam.com/play/PL5.html...
Check our Excel Vlookup Series:
ua-cam.com/play/PL5.htmlvkrKHzPz_Kt91oesJnNUEPZJZlX7DO9
For any training requirement contact us at
contactus@marstraining.in
rashidraj97@gmail.com
OR
visit our website
marstraining.in/
Follow us on
LinkedIn : in.linkedin.com/in/rashidrizwi
Facebook: MARS.TrainingSolutions
LIKE, SHARE, COMMENT AND SUBSCRIBE TO MY CHANNEL
#exceltips #advanceexcel #msexcel #exceltricks #excelhacks #exceltipstricks #removeduplicates
Переглядів: 185
Відео
Pivot Table - Set default layout to tabular
Переглядів 793 місяці тому
Pivot Table - Set default layout to tabular This video will walk you through setting the pivot table report's default layout to be tabular. You can avoid creating a tabular pivot report each time by using this parameter. Check our other Advance Excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | ...
Rupees to Dollar conversion in Excel #excel #shorts #advanceexcel
Переглядів 584 місяці тому
Rupees to Dollar conversion in Excel #excel #shorts #advanceexcel This video will demonstrate how to swiftly convert a column of data in Excel that contains rupees to dollars in one move. Check our other excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | How to Change Date Format In Excel ua-cam...
Round Function in Excel #excel #shorts #advanceexcel
Переглядів 564 місяці тому
Round Function in Excel #excel #shorts #advanceexcel Round Function in Excel is used to round numbers. You'll discover how to round a number to the closest integer and to a certain number of decimals. Check our other excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | How to Change Date Format In...
Calculate Difference Between Two Date In Years In Fractions - YEARFRAC
Переглядів 616 місяців тому
Calculate Difference Between Two Date In Years In Fractions - YEARFRAC In this video, we will explain you'll about the YEARFRAC function in Excel. The YEARFRAC function in Excel will yield a decimal value representing the fraction of years between two dates. Check our other Advance Excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz...
Extract Day From Date in Excel
Переглядів 666 місяців тому
Extract Day From Date in Excel This video will show you how to use Excel's simple Day function to extract the day from a date, and how to utilize the Text function to get the day's name. Check our other excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | How to Change Date Format In Excel ua-cam....
Excel Formula to Extract Month From Date in Number & Text Format
Переглядів 1577 місяців тому
Excel Formula to Extract Month From Date in Number & Text Form In this video, we'll show how to use an easy formula to quickly extract the month from a date in both text and number forms. Check our other excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | How to Change Date Format In Excel ua-cam...
Excel Pivot Table Report Layout
Переглядів 2287 місяців тому
Excel Pivot Table Report Layout This video will explain how to create an ideal pivot table report with a clean, eye-catching layout . You will learn the many methods for creating a pivot report tabular in this video. Check our other excel videos: ua-cam.com/play/PL5.html... Check out our Excel VBA series ua-cam.com/play/PL5vkrKHzPz_LAvm3FgsLAMnz2H4oii29C.html Date Format In Excel | How to Chang...
How to Create a Dynamic Range in Excel
Переглядів 2147 місяців тому
How to Create a Dynamic Range in Excel Do you want your data entries to be automatically reflected in your pivot report, Vlookup, and other calculations? Check out this video tutorial where we'll walk you through two easy ways to make your range dynamic. The first method involves using the Format as Table option, while the second method - which is more efficient and prevents your file size from...
How to Calculate Time Difference in Excel | How to Calculate Difference between Two Times in Excel
Переглядів 1078 місяців тому
How to Calculate Time Difference in Excel | How to Calculate Difference between Two Times in Excel This video will explain you'll how to calculate difference between two time in Excel if the cycle is of 12 hours or 24 hours or more than 24 hours. This trick will work in all scenarios. The video should be watched carefully to avoid missing any steps when calculating time difference. Check our ot...
Autofit Column Width with VBA code |How to Set Column Width to Autofit in Excel
Переглядів 1388 місяців тому
Autofit Column Width with VBA code |How to Set Column Width to Autofit in Excel In this video we will learn how to autofit the width of a column in excel using a one line easy VBA code, which will adjust the column width to fit the data, making it easier to read and understand #viral #trending Check our other excel videos: ua-cam.com/play/PL5.html... Date Format In Excel | How to Change Date Fo...
How to Convert Wrong Date Format to the Correct Date Format | Excel
Переглядів 2198 місяців тому
How to Convert Wrong Date Format to the Correct Date Format | Excel
Date Format In Excel | How to Change Date Format In Excel | Excel Date Formatting
Переглядів 1238 місяців тому
Date Format In Excel | How to Change Date Format In Excel | Excel Date Formatting
Reduce Excel File Size Without Any Software| How To Reduce Excel File Size
Переглядів 4659 місяців тому
Reduce Excel File Size Without Any Software| How To Reduce Excel File Size
How to remove gridlines from specific cell in Excel
Переглядів 3129 місяців тому
How to remove gridlines from specific cell in Excel
How to format numbers in thousands or millions or billions in excel
Переглядів 3302 роки тому
How to format numbers in thousands or millions or billions in excel
How to repeat header in Word Table | How to repeat header rows in Word Table
Переглядів 1522 роки тому
How to repeat header in Word Table | How to repeat header rows in Word Table
How to start page numbers from a specific page in word
Переглядів 792 роки тому
How to start page numbers from a specific page in word
Vlookup tutorial for beginners | Vlookup formula in Excel | Vlookup tutorial for Excel - Part 1
Переглядів 1882 роки тому
Vlookup tutorial for beginners | Vlookup formula in Excel | Vlookup tutorial for Excel - Part 1
How to custom sort in excel | Custom sort video | How to sort custom list in excel
Переглядів 1042 роки тому
How to custom sort in excel | Custom sort video | How to sort custom list in excel
Calculating end of month in Excel | Excel end of month calculation using EOMONTH function
Переглядів 1162 роки тому
Calculating end of month in Excel | Excel end of month calculation using EOMONTH function
Calculating New Date after adding/subtracting Years, Months or Days
Переглядів 542 роки тому
Calculating New Date after adding/subtracting Years, Months or Days
Thank you so so so much sir ❤❤❤❤🙏🏻🙏🏻🙏🏻🙏🏻
Very nice video❤
Explained very well.
Very nice and informative video.
Nice explaination.... Nice tips👍👍
Video fresh nhi hai
Great video sir Need more of this kind of video
Thank you
Nice Learning video sir, really appreciate it
Great sir
Thank you
Thank you bro
Welcome
Great info
Grt teaching 🎉
Thanks a lot 😊
Informative shorts
Nice one
Thanks for watching
Amazing
Thank you very much sir for this long awaited video.
This what I wanted for long time.
Very informative video
Glad you liked it
Thank you for such a brief information. Do make more such content. Looking for the next video soon
Sure 😊
Thank you so much sir. These information will help all of us a lot. Eagerly waiting for next video
Keep watching
Thank You Guruji !
Thank you Sir. I got what I wanted from your teaching
Thank you for the video. How do you round up to nearest 50?
Thank u!!
You're welcome! Please subscribe our channel to get more such informative video
ρяσмσѕм
smart learning
Very much informative and we'll explanation
Glad it was helpful!
Glad it was helpful!
Very informative video and helped me a lot. I was searching for this kind of video only. Thanks
Superb
Yesterday day before I took the training from Mr.Rashid and Same I'm going through your videos, it's Amazing & knowledge able to Learn...
i46qzo #von.ong
Sir kuch video hindi me bhi bana diya kijye humlog ko samjhne k liye
Good for everyone
Excellent
Short, crisp and informative clip
Good endeavour. Please carry on.
Sir u r great...
This is Indian Jugaad Technology...Nice work anyways..Loved it👍
U r MS office wizard
Very nicely explained... Thank you
Nice work👍
Informative