• Categories

Project Based Learning on Microsoft Excel: Basic to Advance

Product ID: VNHA7881

 Availability
Not Available

 Venue
Online - Learn from home

 Duration
30 Hrs

 Date
10th October, 2023

Invite your friends

Add to Calendar 10/09/2023 09:00 AM 12/10/2023 06:00 PM India Standard Time Project Based Learning on Microsoft Excel: Basic to Advance I'm inviting you to join this event. Please take a look. Event name: *Project Based Learning on Microsoft Excel: Basic to Advance* Link: https://vaanahaa.com/product/microsoft-excel-basic-to-advanced/ Online - Learn from home

1990 5990 ( 67% Off )
18% GST applicable*

Developed by: Vaanahaa Eduction and Innovation Labs

What you'll get

Live Classes

No recorded videos, inreact & learn directly from the industry expert.

Q&A Sessions

Clear all your doubts directly from the industry expert.

Unique Certificate

Shareable Online certificate with unique verification code.

Digital Resume

Build your resume at zero cost at our platform.

1-1 Mentorship

Get one to one metorship and career guidance from our experts.

Preplacement Support

Pre-placement assistance from our dedicated HR Team.

Internship

4 weeks internship opportunity for deserving candidates.

Post Workshop document

Get all the learning materials after successfully completed the course

Multiple Device

Seamless accessibility both on mobile and desktop.

Gift vouchers

Get Gift vouchers from Vaanahaa Education and Innovation Labs P Ltd.

What you'll learn

Key topics to be covered:


  • Introduction Basic Excel Tools and Formating
  • Working with Excel Conditional Functions
  • Working with Excel lookup Working with Excel List
  • Introduction to Excel function ie, DSUM(), and various criteria of following ie, OR Criteria, AND Criteria
  • Introduction to DAVERAGE(),DCOUNT(), SUBTOTAL()
  • Working on Excel data validation
  • Dynamic formula using Excel data validation technique
  • Importing and Exporting Data
  • Working on Excel Pivot Tools
  • Excel Power Pivot KPI
  • Working with large sets of Excel data ie, Consolidating Data from multiple worksheets
  • Working with Excel Conditional Functions
  • Working with Excel lookup Functions
  • Introduction to Auditing of an Excel Worksheet
  • Automated repetitive tasks using Macro Function
  • Protecting Excel Worksheets
  • Mastering WHAT IF tools

...Read more
  • Overview
  • Certification
  • Prerequisite
  • Eligibility
  • Overview +
  • Certification +
  • Prerequisite +
  • Eligibility +

Benefits

    • Certificate with unique verification code.
    • Build your resume at zero cost at our platform.
    • 1-1 Career Guidance and Mentorship from our experts.
    • Pre-placement assistance from our dedicated HR Team.
    • Gift vouchers from Vaanahaa Education and Innovation Labs P Ltd.

Why Vaanahaa

  • Quality education is more accessible & affordable.
  • Competencies are based on research and results.
  • We model what we teach.
  • Superior industry experts as chief trainers.
  • Allow you to cement your credibility in the industry with this professional credential.
  • We ensure that our pricing stays competitive, allowing learners to have a great learning experience at the best price possible.
  • Vaanahaa has always prided itself on providing the best quality of education and super productive learneing experience in the market.
  • For more queries please feel to dial our toll-free number 8272 949 397 or write us at hello@vaanahaa.com

Review & Ratings

Add Your Review & Rating

You may also like