BEST MIS TRAINING COURSE IN NOIDA / MIS TRAINING INSTITUTE IN NOIDA / GREATER NOIDA

📷 4.7 out of 5 based on 3415 Votes.

Are you Looking Best Institute for MIS Training Course in Noida / Greater Noida? DUCAT offers MIS training classes with live projects by expert trainers in Noida. Our MIS training program in Noida is specially designed for Under-Graduates (UG), Graduates, working professionals, and also for Freelancers. We provide end to end learning on MIS Domain with deeper dives for creating a winning career for every profile.

When companies need help in improving their current information system or creating a new one, they turn to the expertise of management information systems analysts, or computer systems analysts. These data professionals offer their services as either outside consultants or working in-house.

Advanced Excel Course – Overview of the Basics of Excel

• customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Advanced Excel Course – Working with Functions

• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

Advanced Excel Course – Data Validations

• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on the formula for a cell

Advanced Excel Course – Working with Templates

• Designing the structure of a template
• Using templates for standardization of worksheets

Advanced Excel Course – Sorting and Filtering Data

• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options

Advanced Excel Course – Working with Reports

• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)

Advanced Excel Course – More Functions

• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course – Formatting

• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns, and cells

Advanced Excel Course – Macros

• Relative & Absolute Macros?
• Editing Macro’s

Advanced Excel Course – WhatIf Analysis

• Goal Seek
• Data Tables
• Scenario Manager

Advanced Excel Course – Charts

• Using Charts
• Formatting Charts
• Using 3D Graphs)
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)

Advanced Excel Course – New Features Of Excel

• Sparklines, Inline Charts, Data Charts
• Overview of all the new features

Advanced Excel Course – Final Assignment

• The Final Assignment would test contains questions to be solved at the end of the Course

VBA (VISUAL BASIC FOR APPLICATION) & MACROS

Create a Macro:

• Swap Values, Run Code from a Module, Macro Recorder, Use Relative References, FormulaR1C1, Add a Macro to the Toolbar, Macro Security, Protect Macro.

MsgBox:

• MsgBox Function, Input Box Function.

Workbook and Worksheet Object:

• Path and Full Name, Close and Open, Loop through Books and Sheets, Sales Calculator, Files in a Directory, Import Sheets, Programming Charts.

Range Object:

• Current Region, Dynamic Range, Resize, Entire Rows and Columns, Offset, From Active Cell to Last Entry, Union and Intersect, Test a Selection, Possible Football Matches, Font, Background Colors, Areas Collection, Compare Ranges.

Variables:

• Option Explicit, Variable Scope, Life of Variables.

If Then Statement:

• Logical Operators, Select Case, Tax Rates, Mod Operator, Prime Number Checker, Find Second Highest Value, Sum by Color, Delete Blank Cells.

Loop:

• Loop through Defined Range, Loop through Entire Column, Do Until Loop, Step Keyword, Create a Pattern, Sort Numbers, Randomly Sort Data, Remove Duplicates, Complex Calculations, Knapsack Problem.

Macro Errors:

• Debugging, Error Handling, Err Object, Interrupt a Macro, Macro Comments.

String Manipulation:

• Separate Strings, Reverse Strings, Convert to Proper Case, Count Words.

Date and Time:

• Compare Dates and Times, DateDif Function, Weekdays, Delay a Macro, Year Occurrences, Tasks on Schedule, and Sort Birthdays.

Events:

• Before DoubleClick Event, Highlight Active Cell, Create a Footer Before Printing, Bills, and Coins,

Array:

• Dynamic Array, Array Function, Month Names, Size of an Array

Function and Sub:

• User Defined Function, Custom Average Function, Volatile Functions, ByRef, and ByVal.

Application Object:

• Status Bar, Read Data from Text File, Write Data to Text File.

ActiveX Controls:

• Text Box, List Box, Combo Box, Check Box, Option Buttons, Spin Button, Loan Calculator.

User form:

