• Asia’s #1 & Only Award Winning MIS Reporting With VBA, Dashboard Training Program WITH 100% PLACEMENT ASSISTANCE

Enter Your Details



Online MIS Reporting With VBA, Dashboard

Learn MIS Reporting, VBA & Dashboard from Scratch with Expert, More than 50k Student WorldWide

BESTSELLER

    4.6       4561 students enrolled this month

Offer by ATTITUDE ACADEMY    Last updated:- Jul 6, 2020

What you'll learn

FUNCTIONS

HOW TO MAKE MACRO

ORGANISING AND PRESENTING DATA

AUDITING & ANALAYING DATA

ORGANIZING WORKSHEETS

IMPORTING AND EXPORTING

DASHBOARD & VBA EXPORTING 

INTRODUCTION TO PROGRAMMING INTRODUCTION TO LOGICAL THINKING FLOWCHARTS & ALGORITHMS:

Requirements

Computer/Laptops. That all.

Description

Now you can dynamically increase your productivity with the help of MS-Excel by enrolling for this program not only you will acquire advanced level knowledge of spreadsheets, worksheets, tabular data and charts.You will also get your work done much faster, thus all working professionals & freshers looking for job opportunities in Banking, Insurance, FMCG, BPOs, KPOs & retail sectors increase your proficiency so that you have a lot more time to spare for fulfilling day at work. Learn 100% Practical MS Excel MIS Data Analytics and VBA Dashboard with 100% Job placement and Certified Diploma / Certificate online Course.
Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively.

  • Text Functions
    UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM....
  • DATE & TIME
    DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF....
  • FINANCIAL
    DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE.....
  • LOGICAL
    IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
  • LOOKUP & REFERENCES
    LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....
  • MATHEMATICS
    SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...

  • STREAMING WORKFLOW
    CREATE A MACRO
    EDIT A MACRO
    APPLY CONDITIONAL FORMATING
    ADD DATA VALIDATION CRITERIA
    UPDATE A WORKBOOK PROPERTIES
    MODIFYING EXCEL DEFAULT SETTIING
  • COLLABORATING WITH OTHERS
    PROTECT FILES
    SHARE A WORKBOOK
    SET REVISION TRACKING
    MERGE WORKBOOK
    ADMINISTRATOR DIGITAL SIGNATURE

  • CALCULATING DATA WITH ADVANCE FORMULA
    MANAGE CELL & RANGE NAME
    CALCULATING DATA ACROSS WORKSHEETS
    USE SPECIAL FUNCTIONS
    USING FORMULA TO SEPERATE DATA INTO SEPERATE COL.
    LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
  • Organizing Worksheet And Table Data
    Create A Chart
    Chart Element
    Changing A Chart Type
    Modifying A Chart
    Format A Chart
    Set Up Dynamic & Intreactive Chart
    Calculating In Pivot Table

  • Auditing WorkSheets
    Trace Cell
    Trouble Shoot Error In Formulas
    Troubleshoot invalid Data And Formula
    Watch And Evalute Formula
  • Analyzing Data
    Create A Scenarios
    Perform What-if-analysis
    Perform Statistical Analysis
    Anlysis Toolpack

  • Organizing Sheet And Table Data
    Table
    Create Table Dialog Box
    Styles And Quick Style Set
    Formate Table
    Sort Or Filter Worksheet Or Table Data
    Database function…….Dsum(), Daverage(),Dcount()
  • Inserting Graphics Object
    Insert And Modify Picture And Clipart
    Draw And Modify Shapes
    Illustrate Workflow Using SmartArt graphics
    Layer And Group Graphics Object
    Customizing And Enahancing Workbook
    Customizing Workbook
    Manage Themes
    Create And Use Template(ex-bills)


