Excel Basics Lecture Orientation

in #education6 years ago

hello. I'm JC and I am an office worker who mainly deals with Excel.

The first step is to understand Excel Function.

Mainly used functions are "SUMIF", "SUMPRODUCT", "VLOOKUP", "OFFSET", "MATCH".

The next step is to create a function using "EXCEL VISUAL BASIC".

it is a very important. At this stage, you will be able to use Excel proficiently.

The last step is to make the Excel fluid using "MACROS".

If you use the excel macro, you can easily program any material used in the company.