Posts

Showing posts with the label Ms office

Change Date Format quickly in Excel

Image
Change Date Format quickly in Excel | Excel Help Excel is very important we spend ample amount of time creating #Pivot and chart but main part is data visualiztion Please note when you click the button on themes it auto change entire sheets font / color / size so apply wisely Every Data Analyst is well known aware about the process called ETL Extracting Transform and Load in excel when we have data sheet we ensure that we need to Analyze Data in Excel  and the goal of discovering useful information, informing conclusions, and supporting decision-making which helps to take better decision for #Business improvement if you could see option call #DataAnalyze tool in excel #AI driven approach file get loaded in the worksheet    Its reward time Best comment on youtube comment section will get the rewarded as our focus is just to educate free with entire world we are also offering certification so what are you waiting for   You can type this on the google Discover talent presents to get the f

Add PowerPoint Presentation in Ms Excel

Image
Add PowerPoint Presentation in Ms Excel Supposing you have a sheet with some data, for vivid and interesting look, you want to insert a colorful background behind cell and worksheet We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny need to pay any other institution will provide you certific

Discover Talent Presents Export Excel Table in SharePoint

Image
 Discover Talent Presents Export Excel Table in SharePoint In this series we are covering Discover Talent Presents – Export Excel worksheet data in SharePoint #Excel #ExportData its very easy way to transfer data from one sheet to other  We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny nee

Microsoft Visio In Excel

Image
 Discover Talent Presents - How to use Microsoft Visio | How to Create Flow chart in Microsoft Visio #MicrosoftVisio is the most creative tool I can say this will help you to #DataVisualization and #FlowChart creation purpose now it’s completely depend upon your usage how you needed as per your requirement in the series we have the #BasicsVisio tutorial if you need more help on this you can directly pings us on Facebook, Instagram we are happy to help you .  We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in

