info@mentoringnmore.com Reshaping Institutions and Individuals

Advanced Excel

This course prepares you to explore additional capabilities of excel such as lookup tables, pivot tables, pivot charts, data validations, macros, debugging, to name a few.

Talk to our counsellor on +91-000000000

Apply Before

11/06/2020

Batch - Feb 2021

duration

4.5

months

Start - 17th Feb 21

Why choose us?

Mentoring n More Academy has a team of data analysts with a profound knowledge and working experience of excel capabilities, functions and macros who are experts in their domain. They have applied their skills and knowledge across industries and have practical knowledge and understanding of excel.

Course Content

Conditional formatting

Date formats and calculations

Sorting and filtering

Lookup tables

Pivot tables and pivot charts

Various other charts (gantt, candlestick, waterfall, etc)

Macros and automation

What you will learn

Create interactive dashboards.

Curabitur lectus enim, ornare ac sapien eu efficitur varius turpis. urabitur lectus enim, ornare ac sapien eu efficitur varius turpisk

Improved data analysis.

Curabitur lectus enim, ornare ac sapien eu efficitur varius turpis. urabitur lectus enim, ornare ac sapien eu efficitur varius turpis

Automation of regular redundant activities.

Curabitur lectus enim, ornare ac sapien eu efficitur varius turpis. urabitur lectus enim, ornare ac sapien eu efficitur varius turpis

Tap additional excel capabilities.

Curabitur lectus enim, ornare ac sapien eu efficitur varius turpis. urabitur lectus enim, ornare ac sapien eu efficitur varius turpis

What you will earn

  1. Able to select the appropriate chart type to represent data.
  2. Able to enhance your productivity by using macros to automate regular and redundant activities.
  3. Build enhanced interactive dashboards.

Eligibility

  • Any adult individual from the age of 18 years onwards is eligible for this course.

Our learning methodology

  • Live Instructor
  • Interactive Workshops
  • Pre-Recorded Lectures
  • Assessments
  • Study Materials

Fee Structure

Lorem ipsum

Lorem ipsum dolor sit amet

Lorem ipsum

Lorem ipsum dolor sit amet

Lorem ipsum

Lorem ipsum dolor sit amet

*Nine-month zero-interest EMI Option available

Note: Lorem ipsum dolor sit amet consectetur adipiscing elit

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.