1 / 13

MS Excel Shortcuts 2020 | Excel Shortcut Tips And Tricks 2020 | MS Excel Tutorial l Simplilearn

Microsoft Excel is a top-rated application used for recording, analyzing, and visualizing data. Excel has several shortcut keys that help you in speeding up your work. In this video, we will look at all the essential shortcuts in excel and see how easily you can play around with data with just a few keyboard clicks.<br><br>u2705Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH

Simplilearn
Download Presentation

MS Excel Shortcuts 2020 | Excel Shortcut Tips And Tricks 2020 | MS Excel Tutorial l Simplilearn

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What Is Microsoft Excel? Excel is an application developed by Microsoft that is used to record, analyze and visualize data which is form of a spreadsheet

  2. What Is Excel Used For? • Data entry • Inventory management • Creating checklists • Data filtering • Analyzing data • Building reports and dashboards • Regression analysis • Automating tasks through macros

  3. Click here to watch the video

  4. Excel Shortcuts Excel supports a number of keyboard shortcuts that you can use to speed up your work and make it more efficient Ctrl Shift 9 + +

  5. Workbook Shortcuts • Create a new workbook • Open a new workbook • Save a workbook • Close current workbook • Close Excel • To move to the next sheet • To move to the previous sheet

  6. Cell Formatting Shortcuts • Edit a cell • Copy and paste cells • Bold and italicise the font • Center align cell contents • Add a border • Add outline to the select cells • To delete a column • To hide the selected row • To move to previous cell • Select cells on the right

  7. Additional Cell Formatting Shortcuts • Add a comment to a cell • Display find and replace • Activate Filter • Insert current date • Insert current time • Insert a Hyperlink • To apply currency format • To apply percent format

  8. Row and Column Formatting Shortcuts • To delete a column • To hide & unhide selected row • To hide & unhide selected column • Select the entire row • Select the entire column • Select the entire worksheet • Group and ungroup rows or columns

  9. Pivot Table Shortcuts • Group pivot table items • Ungroup pivot table items • Hide pivot table item • Create a pivot chart on the same sheet • Create a pivot chart on a new sheet

  10. How can Simplilearn help?

  11. Join us to learn more! simplilearn.com UNITED STATES Simplilearn Solutions Pvt. Limited 201 Spear Street, Suite 1100 San Francisco, CA 94105 Phone: (415) 741-3319 INDIA Simplilearn Solutions Pvt. Limited #53/1C, 24th Main, 2nd Sector HSR Layout, Bangalore 560102 Phone: +91 8069999471 UNITED STATES Simplilearn Solutions Pvt. Limited 801 Corporate Center Drive, Suite 138 Raleigh, NC 27607 Phone: (919) 205-5565

More Related