Gayatri Nagar, Nagpur, India - 440022
Verified
3
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.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
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.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Java Script Training classes
1
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in React JS Training
1
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Node.JS Training
1
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
Sahadevi Ramesh kannake
"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. "
Pratiksha Ashok meshram
"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. "
Renu Bhaskar karhade
"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.
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. 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.
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 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.
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 update the linked cells in the target sheet, ensuring real-time synchronization of data.
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.
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.
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 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.
Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
Want to learn from Rohit?
Share this Profile
Recommended Profiles
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
Jaitala Rd Parsodi,
Nagpur
