Advance Excel helps a person to be highly proficient with Microsoft Office and particularly Excel (i.e. pivot tables, lookups, advanced formulas) and Excel advanced functions (macros, index, conditional list, arrays, lookups).
About this Course
This course will give you a deep understanding of the advanced Excel formulas and functions that converts Excel from a basic spreadsheet program into a productive and powerful analytics tool.
You will learn how to use Excel, and write powerful and dynamic Excel formulas, automate, streamline, and completely revolutionize your workflow with Excel.
It will help you master unique tips, tools, advanced graphs, formatting a worksheet, shortcut keys, and graphs and graphics.
This course will build your skills in areas of Excel formulas to analyze dates, text fields, values, conditional formatting, pivot tables, and financial functions.
What will you achieve?
Who this course is for ?
Students (irrespective of any field) with 10+2 or graduation qualifications.
Anyone who wishes to learn Microsoft Excel.
Anyone who wants to be proficient in Microsoft Excel programme.
Anyone with a desire to be a data analyst, market research analyst, financial analyst, clerk, etc.