UrbanPro
true

Rohit Motghare

IT professional having clear understanding of Power BI concepts and best teching skills.

Gayatri Nagar, Nagpur, India - 440022

Verified 3 Students

Book a Demo
Referral Discount: Get ₹ 250 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Rohit Motghare

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Teaches

Web Development Classes

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Data Analytics classes

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Microsoft Power BI classes

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Teaching Experience in detail in Microsoft Power BI classes

I have strong knowledge of Business Intelligence and Data Analytics using Microsoft Power BI. I can conduct sessions to share my knowledge which can be most helpful to find various career opportunities in the industry.

SQL Programming Training

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

BI Reporting Training

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Java Script Training classes

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Years of Experience in Java Script Training classes

1

React JS Training

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Years of Experience in React JS Training

1

Node.JS Training

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Years of Experience in Node.JS Training

1

MySQL DBA Training

Class Location

Online Classes (Video Call via UrbanPro LIVE)

Student's Home

Tutor's Home

Years of Experience in MySQL DBA Training

1

5 out of 5 3 reviews

Rohit Motghare https://p.urbanpro.com/tv-prod/member/photo/12309318-small.jpg Gayatri Nagar
5.0053
Rohit Motghare
S

Microsoft Power BI

"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "

Rohit Motghare
P

Microsoft Excel Training

"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "

Rohit Motghare
R

Microsoft Power BI

"I learned Power BI from Rohit Sir. It was a great experience of learning with hands-on project work. It help me lot to understand real time industry scenarios and importance of business intelligence in the industry. "

Reply by Rohit

Thank you Renu for your kind feedback. and all the best for your bright career.

Have you attended any class with Rohit?

Answers by Rohit Motghare (5)

Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

To compute factorial using VBA in Excel, you can utilize this function. First, access the VBA editor by pressing Alt + F11, insert a new module via Insert > Module, and paste the provided code. The function Factorial(num) takes a number as input and returns its factorial value.... ...more

To compute factorial using VBA in Excel, you can utilize this function. First, access the VBA editor by pressing Alt + F11, insert a new module via Insert > Module, and paste the provided code. The function Factorial(num) takes a number as input and returns its factorial value. Simply input =Factorial(number) into an Excel cell, replacing number with the desired value for which you want to compute the factorial. This VBA code employs a straightforward iterative loop to calculate the factorial of the given number.

 
 
Answers 2 Comments
Dislike Bookmark

Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

To incorporate Solver in Excel, first enable the Solver Add-In by navigating to "File" > "Options" > "Add-Ins" > "Excel Add-ins," and check the "Solver Add-in" box before clicking "OK." Once activated, access Solver in the "Data" tab. Click on the "Solver" icon to open the Solver Parameters... ...more

To incorporate Solver in Excel, first enable the Solver Add-In by navigating to "File" > "Options" > "Add-Ins" > "Excel Add-ins," and check the "Solver Add-in" box before clicking "OK." Once activated, access Solver in the "Data" tab. Click on the "Solver" icon to open the Solver Parameters dialog box. Here, define the objective cell, set constraints for variables, select the solving method, and adjust Solver options. Clicking "Solve" initiates Solver to find a solution that aligns with your specified criteria. Upon completion, review the results to keep the solution or revert to the initial values based on Solver's findings. Solver proves effective for optimizing scenarios such as financial planning, resource allocation, and scheduling by dynamically adjusting variables to meet defined conditions and objectives within Excel. 

Answers 2 Comments
Dislike Bookmark

Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

To automatically update one Excel worksheet from another, you can use various methods: Formulas/Cell References: Utilize cell references or formulas like =SheetName!A1 in the target sheet to link and display data from another worksheet. Any changes made in the original worksheet will automatically... ...more

To automatically update one Excel worksheet from another, you can use various methods:

  1. Formulas/Cell References: Utilize cell references or formulas like =SheetName!A1 in the target sheet to link and display data from another worksheet. Any changes made in the original worksheet will automatically update the linked cells in the target sheet, ensuring real-time synchronization of data.

  2. VBA Macros: Employ VBA macros to automate data transfer between sheets. With VBA, you can create scripts to copy specific ranges or entire datasets from one worksheet to another, allowing for more complex data manipulation or custom updating processes based on your requirements.

  3. Data Connections or Power Query: Establish data connections or use Power Query to pull in data dynamically from another worksheet. By setting up connections or using Power Query transformations, you can link sheets and update data in one worksheet based on changes in the source, offering a more automated and structured approach to data updates.

Select the method that aligns best with your workflow and data updating needs within Excel.

 

Answers 3 Comments
Dislike Bookmark

Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

To modify only the last three digits of a serial number string in Excel VBA, extract the last three characters, convert them to a number, add your desired value while ensuring it stays within a three-digit range, then update the original string with the modified digits. Here's a concise code snippet: Sub... ...more

To modify only the last three digits of a serial number string in Excel VBA, extract the last three characters, convert them to a number, add your desired value while ensuring it stays within a three-digit range, then update the original string with the modified digits. Here's a concise code snippet:

Sub IncreaseLastThreeDigits()
Dim serialNumber As String
serialNumber = "ABC123456" ' Replace with your serial number

Dim lastDigits As Long
lastDigits = (CLng(Right(serialNumber, 3)) + 100) Mod 1000 ' Increase by 100 (for example)

serialNumber = Left(serialNumber, Len(serialNumber) - 3) & Format(lastDigits, "000") ' Update serial number

MsgBox "Updated Serial Number: " & serialNumber ' Display updated serial number
End Sub

Replace "ABC123456" with your actual serial number string and adjust the + 100 part to increase the last three digits by your desired value. Execute this code in Excel VBA to view the updated serial number in a message box.

 
 
Answers 3 Comments
Dislike Bookmark

Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

XLOOKUP is an Excel function used to search for a value in a table and return a corresponding result from another column or row.
Answers 3 Comments
Dislike Bookmark

Rohit Motghare describes himself as IT professional having clear understanding of Power BI concepts and best teching skills.. He conducts classes in BI Reporting, Data Analytics and Java Script Training. Rohit is located in Gayatri Nagar, Nagpur. Rohit takes Online Classes- via online medium. He has 1 years of teaching experience . Rohit has completed Bachelor of Engineering (B.E.) from Rashtrasant Tukdoji Maharaj Nagpur University in 2023. HeĀ is well versed in Marathi, English and Hindi. Rohit has got 3 reviews till now with 100% positive feedback.

X

Share this Profile

Recommended Profiles

Neha B.

Neha B. photo Gurgaon HO, Gurgaon

Aishwarya Holkar

Aishwarya Holkar photo Silicon City, Indore

Srinivas Gorrepati

Srinivas Gorrepati photo Marathahalli, Bangalore

Aniket Sharma

Aniket Sharma photo Neeladri Road Electronic City Ph-1, Bangalore

Sadhvi Academy

Sadhvi Academy photo Vellakinar Village Kumarasamy Avenue, Coimbatore

Dinesh Kumar

Dinesh Kumar photo Sector-21, Chandigarh

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.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

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