Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations. This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

What you will learn in this course:

• Apply custom formats and layouts

• Create advanced formulas

• Use of Scenario

• Pivot tables and charts

• Manage and share workbooks