Advanced Excel
Learn Advanced Excel Course in Chembur, Govandi, Nerul & Chembur Naka at Anubhav. It is recognized as the Best Institute for Advanced Excel Course with 100% Practical and Industry Expert Trainer.
Industry
Trainer
100% Job
Assistance
Personal
Attention
Recognized
Certificate
About Avanced Excel Course
Microsoft Excel Software remains one of the most important software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable skill to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others.
Advanced Excel Course Outline
- Excel Introduction
- Addition
- Substraction
- Multiplication
- Minimum
- Maximum
- Average
- Sum
- Today Function
- Grade
- PercentageΒ
- 2d Column Chart
- 3d Column Chart
- 2d Line Chart
- 3d Line Chart
- 2d Pie chart
- 3d Pie Chart
- 2d Bar Chart
- 3d Bar Chart
- 2d Area Chart
- 3d Area Chart
- Scatter Chart
- Combo Chart
- Sorting and Filtering
- Custom Sorting
- Nested If Function
- Shortcut Keys
- Data customization
- Data Formatting
- Functions(Sum, Average. Min, Max, Small, Large)
- Worksheet protection
- Page setup
- Hyper
- If-Lookup
- H-Lookup
- V-Lookup
- Nested Lookup
- Range Lookup
- Match Function
- Index Function
- Double V-Lookup
- V-Lookup with Match Function
- V-Lookup with Choose Function
- V-Lookup with Column Function
- If, And, OR, Not Functions
- Count
- Count A
- Count IfΒ
- Count Blank
- Datedif Funtion
- Advanced Filter
- Conditional Formatting
- Advance date and time Function
- Manipulation of text
- Text to Column
- Merge Workbooks
- Manage Workbooks
- Work with sparklines
- Surface, Radar & Combination Chart
- Macros
- Data Table
- Flash Fill
- Freeze Panes
- Subtotal
- Scenario Manager
- Goal Seek
- Data Table
- Dsum
- Dmax
- Dmin
- Daverage
- Dcount
- DcountA
- Upper
- Lower
- Proper
- Left
- Right
- Mid
- Concatenate
- Len
- Exact
- Search
- Replace
- Power
- Date
- Now
- Day
- Month
- Year
- Validation Criteria
- Whole Number
- Drop Down List ( List )
- Text Length
- Decimal
- Circle Invalidation Data
- GST Bill Calculation
- Preparing GST Bill
- Page Layout Margin Setting
- Insert List & custom list
- Sorting & Custom Sorting
- Filter & Advance Filter
- Pivot Table
- Pivot Chart
- Slicer and Report Connections
- Developer Tab (Advanced)
- Advance Stock charts
- Custom chart templates
- Consolidation
- Share Workbook
- Compare & Merge
- Remove Duplicate Data
Course Duration – 1 Month
Fees – 6,000/-
Authorized Institute in Mumbai and Navi Mumbai for Advanced Excel Course, Since 20000
Student Testimonials
I have joined courses like mscit, tally, Excel typing,.. The teaching procedure is really good.. It's quiet interesting as it gives more knowledge and experience. It is Best Institute for Advanced Excel course in chembur
My name is Vinayak vilaspure I m from Anubhav classes I felt very nice learning from all the teachers as they are very calm and friendly with the students and solve every doubt of their student also in this pandamic they took initiative and everyday without being irresponsible. It is the Best Institute for Advanced Excel course in Chembur
I learnt mscit, typing,excel,tally,gst courses in Anubhav Computer Institute. It is one of the fab institute which dont only provide computer knowledge but also provides job facilites to their students. Best Institute for Advanced Excel Course in Govandi.
I have joined this Institute for MS-CIT, MS-OFFICE and Excel and I really liked the teachings of the faculty of this Institute. The instructors teaches us in a very simple manner which is understandable. Best Institute for MS-CIT course in Govandi
Superb institute π―π― Very nice coachingπ Class arrangement is clean and very nice β₯οΈ. Best Institute for Advanced Excel course in nerul
