• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to use keyboard shortcuts in Microsoft Excel to increase productivity

By admin on May 5, 2017April 19, 2019

Using keyboard shortcuts in Microsoft Excel helps you increase your efficiency and productivity, and helps you to use Microsoft Excel like a pro.
In this Tip, we take a look at how we can use Excel shortcuts to save us time and increase our business efficiency. We will learn how to use keyboard shortcuts to accomplish the copying of data, formatting of Cells, deleting, applying formula and auto filters as well to create a chart from the filtered information.

You can get a handy reference guide of all these shortcuts and more by downloading our Free Excel Shortcut Cheat Sheet.
Documented below is a quick reference of all the tasks and associated keyboard shortcuts used in this Excel Tip and Trick video:
– Copy entire sheet
– Ctrl + ‘A’
 – Create new sheet
– Shift F11
 – Paste all values
– Ctrl + ‘V’
 – Paste special … column widths
– Alt key on keyboard
– Press ‘S’ for Paste Special
– Press ‘W’ for Column Widths
 – Delete the Date column (D:D)
– Navigate to cell in D
– Ctrl + ‘Space Bar’
– Ctrl + ‘-‘
 – Change the Product Sales column to not show decimal points
– Navigate to column B
– Ctrl + 1
– Tab to Number
– Tab to 0
– Enter for ‘Ok’
 – Select all blank cells in column G
– Navigate to G1
– Ctrl + ‘Space Bar’
– Press ‘Ctrl + G’
– Press Tab twice to go to ‘Special…’ button, press Enter
– Press ‘K’ for blanks
– Ctrl + ‘1’
 – Fill each cell with the following formula
– =sum(Hx/Gx)
– Ctrl + Enter to fill all cells with the formula
 – Delete Product Name column
– Navigate to column B
– Ctrl + ‘Space Bar’
– Ctrl + ‘-‘
 – Apply Auto Filter
– Alt + ‘A’ + ‘T’
 – Filter Category Name On Beverages
– Navigate to B2
– right click button
– Press ‘E’ for Filter…
– Press ‘V’ for Filter on Cell Value
 – Filter Branch on West Coast
– Navigate to cell C2
– Navigate to B2
– Right click
– Press ‘E’ for Filter…
– Press ‘V’ for Filter on Cell Value
 – Create a bar chart
– Press F11
The post How to use keyboard shortcuts in Microsoft Excel to increase productivity appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

How to use the IFS Function in Microsoft® Excel®
Learn how to quickly and easily make changes to the design of your Sage Intelligence Reports

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd