Advance Excel

MS Excel-Basic to Expert

Excel is a tool much needed for everyone. Learn it here and never forget the formulas and techniques taught by an experienced professional from basic to expert level.


Duration: 6 Weeks Videos: 30+ Hours Project: 15 Hours
Language: Hinglish Validity: 365 Days Price: Rs. 1499

COURSE HIGHLIGHTS

SELF-PACED

Slow learner or fast, these courses adjusts to your speed

HANDS-ON PROJECT

This gives you the true taste of real-world challenges.

GET CERTIFIED

A certificate for course and project which can be added to resume.

AFFORDABILITY

Prices like never before, best courses at highly affordable prices.

ACCESSIBILITY

With our App and website support, never stop learning.

DOUBT FORUM

We are available 24*7 for you. Now learn anytime from anywhere.

HOW DOES IT WORK

1.

STEP 01

Start self-paced learning videos at your own pace

2.

STEP 02

Develop an understanding of each concept from basic to expert level

3.

STEP 03

Get practical exposure by working on a 15-hour hands-on project

4.

STEP 04

Get Certified for your course and project which can be added in your resume

SYLLABUS

  • Understanding the interface
  • Entering Data
  • Formatting Data
  • Understanding Basic Formulas
  • Error check in Formulas
  • Rows and Columns
  • Password Protect your workbook
  • Formatting the numeric values
  • Images and Smart Art
  • Print Formats
  • Bonus Module - 1
  • Bonus Module - 2
  • Common Error Types
  • Data Visualization
  • Sparklines
  • Important 2019 Updates
  • Sorting and Filtering
  • Important Tools
  • Database Functions
  • Pivot Tables
  • Pivot Charts
  • Advance Function Basics
  • Formula Editing Tools
  • Role of Calculation Tools
  • Text Functions
  • Date and Time Functions
  • Information Functions
  • Statistical Functions
  • Logical Functions
  • Lookup and Reference Functions
  • Financial Functions
  • Math and Trigonometry Functions
  • Get and Transform Data
  • Power Pivot Basics
  • Advance Power Pivot
  • Cube Functions
  • Shortcuts
  • What-if Tools
  • Infographics
  • Multiple Dependent Dropdown List
  • Dashboards
  • 15 hours of hands on project for practical exposure
  • Apply all learning in above modules here
  • Experience on complex data
  • Project gets evaluated by our instructor
  • Analyse your project with our solution
  • Ready for the final certification exam
  • INSTRUCTIONS

    INSTRUCTION-1

    After a successful purchase, your videos will get unlocked right away, however, your project and final exam test will be unlocked after 30 days of purchase.

    INSTRUCTION-2

    The product can be used only on one laptop/computer and one android device. However, you can watch all the lectures an unlimited number of times until the validity ends.

    INSTRUCTION-3

    The device in which you first 'log in', will be registered and lectures can be viewed only through that registered device. You can have one laptop & one android device. For any issue, write to us at support@skillbuzz.in

    INSTRUCTION-4

    Once you buy the course you will be able to watch the course lectures for 1 year (365 Days). However, your certificate will be valid for a lifetime. Happy Learning!

    Reviews

    5
    star star star star star
    people 19 total
    5
     
    19
    4
     
    0
    3
     
    0
    2
     
    0
    1
     
    0
    Launch your GraphyLaunch your Graphy
    100K+ creators trust Graphy to teach online
    SkillBUZZ Trainings 2024 Privacy policy Terms of use Contact us Refund policy