Help on microsoft exel

If you want to insert excel data into words without creating a link-and-embed process, you can paste the data as a graphic. Just like every software has keyboard shortcuts, excel has its own too. There are many of them but below are the most relevant and widely used. The breaking point while working on a spreadsheet with a massive data set, is scrolling in any direction and trying to find that specific row or column you want.

Users tired of this situation found a simple excel trick to deal with it. And below is how you do it:. Working with spreadsheets with many numbers cells could be a daunting task, but all could be resolved by opening a new or second window. Thanks to Excel, both are possible. First, highlight the column that you want to split up. Next, go to the Data tab and select "Text to Columns. First, you need to select either "Delimited" or "Fixed Width.

In the example case below, let's select "Delimited" so we can separate the full name into first name and last name. Then, it's time to choose the delimiters. This could be a tab, semicolon, comma, space, or something else. In our example, let's choose the space. Excel will then show you a preview of what your new columns will look like.

When you're happy with the preview, press "Next. When you're done, click "Finish. But if you ever spent some time formatting a sheet to your liking, you know it can get a bit tedious. Use the format painter to easily copy the formatting from one area of the worksheet to another. Creating reports in Excel is time-consuming enough. How can we spend less time navigating, formatting, and selecting items in our spreadsheet?

Glad you asked. There are a ton of Excel shortcuts out there, including some of our favorites listed below. Excel can help you do simple arithmetic like adding, subtracting, multiplying, or dividing any of your data.

Use parentheses to ensure certain calculations are done first. Some of the most common include:. Also note that series of specific cells are separated by a comma , , while cell ranges are notated with a colon :. Conditional formatting allows you to change a cell's color based on the information within the cell.

To get started, highlight the group of cells you want to use conditional formatting on. Then, choose "Conditional Formatting" from the Home menu and select your logic from the dropdown.

You can also create your own rule if you want something different. A window will pop up that prompts you to provide more information about your formatting rule. Select "OK" when you're done, and you should see your results automatically appear. Have you ever seen a dollar sign in an Excel formula? When used in a formula, it isn't representing an American dollar; instead, it makes sure that the exact column and row are held the same even if you copy the same formula in adjacent rows.

You see, a cell reference — when you refer to cell A5 from cell C5, for example — is relative by default. In that case, you're actually referring to a cell that's five columns to the left C minus A and in the same row 5. This is called a relative formula. When you copy a relative formula from one cell to another, it'll adjust the values in the formula based on where it's moved. But sometimes, we want those values to stay the same no matter whether they're moved around or not.

We can do that by making the formula in the cell into what's called an absolute formula. Databases tend to split out data to make it as exact as possible. For example, instead of having a data that shows a person's full name, a database might have the data as a first name and then a last name in separate columns.

Or, it may have a person's location separated by city, state, and zip code. Let's go through the formula together using an example.

Pretend we want to combine first names and last names into full names in a single column. To do this, we'd first put our cursor in the blank cell where we want the full name to appear. But you're not finished. The quotation marks around the space tell Excel to put a space in between the first and last name. To make this true for multiple rows, simply drag the corner of that first cell downward as shown in the example.

Pivot tables are used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information in your spreadsheet depending on what you'd like them to do.

Let's take a look at an example. Let's say I want to take a look at how many people are in each house at Hogwarts. You may be thinking that I don't have too much data, but for longer datasets, this will come in handy. Get the details. Work with stocks and geography data. Turn your data into insights.

List of all Excel functions available. IF function. Create a drop-down list. Combine text from two or more cells. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable. Quickly create and share content that stands out, manage your schedule with ease, effortlessly connect with others and enjoy peace of mind - all with Microsoft Try 1 month free.

Learning and training Microsoft Training Center. Microsoft basic video training. Microsoft templates. Money in Excel. Printable infographics. Microsoft tips. Quick start guides. Office cheat sheets.