Course Objective.

ONLINE & CLASSROOM LIVE WITH WORKING TRAINER

Advanced Excel & MIS Training Institute – www.iptindia.com , Call +91 9718724322 +91 8826828093

ADVANCED EXCEL TRAININGFOR MIS EXECUTIVE

IPT has designed One Course for Complete MIS Profile , in this course covered Advanced Excel Featured, Advanced Excel Formulas with Automation Tricks, Dashboard Reporting , Excel VBA Automation with power programming and MS Access database with SQL Query Language, Every this topic covered in this course required for MIS Executive Job, This training held by also working professional our Trainer have already working this profile since more than 10 years

COURSE FEATURES

Comprehensive Course Coverage Certified Expert Trainers Excel Tips, Tricks and Best Practices Online and Class Room Training Free 4 Days Demo Class Class Recording Facility Direct Contact your Trainer All Trainers have Working Experience Live Data and Example use in Class Every Weekend Take Live Projects Free Re-Joining Free Video Class facility Interview Preparation Get a Help on Office Projects

Advanced Excel Training Service focuses upon the basic to advance excel training and also facilitates the candidate to understand the application of excel in their domain area.

It is drilled down to 3 levels (Advanced Excel with Formulas, Excel VBA Macros Programming and MS Access with SQL Query)

Any who has knowledge of Basic Excel

EXCEL FOR MIS EXECUTIVE

Who should attend?

Pre-requisites

Basic Excel Knowledge

TRAINING OUTLINE

TOPIC WILL COVERED

REPORTING CONCEPT

Advanced Excel & MIS Training Institute – www.iptindia.com , Call - +91 971724322 +91 8826828093

Fundamental of Reporting with ExcelWhat is MISHow can Work Reports in Office LiveData Type and Reports TypeData Analysis ConceptBenefits of Report AutomationReport chain SystemMNC Report TypesMs Office Architecture

Advanced Excel & Formulas

Excel Shortcuts & SettingExcel Menu Bars (All Menu Bars)Advanced PasteAdvance Custom FormattingAdvance Conditional FormattingAdvance ProtectionData Handling with sorting and FilterData summarization with PivotAdvanced Pivot TablePivot with Access and SQL ServerReport Representation with Charts

Formulas ( More Than 200 Formulas)Logical formulas (If , Or, and , iferror) Text formulas for Data Cleaning Date and Time CalculationLookup formulas

Advanced Vlookup,Match,Index,OffsetData Summarization with FormulasDatabase Information with formulas

Report Automation Project with formulas

Database ConnectivityUse Microsoft Queries Query data from WebSolver ToolAdvanced Filter and Data ValidationWhat if Analysis with Scenario ManagerSubtotal on Data Report

Advanced Excel with Formulas (Level - 1)

ADVANCED EXCEL TRAINING FOR MIS EXECUTIVE

Array FormulasDynamic ChartsAdvanced Conditional FormattingExcel Button use on Charts

DashboardsBI through DashboardsDynamic charts and reportsKPI DashboardCustomer Service Dashboard in ExcelProject Management Dashboard

Information Dashboard on Survey Results

Dashboard On Power Point

Power Point 2013

Excel Chart in Power Point

Advanced Excel & MIS Training Institute – www.iptindia.com , Call - +91 971724322 +91 8826828093

ADVANCED EXCEL TRAINING FOR MIS EXECUTIVE

DATA ANALYSIS

VBA ConnectivityOther Application Connectivity like Access,PPT,Outlook,SQL,InterNet form,Word,Folder,CP and moreE-Mail AutomationSQL Statements with VBA Programming

Website Data Connectivity Data Automation From Website Send Data Excel To Website Form Microsoft Web Query Microsoft Query Connectivity

PDF Automation with VBA Outlook Mailing Automation with VBA Mailing Connectivity with G-Mail and Other POP Server with CDO Connectivity Create HTML Mail Format with Outlook and Other Mailing Connectivity

Excel VBA Power Programming For Macros (Level - 2)Start-Up VBA Macros

Fundamental of VBA ProgrammingAlgorithm and Flow Chart for ProgrammingProblem Solving Method

Excel MacrosExcel Macros RecordingAssign Macros on Excel Sheet ObjectsEditing in Recording Macros

Excel VBA Macros ProgrammingIntroduction of VBA coding Platform (VBE)Programming code ConceptFormatting and Excel Command Codes

Data Type Deceleration and Condition

Variables and Calculation on VBALogical Condition (If Else,Or,and,Case,Switch,choose)

Loops in VBALoops (For ,Each, Do While, Until)

Excel VBA Formulas & FunctionVBA Function and Make New Excel Formulas with VBA

UserFormUser interface with UserformCreate Custom Dialog Box with User FormCreate New Menu Bars with Userform

VBA Pivot Table Create Pivot Table with VBA Pivot Report Automation with VBA Pivot Report From MS Access Data Pivot Report From SQL Data Pivot Relationship with VBAVBA Charts Events Create Pivot Charts with VBA Charts Automation with VBA

Dynamic Chart with Excel and Data From MS Access Data

Chart Events Charts on UserFomPicture Events Load Picture On UserForm Picture Lookup Cells and Drive Form Project

Duration: - & Fee

1. Complete Advance Excel for

MIS Executive

65 Hours, Fee. – 15000/-.

ADVANCED EXCEL TRAINING FOR MIS EXECUTIVEMS Access Training

Shop No. 4, 2nd Floor

J Block Market

Dakshinpuri New Delhi – 110062

Tel – 011-29967604

Mob- +91 971724322, +91 8826828093,

+91 9968811487

CONTACT US

Advanced Excel and MIS Training Institute

MS Access VBA & SQL Statement (Level - 3)MS Database Relationship and Table

Query, Reports and Forms MS Access VBA OverviewForms EventsForm Connect to TableSQL Select StatementSQL Insert StatementAll SQL Statement worked in VBAMS Access to MS Excel LinkedMS Excel Form to MS Access LinkedMS Access to Outlook Connection

Final Report Automation Projects