We all love a shortcut! Here are a few in Excel to speed up your working!
1. CTRL A – select a range of data
2. CTRL SHIFT and END – Highlights from current cell to end of data.
3. ALT F5 – refresh the contents of a Pivot Table
4. To copy an entire sheet – If you want to move a sheet, you click and drag along the sheet tabs. You probably know that! However, holding down the CTRL key when you click and drag will copy the sheet.
Using tables, I can show you how to produce an updatable chart in One Minute with Microsoft Excel! If you need help with Microsoft Office Training check out our Online courses that are available.
Many people complain that they can’t use Pivot Tables and struggle to make them work. One of the big issues is the raw data they are using. Have a look at some of the common problems, and see if you can spot them in your data! Blank Rows or columns – a blank row or column…
How to create an Income and Expenses Spreadsheet. For parts 2 & 3 of this series, click the links below.
Welcome to Day 4 of 5! Today we look at how to enter your formula correct – and avoid using the Autosum function when not totalling figures. To view the preview tutorials click the buttons below.
Over the next week, I will be covering some of the common problems people have with Excel. So if you are struggling to get Excel to work for you WATCH THIS! For the rest of the series, check out the videos below.
Are you having an online meeting, and want to work through a document? Annotations can life much easier! If you enjoyed this video be sure to check out our helpful online courses.
Vue IT Training, Suite 117 Dragon Coworking, 7-8 New Road Avenue, Chatham, Kent, ME4 6BB
© 2021 VUE I.T. Training. All rights reserved.
Website by Dzines Digital
No products in the cart.
