best ways to learn excel from basics to advance
The basics of Excel
Excel is an efficient tool to extract meaning from vast quantities of information. However, it also performs well for doing simple calculations and tracking virtually all kinds of data. The key to unlocking possibilities can be found in the cells. Cells can be filled with text, numbers or formulas. The data you enter into your cells and then group them into columns and rows. This allows you to mix your data to arrange and categorize it, place it into tables, and create stunning charts. Let’s walk through the fundamental steps to help you get to the right place. so best ways to learn excel from basics to advance will help you
Learn excel from beginner to expert from ms excel course online,
Create your own workbook
Excel documents are also known as workbooks. Every workbook contains sheets, commonly referred to as spreadsheets. You can add any number of sheets you like to your workbook, or create new workbooks in order to keep your data separated. best ways to learn excel from basics to advance
Learn advanced excel training,
Click File, then click New.
Under New, click on the Blank workbook.
New blank workbook
Enter your data
Click on a cell that is empty.
For instance cell A1 on a brand new sheet. Cells are identified by their position in the column and row on the sheet. So, cell A1 is located in the row that is in column A.
Enter text or numbers inside the cells.
Click Enter, or Tab to go to another cell.
Cell borders must be adhered to.
Choose the cell or the number of cells you wish to draw a border around.
The Home tab is where you will find within the Font group Click the arrow next Borders and then select the border style you’d like.
Excel Ribbon Image
For more details, refer to the section on how to apply or remove borders on the worksheet .
Apply shading to cells
Choose the cell or the number of cells you would like to apply shading of cells to.
The Home tab is where you will find under the Font group, select the arrow beside the Fill Color Button image, and the next time you click on Theme Colors or Standard Colors Select the color you would like to use. best ways to learn excel from basics to advance
For more details about how to format the worksheet, go to How to format the worksheet.
Make use of AutoSum to enter your data
If you’ve entered numbers on your spreadsheet, you may like to combine them. One method to do this is using AutoSum.
Select the cell that is to the left or beneath the number you wish to include.
Click Home Then choose AutoSum within the editing group.
AutoSum on the Home tab
AutoSum adds the numbers and displays the results in the cell that you chose.
For more information, visit Use AutoSum to sum numbers
Select a cell, then enter an equivalent sign (=).
It informs Excel that the cells are going to contain the formula.
For instance Enter =2+4 or =4-2; =2*4 =4/2.
This is the way to calculate.
It is also possible to press Ctrl+Enter if it is desired for the cursor to remain on the cell that is active.
For more details, visit Make a simple formula.
Make use of a formatted number
To differentiate between different kinds of numbers, use the format of percentages, currency or dates.
Choose the cells with numbers you would like to format.
Click on the Home tab and then click the arrow inside the General box.
Format Number box on the Home tab
Choose a format for a number.
Number format gallery
If you can’t find the format of the number you’re searching for, click More Formats for Numbers. For more details, visit the available formats for number numbers. best ways to learn excel from basics to advance
Your data should be placed in the form of a table
An easy way to tap into Excel’s power is to arrange your data into the form of a table. This lets you quickly sort or filter your data.
Choose your data by clicking on the first cell and then dragging it until the final cell of your data.
To type Hold Shift down while you use the Arrow keys to select the data you want to access.
Select the Quick Analysis button at the bottom right corner of the screen.
Selected data is displayed with Quick Analysis Lens button visible
Click Tables, then move your mouse to the Table button, to view your data, then click the Table button.
Quick Analysis Tables gallery
Select the drop-down arrow Filter an arrow on the table’s header of the column.
To filter your data, you must clear your Select All checkbox, then select the data you wish to include on your table.
Choose all box in the gallery of Sort and Filter
To sort the data, simply click the Sort button from A-Z or Z-to-A.
Sorting commands are available in the gallery of Sort and Filter
For more information, visit How to make or edit an Excel table.
Display the totals of your numbers by using Quick Analysis
This Quick Analysis tool (available in Excel 2016 and Excel 2013 only) allows you to total your numbers in a matter of minutes. It doesn’t matter if it’s a total number, average, or count you’re looking for, Excel shows the calculation results in front of your numbers.
Choose the cells that have numbers you wish to count or add.
Hit the Quick Analysis button Quick Analysis button located in the lower-right corner of the screen.
all of this Click Totals, then move your mouse across the buttons to view the results of your calculation for your particular data, then click for the application of totals.
Quick Analysis Gallery of Totals
Choose the information you wish to study more in depth.
Click on the Quick Analysis button button image at the bottom-right of the page.
Explore the options available on tabs Formatting as well as Sparklines tabs in order to discover how they impact your data.
Quick Analysis Formatting Gallery
As an example, select an appropriate color scale from the Formatting gallery to separate between medium and high temperatures. low temperatures.
Data that has a color scale conditional format
If you are satisfied with what you find, select that option.
Find out more about how you can study trends in data using sparklines.