Become Smart Excel User Using This EXCEL TRICK




About this tutorial:

Video duration: 00:08:19
Become Smart Excel User Using This EXCEL TRICK – in this video i will share A Excel Magic Trick for smart Excel Users. If you import data to Excel from another program chances are the dates will come in formatted as text, which means they’re not much use to you in formulas or Pivot Tables. here are two best excel tips and tricks to convert invalid date ( dates formatted as text ) into valid dates.

#deepakeduworld #exceltrick #excelinhindi #exceltips #exceltricks

Download Training File :

Excel Tips &…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

31 thoughts on “Become Smart Excel User Using This EXCEL TRICK

    SUNNY KUMAR

    (September 16, 2020 - 3:59 pm)

    Thanks a lot sir….mere saath main ye problem bahut thi….

    SUNNY KUMAR

    (September 16, 2020 - 3:59 pm)

    Thanks sir

    Woldy World

    (September 16, 2020 - 3:59 pm)

    Mujhe ek problem hai,,
    Excel me jo date ham dete hai woh thk rehta hai but jab main kisi ko mail Karun toh date ka format change ho jata hai,, solve this please

    nandan jana

    (September 16, 2020 - 3:59 pm)

    Sir excel main formula chhorke text and number delete keyse kere yea
    Formula ko 2nd sheet main keyse convert kere Pls help me

    Kamran Nabi

    (September 16, 2020 - 3:59 pm)

    In one go

    Kamran Nabi

    (September 16, 2020 - 3:59 pm)

    Dear how to create multiple workbook of whole month

    Rooney chauhan

    (September 16, 2020 - 3:59 pm)

    Hello sir,
    I hope you are doing well now
    Actually I want to ask you something since long time can you make new tutorials for us related to Google sheets full explanations all math odds i'm waiting for the videos n thank you so much for your amazing helpful very informational videos I learned a lot from you deepak sir you are doing great job well done n best of luck for your upcoming Google docs videos… ❤️👌👌👌❤️👏👏👏😇👍

    ADI KARLE

    (September 16, 2020 - 3:59 pm)

    सर मेरे पास एक exel sheet है उसमे 450 कस्टमर कि लिस्ट है
    लिस्ट मे उसका नाम, उसका उधार, चालु बाकी, और उसका टोटल करके रखा है
    उसकी दूसरी शीट मे एक बिल का फॉरमॅट बनाय है
    तो ऊस बिल मे बनया ऊस लिस्ट का डेटा डालणा है
    But उस लिस्ट के सभी कस्टमर का अलग बिल बनाना है
    प्लिज मेरे को व कैसा करना है बटाइये या कर के डिजिये
    प्लिज🙏

    Mitesh Rahevar

    (September 16, 2020 - 3:59 pm)

    Jo aap cell ma old select karo to vahi data transfer ho jo old se related ho, if I select new option so vahi data transfer ho jo new se related ho

    How to transfer
    Which formula use

    KAUSHIK HALDER

    (September 16, 2020 - 3:59 pm)

    Sir ji aap toh Excel ka Master ho..apki har video bht hi Informative hota hai… 1 Request hai – Aap Open Office 4 ke Spreadsheet me Vlookup & Hlookup wala kuch video banaiye na… Please

    Kamal Dougwal

    (September 16, 2020 - 3:59 pm)

    Sir apka contact no.mileja officially kuch puchna jruri hai

    Rajinder Saini

    (September 16, 2020 - 3:59 pm)

    Can We Extract Data Between Two Dates With Any Simple Formula…

    Shubham Malla

    (September 16, 2020 - 3:59 pm)

    Nice video
    #ASHHSISTERS

    Anglina Anglina

    (September 16, 2020 - 3:59 pm)

    Sir mujhe complete computer operator and programming assistant ka course sikhna h .mplz btaye kese hoga

    Saboor Halimzi

    (September 16, 2020 - 3:59 pm)

    Dear sir
    please make shop management system 🙏

    NAVJYOT SINGH

    (September 16, 2020 - 3:59 pm)

    I have query when I click in excel numbering heading a tab open which are delete, copy, cut,paste but insert open show hide. How could I get back this.

    Rupesh Patel

    (September 16, 2020 - 3:59 pm)

    Sir mujhe Petrol pump managment sheet pe krna hai plz petroleum managment sheet pe video banaye..

    Monty Goyal

    (September 16, 2020 - 3:59 pm)

    Pls Excel file ko password lgane ka btana pls

    Umesh Kumar

    (September 16, 2020 - 3:59 pm)

    सर मै excel sheet मे बहुत दिन से फ़ोर्मुल लगा रहा हूँ मसाला बनाने का पर जैसे मुझे चाहिये ओ लगा नहीं पा रहा हु अगर आपके पास समय हो तो क्या आप मुझे guide कर सकते है ? मेरा न. 9910831495

    Ramashish Mallah

    (September 16, 2020 - 3:59 pm)

    What are the benefits of Membership.

    anokha sangam

    (September 16, 2020 - 3:59 pm)

    दक्षिण हरियाणा बिजली वितरण निगम के बिल पर वीडियो बनाइए प्लीज तब मैं मान लूंगा कि आप एक्सेल में एक्सपर्ट हो

    Kashif Khan

    (September 16, 2020 - 3:59 pm)

    THANKS SIR FOR PROVIDING UR VALUABLE TRICKS AND TIME, WHAT IS THE SHORTCUT KEY OF PASTE SPECIAL KEY OF " VALUE ONLY" REGARDS

    BHAVESH PARMAR

    (September 16, 2020 - 3:59 pm)

    Today date is remembered

    inderjit singh

    (September 16, 2020 - 3:59 pm)

    Nice video sir

    GAURAV RASTOGI

    (September 16, 2020 - 3:59 pm)

    You have 9 times more subscribers than one Blog which is considered the Most Popular Excel Blog , Well Done Bro …

    Vilas Chavan EduTechCare

    (September 16, 2020 - 3:59 pm)

    Sir, please make videos on vba userforms

    Jai Prakash

    (September 16, 2020 - 3:59 pm)

    Nice vdo

    Knowable Info

    (September 16, 2020 - 3:59 pm)

    excellent sir

    Sukh Talwandi lal singh

    (September 16, 2020 - 3:59 pm)

    Please contact no

    Sukh Talwandi lal singh

    (September 16, 2020 - 3:59 pm)

    Good

    Indian Monster

    (September 16, 2020 - 3:59 pm)

    # How to make this Proper way to Convert USD DOLLAR Amount to Word…..in EXCEL VBA Script ?????

    USD $ :

    100050.20

    ONE LAKH FIFTY AND CENTS TWENTY ONLY –( This line has been Proper way to convert USD Dollar to word)

    ( I WAS used Powerutility add-ins but every time change Formula , Im scared, totaly time Wasting every time ……….

    Show above the result…….

    pleased make this VB module File……

Leave a Reply

Your email address will not be published. Required fields are marked *