Welcome to officecoding...

2017 April

What function should I use to locate and retrieve data or its associated data?

April 18, 2017
|

VLOOKUP and HLOOKUP are the functions that can do this. VLOOKUP is the function that will search data vertically while HLOOKUP is the function that will search data horizontally.

The below image shows how VLOOKUP Function works:

In the above example, […]

Read more

How to integrate or combine values from two (2) or more columns in Excel?

April 18, 2017
|

The function of Microsoft Excel that can do this is called Concatenate Function.   The below image shows how  Concatenate Function works:

There are cases where there is a need to combine two or more different data contained in different columns.  In […]

Read more

Advanced Solutions or Tools within Excel Using VBA in Dubai and UAE

April 18, 2017
|

Microsoft Excel is more than just a spreadsheet. Dubai or UAE companies in general can benefit a lot in using Excel.  Two (2) of the advanced features of Excel and other Microsoft Office Applications are the Visual Basic Editor (VBE) and Visual Basic for Applications (VBA).

Too […]

Read more

What can Microsoft Excel be used to?

April 18, 2017
|

Microsoft Excel is the most used spreadsheet program in the world. Dubai companies can also benefit from Microsoft Excel. Why use Microsoft excel in Dubai? Everyone can use Excel in Dubai to analyze data and make better decisions.

The following are the reasons:

Excel is easy to use […]

Read more