Posts

Showing posts with the label excel hacks

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

Find the Largest Number in Excel

Image
Discover Talent Presents - Find the Largest Number in Excel When there are duplicates MAX or LARGE Function  , this is essential function in ms excel #LARGE #MAX #Formula in #Excel in this series clearly explain how it works max function and its feature  also clearly defined how we can add the FREQUENCY AND #IF formula in #LARGE_Function which fetch the correct result from the #BigData watch this video entirely and dont skip it .   You can type this on the google Discover talent presents to get the free learning material for MsexcelTraining Hurry up.! We also available on the below platforms. Pinterest  https://www.pinterest.com/DiscoverTalentPresents Instagram (Reels & IGTV): @DiscoverTalent143  Tumblr: - https://discover-talent-present.tumblr.com  YouTube: (Shorts) – https://www.youtube.com/DiscoverTalent143  Facebook: - https://www.Facebook.com/DiscoverTalent143  LinkedIn: - https://in.linkedin.com/in/discovertalent143 Blogger: https://discover-talent-presents.blogspot.com Teleg

Extract Domain Name from an Email ID in Excel

Image
 Discover Talent Presents -Extract Domain Name from an Email ID in Excel -1 if you want to see how to extract a user name feel free to watch our previous video series Extract User Name from an Email ID in Excel  Extract Domain Name from an Email ID in Excel In #Excel when we have raw dump with email id's and we need to adhere ETL ( Extract , Transform and Load ) in excel that time formulas and function plays a really important role in this tutorial as well i have demonstrated how you can segregate user name from email id with 2 unique ways feel free to comment in below section which step you loved the most and which save your time make you more productive in your daily regime office work #LEFT #Search Function and #FindAndReplace . These steps are simple and easy to perform if you still find any difficulty to perform feel free to ping me on FB / LINKED IN / Youtube / Instagram channel Happy to assist  You can type this on the google Discover talent presents to get the free learn

How to use SumIfs Function

Image
How to use SumIfs Function  Discover Talent Presents - Sum Ifs Function in Ms Excel #Shorts #Excel #SumIfs . Sum function will help you to get the total of specific value , SUMIFS help you to add multiple condition based on that you will get the summary based #Total of the #Sales / #Salary whatever data you wish to have the #GrandTotal in this tutorial we have tried the sample data sheet where you can add the #Criteria for #SumIfs #Function or #Formula and get the result instantly . Urge you to pause on the video wherever required. our motto is to #Upskill our #People #FreeOfCost  You can type this on the google Discover talent presents to get the free learning material for #MsexcelTraining Hurry up.! We also available on the below platforms. Pinterest https://www.pinterest.com/DiscoverTalentPresents Instagram (#Reels & #IGTV): @DiscoverTalent143  Tumblr: - https://discover-talent-present.tumblr.com  YouTube: (#Shorts) – https://www.youtube.com/DiscoverTalent143  Facebook: - htt

Use Filters in Ms Excel

Image
 Use Filters Effectively in excel - Filters function is the essential feature in ms excel you can either use the ctrl + shift + L or you can use Alt + D + F + F for the filter the specific work sheet in ms excel #Filter and the #AdvanceFilter how to use this function more smartly in the series i have covered for the same.    #MsExcel checkout the more learning for #Analytics and #BusinessSolution with us , we also offer certifications with free of cost and career guidance #SixSigma we are launching soon hence urge you to subscribe our channel and get Free of cost #YellowSixSigma Certificate . It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the whole job. Discover Talent Presents what we offer work on large worksheet effectively check out the video and share your comments in below section and don’t forget us to subscribe because your one subscribes or thumb in the form of like motivate us to

Correct VALUE Error in Excel

Image
 Discover Talent Presents | How to correct a VALUE error in the Excel function #Shorts  in this series are covering the topic called #VALUE_Error, this error is most often the result of specifying a mathematical operation with one or more cells that contain text...  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same. We are here to help you out the #VALUE!  It means the Wrong type of argument in a function or wrong type of operator These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandling

