Course Details

Send A Message

COURSE DESCRIPTION

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc.

COURSE CONTENT

  • Introduction to MS EXCEL and understanding basic working with it
  • Working with Formulas/Functions
  • Financial Functions
  • Logical & Error Functions
  • Text Functions
  • Conditional Formatting
  • Data Sorting & Filtering
  • Sparklines, Slicers & Timelines
  • Data Analysis
  • Pivot Tables & Charts
  • VBA Macros

  1. Visual Basic Application(VBA)
    • VBA Tutorial
    • Home
    • Overview
    • Excel Terms & Micros
    • Micro Comments
    • Message & Input Box
    • Variables, Constants, Operators
    • Decision, Loops, Strings
    • Date & Time, Arrays, Functions
    • Sub Procedures, Events, Error Handling
    • Excel Objects, Text Files
    • Programming Charts, User Forms

  2. Management Information System Report(MIS)
    • Excel Dashboard & Data Analysis
    • Learning Dashboard & Reporting
    • Introduction to VBA for Dashboard
    • Dashboard with excel 2013 Pivot

C-DAC (Centre for Development of Advanced Computing) ) is an Indian autonomous scientific society, operating under the Ministry of Communication and Information Technology. C-DAC provides several certification courses in the field of advanced computing and software development. Certification from C-DAC is Government of India accredited, and institute providing Government certification, thereby being more authentic, assured and market accepted as compared to other standalone players having limited authenticity.

About us

Education is the most powerful weapon which you can use to change the world This philosophy guides us every day to strive towards providing quality computer education to the larger masses. It is our way of influencing lifes’ of individuals around us. Our approach towards education is simply to turn mirrors into windows for our students.
Jai Enterprises,C-DAC’s franchisee in Chembur, is one of the oldest computer institute and training centre in Mumbai. It has been designated as Grade A centre in Maharashtra for last 19 years, a feat achieved by only a handful centres. Gradation primarily depends on the quality of computer education produced, diversity of faculty and their credentials and feedback from students. On all these parameters, we have stood the test of times and have been able to achieve, maintain and provide the highest standards of computer education.
We are Authorized Training Centre of C-DAC GIST PACE. Over the years, we have been aiding and helping students and professionals learn various hardware, software and diploma in computer courses, which have been well-received and appreciated. Our students express this through Testimonials. We have also been associated with disseminating computer education through various social initiatives and imparting computer courses to underprivileged children. Jai Enterprises, through its partners MKCL (MS-CIT), ETH (University of Pune) and MKCL (KLiC Courses) provides its course seekers acompetitive edge over other players in the market.

about images

COURSE FEATURES

  • Time:
  • Duration:
  • Between 9 am to 9 pm
  • 30 hours