Posts

Showing posts with the label learning excel

Embed other Extension file in Excel

 To insert an object in Excel, follow these steps: Click on the cell where you want to insert the object. Click on the "Insert" tab in the top menu. Click on "Object" in the "Text" section of the toolbar. In the "Object" dialog box, select the type of object you want to insert. You can choose from options such as "Microsoft Excel Chart," "Microsoft Word Document," "Adobe Acrobat Document," and others. Select the "Create New" option to create a new object or select "Create from File" to insert an existing file. If you selected "Create New," select the type of object you want to create and click "OK." If you selected "Create from File," browse for the file you want to insert and select it. If desired, check the box next to "Link to file" to create a link between the object in your Excel sheet and the original file. Click "OK" to insert the object int

Excel Multiple Choice Questions

Image
You may wonder what top 10 questions multiple choice in Excel which help you to groom yourself in Excel sheet check out al Ten questions Don't forget to subscribe our blog for latest updates on. Data analytics | Excel | Certification  What is the keyboard shortcut to save an Excel spreadsheet? a) Ctrl+S b) Ctrl+P c) Ctrl+X d) Ctrl+Z Answer: a) Ctrl+S Which of the following formulas would you use to add up a range of cells in Excel? a) =SUM() b) =AVG() c) =COUNT() d) =MIN() Answer: a) =SUM() What does the function =NOW() do in Excel? a) Returns the current date and time b) Returns the current time c) Returns the current date d) Returns the current year Answer: a) Returns the current date and time Which of the following is NOT a valid chart type in Excel? a) Pie chart b) Line chart c) Bubble chart d) Email chart Answer: d) Email chart What is the shortcut key to insert a new row in Excel? a) Ctrl+R b) Ctrl+N c) Ctrl+I d) Ctrl+Shift+Plus (+) Answer: d) Ctrl+Shift+Plus (+) Which of the

Resolve NA Error in Ms Excel

Image
 in this series are covering the topic called #NA Error , Technically, this is not an error value but a special value that you can manually enter into a cell to indicate that you don’t yet have a necessary value ( NA – No Value available )  .  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   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 #ErrorHandlingTechnique these error handling advancement makes you more proficient in excel while you use any #Formula

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

Add Header and Footer for Ms excel

 In this video we have covered how to setup a page while taking a printout in #MsExcel and also covered the importance of #PageSetup and #ViewTab in #MicrosoftExcel  This video will help you before you taking a any printout to make sure how to select page setup ( #Protrait , #Landscape ) #PageMargin and why we use the #NarrowMargin while giving the printout .  You may have queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  What is Page Setup in Excel? How do you set page area in Excel? How do I set my printer page? Why is Page Setup greyed out in Excel? What is the use of view tab ? How to add header and footer in excel sheet? How to add header in excel sheet Our consistent #DiscoverTalent143 follower gave us the recommendation video who is the winner of #MrsFaceOfIndia2020 #PreetiThakuria watch her message at the end.  This function will help you to make your work smartly in your #DailyRegime #Office , #School #College