+91 8877442020

ADVANCED EXCEL
An Excel Expert is a person who collects, organizes, and analyzes data. S/He is also involved in finding, editing and analyzing data, creating databases and writing reports with conclusions. There are various techniques of data analysis, which an excel expert must understand in order to perform efficiently.
Data analysis is important as it assist humans in getting the insight of patterns related to business, customer, revenue, etc. Therefore, doing the analysis helps to produce the best results for the decision making. The conclusions made by excel expert based on data are very helpful in every organization for forecasting the business speculations.
Course Details
Description
This course is for professional looking for advanced data management and creating industry standard reports and charts in Microsoft Excel.
-
Advanced File Tasks
-
Working with Functions and Formulas
-
Data Tools in Excel
-
Managing Tables in Microsoft Excel
-
Grouping & Outlining and Subtotals
-
What-If Analysis
-
Advanced PivotTables & Chart
-
Advanced Excel Tasks
-
Creating HLOOKUP and VLOOKUP Functions
-
Advanced Conditional Formatting
-
Advanced Lookup Functions
-
Advanced Functions in Excel
Eligibility
HSC and Above
Bachelors Degree and Above
Anybody wants to become Data Analyst
Who want to learn advance Excel for more skillable work.
Duration
Regular Mode
45 Hrs / 2 Months
LIVE Training
10 Days