Advance Excel 10daneces

Advance Excel With Macro

4 Star Rating: Very Good 4.40 out of 5 based on 315 ratings.
  • Overview
  • Course

10Daneces Experts designed for Advance Excel With Macro training for Freshers/College Students/Professionals (IT & Non-IT) to cater the needs of dynamic IT companies. We also offer professional real time projects for students in their final semester.

Course completion and project completion certificates will also be provided upon successful completion of the course. We have also partnered with major MNCs & Agencies to place candidates with our clients.

Key Features of Advance Excel With Macro Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.

Ms Excel Advance

ADVANCED DATA SORTING

  • Multi-level sorting
  • Restoring data to original order after performing sorting
  • Sort by icons
  • Sort by colours

Lookup Functions

  • Lookup
  • VLookup
  • HLookup

Subtotal, Multi-Level Subtotal

Grouping Features

  • Column Wise
  • Row Wise

Consolidation With Several Worksheets

Filter

  • Auto Filter
  • Advance Filter

Printing of Raw & Column Heading on Each Page

Workbook Protection and Worksheet Protection

Specified Range Protection in Worksheet

Excel Data Analysis

  • Goal Seek
  • Scenario Manager
  • Data Table

Advance use of Data Tables in Excel

Reporting and Information Representation

  • Pivot Table
  • Pivot Chat
  • Slicer with Pivot Table & Chartwith Pivot Table & Chart

Generating MIS Report In Excel

Advance Functions of EXCEL

  • Math & Trig Functions
  • Text Functions
  • Lookup & Reference Function
  • Logical Functions & Date and Time Functions

MIS Reporting& Dash Board

  • Inventory Statement
  • Payroll Report
  • Salary Slip
  • Loan Assumption Sheet
  • Invoice Creation

VBA

Introduction

  • Introduction to VBA

Calculations without VBA

  • Using Black-Scholes formula

How to Learn VBA

  • For many tasks, VBA is simple to use
  • You can do almost anything using VBA
  • You will never learn all about VBA by reading a book

Calculations with VBA

  • Creating a simple function
  • A Simple Example of a Subroutine
  • Creating a Button to Invoke a Subroutine
  • Functions can call functions
  • Illegal Function Names
  • Differences Between Functions and Subroutines

Storing and Retrieving Variables in a Worksheet

  • Using a named range to read and write numbers from the spreadsheet
  • Reading and Writing to Cells Which are not Named
  • Using the Cells Function to Read and Write to Cells

Using Excel Functions

  • Using VBA to compute the Black-Scholes formula
  • The Object Browser

Checking for Conditions

  • If-Else Conditions

Arrays

  • Defining Arrays

Iterating

  • A simple for loop
  • Creating a binomial tree
  • Other kinds of loops

Reading and Writing Arrays

  • Arrays as Output
  • Arrays as Inputs
    • The Array as a Collection
    • The Array as an Array

Miscellany

  • Getting Excel to generate your macros for you
  • Using multiple modules
  • Recalculation speed
  • Debugging
  • Creating an Add-in

A Simulation Example

  • What is the algorithm?
  • VBA code for this example
  • A trick to speed up the calculations

Drop us a query

Contact us : +918851281130

Course Features

Real-Life Case Studies
Assignments
Lifetime Access
Expert Support
Global Certification
Job Portal Access