top of page

Deep Dive into
Advanced Excel and VBA
with Chat GPT

check.png
check.png

Live Classes       Industry Projects      1:1 Mentorship
100% Placement Assistance

check.png
check.png
Next batch starts 3rd July, 2023
Only Limited Seats Available
Homepage  Front Page - Top Section Image  Header Image - SkillEnable Website (1x1).png

1100+

Tech Professionals

6 LPA

Highest Salary
(Fresher)

94%

Placement
Success Rate

7.5 LPA

550+

Average Salary
Hiring partners

Our Alumni Works At

Hiring Partners - DS, DA, BA (SkillEnable).webp

What could you become

excel vba.png

Take the First Step towards
a Successful Career

Banner - SkillEnable 1 (1x1).webp

Success stories.

Rahul Jaiswal (min).webp

Rahul Jaiswal

Bengaluru, 2 years' experience

Thanks to the SkillEnable's data science course and outstanding assistance, I was able to crack a job at Capgemini. My understanding of the course was greatly improved by the real-time projects and respective project experience certification.

FRESHER
ASSOCIATE DATA SCIENTIST
download_edited.png

This programme will uplift your career
Here's how.

elearning.png
30+ hours of Live Online Training
presentation.png
Learn by working on real-world problems
list.png
Work on 10+ Live Projects
idea.png
20+ hours Holistic Development Training
trust.png
100% Placement Assistance
coaching.png
1:1 Mentorship with Instant Doubt Solving

Course details

  • Mathematical Functions
    Sum Sumproduct Averagea Min, Mina Max, Maxa Small, Large Abs Count, Countblank, Counta Aggregrate Mod Rank, Absolute & Relative Referencing
  • Paste Special
    Value Format Transpose Link Subtract Product and Many Useful Features
  • Rounding Functions
    Round Roundup,Rounddown, (Also to nearest Tens, Hundreds and Thousands) Ceiling Floor and Mround
  • Text functions
    Trim Concatenate, '&' Lower, Proper, Upper and Value
  • Date
    Day, Date, Month, Year, Now, Today Cleaning and Formatting
  • Advanced Text
    Left, Right, Mid, Replace, Substitute Find, Len Working with '*', For Data Cleaning Text to column & Other Advanced Data Cleaning Techniques
  • Shortcuts
    Smart Editing Techniques Learning Useful Shortcuts The Easy Way and Formatting
  • Lookup functions
    Vlookup & Hlookup Automation Of The Same
  • Logical Operators
    If, Nested If, And, Or, Isna, Iserror, Isblank, Is text, Is formula & XOR
  • Conditional formatting
    Basic Conditional Formatting( Formatting using Formula covered in next Module)
  • Data Analysis
    Data Filtering Sorting, Flash Fill Creating Pivot Tables, SmartArt, Charts And Formatting (Advance Level Covered in The Next Module) Split Chart
  • Print & View & Soft Skill Training
    Insert Header/Footer Freeze/Unfreeze Panes Split screen Horizontally and Vertically Repeat Row & Column titles on every printed page Soft Skills Mock Interview Case Study
  • VBA
    VBA Basics Variables Conditional Logic: If And Select Cases Loops Cells, Rows, Columns & Sheets Massage Box & Input Boxes Events Application Setting Advanced Procedures, Variables and Functions Arrays

ZERO COST EMI OPTIONS AVAILABLE

Pricing

Advanced Excel  & VBA (1.5 Months)

Course Price - Advanced Excel.png

Get a real world understanding
through Industry Projects

Advanced Excel

  • Conditional Operator

  • Splitting Cell Data

  • Pivot Table & Pivot Chart and many more

VBA

  • Creating macros

  • Generating charts and graphs

  • Analyzing data trends.

Admissions Process

Apply for the program

1

2

Review Demo Classes

3

Complete 

Documentation

4

Pay the Course Fee

5

Start your

classes

Get Certified in 1.5 Months

excel vba.png
5.png
4.png

Career Services by SkillEnable

3.webp

Placement Assistance

Placement opportunities are provided once the learner is moved to the placement pool. Get notified by our 550+ hiring partners.

Exclusive Job access by SkillEnable

More than 550+ hiring partners including top start-ups and product company hiring our learners. Mentored support on job search and relevant jobs for your career growth.

Our Media Presence

"SkillEnable launches
new upskill programme;
aims to enable 75,000 jobs"
YourStory.webp
"SkillEnable launches job-enabled courdes for college freshers and working professionals"
The Times of India.webp
"SkillEnable appoints ex-Amazon Ashish Sharma to spearhead its own-branded Program Vertical"
Zee News.webp
bottom of page