UrbanPro
true

Overview

I am Manager, Data Analytics and Reporting in HCL Technologies LTD having 10+ years of experience in Advance Excel, VBA macros, Tableau, SQL, Power BI.

If you are looking for someone to make you learn a complete spreadsheet solution for your skills enhancement, automate current manual processes, or are struggling with any complex spreadsheet or VBA issue, feel free to contact me.

If you want to be excellent at developing and maintaining User Forms, Macros, Automated Templates & Reports, I may be the right person to take you there.

Some examples of apps you will frequently build after getting connected:

* Turn raw data (csv files and other plain data) into beautiful reports
* Rearrange and organize complex and disorganized data
* Process large amounts of data very quickly
* Organize Financial data into statements, analytics, and graphs
* Create client price quotes using nice menus that change based on selection
* Build estimates and orders–including those requiring heavy and complex calculations with many factors (for example, construction and financial apps)
* Provide forms for staff use that control and restrict input to valid selections
* Extract and clean up data
* And a whole lot more.

Languages Spoken

Hindi Mother Tongue (Native)

English Proficient

Education

RSS(PG) Degree College, Pilkhuwa, Hapur, Uttar Pradesh 2006

Bachelor of Arts (B.A.)

Address

Krishna Nagar Colony

Dasna, NH 24 (now 9)

Dasna, Ghaziabad, India - 201015

Landmark: Near Shiv Mandir Gaurav Enclave, Eastern Peripheral Expressway

Verified Info

ID Verified

Phone Verified

Email Verified

Report this Profile

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

Teaches

Microsoft Excel Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

10

Teaches following Excel features

Excel VBA Training, Basic Excel, Excel Macro Training, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

1. Creating and Editing Formulae 2. Conditional Functions & Formats and Date Calculations 3. IF functions and Conditional Formatting 4. Lookup and Reference Functions 5. Pivot Tables & Charts 6. Excel Charts / Graphs 7. Introduction to Excel VBA 8. Variables 9. Excel Object Model 10. Procedures 11. Functions 12. Workbook Object 13. Worksheet Object 14. Range Object 15. If-Else Condition 16. Looping 17. Arrays 18. Collection 19. PivotTable Object 20. Charts Object 21. Using SQL Queries (ADODB) 22. User Form Design

Tableau Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Tableau Training

5

Teaching Experience in detail in Tableau Training

In Tableau Course you will learn: 1. Measure vs. Dimension 2. Discrete - Continuous Dimension 3. Discrete - Continuous Measure 4. Aggregation 5. Granularity 6. Data Source Filters + Extract Filters 7. Context Filters + Date Filters 8. Live vs. Extract (Theory + Practice) 9. Save - Edit Data Source 10 .twb, .twbx, .tds, .tdsx, .hyper 11. Union (Theory + Practice) 12. Left Join, Right Join, Inner Join, Outer Join 13. Cross Database Join 14. Blending (Theory + Practice) 15. Rename Column, Data Types 16. Hide, Split, Custom Split, Alias 17. Default: Aggregation + Color + Shape 18. Default: Number Format + Comment 19. Basic Charts 20. Text Table + Highlight Table 21. Stacked Bar Chart 22. Combined Axis Chart 23. Combination Charts 24. Groups 25. Static Set vs. Dynamic Set 26. Dynamic Set Top N + Bottom N 27. Hierarchy (Date + Location + Time) 28. Manual vs. Computed Sort 29. Reference Line 30. Reference Band & Distribution (BONUS) 31. Trend Line 32. Table Calculation 33. Calculated Field 34. Histogram & Bin 35. Dashboard Design Principles 36. Dashboard Elements 37. Dashboard Actions 38. Create - Edit Device Layout 39. Story 40. Dashboard vs. Story 41. Export Options ( PDF + Image + DB)

Courses

Documents (1)

Examples of Automations through...

Reviews

No Reviews yet!

FAQs