• User form and Ranges, Currency Converter, Progress Indicator, Multiple List Box Selections, Multicolumn Combo Box, Dependent Combo Boxes, Loop through Controls, Controls Collection, User form with Multiple Pages, Interactive User form

INTRODUCTION TO SQL

Introduction to Oracle Database

• List the features of Oracle Database 12c
• Discuss the basic design of Database
• Categorize the different types of SQL statements
• Describe the data set used by the course
• Log on to the database using the SQL Developer environment
• Save queries to files and use script files in SQL Developer

Introduction to Oracle Database

• List the features of Oracle Database 12c
• Discuss the basic design of Database
• Categorize the different types of SQL statements
• Describe the data set used by the course
• Log on to the database using the SQL Developer environment
• Save queries to files and use script files in SQL Developer

Retrieve Data using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements
• Select Table Data With All Columns
• Select Table Data With Specific Columns
• Use Arithmetic Operators
• Use Concatenation Operators
• Learn the DESCRIBE command to display the table structure

Learn to Restrict and Sort Data

• Use WHERE clause to limit the output retrieved
• List the comparison operators and logical operators
• Describe the rules of precedence for comparison and logical operators
• Use character string literals in the WHERE clause
• Write queries that contain an ORDER BY clause to sort Data
• SQL Row Limiting Clause (Fitch First,Offset and With Ties)

Usage of Single-Row Functions to Customize Output

• Differences between single row and multiple row functions
• Manipulate strings with character function in the SELECT and WHERE clauses
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the DATE functions

Invoke Conversion Functions and Conditional Expressions

• Describe implicit and explicit data type conversion
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nest multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Use conditional IF THEN ELSE logic in a SELECT statement

Aggregate Data Using the Group Functions

• Use the aggregation functions to produce meaningful reports
• Divide the retrieved data in groups by using the GROUP BY clause
• Exclude groups of data by using the HAVING clause

Display Data From Multiple Tables Using Joins

• Write SELECT statements to access data from more than one table
• View data that does not meet join condition by using out
• Join a table to itself by using a self-join

Use Sub-queries to Solve Queries

• Describe the types of problem that sub-queries can solve
• Define sub-queries
• List the types of sub-queries
• Write single-row and multiple-row sub-queries

The SET Operators

• Describe the SET operators
• UNION and UNION ALL to Combine Result of Multiple Queries
• Use of INTERSECT
• Use of MINUS
• Control the order of rows returned

Data Manipulation Statements

• Describe each DML statement
• Insert rows into a table
• Change rows in a table by the UPDATE statement
• Delete rows from a table with the DELETE statement
• Save and discard changes with the COMMIT and ROLLBACK statements
• Explain read consistency

Use of DDL Statements to Create and Manage Tables

• Create a simple table
• Alter and Truncate Table
• Drop Table and Concept of Recyclebin
• Stop Entry of Invalid Data Through CONSTRAINTS
• Primary Key, Foreign Key
• Not Null, Unique, and Check Constraints

Other Schema Objects

• Create a simple and complex view
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

Control User Access

• Create Users
• Grant System Privileges
• reate and Grant Privileges to a Role
• Change Your Password
• Grant Object Privileges
• How to pass on privileges?
• Revoke Object Privileges

Management of Schema Objects

• Add, Modify, and Drop a Column
• Add, Drop, and Defer a Constraint
• How to enable and Disable a Constraint?
• Create an External Table by Using ORACLE_LOADER
• Query External Tables

Manage Objects with Data Dictionary Views

• Explain the data dictionary
• Use the Dictionary Views
• USER_OBJECTS and ALL_OBJECTS Views
• Query the dictionary views for constraint information
• Query the dictionary views for View and Sequence
• Query the dictionary views for Index
• Comment On table and Columns

Manipulate Large Data Sets

• List the types of Multitable INSERT Statements
• Use Multitable Unconditional INSERT ALL Statements
• Use Multitable Conditional INSERT ALL Statement
• Use Multitable Conditional INSERT FIRST Statement
• Merge rows in a table
• Track Changes in Data over a period of time

Data Management in different Time Zones