Exporting Excel Data
Importing Delimited Text File
Publish A Worksheet To The Web
Importing Data From The Web
Create A Web Query

  • Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a Algorithm
  • Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros - an Introduction
  • The Power of Macros - What, When, How to use Macros. Introduction to Object Oriented Programming
  • Objects, Its Functions, Methods and Properties Introduction to Events
  • Details of Events, How & When to use of Events, Preparing to 'Macro' Visual Basic Editor (VBE) Developer Tab, Security
  • Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE - Features, Options, Intelligence Technology
  • Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature - Tips and Tricks.
  • Terms like 'Compile', 'Debug' 'Keywords' etc. Recording Macro
  • If and when to use Macro recorder with the code More On Excel Macros - I Structure of an Excel Workbook from VBA Point of View - Common Objects
  • MS Excel Objects like Applications, Work sheets, Workbook, etc. Coding plate form , Variables and Constants
  • What are Variables and Constants?
  • Type of Variables; How and When to use Variables to Store Information.
  • Typical Variable Naming Prototype
  • When to use Constants or Variables More on Excel Macros - II Loops
  • For-Next, For-Each, Do-While, For Each Loop Decision-Making and Code Branching
  • If-Then-Else, Select-Case, And/or Conditions User Defined Functions (UDF)
  • What are user’s Defined Functions? How to createÿ & use them. Form Controls vs. ActiveX Controls Getting into the Code Msg Box and Input Box Working with Data in Excel
  • Data Types in Excel Worksheets, Like Dates, Texts, and Nulls etc. Working with Workbooks, Worksheets Ranges and Cells etc.
  • Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files Opening & Saving Files Introduction to User Forms
  • Working with User Forms & User Forms Events
  • User form Controls
  • How to use Data Validation in the Control
  • Use of Text Box, Label, Drop down, List box, Image Box
  • What is the Use of Message Box in VBA
  • Searching Data into to the Database and finding records from the database
  • Connecting VBA to Outlook
  • Working with User Forms & User Forms Events
  • Sending Email to Multiple Users Through VBA
  • How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website Through VBA
  • Data Validation & Input Restrictions Effective Coding
  • Testing and Debugging Your Code
  • Effective Error Handling
  • Automation Development Report & Live Project

Limited Period Offer
INR 999/- INR 15000/- 93% Off
Book Now

7 Days Money-Back Guarantee*

Includes

What you'll learn

FUNCTIONS

HOW TO MAKE MACRO

ORGANISING AND PRESENTING DATA

AUDITING & ANALAYING DATA

ORGANIZING WORKSHEETS

IMPORTING AND EXPORTING

DASHBOARD & VBA EXPORTING 

INTRODUCTION TO PROGRAMMING INTRODUCTION TO LOGICAL THINKING FLOWCHARTS & ALGORITHMS:

Requirements

Computer/Laptops. That all.

Description

