Whatever your needs may be, Excel is sure to have a feature or two that enhance your business skills and make your life a little, or a lot, easier if used well. Each Cell has a name, that name comes from the Column and Row the Cell sits on. Each Column is a vertical series of Cells. Each Row is a horizontal series of Cells. Excel Formulas can be used to either calculate the value of a single Cell or multiple Cells, as well as use Functions to calculate values or retrieve data.
Simple Formulas can calculate by adding, dividing, multiplying or subtracting values from other Cells. For example, if you wanted to add together the values of three Cells to work out the total value, you could do this:.
In the example above, it shows how you can highlight multiple Cells in a Row; this also works if you need to highlight multiple Cells in a Column. First, you have to ensure that there is a common identifier in both your lists. The common identifier must be identical in each list — in this case the common identifier is customer email addresses. The Column containing the common identifier needs to be located to the left of the data you want to retrieve.
There may come a time when you need to add up values in a particular Column, Row or specific Cells based on certain criteria. Now, if you wanted to add up how many people are going to attend your restaurant on a certain day, you can use a SUMIF like this:.
You may find that you need to count how many times a certain value appears in a Column, Row or specific Cells. For example, imagine you own a restaurant and you have a list of all your bookings. Excel Charts and Graphs can be really useful to visualise data and give a clearer picture of what the data can tell you.
Looking at numerous Columns and Rows full of various information can be a bit hard on your eyes and in some cases it just looks meaningless. This is where Charts and Graphs can help by showing the data in a different way, which may result in you spotting some sort of trend or pattern.
Following on from the examples above, we have some data relating to restaurant customer numbers and booking numbers for certain dates. This will then present you with some appropriate charts and graphs, like so:. Outgoings, Name, Category, Months.
Continue to enter appropriate headings both across Columns and Rows, then enter the names and categories for each item of your budget into the relevant Cells. It will take you from the very beginning opening a spreadsheet , through entering and working with data, and finish with saving and sharing. Got a different version? No problem, you can still follow the exact same steps. When you first open Excel by double-clicking the icon or selecting it from the Start menu , the application will ask what you want to do.
To open an existing spreadsheet like the example workbook you just downloaded , click Open Other Workbooks in the lower-left corner, then click Browse on the left side of the resulting window.
A workbook is an Excel file. It usually has a file extension of. A spreadsheet is a single sheet inside a workbook. The Ribbon is the central control panel of Excel.
You can do just about everything you need to directly from the Ribbon. There are a number of tabs, including Home , Insert , Data , Review , and a few others.
Each tab contains different buttons. It says Tell me what you want to do. In addition to tabs, the Ribbon also has some smaller sections. You can manage those sheets with the sheet tabs near the bottom of the screen.
Click a tab to open that particular worksheet. Just know that there are lots of other ways to get data into your spreadsheets if you need them. The application looks complicated, way too advanced, and like something that would take hours to figure out. Is there any way to make Microsoft Excel less scary and intimidating? By learning a few spreadsheet tricks, you can bring Excel down to your level and start looking at the application in a different light.
We rounded up some of the simplest yet powerful MS Excel spreadsheet tips you can start using on your data. To start you off, get yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can help them follow your data and calculations easily.
To quickly apply your formatting across hundreds of cells, use the Format Painter:. To format a range of cells, double-click the Format Painter during step 1. Also at the bottom of the screen, on the right side, you'll see icons to change the view — you can see print previews of the spreadsheet, for example, and use the zoom slider to change the size of the spreadsheet on your screen.
Every worksheet is composed entirely of a grid of cells. Cells are identified by their X and Y coordinates, such as A1 and C You're unlikely to ever run out of cells; Excel supports a maximum of 1,, rows and 16, columns. At the top of the page, you'll find Excel's main controls in the ribbon. The ribbon is divided into tabs such as Home, Insert, Draw, Formulas, and Data with the most important features appearing in the ribbon for each of those categories.
You can also perform some operations using the right-click menu right-click on a cell or range of cells to see the available options.
In a lot of ways, Excel is similar to Word when it comes to formatting and arranging the content of cells. Click the Home tab to get access to a variety of common formatting tools, like bold, italic, underline, and font size options. You can also shade and color text and cell backgrounds. One thing to keep in mind is that Excel treats a cell as an indivisible unit.
You can't format different numbers, letters, or words within a cell differently, so the entire cell is going to have the same font size, bolding, and text color. You can change the width of a cell by dragging its right edge.
If some cells in a column have text that extends beyond the end of the cell, for example, and is covered by content in the cell to the right, position the mouse over the division between the cells in the column header at the top of the spreadsheet. Then click and drag it to resize the entire column. Another solution: Rather than changing the width of a cell to make sure the text is visible, you can format the cell so the text wraps within the cell.
Another trick you can try is merge two cells into one , which can be handy for formatting a table full of text and numbers. You can also automatically snap the column to the width of the widest cell. Position the mouse over the right edge of the cell in the header and double click.
The column should adjust — larger or smaller — to the best size to fit the column. Need to move a column from one place in the spreadsheet to another? You can do that, too. There are a lot of other common formatting tasks you might want to do in Excel, such as removing blank rows to improve the appearance of your spreadsheet, as well as hiding rows with data you need but don't necessarily want to display.
You can also easily add new rows in a spreadsheet between rows of existing data and even "freeze" a row so that it always stays on the screen even as you scroll through the rest of the sheet.
At a fundamental level, Excel is a calculator that lets you perform calculations using different cells. To add multiple cells together, put numbers in three nearby cells, such as a 1, 2, and 3.
0コメント