Discover Talent Presents REPLACE Function- REPLACE Formula in Excel

Image
 I need 7K views targets 🎯 To get new video 🎥 published  Pls show your support coming #Live soon #LiveQuiz  REPLACE Formula in Excel | Change Text with Excel REPLACE Function | How To Use Replace Function  Discover Talent Presents – Replace Function in Excel | How to Use Replace Formula in Ms Excel #Shorts In Accounting, Finance, MIS Related Work Or Any Organization We See The #Shorts  Password protection Salary protected Sheets We Need To Prepare In Data Sheets Through The #ReplaceFunction Function Which Is Available In #Msexcel You Can Easily Do It Without Hassle Watch This YouTube #Shorts And Understand The Ms Excel Tips And Tricks Easy Way with 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 #Trick

Data Validation in Excel

Image
  Data Validation Whole Number | Decimal | Drop Down List | Date | Text Length in Microsoft Excel #DropDownList #DataValidation is an essential function in Ms excel which is most frequently used in excel specially when we create structed forms or any #ExcelTemplate when users interact with your created forms or template and as a publisher and creator you want he /she chose the required field as per the #Validation then this rules needs to set it up as per your requirement there nice amount of options like If incase it's working the above video then refer the below video #WholeNumber #Text #Decimal #Date #List #SelectList and much more few I have covered in this series if you wish to know more about other categories too feel free revert us will help you out now 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 t

=SUM() or Alt + = Which is best?

 Everyone beginner to experience holder who uses the Ms excel they know how to calculate total in Ms excel. Which is good part part. However being known excel and in reality being more productive in our daily regime is more important So here is the Quick Tip from discover talent presents how quickly you could add the sun value for respective cells in Ms excel This video we have demonstrate that the fast work or more productive work applicable any laptop user then if you are windows user or MAC user.  As you know with the help of =Sum() function we could add the total But here with help of keyboard short cuts fraction of sec you will get the result Try this ExcelHack and share your feedback in below comment. 

COVID-19 Recommended Chart and 3D Map

Image
 In this video series we will cover #RecommendedChart #COVID19 #InsertRibbon . this will help you to not only use the insertion function like #clipart #logo #button #image #graphics #photo but alos help you to #datavisualization how to do that . watch this video till end its an free ware asset for all of you and it’s a great platform to enhance your skill So keep watching this video till end . and share your love with us by clicking on the #Like button. C19 Data analysis you can you on your own  https://www.youtube.com/watch?v=23sX95u2wfM&list=PLCqnj_UiTQvPNZd8qDa23Jrm0AomlmTjy Also in upcoming #Video series we will cover #COVID19 data visualization 3D maps with cases and #death data will get it from #WorldHealthOrganization #WHO #COVID19_Deaths #Covid19_Cases with #charts and #3DMap so don’t miss the ending of this video also the beginning of that video. Would encourage you to subscribe our channel to learn and earn the #FreeCertificate in ms excel How ? watch our video series 1

Home Ribbon Tab MsExcel

Image
Discover Talent Presents | Home Ribbon Tab - Conditional Formatting Tutorial 5-6 In this video series we will cover the #ConditionalFormatting #FormatAsStyles #CellStyles #MsExcel #MsExcelTraining . If you are New to my channel would recommend you to subscribe my channel on YouTube .We have covered #Clipboard, #Font, #Alignment , #Number & and in this series we will cover #Styles.  Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. So stay with me and watch the complete video series this made for the beginners who wish to start there career in #Reportng #Anlyst #WorkinMsExcel   Type on Google #DiscoverTalentPresents for FREE Certification in Excel By Discover Talent Presents ( Like , Share , Comment ) Discover Talent Presents | Learn Basic Ms excel – Tutorial 1 https://www.youtube.com/watch?v=09lIUqJlf2s Discover Ta