Advanced Data Analysis Level 1
- Advanced excel fundamentals
- Important rules like Table design, Cell reference, Cell value input, Knowing Rows & Columns, Division, SUM, Percentage, Multiplication, Subtraction, Cell locking, Row/ Column lock, Table arrays, painter, Automation, IF, SumIF, Count, CountIF, Average, Freeze panes, double sum, Triple sum, Triple multiplication NEW, Vlookup, double IF, multi sheet rules, Hlookup, Index & match, Array, MIS, analytics, dynamic Charts & more.
- MS excel / WPS
- Free lessons available
- Analyze and compare data
- Make reports & advanced rules for analyzing data
- Advanced assignments
- Interview preparation & career guidance
- Certificate of achievement.
- Complete study time: 40 hours
- 100% best for HR, Finance, Marketing, E -commerce, Education, Sales etc.
Excellent course for all people who needs Advanced Excel and learning
Best in this price and very easy to understand. I got 50+ rules in this course. I really liked the course.
Guys don’t just look at price get benefits.
Best thing you get free courses and certification and then enroll for any paid course as paid courses will add more value in any CV and employers endorse in your promotions.
Download coupons & free CV
- Get a chance to learn important new age skills for your jobs.
- Save time and money
- Organizations get trained employees
- Create better analytical skilled employees
- 100% English
- For direct counseling In India DM Instgram @anywheregk
- School students / college students
- Corporate jobs / Businessmen / Companies.
- Anyone seeking better knowledge of Advanced Data Analysis
Analyze & manage data
Some topics will be repeated so that you can understand and they are important.
Beginner data rules
Analyze data with simple & advanced rules
- Data cleaning & sorting ADAL1
- Absolute,relative cell referencing, sum, divide, percentage ADAL1
- Transpose, all round rules & filter beginner ADAL1
- Freeze panes & advanced date ADAL1
- Concatenate, flash fill, sort & filter & advanced conditional formatting ADAL1
- Dynamic charts & print ADAL1
- HR performance management & data analysis ADAL1
Advanced data rules
Analyze data with advanced rules
- If, vlookup & advanced vlookup. double if & multisheet rules ADAL1
- Hlookup & advanced Hlookup ADAL1
- Index ADAL1
- Match spreadsheet ADAL1
- Match & reconcile with advanced conditional formatting ADAL1
- MIS Advanced Analytics 1 ADAL1
- MIS Advanced Analytics 2 ADAL1 Part 1
- MIS Advanced Analytics 2 ADAL1 Part 2
- ADAL1 Assignments
- Career guidance & Comparison with other websites ADAL1
- Course review and offer ADAL1
- Interview preperation ADAL1
- ADAL1 Exam