6 Chrome tricks everyone should know

6 Chrome tricks everyone should know

 

We all have our browser of choice, but odds are, you’ve dabbled in Google Chrome more than a few times. According to its maker, there are roughly 310 million Chrome users, making it by far the most popular browser.

Office for Mac 2016 unveiled by Microsoft

With the release of Office for Mac 2016, Microsoft brings a long overdue refresh to its flagship suite of productivity applications for Mac users. As well as design changes that deliver similarities to the Windows versions of the applications, the latest upgrade - currently free of charge while it remains in preview stage, prior to full release later this year - harnesses the power of cloud computing to deliver Office 365 collaboration features.

Using concatenate in Excel

If you use Excel there is a good chance that you have used a wide variety of formulas. But, when it comes to working out how to combine the content of different cells into a new one, without adding them together, many users will simply cut and paste. Did you know though that the concatenate formula can also do this for you?
Using the concatenate formula to combine cells
If, for example, you have a spreadsheet with first names in column A, last names in column B, and want to combine them into column C to display the full name you can do so by:

Clicking on cell C2 (or the row where the information you want to combine is)
Typing =concatenate(
Clicking on cell A2 and then adding a comma (,)
Clicking on cell B2 and closing the formula with a closing bracket
Hitting Enter

You should see the two cells are now combined in cell C2, with the formula for cell C2 reading:

=CONCATENATE(A2,B2).

The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read:

=CONCATENATE(A2," ",B2)

The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2.

If you have more than two columns you would like to combine, then simply add a comma after each cell.

Excel headers and footers 101

Microsoft Excel has become an increasingly versatile work application catering to most businesses, big and small. While most users are familiar with all the functions the app has to offer, many are still unaware that you can add a header or footer to your spreadsheets.

Creating an alias on Outlook.com

In many TV shows and movies about spies there is always one character with a great alias. When it comes to espionage, an alias is important, but it may seem less so for most business owners or managers. However, with Microsoft's Outlook.com there is a great alias related feature that you may find useful.

How to add address books in Outlook

Microsoft Outlook delivers more than many business people perceive it to do. More than just an email application, this program can also handle important notes, reminders, and details of business matters through Outlook Address Book. Though it is more often used to pull out the email addresses of your contacts, the address book is also a great tool to organize and sync client details to another application.

Using Spike in Word

The word processor is one of the integral pieces of software at a business's disposal. While there are more than a few options available to users, the most useful has to be Microsoft Word. With a variety of useful features, users can create almost any style of document.

Office 2013’s Research Pane

One of the features of Microsoft Office applications is the research pane. It used to be accessible from review menu of a Word document. With the release of Microsoft Office 2013, it appears that research button can no longer be seen under the review tab.

Outlook’s new search folder

Microsoft Outlook is an application used for managing personal information including email, tasks, contacts, and calendars. It is one of the programs that is included when you install Microsoft Office on your computer. While Outlook has many useful features, one of the most useful is the ability to create new search folders which let you conveniently access priority emails.

Getting help for your Office issues

Microsoft Office might not be the program that is top of mind with users these days, but you cannot deny the legendary success it has seen over the past 20 years. Moreover, the platform is still one of the most sought-after enterprise software products in the market.