• Time Zones
• CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP
• DBTIMEZONE and SESSIONTIMEZONE
• Difference between DATE and TIMESTAMP
• INTERVAL Data Types
• Use EXTRACT, TZ_OFFSET and FROM_TZ
• Invoke TO_TIMESTAMP, TO_YMINTERVAL and TO_DSINTERVAL

Retrieve Data Using Advance Sub-queries

• Multiple-Column Subqueries
• Pairwise and Non-pairwise Comparison
• Solve problems with Correlated Subqueries
• Update and Delete Rows Using Correlated Subqueries
• The EXISTS and NOT EXISTS operators
• Invoke the WITH clause

BEST ONLINE POWER BI TRAINING COURSE IN NOIDA | POWER BI TRAINING INSTITUTE IN NOIDA

📷 4.7 out of 5 based on 3965 Votes

Ducat offers Power BI Training. Power BI is a cloud-based business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators. Make informed decisions quickly. Connect, model, and then explore your data with visual reports that you can collaborate, publish, and share. Power BI integrates with other tools, including Microsoft Excel, so you can get up to speed quickly and work seamlessly with your existing solutions.

Power BI overview

• Dataset
• Reports
• Dashboard
• Workspace
• Tiles
• Q&A Question box

Power BI versus Excel Reporting

• Diff
• When we use which reports.

Cloud vs On-Prem Reporting

• Cloud
• On Premises
• Compare

Introduction to the M language

• Evaluation model
• Operator
• Type Conversion
• Expression ,value and let expression

Power BI Desktop

• Introduction
• Download & install

Connect To data

• Excel
• csv
• Sql server
• Web
• MS Access
• Other

Shape & Combine data

• Add Custom column
• Add new column
• Change Type
• Replace Values
• Split column
• Group by
• Un Pivot
• Rename
• Remove
• Applied steps
• Remove Error

Combine Data

• Remove Top Row
• Remove Bottom row
• Remove Blank row
• Merge Query
• Append Query

Data View in Desktop

• Data view Grid
• Modelling Ribbon
• Formula bar
• Search
• Fields List

Relationship

• Relationship view
• Add/ Edit relationship

Introduction to the DAX language

• DAX
• DAX Important
• Syntax
• Create
• Context

DAX function

• Date and Time Functions (DAX)
• Time Intelligence Functions (DAX)
• Filter Functions (DAX)
• Information Functions (DAX)
• Logical Functions (DAX)
• Math and Trig Functions (DAX)
• Other Functions (DAX)
• Parent and Child Functions (DAX)
• Statistical Functions (DAX)
• Text Functions (DAX)

Categorization

• Introduction

Building a Report

• Report View
• Report canvas
• Visual configuration

Custom Visuals

• Type
• Download & Add Visual Gallery

Power Bi Web

• Create Reports in Power BI Website
• Get Data from Website
• Building Dashboards
• Sharing
• Power Q&A
• Power BI Mobile App
• Scheduling

Power BI Gateway

• On-premises date gateway
• Personal
• Analysis Services Connector (depreciated)

Embed Power BI

• Publish on Web
• REST API
• Power BI Embedded

Power BI Q&A Natural Language

• How it work
• Visualization
• Question sample
• Advantage

ADVANCED MICROSOFT EXCEL 2013 TRAINING IN NOIDA

📷 4.7 out of 5 based on 3261 Votes.

Are you Looking Best Institute for Advanced Excel Training Course in Noida / Greater Noida? DUCAT offers Advanced Excel training classes with live projects by the expert trainer in Noida. Our Advanced Excel training program in Noida is specially designed for Under-Graduates (UG), Graduates, working professionals, and also for Freelancers. We provide end to end learning on Advanced Excel Domain with deeper dives for creating a winning career for every profile.

