Microsoft Office Skills

Do you want to be a Rockstar in your office from Day 1? Become a proficient user in Microsoft Excel, Microsoft PowerPoint, Microsoft Word.

Latest Articles

Formatting an Excel Worksheet Professionally

In this article we will show you how to give a good-looking initial formatting to an Excel spreadsheet. Please

Formatting an Excel Worksheet Professionally

In this article we will show you how to give a good-looking initial formatting to an Excel spreadsheet. Please feel free to download the spreadsheet files we will use in this article: This is how a blank sheet looks like when you open a new Excel file. What we...
Learn More

INDEX and MATCH – the Perfect Substitute of VLOOKUP

INDEX and MATCH are two of the most interesting Excel functions. The INDEX function can return an item from

INDEX and MATCH – the Perfect Substitute of VLOOKUP

INDEX and MATCH are two of the most interesting Excel functions. The INDEX function can return an item from a specific position in a list. The MATCH function can return the position of a value in a list. The INDEX / MATCH functions can be used together, for the...
Learn More

VLOOKUP and HLOOKUP – Practical Examples

Lookup Functions VLOOKUP and HLOOKUP are among the most frequently used tools in Excel, because they allow users to

VLOOKUP and HLOOKUP – Practical Examples

Lookup Functions VLOOKUP and HLOOKUP are among the most frequently used tools in Excel, because they allow users to transfer large quantities of data based on a given criterion. Please feel free to download the spreadsheet files we will use in this article: In the picture we have here,...
Learn More

Do you want to be a Rockstar in your office from Day 1? Become a proficient user in Microsoft Excel, Microsoft PowerPoint, Microsoft Word.

Popular articles:

Get our Career Guide!