In short, it is automatic formatting that works by the conditions that you define.įor example: highlighting the top 15 customers, below-average performing employees, etc. It highlights the portions of the data to meet any given condition. Excel pivot tables can be used to summarize, analyze, explore and present the data.įollow these points to create a pivot table: To ease out the process of report writing on excel, pivot tables are used. One of the highlighting facts of the usage of excel in workplaces is its ability to create charts and reports. Conversion- In case you want to convert a number from one measurement to another, just use the convert() function.Įxample- Use CONVERT (12, “tsp”, “Oz”) to find out that 12 tsp is actually 2 ounces.You can clean up cell contents with the trim() spreadsheet function.Įxample: Use trim(” copied data “) to get copied data. Clean-Up- In case you have copied data from other sources, a lot of empty space next to each cell value appears.Simple just round off a number to the nearest even, odd number Data with Fractions- When you are working with data that has fractions or decimals, there may require a need that to find the nearest integer.Current Date- In businesses like logistics where you need to find out the current date every single day, instead of doing the same each day, you can use today()Įxample: Use today() to get or whatever is today’s date.to calculate the sum of range A1: A2, use the formula SUM- To calculate SUM function between the two cells, i.e.
To let Excel know that you want to enter a formula, type an equal sign (=).įollowing are the formulas you need to know in lieu of How to learn Excel:.To enter any formula, execute the following steps first: The built-in Excel features like Autosum make it easy to write formulas as per the needs of the user. Using Microsoft Excel formulas, make it convenient for users to make calculations and to handle the data. In the process of how to learn Microsoft Excel, follow the above-stated, simple formatting tricks for easy data handling. To enter a percentage, simply follow the value with a percent sign.Then, press the space bar and type the fraction, including the slash. To enter currency, type a dollar sign ($) before typing the value to apply the Currency format.While using Excel you can format some values as you enter them: Table Formatting- You can adjust the table formatting by choosing Quick Style options for table elements, such as header and total rows, first and last columns, and banded rows and columns.In order to copy formatting, use Paste.Use the fill handle to copy formatting.Applying the right formatting to specific cells helps users to work more efficiently. Due to its grid system, Excel can store and manage thousands of data points with so much ease. How to use Microsoft Excel includes Formatting Dataĭata handling is one of the foremost reasons for what is Microsoft Excel used for. In order to change this, simply right-click on it and choose which summaries to show. Status bar: The status bar shows quick summaries of selected cells that include functions like count, sum, average, minimum or maximum values.In order to avoid the messy look, the spreadsheet grid shows a few rows & columns only. Each Excel file can contain several sheets. Spreadsheet Grid: It is a place for all the numbers, data, charts, and drawings.Once you start building formulas, this tab becomes useful. Formula Bar- This is where any calculations or formulas you write will appear.The most important ribbons are – Home, Insert, Formulas, Page Layout, and Data. Ribbon- It is like an expanded menu that depicts all the features of Excel in a form that is easily understandable.Let’s understand a few basic terms enlisted below: Conclusion:- How to use Microsoft Excel?Įxcel is a massive application with 1000s of features and 100s of ribbon commands.How to use Microsoft Excel includes Formatting Data.