Microsoft Excel is a spreadsheet application that is primarily used for dealing with complex data manipulation and analysis-related tasks. The application effectively helps in turning vast amounts of raw data into well-organized meaningful information in minimal timeframes, thereby expediting the overall quality and delivery of work. Appropriate knowledge about the optimal use of Microsoft Excel software considerably adds to one’s productivity at the workplace, and this is why advanced level training on Microsoft Excel 2013 is considered to be the need of today for professionals involving Microsoft Excel as a part of their daily work routine. Here is YOUR chance to Learn the Microsoft Excel Tools and Techniques by enrolling in our Hands-on Advanced Microsoft Excel Training workshops where you get to learn the Microsoft Excel formulas, shortcuts, macros, and much more that help raises your efficiency and effectiveness at work.

Advanced Excel Course – Overview of the Basics of Excel

• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Advanced Excel Course – Working with Functions

• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

Advanced Excel Course – Data Validations

• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell

Advanced Excel Course – Working with Templates

• Designing the structure of a template
• Using templates for standardization of worksheets

Advanced Excel Course – Sorting and Filtering Data

• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options

• Advanced Excel Course – Working with Reports
• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)

Advanced Excel Course – More Functions

• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course – Formatting

• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns, and cells

Advanced Excel Course – Macros

• Relative & Absolute Macros
• Editing Macro’s

Advanced Excel Course – WhatIf Analysis

• Goal Seek
• Data Tables
• Scenario Manager

Advanced Excel Course – Charts

• Using Charts
• Formatting Charts
• Using 3D Graphs
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)

Advanced Excel Course – New Features Of Excel

• Sparklines, Inline Charts, Data Charts
• Overview of all the new features

Advanced Excel Course – Final Assignment

• The Final Assignment would test contains questions to be solved at the end of the Course

VBA (VISUAL BASIC FOR APPLICATION) & MACROS

Create a Macro:

• Swap Values, Run Code from a Module, Macro Recorder, Use Relative References, FormulaR1C1, Add a Macro to the Toolbar, Macro Security, Protect Macro.

MsgBox:

• MsgBox Function, Input Box Function.

Workbook and Worksheet Object:

• Path and Full Name, Close and Open, Loop through Books and Sheets, Sales Calculator, Files in a Directory, Import Sheets, Programming Charts.

Range Object:

• Current Region, Dynamic Range, Resize, Entire Rows and Columns, Offset, From Active Cell to Last Entry, Union and Intersect, Test a Selection, Possible Football Matches, Font, Background Colors, Areas Collection, Compare Ranges.

Variables:

• Option Explicit, Variable Scope, Life of Variables. VBA (VISUAL BASIC FOR APPLICATION) & MACROS

If Then Statement:

• Logical Operators, Select Case, Tax Rates, Mod Operator, Prime Number Checker, Find Second Highest Value, Sum by Color, Delete Blank Cells.

Loop:

• Loop through Defined Range, Loop through Entire Column, Do Until Loop, Step Keyword, Create a Pattern, Sort Numbers, Randomly Sort Data, Remove Duplicates, Complex Calculations, Knapsack Problem.

Macro Errors:

• Debugging, Error Handling, Err Object, Interrupt a Macro, Macro Comments.

String Manipulation:

• Separate Strings, Reverse Strings, Convert to Proper Case, Count Words.

Date and Time:

• Compare Dates and Times, DateDif Function, Weekdays, Delay a Macro, Year Occurrences, Tasks on Schedule, Sort Birthdays.

Events:

• Before DoubleClick Event, Highlight Active Cell, Create a Footer Before Printing, Bills and Coins, Rolling Average Table.

Array:

• Dynamic Array, Array Function, Month Names, Size of an Array.

Function and Sub:

• User Defined Function, Custom Average Function, Volatile Functions, ByRef and ByVal.

Application Object:

• Status Bar, Read Data from Text File, Write Data to Text File.

ActiveX Controls:

• Text Box, List Box, Combo Box, Check Box, Option Buttons, Spin Button, Loan Calculator.

User form:

• User form and Ranges, Currency Converter, Progress Indicator, Multiple List Box Selections,Multicolumn Combo Box, Dependent Combo Boxes, Loop through Controls, Controls Collection, User form with Multiple Pages, Interactive User form