- No prior knowledge required.
- Determination and Desire to learn new things.
- A positive attitude to success.
- A willingness to learn and practice.
Enroll in the Course Below Open – Enroll Course
Welcome to the best online course on Excel.
its features and formulas, one can use the tool to make send of the data.
- Basic formatting in excel
- Datatypes of excel
- Insertion and deletion of new rows and columns in excel.
- Sorting and filtering data in excel
- Learn about the different text functions- UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, TRIM, CONCATENATE, LEN
- Learn about the different statistical functions- MIN, MAX, AVERAGE.
- Finding different percentiles.
- Finding missing values in data
- Finding outliers in data
- Learn about the different logical functions- IF, IFERROR, COUNTIF, SUMIF, AVERAGEIF.
- Learn about conditional formatting.
- Learn about lookup functions- VLOOKUP, HLOOKUP.
- Learn about index and match
- Learn to create pivot tables and pivot charts.
- Learn to create interactive dashboards.
- Learn about What-if Analysis:- Goal Seek analysis, Data Tables, Scenario Management.
- Learn about performing linear regression in excel.
- Learn Advanced Filtering.
- Macros and VBA.
- User-Defined Functions.
- Working with VBA Forms and many more.
Enroll now and make the best use of this course.
Who this course is for:
- Who is interested in Data Analyst role.
- Who wants to become a Data Scientist.
- To become a successful Business Analyst.
- Those who are looking for Job who wants to be expertise in Excel.
- Students and professionals who want to improve the training capabilities. Job-seekers.