Microsoft 365 AI Worksheets

 Discover Talent Presents | Artificial intelligence in excel | Artificial intelligence in Office 365  AI as we hear from every one, Automation new scope etc etc. now do you know the excel ( #Artificialintelligence ) #MsExcel #Data have that ability who help us to Analyze the data and share us the insights as per ML #AI now you will ask what is ML (Machine learning) basically the task which we used to do same done by the ML more effectively with less errors.  Everyone knows #MsExcel but how are we different from others knowing the #NewFeature like this so here we discover talent presents give you the demonstration how this works and how could you create chart without hassle so watch this video entirely and share your feedback in below comment section if any. we are happy to answer those also if you are seeking any certification, which creates value for your career. We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share e

Resize any Photo or Image Quickly and Easily

Image
 Discover Talent Presents | Resize any Photo in Ms Paint #Shorts Students, Colleagues , College Grads always need to have this option handy #ResizeImage majorly when they submit any online form that time they would need the image in specific size and height and width here #MsOffice #TipsandTricks we came up with the suggestion, where you need to click on the image and check the current size of image and then just open that image in the #Paint simply click on the required size parameter in pixel and you are done if you are still unsure how to do it ? watch our video or else don’t hesitate to ping on your #YoutubeChannel in comment section we will respond you ASAP We have published 150+ videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV.  which creates value for your career. We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search u

REPT Function in Ms Excel

Image
 REPT Function in Excel | How to Use REPT Function | What is the Use REPT In Excel  the #REPT Function is categorized under #Logicalfunctions. The formula will repeat characters a given number of times.  This will help you to #Visualize the #DataSets in Excel especially if you are financial institution or large-scale industry where you want to do #datavisualization or as a #DataSecracy you need hide the exact value of #dollar #Rupee or anything you can do it just click on the play button watch this video till end. You will be fill grateful today after watching this video and learn something new for sure. What exactly this #REPTFunction does ? we have covered this in the video still some glimpse in the form of text is here do refer and sharr your feedback Summary. It basically the Repeat text as specified. The repeated text. You can type this formula like this  =REPT (text, number_times) text - The text to repeat. number_times - The number of times to repeat text. The REPT function repe

Basics Function of Ms Excel

Image
 We have published more than 80 videos which are covering ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV . which creates value for your career . We share excel expertise on this channel ( #QuickExcelHacks , #ExcelTips, #MsExcelTraining , #MsExcel and #MsOffice Guide ) Free of cost ( no hidden charges ) urge you to subscribe us to upskill yourself  हमने 80 से अधिक वीडियो प्रकाशित किए हैं जो आगे बढ़ने के लिए एमएस एक्सेल बेसिक को कवर कर रहे हैं। हम मुफ्त एमएस एक्सेल सर्टिफिकेशन भी प्रदान करते हैं जिसे आप अपने रिज्यूम या सीवी में जोड़ते हैं। जो अपने कैरियर के लिए वैल्यू बनाता है . हम इस चैनल पर एक्सेल विशेषज्ञता साझा करते हैं (#QuickExcelHacks, #ExcelTips, #MsExcelTraining, #MsExcel और #MsOffice गाइड) मुफ्त (कोई छिपा शुल्क नहीं) आपसे आग्रह करते हैं कि आप हमें अपने आप को उप-कौशल प्रदान करने के लिए सदस्यता लें Discover Talent Presents | Ms Excel training - You Should Know These Basic Functions of Excel - LIVE here you should know the

Hide text in spread sheet

Image
Hide text in spreadsheet discover talent presents Welcome to our channel this #Tips #HideText #MsExcel will help you to work more proactively and effectively in your daily regime Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. #ShortcutKey to open format cell is CTRL + 1. Learn more with us and in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents We have published more than 150 videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV.  which creates value for your career. We share excel expertise on this channel in this we are covering #QuickExcelTips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on go

Azadi Ka Amrit Mahotsav Ministry of Culture Government of India

Image
 Free Certification - Azadi Ka Amrit Mahotsav, Ministry of Culture, Government of India #Shorts #GovermentOfIndia आझादी का अमृत महोत्सव get 100% Free certification  Thanks for visiting here  , we also offer msexcel  and other freeCertification  Free Certification | Pride for National Anthem | 15th August - Azadi Mahotsav | Govt. of India #Govt #MinistryOfCulture #RashtraGaan As we celebrate Azadi Ka Amrit Mahotsav, let's take pride in National Anthem: Sing & Upload it on rashtragaan.in Videos will be merged/shown on 15 August 2021. We would appreciate if you tag us on your certificate so we can proudly feature you on our YouTube channel with you photo For more learnings training on analytics, data piece join us on google search 🔍 discover Talent presents and be found

Discover Talent Presents Create Data Entry Form In Excel

Image
Create Data Entry Form in Excel - discover talent presents  Welcome to our channel this #QuickAccessToolbar #DataEntry #Form in excel #Tips #HideText #MsExcel will help you to work more proactively and effectively in your daily regime Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. #ShortcutKey to open format cell is CTRL + 1. Learn more with us and in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents We have published more than 150 videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV.  If any issues occurred while playing video 🎥 don't worry visit our below video which creates value for your career. We shar

Discover Talent Presents | How do I use Advanced Filter in Excel?

Image
 Hi  I m your host Vinod , In this tutorial will show you TOP-6 uses of Advanced Filter in  MsExcel watch this video till end .  You may have the queries like How do I use Advanced Filter in Excel? What are the criteria we can use in advanced filter in MS Excel? Why Advanced Filter in Excel not working? How do I filter multiple criteria in Excel? How do you filter a formula in Excel? advanced filter ms excel Check out the difference between normal filter ( Alt +D + F + F ) & Advance Filter . What is the demerits in #NormalFilter and how beneficial advanced filter in your daily routine work .  This function will help you to make your work smartly in your #DailyRegime #Office , #School #Colleges etc. #MIS #Reports  Just type -  #DiscoverTalentPresents on the Google and be found.  We are also available on the –  #Pinterest https://www.pinterest.com/pin/6591440 #Instagram: #DiscoverTalent143  #Tumblr: - https://discover-talent-presents.tumb... #Youtube - youtube.com/DiscoverTalent143 

Without Macro Record excel Cells

Image
 As we all know there is amazing feature call macro in excel. Which helps you to work efficiently and it removes the manual task for sure A macro is like a set of actions which we ideally record or type codes in the form so whenever required to perform those steps we can use or run multiple times.  A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open to any possible changes. We have Macro based videos coming soon on our channel But what if you NOVICE in Macro and still wanted to remove manual effort!! Can't you  work smart??  The ans is NO  It's not necessary to learn code specially if the inbuilt feature is available in Ms excel  So do you perform that task using Ms Excel In built function.  As we all know instead of reading videos create nice impact for understanding So recommend you to watch the below given video and subscribe our channe

Discover Talent Presents | Top40 Ms Excel Short Cut keys lesson 2

Image
 world is changing  rapidly and we need to go along with the flow by enhancing the skill sets this #ShortCut Keys will help you in your #Competitive exams #Govt as well as  #Private job . This is a basic approach if you have gone through my previous video which is lesson 1 you will be more than happy to continue with this series. as i told you earlier #MsExcel is too vast i think i need to prepare other #Lession3 video which will cover almost all shortcut keys which will help you to enhance your #Skill sets so what are you waiting for ? urge you to please check out the videos which is available on the #DiscoverTalent143 and watch entire video series which will help you to grow in your career. learning is never ending . if you not able to understand any short cut keys in the #Video then please comment in the below section i am happy to help you out with demo as well. main goal our #DiscoverTalentPresents channel is #ToGrowTogether  as we know this is really easy but not sure where to st

Discover Talent Presents | Top 30 Short Cut Keys in Ms Excel Lesson 1

Image
 in #MsExcel #ShortCut plays a very important role . Especially the people who work upon the dash boards , daily reporting , #MIS work . We got amazing response on our #DiscoverTalent143 #Instagram handle . Requesting for the #MicrosoftExcel Shortkeys ! there are ample amount of short cut keys on the . #Google Etc. thing but what my audience needed i know better hence they showed trust upon me :) and without hesitation demanded for the #Begineer level #ShortCutKeys  Here is the video as requested i assure you if you implement this in your daily regime #Working from office or home will help you to stay smartly among the all coworkers so what are you waiting for  Watch the Full video and dont miss the ending ! :) amazing fun and yes you can also find the Discover Talent now on #Google as well Just type - #DiscoverTalentPresents on the Google and be found. We are also available on the -  #Pinterest https://www.pinterest.com/pin/659144095455107390/ #Instagram : #DiscoverTalent143 #Tumblr