Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Hash
Hash Analytics photo

Hash

NM-1, 2nd Floor, Sunder Sing Marg, Old DLF Colony, Gurgaon HO, Gurgaon, India- 122001.

Phone Verified Email Verified

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Are you Looking to Learn?

Overview

Hash Analytics,leading analytics training institute in Gurgaon and Delhi NCR, is a group of 25+ combined experienced industry analytics professionals, who are determined to educate college students and young professionals for their growth and development in Analytics Industry. We have wide experience in different industry verticals ranging from Health care, Retail, Banking and Financial Services, e-commerce. We have the right set of tools and specialized courses designed by industry experts to transform student’s career to a Business Analyst or Data Scientist.
Our Course Offerings are 1. Analytics with Excel - to help you to build your analytical skills on excel.
2.Automations using VBA – From basic macros to advanced techniques to build automated and customized dashboards.
3.Database management with SQL Server - basic SQL fundamentals, procedure, function, cursor and triggers of PL/SQL.
4.Data Analytics with SAS – Application of SAS Procs to solve business analytics problems
5.Data Analytics with R – R Programming language and its application in Analytics
6.Predictive Modelling with SAS & R – advance skills in data mining, multivariate statistics, and database processing and data analytics.

Address

NM-1, 2nd Floor, Sunder Sing Marg, Old DLF Colony,

sector 14

Gurgaon HO, Gurgaon, India- 122001.

SQL Server Training Overview

SQL Server Training

Class Location

At the Institute

Online (video chat via skype, google hangout etc)

Reviews

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

Answers by Hash (2)

"Is it necessary to have the knowledge of VB script for Excel Macro Training?" in   IT Courses/MS Office Software Training/Microsoft Excel Training

Yes, It is necessary to have knowledge of VB script, although without it you can record macro at basic level and perform lot of general tasks. It depends on the level and complexity of task you want to achieve.

0
|
0

"What is the major concepts Excel VBA Training teaches?" in   IT Courses/MS Office Software Training/Microsoft Excel Training

Our Complete Course Package is: Introduction to Excel Introduction to MS Excel, quick review on excel options Navigating spreadsheets and Often-Used Terminology Basic data manipulation Working with worksheet- Edit, move/copy and delete worksheet. Formatting and processing data Advance function and formulas: Logical functions: AND, OR, NOT, IF, IFERROR, ISERROR, TRUE, FASE etc. Lookup and reference functions: lookup, vlookup, hlookup, index, match, offset, transpose, row, column etc. All date and time function Text manipulating functions Subtotal and data validation Text functions: Left, right, trim, mid, lower, upper, trim, trunc, convert, concatenate, dollar etc. Pivot tables and Pivot chart Creating Pivot table and pivot chart Type of pivot chart and their usages Changing and updating data range, pivot data filter, group-ungroup pivot data Formatting pivot table and pivot chart and making dynamic pivot tables and charts. Analyzing data with Excel Sorting Data: A-Z, Z-A, advance sort Filter: Use filter to sort data and advance filtering options What-if Analysis Consolidating data and worksheets Conditional formatting with multiple cell rules Statistical and mathematical functions: Match function: Sum, count, sumifs, countifs, sumproduct, round, random etc. State functions: stdev, ttest, correl, median, average, averageifs etc. Other analytics functions: rank, quartile, decile, percentile etc. Charts and graphs Simple chart Pie chart, bar chart, line chart, scatter plot, doughnut Curve fitting and distribution For VBA we cover following topics: Create a Macro Message Box Workbook and Worksheet Object Range Object Variables If Then Statement Loop Macro Errors String Manipulation Date and Time Events driven programming Arrays Function and Sub Application Object ActiveX Controls User form Interacting with Other Office Applications via Excel VBA Excel Dashboards After covering the above topics you will have fairly good knowledge of Excel/VBA for working in any company/Job.

0
|
0

Hash address

x
SQL Server Training

Class Location

At the Institute

Online (video chat via skype, google hangout etc)

Business Analytics Training classes
Microsoft Excel Training classes

Class Location

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

"Is it necessary to have the knowledge of VB script for Excel Macro Training?" in   IT Courses/MS Office Software Training/Microsoft Excel Training

Yes, It is necessary to have knowledge of VB script, although without it you can record macro at basic level and perform lot of general tasks. It depends on the level and complexity of task you want to achieve.

