Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
There may be times when you need to generate a series of random numbers based on specific mean and standard deviation for some scenarios. Below are some guidelines that will help you. Generate random numbers by given Mean and Standard Deviation To solve this, you need to follow the below step-by-step process. Step 1 To begin with, you need to enter your needed mean and standard deviation into two empty cells, in this case, I have selected A1 and A2 as shown in the below screenshot. Step 2 Afterwards, in cell B3, type this formula =NORMINV(RAND(), $B$1, $B$2) and ... Read More
When you enable change tracking for a workbook, you will have the ability to choose which changes to accept and which to reject. You can make this decision by selecting the Accept/Reject Changes option from the drop-down menu of the Track Changes command button on the Review tab of the Ribbon. Excel will analyze all of the highlighted changes that have been made to the shared file by you and anybody else who has worked on it, and it will give you the option to either accept or reject specific modifications. Excel will show you a warning dialogue box before ... Read More
When we need to make changes to anything in any cell, editing is a typical practice. Therefore, it is really necessary to get some practice using the shortcut key for this particular activity. There are times when we have to change the content of the cell. Because we frequently need to amend the formula or debug the formula, the shortcut is quite useful. Often, we may need to edit the formula. In addition, it is essential to practice shortcut keys in order to reduce the amount of time required for particular tasks when you are a new learner. Because of ... Read More
Consider that you have a list of names in which one name is repeated multiple times. Now you need to scan the column for the name which is repeated multiple times and add 1 if another repeated name is entered in the specific cells to show the total number of the repeated name. Below shows an example of how to do this. Add 1 to a specified cell if the cell contains certain text with an array formula The array formula below can help you add 1 to a specified cell if a cell range contains certain text in the ... Read More
The purpose of this article is to show you how you can use a formula in Excel in order to add a specified character before each word in a cell. Add a Character before each word in a cell with the Formula The following instructions will help you to add one or a few characters before each word that appears in an Excel cell. Step 1 Open an Excel workbook, select a cell blank cell and enter the below formula mentioned formula into the formula bar and then press Enter key. =”Character”&SUBSTITUTE(cell reference, ’’ “, “character”) Consider you ... Read More
The Y axis is automatically added to the left-hand side of an Excel chart while it is being created. You may need to switch it to your right hand in some circumstances, but how would you go about doing that? You will learn about the workarounds in this article. Add a right hand/side y axis to an excel chart Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot. Step 2 Then, select the cells ... Read More
You can use the scrollbar feature to show a chart with lots of data, just by dragging the scrollbar, you will see the data changing continuously while it's being displayed in the chart. If a lot of data needs to be shown, you can add the scrollbar. However, there is a tricky part in Excel when it comes to adding a scrollbar to a chart, so follow these steps step by step to finish this task. Add a Scrollbar in Excel You have the following data range wherein you want to add the scrollbar chart to the Excel worksheet. ... Read More
When dealing with data in Excel, there are instances when you may find that you need to do certain data conversions on cells, such as converting units, converting currencies, converting time zones, and so on. Convert Units In most cases, when we need to convert a number from one unit of measure to another, we will utilize the CONVERT function. However, the CONVERT function will not operate properly for some of the unit conversions that you attempt. Step 1 You may use the CONVERT function to convert the inches specified in the range to the corresponding values in feet, centimeters, ... Read More
YouTube is a fantastic venue for developing a devoted and active following that feels directly connected to you. Consider to include a live streaming in your YouTube strategy if you want to step up the level of interaction with your audience. When you live stream on YouTube, you can communicate with your viewers immediately, answer their questions and comments, and allow for unfiltered audience interaction. Additionally, it's a fantastic approach to expand your YouTube following and gain the trust of your viewers. We'll cover how to live stream on YouTube, how to advertise your live broadcasts, and more in this ... Read More
Entrepreneur! When you consistently produce top-notch YouTube videos, people look up to you as an authority. However, your video engagement may start to decrease and viewers won't stick around to the conclusion if you ramble, stumble, or can't keep their attention. When your thoughts don't flow naturally, the spectator finds it difficult to see the outcome. In order to help you plan, organise, structure, and storyboard your videos so they flow better and make you sound like the authority you are, I'll be sharing how to boost the engagement of your YouTube videos. The Perfect Timeline to make a video ... Read More