But the power of Excel is its ability to perform mathematical calculations and other functions. When you are ready to write math formulas, see Excel Math Basics. An Excel worksheet, or spreadsheet, is a two-dimensional grid with columns and rows. Look at the worksheet below.
The column names are letters of the alphabet starting with A, and rows are numbered chronologically starting with one. Each cell has an address or a cell reference : cells in Row 1 are A1, B1, C1, and so on.
And cells in the first column are A1, A2, A3, etc. Cell references are often used in math formulas or functions. A KeynoteSupport. The Name Box is located in the area above Column A, and displays the cell reference of the selected cell - the cell where the cursor is resting. In our spreadsheet above, the selected cell is C2. Notice that the column letter C and the row number 2 change color.
The beginning of the Formula Bar can be seen in the area above Column D on our worksheet. The Formula Bar displays the contents of the selected cell which may be a number, text, or formula. A workbook is a collection of worksheets. New workbooks, when created, contain three worksheets by default.
Worksheet names are displayed on tabs at the bottom of the workbook. To remove your duplicates, highlight the row or column that you want to remove duplicates of. Then, go to the Data tab, and select "Remove Duplicates" under Tools.
A pop-up will appear to confirm which data you want to work with. Select "Remove Duplicates," and you're good to go. You can also use this feature to remove an entire row based on a duplicate column value.
So if you have three rows with Harry Potter's information and you only need to see one, then you can select the whole dataset and then remove duplicates based on email. Your resulting list will have only unique names without any duplicates. It would take a lot of time to copy and paste each individual header. Not to mention, you may easily fall into one of the biggest, most unfortunate Excel traps: human error.
Instead, let Excel do the work for you. Go ahead and highlight the column or row you want to transpose. Paste Special is one function I find myself coming back to time and time again.
In the module, you can also choose between copying formulas, values, formats, or even column widths. What if you want to split out information that's in one cell into two different cells? For example, maybe you want to pull out someone's company name through their email address. Or perhaps you want to separate someone's full name into a first and last name for your email marketing templates. 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.
Click on any cell, then click into the formula bar and start typing. Open up the first sheet in the example workbook, click into cell C1, and type the following:. Try doing different types of arithmetic on the other numbers in columns A and B using this method. These let you run complex calculations with a few keypresses. Check out our other blog posts to see some of the great things you can do with functions! You can also use this to include numbers in different columns.
We put the contents of A5 and B5 together. Excel has dozens of useful functions. To find the function that will solve a particular problem, head to the Formulas tab and click on one of the icons:.
Scroll through the list of available functions, and select the one you want you may have to look around for a while. If you start typing a formula, starting with the equals sign, Excel will help you by showing you some possible functions that you might be looking for:. This is a tiny preview of how functions work and what they can do. It should be enough to get you going on the tasks you need to accomplish right away. You can also click the Save button in the Quick Access Toolbar :.
Trying to recover unsaved changes is a pain! Click the Share button in the top-right corner of the window, and Excel will walk you through sharing your document. You can also save your document and email it, or use any other cloud service to share it with others. Check which formats are compatible with Numbers for Mac. If you want to open a Numbers spreadsheet in another app like Microsoft Excel, use Numbers to convert the spreadsheet to an appropriate format.
When the file opens, you might get a message that the spreadsheet will look different. For example, Numbers notifies you when fonts are missing. You might see also see warnings when you open spreadsheets created in older versions of Numbers. Numbers for iCloud lets you open, edit, and share your files from a supported browser on a Mac or PC. Check which formats are compatible with Numbers for iCloud. Excel Budget Template Project Managers working on small to midsize projects can use Microsoft Excel to visualize, plan and track their projects.
Getting started with Excel - look no further. What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.
0コメント