0
|
0

"What is the major concepts Excel VBA Training teaches?" in   IT Courses/MS Office Software Training/Microsoft Excel Training

Our Complete Course Package is: Introduction to Excel Introduction to MS Excel, quick review on excel options Navigating spreadsheets and Often-Used Terminology Basic data manipulation Working with worksheet- Edit, move/copy and delete worksheet. Formatting and processing data Advance function and formulas: Logical functions: AND, OR, NOT, IF, IFERROR, ISERROR, TRUE, FASE etc. Lookup and reference functions: lookup, vlookup, hlookup, index, match, offset, transpose, row, column etc. All date and time function Text manipulating functions Subtotal and data validation Text functions: Left, right, trim, mid, lower, upper, trim, trunc, convert, concatenate, dollar etc. Pivot tables and Pivot chart Creating Pivot table and pivot chart Type of pivot chart and their usages Changing and updating data range, pivot data filter, group-ungroup pivot data Formatting pivot table and pivot chart and making dynamic pivot tables and charts. Analyzing data with Excel Sorting Data: A-Z, Z-A, advance sort Filter: Use filter to sort data and advance filtering options What-if Analysis Consolidating data and worksheets Conditional formatting with multiple cell rules Statistical and mathematical functions: Match function: Sum, count, sumifs, countifs, sumproduct, round, random etc. State functions: stdev, ttest, correl, median, average, averageifs etc. Other analytics functions: rank, quartile, decile, percentile etc. Charts and graphs Simple chart Pie chart, bar chart, line chart, scatter plot, doughnut Curve fitting and distribution For VBA we cover following topics: Create a Macro Message Box Workbook and Worksheet Object Range Object Variables If Then Statement Loop Macro Errors String Manipulation Date and Time Events driven programming Arrays Function and Sub Application Object ActiveX Controls User form Interacting with Other Office Applications via Excel VBA Excel Dashboards After covering the above topics you will have fairly good knowledge of Excel/VBA for working in any company/Job.

0
|
0

Hash conducts classes in Business Analytics Training, Microsoft Excel Training and SAS Certification. It is located in Gurgaon HO, Gurgaon. It takes Regular Classes- at the Institute and Online Classes- via online medium.

Share this Profile

Recommended Profiles

Lokesh photo Lokesh photo Ad

Loading...

Lokesh

Gurgaon HO,Gurgaon

Call or whatsapp for Microsoft Training :- 9899 - ...

Amitesh Sri photo Ad

Loading...

Amitesh Sri

DLF City Phase 3,Gurgaon

I am an IT professional work with one of the top m...

Sarbadal P. photo Ad

Loading...

Sarbadal P.

DLF Phase 3,Gurgaon

Training includes Excel VBA & Macro, Excel VBA.

Similar Profiles

C O R E photo

C O R E

C O R E photo Gurgaon HO, Gurgaon

LEARN ENGLISH THE FUN WAY! No boring grammar lessons. Our classes follow the 5 Es Methodology of Engaging, Effective, Experiential,...


Skill IT Training and Consultancy photo

We offer training programs for different audiences in academic setups to enhance their personal effectiveness through life...


Featured
SDK Its Solutions Pvt.Ltd photo

SDK Its Solutions Pvt.Ltd

SDK Its Solutions Pvt.Ltd photo Gurgaon HO, Gurgaon


Gurgaon IAS Academy photo

Gurgaon IAS Academy

Gurgaon IAS Academy photo Gurgaon HO, Gurgaon

IAS/IPS/HCS/RAS and other state civil services coaching by highly experienced and dedicated faculties. Hostel facilities...


PythaGurus photo

PythaGurus

PythaGurus photo Gurgaon HO, Gurgaon

PythaGurus was established in India by a team of Top 10 US Business-School graduates and seasoned Training/Test preparation...


Talent Plus Plus photo

Talent Plus Plus

Talent Plus Plus photo Gurgaon HO, Gurgaon


Sharma tution center photo

Sharma tution center

Sharma tution center photo Gurgaon HO, Gurgaon

We provide home and group tutions to students from class VI to X Eight seven five zero seven three five two five five.


G.A.V Academy photo

G.A.V Academy

G.A.V Academy photo Gurgaon HO, Gurgaon


Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.