One of my students asked me what the hell going on there, every interviewer asked me about my Excel skills!
Unfortunately, he missed his chance because of his lack of skills in microsoft excel.
Logically it’s meant to happen this way because every industry requires the candidate must have the skills in Ms- Excel. Basics in excel are must nowadays, and you need to ensure your excel skills before facing another interview because it matters now.
So here today I will give you the guideline assuming you as a beginner.
Microsoft Excel is the most used and popular software that provides worksheets contained with a massive number of rows and columns. The data you submit can be recorded in the worksheet that is also known as a spreadsheet. This is somewhat similar to Microsoft word table, but the Microsoft Excel has more power to perform simple to complex mathematical calculations, and other functions as well. The point is, Microsoft Excel helps to work very conveniently.
A work field that is comprised of cells in rows and columns is a spreadsheet. It is used to arrange, calculate, and sort out the data in a spreadsheet. The rows in a worksheet have numeric names (1, 2, 3) while the columns have the alphabetic names. So what makes the Excel software unique? Because it is able to calculate values using mathematical formulas and the date.
The arrow keys in your keyboard can be used to move left, right, up, and down from the current cell. Then press the Enter key to move to the cell immediately below the current cell, and just press the Tab key to move one cell to the right. Yeah, It is that easy!
There are plenty of ways you can use to select cells in an Excel spreadsheet:
For example, Suppose you have entered 10.4367 in a cell. But the cell was formatted to show only two decimal places, Excel will display 10.43 in that worksheet cell. However, Excel will still use the real cell value that you entered, 10.4367.
There are several ways to propagate date from one cell to adjacent cells. Let’s try with 2 commonly used keyboard shortcuts that allow you to fill down and the right:
To propagate in any area, use the Fill Handle. Select the cell with data to be copied, hover the cursor over the cell’s lower right corner until the cursor turns to a plus sign (+) or a black square, and drag up, down, left, or right to fill the cells.
If the data to be copied is a date, number, or a custom-made series, it will be incremented by one instead of just copied when the Fill Handle is used.
Suppose you need to show the months of the year in column A. So all you need to do is just type the year in column A and write down January in cell A1, drag the file Handle down to your required cell, and the months will be displayed in chronological order in column A.
If you want to move cell contents then, take your mouse pointer to the target cell and right-click- click Cut. As same as to Copy, right-click, then select Copy and paste it in the other cell.
You can also paste your data in the multiple adjacent cells at the same time. Just select the blocks of cells you want to fill in and then press right-click, select Paste.
If you want to insert a new row in a spreadsheet, right-click on a row number, and click Insert. Press the F4 key to add each additional row.
To delete, right-click on the row number, and click Delete. Adjacent rows can be deleted by selecting them at a glance before clicking Delete. And non-contiguous rows can be selected by pressing and holding the CTRL button before clicking Delete.
If you want To insert a new column, right-click on a column letter and click Insert. The column added on the left. As similar as rows, if you want to add additional columns after inserting the first column, press the F4 key.
To delete a column, as like as row, right-click on the column letter, and click Delete. Adjacent columns can be removed by highlighting them before clicking Delete. And also, you can delete non-adjacent columns by pressing and holding pressing and holding the CTRL-key and click Delete.
To prevent any harm of your data there are two ways. First of all, the cell must be locked. Secondly, the worksheet must be protected. If you have any valuable data or complex formulas that you really don’t want to lose, then it is up to you which cells to lock and which worksheet protection options to take.
ALT+= Inserts a SUM formula.
CTRL+TAB switches between open Excel windows.
CTRL+1 Displays the Format Cells dialogue box.
CTRL+SHIFT+” Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+K Opens the Hyperlink dialogue box.
CTRL+F Opens the Find dialogue box.
CTRL+H Opens the Find & Replace dialogue box.
CTRL+N Opens a new workbook.
CTRL+S Saves workbook.
CTRL+C Copy
CTRL+X Cut
CTRL+V Paste
CTRL+P Opens Print dialogue box
In conclusion, I want to say you that, learning Microsoft Excel can not be your waste of time, it is any industries’ demand these days. If you want to progress in your career you should consider learning Microsoft Excel, there is no other way than this.
So what are you waiting for?
Let’s get started with us and be an expert in days
Phlebotomy or more commonly known as venipuncture, is one of the essential services in the healthcare industry. Conversely, it’s one
It’s no news that technology has made the human learning process a walk in the park compared to in the
Who doesn’t love kids? They are like little angels walking around us. What if you could choose a career in which your primary responsibility would be to take care of kids? This blog will show you how to become a nursery nurse even without a college degree.
Before making a career decision in 2020, stop for a moment and think. What factors have you considered yet? Only
Planning to become a motorcycle mechanic or motorcycle technician? You need to understand the difference between them first. Because becoming
Have you ever realized how important plumbers are in our lives? We call them when we need to fit or
0 responses on "Basics in Excel: A Beginner's Guide To Getting Started"