UrbanPro
Hash Analytics photo

Hash

Gurgaon HO, Gurgaon, India- 122001.

x

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?

Connect With Hash

Hash

Connect With Hash

Hash is currently not available to take your call. Please provide the following information, so that Hash can call you back.

What do you want to learn?

Please select a category

Please select a category

No matching category found.

Please enter the Pin Code.

Please enter your name.

Please enter valid Phone Number

Note: Please enter the phone number that you want to receive a call on.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Hash

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

About Us

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.

Classes Conducted

SAS Certification
SQL Server Training
Business Analytics Training classes
SAS Training classes
Microsoft Excel Training classes

Teaches following Excel features:

Excel VBA & Macro Training

Address

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

sector 14

Gurgaon HO, Gurgaon, India- 122001. .

Reviews

No Reviews yet! Be the first one to Review
Write a Review

Answers by Hash 2 Questions Answered

"Is it necessary to have the knowledge of VB script for Excel Macro Training?" in   Microsoft Excel Training classes

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   Microsoft Excel Training classes

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
Load More

Related Profiles

Featured
Exponent Software Solutions photo

Exponent Software Solutions

Exponent Software Solutions photo Gurgaon HO, Gurgaon

About us


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.

About us

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


IIJT photo

IIJT

IIJT photo Gurgaon HO, Gurgaon

About us


G.A.V Academy photo

G.A.V Academy

G.A.V Academy photo Gurgaon HO, Gurgaon

About us


Skill IT Training and Consultancy photo

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

About us

We offer training programs for different audiences in academic setups to enhance their personal effectiveness through life skills and functional skills. There are unique programs designed for each of the following, 1. Faculties 2. Students (school level, Higher education) 3. Academic Leaders 4. staff Along with these human capacity building programs we offer process consultancy to design conducive academic and management process to make optimum use of resources and add innovation to the existing system.


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...

About us

IAS/IPS/HCS/RAS and other state civil services coaching by highly experienced and dedicated faculties. Hostel facilities can be arranged for those who require it.Subjects offered:- G.Studies, History, Public Administration, CSAT and Interview preparations.Other competition exams such as Bank PO's/ NDA/ CDS/ Railways/ Delhi Police.


Bites Academy photo

Bites Academy

Bites Academy photo Gurgaon HO, Gurgaon

we provide coaching and tuitions for students

About us

we provide coaching and tuitions for students


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...

About us

PythaGurus was established in India by a team of Top 10 US Business-School graduates and seasoned Training/Test preparation industry professionals. Our leadership team comprises of professionals who were educated in the Top-10 Graduate Schools in the United States ( Our Management Team) , and our programs are of significantly higher quality than our peer firms in the entire region.


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,...

About us

LEARN ENGLISH THE FUN WAY! No boring grammar lessons. Our classes follow the 5 Es Methodology of Engaging, Effective, Experiential, Earnest and Encouraging. From professionals to job seekers, from housewives to businessmen. Welcome all! Our curriculum keeps everyone's needs in mind.


Focus on Teaching photo

Focus on Teaching

Focus on Teaching photo Gurgaon HO, Gurgaon

Angular JS Trainer | JAVA | KAFKA | FLINK | SPRING | HIBERNATE | TYPESCRIPT | PLSQL | SQL. | Had an experience working with...

About us

Angular JS Trainer | JAVA | KAFKA | FLINK | SPRING | HIBERNATE | TYPESCRIPT | PLSQL | SQL. | Had an experience working with Wipro. Have worked in Abroad for years.


Show All

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