Now you can dynamically increase your productivity with the help of MS-Excel by enrolling for this program not only you will acquire advanced level knowledge of spreadsheets, worksheets, tabular data and charts.You will also get your work done much faster, thus all working professionals & freshers looking for job opportunities in Banking, Insurance, FMCG, BPOs, KPOs & retail sectors increase your proficiency so that you have a lot more time to spare for fulfilling day at work. Learn 100% Practical MS Excel MIS Data Analytics and VBA Dashboard with 100% Job placement and Certified Diploma / Certificate online Course.
Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively.

  • Text Functions
    UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM....
  • DATE & TIME
    DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF....
  • FINANCIAL
    DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE.....
  • LOGICAL
    IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
  • LOOKUP & REFERENCES
    LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....
  • MATHEMATICS
    SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...

  • STREAMING WORKFLOW
    CREATE A MACRO
    EDIT A MACRO
    APPLY CONDITIONAL FORMATING
    ADD DATA VALIDATION CRITERIA
    UPDATE A WORKBOOK PROPERTIES
    MODIFYING EXCEL DEFAULT SETTIING
  • COLLABORATING WITH OTHERS
    PROTECT FILES
    SHARE A WORKBOOK
    SET REVISION TRACKING
    MERGE WORKBOOK
    ADMINISTRATOR DIGITAL SIGNATURE

  • CALCULATING DATA WITH ADVANCE FORMULA
    MANAGE CELL & RANGE NAME
    CALCULATING DATA ACROSS WORKSHEETS
    USE SPECIAL FUNCTIONS
    USING FORMULA TO SEPERATE DATA INTO SEPERATE COL.
    LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
  • Organizing Worksheet And Table Data
    Create A Chart
    Chart Element
    Changing A Chart Type
    Modifying A Chart
    Format A Chart
    Set Up Dynamic & Intreactive Chart
    Calculating In Pivot Table

  • Auditing WorkSheets
    Trace Cell
    Trouble Shoot Error In Formulas
    Troubleshoot invalid Data And Formula
    Watch And Evalute Formula
  • Analyzing Data
    Create A Scenarios
    Perform What-if-analysis
    Perform Statistical Analysis
    Anlysis Toolpack

  • Organizing Sheet And Table Data
    Table
    Create Table Dialog Box
    Styles And Quick Style Set
    Formate Table
    Sort Or Filter Worksheet Or Table Data
    Database function…….Dsum(), Daverage(),Dcount()
  • Inserting Graphics Object
    Insert And Modify Picture And Clipart
    Draw And Modify Shapes
    Illustrate Workflow Using SmartArt graphics
    Layer And Group Graphics Object
    Customizing And Enahancing Workbook
    Customizing Workbook
    Manage Themes
    Create And Use Template(ex-bills)


Exporting Excel Data
Importing Delimited Text File
Publish A Worksheet To The Web
Importing Data From The Web
Create A Web Query

  • Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a Algorithm
  • Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros - an Introduction
  • The Power of Macros - What, When, How to use Macros. Introduction to Object Oriented Programming
  • Objects, Its Functions, Methods and Properties Introduction to Events
  • Details of Events, How & When to use of Events, Preparing to 'Macro' Visual Basic Editor (VBE) Developer Tab, Security
  • Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE - Features, Options, Intelligence Technology
  • Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature - Tips and Tricks.
  • Terms like 'Compile', 'Debug' 'Keywords' etc. Recording Macro
  • If and when to use Macro recorder with the code More On Excel Macros - I Structure of an Excel Workbook from VBA Point of View - Common Objects
  • MS Excel Objects like Applications, Work sheets, Workbook, etc. Coding plate form , Variables and Constants
  • What are Variables and Constants?
  • Type of Variables; How and When to use Variables to Store Information.
  • Typical Variable Naming Prototype
  • When to use Constants or Variables More on Excel Macros - II Loops
  • For-Next, For-Each, Do-While, For Each Loop Decision-Making and Code Branching
  • If-Then-Else, Select-Case, And/or Conditions User Defined Functions (UDF)
  • What are user’s Defined Functions? How to createÿ & use them. Form Controls vs. ActiveX Controls Getting into the Code Msg Box and Input Box Working with Data in Excel
  • Data Types in Excel Worksheets, Like Dates, Texts, and Nulls etc. Working with Workbooks, Worksheets Ranges and Cells etc.
  • Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files Opening & Saving Files Introduction to User Forms
  • Working with User Forms & User Forms Events
  • User form Controls
  • How to use Data Validation in the Control
  • Use of Text Box, Label, Drop down, List box, Image Box
  • What is the Use of Message Box in VBA
  • Searching Data into to the Database and finding records from the database
  • Connecting VBA to Outlook
  • Working with User Forms & User Forms Events
  • Sending Email to Multiple Users Through VBA
  • How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website Through VBA
  • Data Validation & Input Restrictions Effective Coding
  • Testing and Debugging Your Code
  • Effective Error Handling
  • Automation Development Report & Live Project

Placed Learners


Related Courses

Why Choose Us

BEST FACULTY

100+ BATCHES

100% PRACTICAL

24*7 ONLINE ACCESS

8,676 + PLACED

10+ YEARS

Enter Your Details

Still have questions? Call @+91-9654382235 for answers

  CALL NOW