1. What Excel features do you teach?

Excel VBA Training, Basic Excel, Excel Macro Training and others

2. Which classes do you teach?

I teach Microsoft Excel Training and Tableau Classes.

3. Do you provide a demo class?

Yes, I provide a free demo class.

4. How many years of experience do you have?

I have been teaching for 10 years.

Answers by Brajpal Singh (1)

Answered on 04/12/2020 Learn IT Courses

Hello Preeti,After going by the trend, SQL, Tableau & Python course will be great for you to achieve success. It may seem overwhelming to you, but if you to some serious effort, you may learn as much to get entry-level jobs in the IT domain. Best of Luck!
Answers 301 Comments
Dislike Bookmark

Teaches

Microsoft Excel Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

10

Teaches following Excel features

Excel VBA Training, Basic Excel, Excel Macro Training, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

1. Creating and Editing Formulae 2. Conditional Functions & Formats and Date Calculations 3. IF functions and Conditional Formatting 4. Lookup and Reference Functions 5. Pivot Tables & Charts 6. Excel Charts / Graphs 7. Introduction to Excel VBA 8. Variables 9. Excel Object Model 10. Procedures 11. Functions 12. Workbook Object 13. Worksheet Object 14. Range Object 15. If-Else Condition 16. Looping 17. Arrays 18. Collection 19. PivotTable Object 20. Charts Object 21. Using SQL Queries (ADODB) 22. User Form Design

Tableau Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Tableau Training

5

Teaching Experience in detail in Tableau Training

In Tableau Course you will learn: 1. Measure vs. Dimension 2. Discrete - Continuous Dimension 3. Discrete - Continuous Measure 4. Aggregation 5. Granularity 6. Data Source Filters + Extract Filters 7. Context Filters + Date Filters 8. Live vs. Extract (Theory + Practice) 9. Save - Edit Data Source 10 .twb, .twbx, .tds, .tdsx, .hyper 11. Union (Theory + Practice) 12. Left Join, Right Join, Inner Join, Outer Join 13. Cross Database Join 14. Blending (Theory + Practice) 15. Rename Column, Data Types 16. Hide, Split, Custom Split, Alias 17. Default: Aggregation + Color + Shape 18. Default: Number Format + Comment 19. Basic Charts 20. Text Table + Highlight Table 21. Stacked Bar Chart 22. Combined Axis Chart 23. Combination Charts 24. Groups 25. Static Set vs. Dynamic Set 26. Dynamic Set Top N + Bottom N 27. Hierarchy (Date + Location + Time) 28. Manual vs. Computed Sort 29. Reference Line 30. Reference Band & Distribution (BONUS) 31. Trend Line 32. Table Calculation 33. Calculated Field 34. Histogram & Bin 35. Dashboard Design Principles 36. Dashboard Elements 37. Dashboard Actions 38. Create - Edit Device Layout 39. Story 40. Dashboard vs. Story 41. Export Options ( PDF + Image + DB)

Courses

No Reviews yet!

Answers by Brajpal Singh (1)

Answered on 04/12/2020 Learn IT Courses

Hello Preeti,After going by the trend, SQL, Tableau & Python course will be great for you to achieve success. It may seem overwhelming to you, but if you to some serious effort, you may learn as much to get entry-level jobs in the IT domain. Best of Luck!
Answers 301 Comments
Dislike Bookmark

Brajpal Singh describes himself as Manager, HCL Tech, 14 years exp in Data Analytics, here to make you AWESOME in Data Analysis.. He conducts classes in Microsoft Excel Training and Tableau. Brajpal is located in Dasna, Ghaziabad. Brajpal takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 10 years of teaching experience . Brajpal has completed Bachelor of Arts (B.A.) from RSS(PG) Degree College, Pilkhuwa, Hapur, Uttar Pradesh in 2006. He is well versed in English and Hindi.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Brajpal Singh

Let Brajpal Singh know you are interested in their class

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.

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more