12,000 10,000Flat 2,000 off

Searching for Advanced Excel Course in Thane? You have arrived at the right place., specially planned for the one who wishes to master their Excel skills. As we all recognize that Ms. Excel is the most admired and a must required application in any sort of work we do. It is quite common and broadly used Microsoft product across the world.

At Petaa Bytes, we give one on one training and attention which will help you get in-depth knowledge about the topic and a keen interest towards Advanced Excel as it is vast and deep to be learned.

By The End of  Advanced Excel Course in Thane at Petaa Bytes You Will Learn

  1. Basic excel
  2. Advanced excel
  3. Basics of excel vba
  4. Vba

Training Includes:

  •  Instructor-led Live Classes
  •  Certification recognised by top companies
  •  24×7 Tech Support
  •  Lifetime access

Request a demo

Why Advanced Excel course in Thane at Petaa Bytes?

The Advanced Excel Course offered by Petaa Bytes in Thane, which is planned for students who are already aware of the fundamentals of Microsoft Excel, and who would like to use  superior features of Microsoft Excel that help in improving their effectiveness of working with worksheets, exploring data, generating MIS reports, and automating different responsibilities. However We are considered one of the superior Coaching Institute, who  provides Advanced Excel Course in Thane in affordable fees.

Petaa Bytes will present delegates with the understanding and expertise to store, categorize and operate worksheet statistics for numerous ideas. A person who reports edits and retains large spreadsheets is an ultimate candidate for this exercise. Our mentor is recognized for their skills and a supportive and pleasant approach.

we teach  Advanced Excel Course in Thane, contains all the characteristics of working in a dynamic system format/ programme to generate higher worksheets and manipulate data effectively. Microsoft Excel is a spreadsheet programme that is used about every day in almost every business behavior.

Our students are handled by skilled, specialized and trained instructors, who individually have a very good training experience. We also teach Advanced Excel Course Online  with all the features and statistics taught Online with our team of experts and digital representatives available to solve all the queries through e-mails and other social

First of all i want to thank Shrikant sir for guiding me into a new era of hot technology 'Hadoop'. The class session was really good and the doubt clearance was not just limited during the class session but off the class also whenever i had a doubt, sir was always available to clear the doubt in a perfect manner in call and and by taking session of my system using Teamviewer. Now for the guys who are interested in learning Bigdata technology i will recommend to get trained under Shrikant Sir.

Manoj Sharma

cyou-46×47
Have completed Hadoop course on Petaa bytes. Found very useful for professional software developer. Course with lots of practical examples definitely helpful for those who want to build their carrier in hadoop.

Anand

test1

Job

Opportunities

OPEN POSITIONS

Drop us a mail at info@petta-bytes.com. We’ll be happy to hear from you.
Alternatively, choose from our list of openings and apply for the one you’re ready to take head on.

Videos

HADOOP

What are the Syllabus for Advanced Excel course in Thane ?

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

 

 12,000 10,000Flat 2,000 off