Excel_VBA_SQL

Tableau

  • Introduction
  • Prepare files
  • Deep Dive into Tableau
  • Getting Data from different Sources
  • Tableau Joins
  • MetaData
  • Data Blening
  • Hierarchy and Groups
  • Quiz
  • Dual Axis Graphs
  • Histogram
  • Pareto Chart
  • Motion Chart
  • Box Plot
  • Funnel Chart
  • Waterfall Charts
  • Quiz
  • Maps in Tableau
  • Advance Maps
  • Polygon Maps
  • Geocoding
  • Quiz
  • Parameters
  • Sorting
  • Filteration
  • Data blending
  • Dashboard Filter
  • Sets
  • Grouping
  • Analytics Dashboard
  • Quiz
  • Numeric Calculations
  • String Calculations
  • Date Calculations
  • User Defined Calculations
  • Logical Calculations
  • Control Charts
  • Statistical Measures
  • Box Plots

Excel

  1. Creating, editing, saving and printing spreadsheets
  2. Working with functions & formulae
  3. Graphically representing data : Charts & Graphs
  4. Analyzing data : Data Menu, Subtotal, Filtering Data
  5. Formatting worksheets , Securing & Protecting spreadsheets
  1. Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT,LEN,TRIM)
  2. Nested functions , Name cells /ranges /constants
  3. Relative, Absolute, Mixed cell references : >,<,= operators
  4. Logical functions using IF, AND, OR, NOT
  5. The LOOKUP function , Date and time functions , Annotating formulas
  1. Sub Total Reports, Auto Filter
  2. Password Protecting Worksheets
  3. Linking Multiple Sheets
  4. Sheet Referencing
  5. Linking Between Word/Excel/Ppt
  6. What-if-analysis, GOAL SEEK
  7. Pivot Tables, NESTED IF
  1. Create charts , Enhance charts, Drawing toolbar features
  2. Interactive charts
  3. Dashboards in Excel

VBA

  1. Recording the Macros
  2. Understanding VBA
  3. How to Develop functions/ Create Macros or add ins
  4. \VBA Concepts
  5. Macro Security
  6. Enable/Disable Macros
  7. Saving your macro worksheet.
  1. Recording the Macros
  2. Writing your first macro
  3. Modifying your macro
  4. Understanding VBE
  5. Ways to Run Macros
  6. Creating UDF’s
  7. Call
  8. Variables
  9. Loops
  1. What are user defined functions. How to create & use them.Form Controls vs. ActiveX Controls Getting into the Code MsgBox and Input Box Working with Data in Excel
  2. Data types in Excel worksheets, like Dates, Texts, Nulls etc. Working with workbooks, worksheets, ranges, cells etc.
  3. Using offset and other cell navigation methods. Working with Arrays Power Data Processing Working with Data in Excel
  4. Working with dynamic ranges. Protecting worksheets, cells and ranges. Working with multiple files. Opening & Saving files Introduction to User Forms

SQL

  1. What is SQL?
  2. Why SQL?
  3. History
  4. SQL Process
  5. SQL Commands
  6. DDL – Data Definition Language
  7. DML – Data Manipulation Language
  8. DCL – Data Control Language
  9. DQL – Data Query Language
  1. Create Table
  1. Alter Table
    1. Add Column
    2. Modify Column
    3. Rename Column
    4. Drop Column
    5. Add Constraint
    6. Drop Constraint
  1. SQL Data Types
  2. SQL SELECT
  3. SQL DISTINCT
  4. SQL WHERE
  5. SQL AND, OR
  6. SQL IN
  7. SQL bETWEEN
  8. SQL WILDCARD
  1. SQL LIKE
  2. SQL ORDER BY
  3. SQL GROUP BY
  4. SQL HAVING
  5. SQL ALIAS
  6. SQL INSERT INTO
  7. SQL INSERT INTO SELECT
  8. SQL UPDATE
  9. SQL DELETE
  1. SQL Data Types
  2. Exact Numeric Data Types
  3. Approximate Numeric Data Types
  4. Date and Time Data Types
  5. Character Strings Data Types
  6. Unicode Character Strings Data Types
  7. Binary Data Types
  8. Misc Data Types
  1. SQL Operators
  2. What is an Operator in SQL?
  3. SQL Arithmetic Operators
  4. SQL Comparison Operators
  5. SQL Logical Operators
  1. SQL Expressions
  2. Syntax
  3. SQL – Boolean Expressions
  4. SQL – Numeric Expression
  5. SQL – Date Expressions
  • SQL Joins
  • SQL Joins Types
    • INNER JOIN
      • Syntax
      • Example
    • LEFT JOIN
      • Syntax
      • Example
    • RIGHT JOIN
      • Syntax
      • Example
  • FULL JOIN
    • Syntax
    • Example
  • SELF JOIN
    • Syntax
    • Example
  • CARTESIAN JOIN
    • Syntax
    • Example
  • SQL Unions Clause
    • Syntax
    • Example
  • The UNION ALL Clause:
    • Syntax
    • Example
  • SQL Date Functions
  • SQL Temporary Tables
  • SQL String Functions
  • Date Convert Functions
Excel VBA SQL Course Detail
Fees:
Rs 20,000

 

Class Mode:
Classroom/Online

 

Duration:
2 Months

 

Course Contents:
Basic+Advance Excel + VBA + SQL

 

Course Benefit:
Student will able to Advance Excel with VBA and SQL

 

KEY FEATURES

2 Months of Classroom Training.

 

Session have assignments and daily task.

 

Recorded Videos and presentation for reference.

Books and related data sets in form of excel and csv.

 

Interview Questions for related topic.

 

Used Case Study and Projects to understand real scenarios.

CHOOSE YOUR COURSE

APPLY TO OUR CERTIFICATION COURSES NOW

Data
Science

Machine
Learning

Artificial
Intelligence

Python
Programming

R
Programming

Data
Visualization