UrbanPro
Hash Analytics photo

Hash

Gurgaon HO, Gurgaon, India- 122001.

Connect with Hash
Are you Looking to Learn?
Connect with Hash

What do you want to learn?

Search and select a category

Please select a Category.

No matching category found.

Enter your location

Please select a Location.

Please select a Location.

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

Microsoft Excel Training classes

Teaches following Excel features:

SAS Training classes
SAS Certification
SQL Server Training
Business Analytics Training classes
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 Analytics 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

Related Profiles

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.


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.


GITS Academy photo

GITS Academy

GITS Academy photo Gurgaon HO, Gurgaon

GITS Academy is a training Institute for Professional courses in Business Analytics & Clinical Research. Courses in Business...

About us

GITS Academy is a training Institute for Professional courses in Business Analytics & Clinical Research. Courses in Business Analytics: 1. SAS, 2. SPSS, 3. Data Analysis & Data Managememt using Excel, 4. VBA/Macros for Analystic advanced. 5. VBA for advance user, 6. Advanced MS Access, 7. Advanced Business statistics using Excel, 8. Predictive Modeling, 9. MS SQL Server 2008, 10. MS BI (SSAS, SSiS, SSRS) Courses in Clinical Research: 1.CRA Training, 2. PG Diploma in clinical Research, 3. PG Diploma in Clinical Data Management, 4. PG Diploma Pharmacovigilence, 5. PG Diploma in Clinical Trial Management


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.


IIJT photo

IIJT

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


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


Focus on Teaching photo

Focus on Teaching

Focus on Teaching photo Gurgaon HO, Gurgaon

Expertise in teaching maths, physics and computer science to students of class 8-12 across all English boards(ICSE, CBSE)....

About us

Expertise in teaching maths, physics and computer science to students of class 8-12 across all English boards(ICSE, CBSE). We also cover all Java, Advance Java, SQL, Hibernate , Spring, Unix, PL/Sql training's to aspirants looking for JOB in IT. We being corporate professional know how and what to teach efficiently so that students can grasp it in one go. For the quality to understand we provide one trail class to every aspirants who is looking to start with us. We are not traditional tutors, we are corporate professionals who know exactly what is to start with that is in market to crack interviews or getting good marks in boards.


Featured
Exponent Software Solutions photo

Exponent Software Solutions

Exponent Software Solutions photo Gurgaon HO, Gurgaon

About us


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.


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.