Data Analytics Introduction

Advanced Excel Outline

 

PAGE LAYOUT MENU

 

FORMULA MENU

MATHEMATICAL FUNCTIONS

SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS,

MOD, SQRT, ROUND, ROMAN, COUNTA, AVERAGEIF

CHARACTER FUNCTIONS

UPPER, LOWER, PROPER, CONCATENATE,

LEFT, RIGHT,LENGTH

 

DATE FUNCTIONS

TODAY(), NOW(), EDATE() ,EOMONTH(),NETWORKDAYS(), DATEDIF()

 

BOOLEAN FUNCTIONS

AND, OR IF CONDITION,

TRACE PRECEDENCTS,

TRACE DEPENDENTS,

 

DATA MENU

SUBTOTAL,GROUP,UNGROUP,

 

REVIEW MENU

 

COMMENT,

 

PROTECT SHEET,

PROTECT WORKBOOK,

ALLOWS USER TO EDIT RANGES.

 

 

SHOW HIDE, ZOOM,

NEW WINDOW,

FREEZE PANES,

SAVE WORK SPACE

OTHER FUNCTIONS

 

VLOOKUP

HLOOKUP

MATCH
INDEX
INDIRECT
ISNA

 

VISUAL BASIC APPLICATION(VBA)

 

CONTROLE FLOW STRUCTURES

LINEAR

SEQUENTIAL

IF STATEMENTS

DO LOOP (ENTRY CONDITIONAL LOOP)

ASIGNING MACROS TO SHAPES

USER DEFINED FUNCTIONS

CLASSES AND OBJECTS

 

Please click on this link to Know more on Advanced Excel Course Outline

 

SQL (Database)

 

Introduction to SQL

Retrieving Data

Updating Data

Inserting Data

Deleting Data

Sorting and Filtering Data

Advanced Filtering

Summarizing Data

Grouping Data

Using Subqueries

Joining Tables

Managing Tables

Using Views

Stored Procedures

Using Cursors

Using Transactions

 

Please click on this link to Know more on SQL Course Outline

 

 

Tableau - Data Visualization tool

 

Introduction

The Tableau Environment

Connect to Data

Editing Field Properties

Building Data Views

Filtering

Advanced Analysis

Trend Lines and Statistics

Background Images

Background Maps

Publish and Share

Dashboards

Saving and Exporting

Tableau Server Comprehensive

 

Please click this link for more - Tableau Course Outline

Power BI course Outline (Optional)

How to use Visual in Power BI ?
Charts in Power BI
Matrixes and tables
Slicers
Map Visualizations
Gauges and Single Number Cards
R Visuals in Power BI
What Are Custom Visuals ?
KPI Visuals
Data Binding
Power BI report server

Please click this link for more - Power BI Course Outline

SAS course Outline (Optional)

Introduction SAS

What is Base SAS

Advanced SAS

Importing data in SAS

Analysis using SAS

Reports in SAS

Using Macros in SAS

Using Sql queries in SAS

Exporting Reports in SAS

SQL SAS

Macros SAS

 

Apply Now

Placement Assistance

At SVM TECHNO LABS, we are committed to not only providing top-notch training but also assisting our students in their career growth. Our placement assistance program is designed to support and guide you in securing exciting job opportunities in the SAP ecosystem.

Apply Now