Microsoft Excel is used in many different professions and industries. The internet is filled with many different types of training courses, so it makes sense that you learn how to use Microsoft excel. Excel would be used on a consistent basis with different professions including bankers, analysts, accountants, consultants, and marketing professionals. Excel is so prominent in the workforce it will pay for you to receive training and experience which you can put on your CV. If you lack educational experience learning excel might help improve your job opportunities. On completing a training course such as https://www.nationaltrainingsolutions.ie/safety-training/microsoft-excel-training, you will make yourself more valuable in the modern-day workforce. Here is our helpful Microsoft Excel Training user guide.
What is Excel?
Microsoft Excel is an office program that provides spreadsheets which comprise of columns and rows. All details can be displayed in the spreadsheets. Excel can perform easy too complicated math’s calculations and other functions. Excel features include pivot tables, calculation, a macro programming language called visual basic for applications, and graphing tools.
• Excel Basics
An excel worksheet is a 2-dimension grid with rows and columns.
Cells, Rows, and Columns
A cell is an individual box within the spreadsheet in which you can enter values such as numbers and words.
A row is a horizontal line of cells. A column is a vertical group of cells.
Inserting Columns and Rows
As you work around your data, you may find that you are constantly adding more rows and columns which can be tedious. The rows are chronologically numbered and start with the number 1 and the columns are letters of the alphabet starting with A.
To add multiple columns or rows in the worksheet, highlight the same number of pre-existing columns or rows that you want to add, then click and select insert.
Autofill allows you to quickly fill adjacent cells with several types of data including formulas, series, and values. Select the cells that you require, locate the fill handle than either double click or drag the fill handle to cover the cells you want.
If you are looking at large data sets, you don’t need to be looking at all rows at the same time. Filters will let you to pare your data down to only view specific rows at one time. A filter can be added to each column in your data set. To add a filter, you click the data tab and select the filter.
1. Moving from cell to cell
To move from cell to cell use the arrow keys on the keyboard to move up, down, right, or left from the cell you are currently in. Click the enter key for moving into the cell straight away underneath the current cell, you must then click the tab key for moving 1 cell to the right.
There are several ways to select a cell in an excel spreadsheet. These include:
• Click into a cell to select 1 cell
• Click on the row number to select more than 1 row of cells
• Click on the column letters to select more than 1 column of cells
• For selecting multiple of contiguous cells, click in 1 cell corner and the mouse must be dragged to the opposite corner.
• For selecting multiple cells that are not contiguous, click and hold the control key while clicking in the cells that you desire.
• To select all the cells on the spreadsheet, click in the upper right corner of the spreadsheet.
Entering data into the cells
For entering data into the cells, click into the cell area and start typing. All information that is typed will be displayed in the formula bar.
Moving and copying cell contents
For moving content in a cell, right click while in the cell and click cut, then right click your mouse in the new cell you want to copy into and paste.
Adding and deleting columns and rows
For inserting a new row into the worksheet, right click on a row-number and then insert. The row will always be inserted over the row that you click on. For deleting a row, right click on the row-number and then delete.
For inserting a new column, right click on a column letter and then click insert. The column is always inserted to the left of the column that you click on. For deleting a column, right click on the column letter, and then click delete.
Protecting your spreadsheet and locking cells
There are 2 ways of preventing important content in the cells from being accidentally deleted or overwritten.
•Locking the cell
•Protecting the worksheet
To lock or unlock a cell in excel click into format options. Click inside a cell right click and click format cells.
To protect a worksheet, click the review tab, click protect worksheet, and click ok.