140 likes | 199 Views
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
E N D
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
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
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 + +
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
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
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
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
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
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