EDUCBA

Early Bird Offer

limited Period offer Offer

Advanced Excel WorkshopLive Class

Our Advanced Excel training is a 1-day accelerated workshop designed to help you improve your efficiency of working with spreadsheets, analyzing data, and running Macros. The workshop starts off with Excel formulas, functions, data sorting, and then introduces you to advanced topics such as Pivot Tables, Advanced Charting and Graphing Techniques, Data Validation and VBA & Macros. You can dramatically increase your efficiency and stay at the top of your Excel game as this 1-day workshop is focused to give you a flavor of advanced Excel functions, VBA & Macros and everything in between.

Includes:

Live Online Classes (1 Day)
  • 4.7
  • 133,706 ratings

Key Features

1 day of Intensive Training
Industry Expert & Instructors
Excel Working Templates
Query Resolution
Verifiable Certificate
Access to Workshop Recordings

Early Bird Offer Ends in:

$1999

Live Online Classes PREFERRED

Choose Your Batch:

Sunday Sold Out
9:00am IST to 5:00pm IST

Overview

Our Excel Live Online Training covers 1 day of comprehensive, interactive, and instructor-led training, thus imparting working knowledge of crucial Excel tools and functions.

Live Online Classes Curriculum Download Curriculum

  • Module 01 – Advanced Formulas and Functions

    Time-saving Formulas in Excel

    • Logical Formulas
      • OR
      • IF
    • Maths Formulas
      • SUM
      • SUMIF
      • SUMIFS
      • SUMPRODUCT
    • Reference Formulas
      • VLOOKUP
      • HLOOKUP
      • INDEX
      • MATCH
    • Text Formulas
      • LEFT
      • RIGHT
      • MID
      • LEN
  • Module 02 – Graphs and Charts
    • Advanced Graphs and Charts
      • Histogram
      • Sparklines
      • Scatter Plot
      • Thermometer Chart
  • Module 03 – Pivot Tables
    • Getting the most out of Pivot Tables
      • Introduction to Pivot Tables
      • Creating a Pivot Table
      • Formatting Pivot Table
      • Grouping Data
      • Pivot Table Slicer
      • Pivot Charts
  • Module 04 – Data Validation & Analytical Options
    • Validating And Updating
      • Data Validation
      • Data Validation Lists
    • What If Analysis
      • What If Analysis
      • Goal Seek
  • Module 05 – VBA & Macros
    • Getting Started with Excel VBA
      • Enabling developer toolbar
      • File types supported by macros
      • Macro security
    • Using the Macro Recorder
      • Naming macro
      • Add shortcut key
      • Adding a description
      • Store macro in workbook
      • Store macro in separate file
    • Running a Macro
      • Adding Macro to quick access toolbar
      • Button form control
      • Clipart
      • Shape and WordArt
      • SmartArt
    • Visual Basic Editor
      • Access (ALT+F11)
      • Layout of window
      • Rearrange display window
      • Debugging VBA code
    • Recorder Problems
      • Unnecessary code added
      • Troubleshoot difficulty
      • Absolute references to cells
    • Using Messages Boxes
Call Our Course Advisors

IN : +91-8800880140

Excel Course - Certificate of Completion

Online Excel Course

Pre-requisites

    There are a few requirements for this course. Let’s have a look –

  • Willingness to learn MS Excel: If you feel that you need to learn the nitty-gritty of MS Excel, this is the right course for you. Just for the sake of doing (without any motive or interest) won’t produce the best result even after doing this Excel course.
  • A basic sense of maths: You don’t need to know everything about mathematics. But a fundamental sense would definitely help.

Target Audience

  • Students from any domain: If you’re a student, you can do this Excel course. It will teach you the functions, formulas you need to learn to get ahead in your job search/ employment.
  • Professionals from any domain/industry: If you’re a professional and you feel that you need to learn the nitty-gritty of MS Excel, this excel course may be the right one for you.

FAQ – General Questions

Why should I do this Excel course?

Because this is the best course you would ever find on MS Excel. If you’re looking for learning Excel, your search ends here. Most importantly, the workshop will help you perfect skills that not many people are aware of. Thus, making you more efficient and appealing to the employers.

What would I get out of this Excel course?

A lot. Once you do this course, it’s given that you don’t need to worry about Excel again (provided you do the work on what you learn)

Can I see the recorded workshop sessions later?

Yes, you will get access to recorded sessions which you can view later too.

Can I access this workshop from anywhere?

Yes, you can definitely access this live online workshop from anywhere & everywhere. Once you are registered for this Live Online workshop, you will get your own login credentials which you can use to access the workshop on a particular day from anywhere.

Who are the Instructors for this Live Online Workshop?

The instructors are Industry based professionals who have had tons of experience in the field of Online Training. All the sessions in this workshop are based on Industry based standards. Also, the curriculum has been started from Scratch to get the participant well-acquainted with each and every advanced excel concept.

What are the Payment Options?

There are both Online & Offline Payment options available. In online payment options, you pay by Credit Card, Debit Card or Net Banking. In the offline payment option, you can deposit Cash, Cheque or Demand Draft.

Course Testimonials

Fredric C - Excel Course

Testimonials

create dashboard in excel

This course provided dissected, easy to understand mini-modules on creating effective data dashboards. While this specific course contained a tutorial on tracking sales, specifically, I am confident that the explanations provided in this course will help me develop a comprehensive dashboard for tracking personnel survey responses, making it easy to identify patterns, trends, and predictions of the results. Thank you, EDUCBA, for providing a comprehensive tutorial on creating effective dashboards in Excel. This was the first of many courses I will take from EDUCBA!
Linked

Noushin Nikpour

 

Greg Kowalczyk - Excel Course

Testimonials

Comprehensive course for refresher

Great course for someone like me who’s been using Excel everyday but didn’t know about data analysis tool available in it. I’ve always have to open JMP for analysis even just for simple charting and correlation plotting. Now I know I can do that in Excel too. Thanks! 🙂
Linked

Michelle Esber

 

avinash bawa - Excel Course

Testimonials

HR Excel Training

I have learned a lot from your courses about Excel. I can say it is especially useful for people who lack in advanced Excel skills. Everything in videos are very clear and well-defined. I am very happy with the result, so thank you for providing us with the good quality of programs!
Linked

Gizem Ayvazoglu

 

avinash bawa - Excel Course

Testimonials

excel course for beginner

i’m just excited to passed this journey. i’ve learned more points that will help me for my career. I was very happy to participate in this beginner excel course. I deepened my knowledge and especially I mastered the basics. the teaching methodology is excellent and make this course an excellent program.
Linked

henri-joel atchello Kouadio

 

🚀 Limited Time Offer! - ENROLL NOW