Microsoft Excel – Essential Tricks You Should Know

Microsoft Excel

Image by http://bit.ly/1Y0lLvQ

Proper writing and spelling is important! That’s why Online-Spellcheck.com provides you with a quick and easy spellcheck for all your writings and documents. BUT in many positions, jobs and in every day life, not only excelling in handing Microsoft Word (or other text editing programs) is required.

Many jobs require the knowledge of Microsoft Excel or another spreadsheet software. Thus, we have collected the most essential Excel tricks you should know!

 

Excel Skills For Work & Your Every Day Life

Some of the following tips and tricks will improve your visual presentations while others will help you find your way through spreadsheets or make working with them faster and easier. What all of them have in common is that they are easy to apply and available in the open source programs of OpenOffice and LibreOffice as well! Some of these tricks are even available in Google Sheets, the spreadsheet service from Google.

 

Following, we will show some neat tricks and how you can execute them in Microsoft Excel, LibreOffice or OpenOffice Calc and Google Sheets!

 

Charts

Charts are a great way to professionally present data or get a quick overview. Microsoft Office offers a function called “Recommended Charts” that allows you to choose a design to represent your data in a visually appealing way. And here’s how you do it:

 

Microsoft Word: Insert > Chart > Recommended Charts or Chart Type

OS_Charts_Excel

 

Libre/OpenOffice: Charts symbol in task bar

OS_Charts_LibreO_Button

OS_Charts_LibreO

 

Google Sheets: Insert > Chart > Recommendations or Chart types

OS_Charts_Google

 

Conditional Formatting

As a quick and easy overview, you can also add conditional formatting to your table. Want to highlight values lesser than 50% or text that contains a certain word in a different color? No problem! The rules and criteria as well as the highlighting formatting can be customized to a big extend. Here is how you do it:

 

Microsoft Word: Home > Conditional Formatting > Add

OS_Formatting_Excel

 

Libre/OpenOffice: Format > Conditional Formatting > Conditions

OS_Formatting_LibreO

 

Google Sheets: Format > Conditional formatting…

OS_Formatting_Google

 

Autofill

The autofill feature is one of the most basic in all spreadsheet programs and yet one that is often overlooked. This time saver helps you to quickly copy rows and columns of data. This is how it can be achieved:

 

Microsoft Word: click on bottom-right corner of the cell > drag it

OS_Autofill_Excel

 

Libre/OpenOffice: click on bottom-right corner of the cell > drag it

OS_Autofill_LibreO

 

Google Sheets: click on bottom-right corner of the cell > drag it

OS_Autofill_Google

 

Add Value from other Sheet

In bigger calculations (or when you want a clean spreadsheet to show your data), many different sheets are used in one document. With a very simple command, you can insert vaues from another sheet. Here’s how:

 

Microsoft Excel: enter the command =SHEETNAME!CELL

OS_DiffSheet_Excel

 

Libre/OpenOffice: enter the command =SHEETNAME.CELL

OS_DiffSheet_LibreO

 

Google Sheets: enter the command =SHEETNAME!CELL

OS_DiffSheet_Google

 

Move & Copy Data to other Cells

Instead of a lot copy & paste, there is a very quick way to move or copy a whole selection. In complicated spreadsheets, this makes adding a column in one of many, layered tables a lot easier! This is how it’s done:

 

Microsoft Excel: select section you want to move/copy > move your pointer to the right-most border until a cross icon appears > drag wherever you want

OS_Drag_Excel

 

Libre/OpenOffice: select section you want to move/copy > move your pointer to the right-most border > drag wherever you want

OS_Drag_LibreO

 

Google Sheets: select section you want to move/copy > move your pointer to the right-most border until a hand icon appears > drag wherever you want

OS_Drag_Google

 

Values Starting with 0

If you want to display a value that starts with 0, spreadsheet programs tend to remove all the zeros and start with the first natural number. This can be prevented with one easy trick:

 

Microsoft Excel: type a ‘ at the beginning of your value

OS_Zero_Excel

 

Libre/OpenOffice: type a ‘ at the beginning of your value

OS_Zero_LibreO

 

Google Sheets: type a ‘ at the beginning of your value

OS_Zero_Google

 

email
Posted in Help Tagged with: ,