In the article below we addressed a couple of our latest Excel tips to help you to work faster using Excel in your daily routine. You will learn how to deselect cells or a range from a current selection, how to quick analyse data in Excel, to add a conditional column, and finally add a column from an example.
How to Unselect a Cell From a Selection
With the whole area selected, you hold down the CTRL (or Command on mac) key and click on the cells you want to deselect. To unselect a range of selected cells hold down the CTRL (or Command for Mac) key and drag the range you want to deselect, starting from within a selected range. As you can see in the image below.
How to Multi Select Cells or Ranges
This feature as available before, it means that you can still use the CTRL (or Command on Mac) key to click on an unselected cell to select it. The new thing is that you can select an additional range simple use the CTRL (or Command on Mac), starting on an unselected cell and drag the mouse to select the range, as the image below is showing.
*This article is based on the information provided by the Microsoft blog which you can access here.
How to Quick Analyse your Data in Excel
Excel's Quick Analysis button lets you instantly create different types of charts, including line and column charts, or add miniature graphs called sparklines. Check the example below to see how it works.
Select the data and select the Quick Analysis button in at the end of your selection (or press Crtl + Q).
Them select charts and click more to see all chart options available.
Choose the type of chart you want, and it will be ready.
Watch below the video explaining how to use the feature:
How to Add a Conditional Column
Using Power Query in Excel, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically display the values that you specified. Click below to play the video and see how it works.
Add a Column From an Example
You can use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column. You can create a new column example from a current selection, or from providing input based on all (or selected) columns in a given table. Watch the video to see how it works:
*The videos above are from the Microsoft Office 365 Youtube channel.
Master your Excel skills
Being Microsoft Office skilled can be handy in the daily basis, it can save your time and make your activities more productive. At New Horizons Ireland we frequently run a wide range of Microsoft Office classes either on our premises or online. Check out below our classes.
We also provide a wide range of Technical courses, such as Microsoft Azure, Windows Server, CompTIA, Cisco and more.
Complimentary Office Skills Assessment
Looking to find out what level of Excel, Word or PowerPoint you need to enrol in or simply looking to find out your level of expertise in Office? Well click the link below and take the test no, completely obligation free.
Free skills assessments for:
Subscribe for more!
Like our tips and tricks? Like to get your hands our latest keyboard shortcut cheat sheets? Or want to make sure you never miss our webinars and resources? Well subscribe to our Newsletter now!