Posts

Showing posts with the label Ms excel free training

Free Online Courses

Image
 In Lockdown Get 100% Free Training's | free training courses | Free Online Courses | 50+ Free Course As we all know lockdown in place due to Covid19 things are not really good but as we can hope for the best we need to invest some time in self this is the right time to learn more and upskill we discover talent presents are here to help you out with interview preparation, Ms office trainings and 100% free trainings material one of the website like.  Credly is the world's largest network especially when you login to the linked in or the Facebook and when you search some trainings you can find the #Credly whereas per your areas of interest you can enrol  for the #FreeTrainings #Certification #Badges you will get it watch out our video series you will come to know how to explore this website and what is the procedure to sign up or sign in for this website. Also there are some paid trainings to in the Credly however if you analyze the website in proper way you will come to know to

Ms excel Questions by discover Talent presents

Image
Which keyboard shortcut opens the Go To dialog box? a. Ctrl + B b. Ctrl + Shift + B c. F2 d. F5 @@@@@@@@@@@@@@@@@@@ To keep specific rows and columns from scrolling off the screen you first must  position the cell pointer a. to the right of the column you want to remain on the screen b. below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen @@@@@@@@@@@@@@@@@@@@@ When you create two or four separate windows containing part of the  spreadsheet that can be viewed, you have created a. sections b. panes c. views d. subsheets @@@@@@@@@@@@@@@@@@@@@ The accounting style shows negative numbers in a. Bold b. Brackets c. Paranthesis d. Quotes @@@@@@@@@@@@@@@@@@11 Which of the following component displays the contents of active cell? a. Name box b. Formula bar c. Menu bar d. Status bar @@@@@@@@@@@@@@@@@@@ How many sheets are there in Excel Workbook by default? a. 2 b. 3 c. 4 d. 5 @

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

Discover Talent Presents | combine two text with The help of MsExcel Function

Image
In daily work routine especially when we worked as a data analyst and we use to pull raw dump if we have more than 10000 column or rown to work upon this. Video will help you.  in #MsExcel how to combine two context with the help of #MsExcelFunction ease. ! watch this video from the beginning to avoid more confusion . share your valuable feedback in below comment section . This video will help you in your #MIS , #Reporting , #DailyDashboard and #Educational purpose. .  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 :- https://discover-talent-presents.tumblr.com/ #Youtube - youtube.com/c/DiscoverTalent143 #Facebook :- Facebook.com/DiscoverTalent143 #LinkedIN :-  Check out Discover Talent’s profile on LinkedIn https://www.linkedin.com/in/discovertalent143