Open Contact Form
Please Contact Us

Your Name (required)

Your Email (required)

Subject

Your Message

Advanced Excel Course in Mumbai

Advanced Excel Center

BASIC EXCEL

 

  • Introduction to MS Excel / Advanced Excel Course in Mumbai
  • Brief Tour of Excel 2007
  • Formatting, Format Painter
  • Pasting data, Paste Special Values, Filters
  • Data Sorting, Grouping, Text to Column
  • Basic Formulas (Sum, Max, Min, Avg, Count, etc)
  • Formula Auditing
  • If Conditions and Conditional Formatting
  • Hyperlinks
  • Simple Graphs
  • Simple Report Preparation

ADVANCED EXCEL

  • Advanced Formulas – Vlookup, Hlookup, Countifs, Sumif, Sumifs, Extensive If Conditions, Conditional Formatting, Logical Functions, Text Functions and Much more Functions for Advanced Excel Course in Mumbai.
  • Excel Tables
  • Excel Wonderland – Pivot Tables – Extensive Coverage of Pivot Tables
  • Charts
  • Excel Dashboard Preparation
  • Dynamic Reports / Dashboards
  • Sheet Protection, Workbook Protection
  • Introduction to Macros, Basics of Macros.

BASICS of EXCEL VBA

  • Software Development Life Cycle
  • VB(Visual Basic) v/s VBA(Visual Basic for Application)
  • Brief Computer Architecture
  • Computer Program – Compiler, Interpreters
  • Brief Introduction to MS Office
  • Brief Introduction to MS Excel & Advanced Excel Course in Mumbai
  • Brief Introduction to Data Base
  • Writing Flow chart
  • Computer Programs
  • Programming Concepts – Logic – Syntax

VBA

  • Tour of VBE (Visual Basic Editor)
  • Code Window, Project Window, Properties Window
  • Introduction to Module, User forms and Class
  • Writing First Program
  • Recording Macro
    • Absolute Recording
    • Relative Recording
  • Constraints in Naming the Macro
  • What are comment lines? and why is it required?
  • Short cut keys
  • Executing Recorded Macro, Editing the Macro, Debugging the macro
  • Macro Security
  • Running Macros from Code Window, Excel etc;
  • If..Else conditional Statement, Nested ifs
  • Select Cases
  • Looping
  • For Loop & For each loop – Do While Loop
  • Cells, Active Cells, Range, Used Range, Sheet, Worksheet, Workbook, Active Workbook, This Workbook, Applications
  • Program Structure
  • Input Box
  • Msgbox
  • File Dialogue Box
  • What is Sub? Function?
  • What is Function Definition?
  • Difference between Procedure & Function?
  • Procedure calling procedure, Procedure calling Function, Function calling procedure, Function calling Function
  • User Defined Excel Function
  • Built-in VBA function. Ucase, Lcase
  • Immediate Window
  • Variables? Importance of Variable?
  • Different types of Variables
  • Option Explicit, Option Base etc
  • Public Variable, Private Variable, Local Variable, Global Variable
  • Scope of Variable
  • Public, Private functions
  • Writing Programs in multiple Modules
  • Constants
  • Arrays (Static, Dynamic, Redim, Preserve)
  • Workbook and Worksheet Events
  • FileSystemObjects
  • User Forms
  • End To End Automation – Hands on Experience

Searching for Advanced Excel Course in Mumbai? You have arrived to the accurate place. Advanced Excel Center in Mumbai, specially planned for the one who wish to master their Excel skills. As we all recognize that Ms. Excel is the most admired and must required application in any short of work we do. It is quite commonly and broadly used Microsoft product across the world. At Advanced Excel Course in Mumbai gives one on one training attention which will help you get in depth familiarity towards Advanced Excel. This course is planned for students who are already well-known with the fundamentals of Microsoft Excel, and who would like to work with more superior features of Microsoft Excel that help in improving their effectiveness of working with worksheets, exploring data, generating MIS reports, and automating different responsibilities. Advanced Excel Course in Mumbai all characteristics of working with the dynamic programme to generate higher worksheets and effectively manipulate data. Microsoft Excel is a spreadsheet programme that is used about every day in lots of business behavior. Advanced Excel Center in Mumbai will present delegate with the understanding and expertise to store, categorize and operate worksheet statistics for numerous ideas. This course is planned for students who need to move toward to grab with extra superior features of Excel. A person who reports, edits and retain larger spreadsheets is an ultimate candidate for this exercise. Our teacher is recognized for their skills and supportive, pleasant approach. Advanced Excel Course in Mumbai is handle by skilled, specialized and trained instructors, who individually have a very good training experience.