Work with data entry forms
work with data entry forms One reason that people like Microsoft Access is that it allows for friendly data-entry forms that are easier to use than row-and-column spreadsheets. Excel offers data-entry forms, too, if you know where to look forCiteste tot ... 290 cuvinte
Dimensiune mica
+ cu imagini |
 |
 |
The power of charts
the power of charts Charts (also called graphs) summarize and present data in a graphical way. Take a look at Figures 5-1 and 5-2; which would you rather look at? Excel uses the terms graph and chart interchangeably. Throughout the main parCiteste tot ... 414 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Move and copy sheets
move and copy sheets Worksheet tabs are arranged from left to right at the bottom of the workbook window, as you already know. When you insert a new worksheet, it might not be exactly where you want it. That's okay, though, because you can reaCiteste tot ... 409 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Change chart lines and fills
change chart lines and fills To customize any part of the chart, right-click it and choose Properties (the exact name depends on the element). A dialog box opens, and from that dialog box you can change the line and fill colors and properties.Citeste tot ... 330 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Create a 3d range
create a 3d range A 3D range is a range that includes the same cell(s) on more than one sheet. This can be helpful when you have multiple sheets that all contain basically the same information but for different groups, people, organizations, mCiteste tot ... 316 cuvinte
Dimensiune mica
- fara poza |
|
 |
Financial functions - PMT
financial functions There is also a host of financial functions available in Excel. The ones you choose to use will depend upon your job function. If, for example, you are a financial analyst, you might use IRR to calculate the internal rate oCiteste tot ... 1214 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Add and delete sheets
add and delete sheets Most people are accustomed to working with Excel in two dimensions: across and down. But did you know that, by default, each Excel workbook actually consists of three separate sheets? What's more, you can add as many sheeCiteste tot ... 328 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Change the chart type and layout
change the chart type and layout Different chart types can convey very different messages with the data, as you saw earlier in this lesson. If the message isn't quite right, try a different chart type. The Chart toolbar has an abbreviated lisCiteste tot ... 771 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Create a chart
create a chart A good chart contains not only data, but also descriptive labels that help the user understand the data. For example, you should be able to tell at a glance that a certain pie slice represents 30 percent of the whole, as well asCiteste tot ... 766 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Search and sort data
search and sort data Any good database has a means for quickly locating certain data, and Excel is no exception. Excel offers several Find methods. As you saw previously, you can use the data-entry form to find records with certain criteriaCiteste tot ... 851 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Functions that make choices
functions that make choices In Excel, there are several functions that are used to make choices for you while you work. One such choice might be based on a test condition. For example, you can build a formula in Excel that says, 'If a cerCiteste tot ... 651 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Copy cell content
copy cell content In the preceding lesson, you learned about 3D references in worksheets, which enable you to work with data among multiple sheets in a workbook. Now you're no longer limited to two dimensions! In this lesson, you learn aboutCiteste tot ... 711 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Create a custom fill series
create a custom fill series In the preceding examples, you saw that dragging January or Monday produced a fill series, but dragging your name produced only identical copies of your name. That's because week and month names are predefined fillCiteste tot ... 345 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Plan your database
plan your database A database is a collection of data that is organized using a consistent structure. An address book is a database, for example. You have entries for many different people, but you collect the same information about each persoCiteste tot ... 419 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Name and color-code sheets
name and color-code sheets Each sheet starts out with a generic name like Sheet1, Sheet2, and so on. When you insert new sheets, their default names continue with that naming convention. For example, in a workbook with three sheets, the next nCiteste tot ... 433 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Use styles
use styles If you have used styles in Word before, you already probably understand the concept of a style. A style is a collection of formatting settings that you can apply all at once. Styles are not quite as easy to use in Excel as they arCiteste tot ... 271 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Custom number formats
custom number formats This lesson's saved the Custom number format for last because it's the most complex and powerful. With it, you can create your own number formatting rules. First, the basic procedure: Select the cell(s), choCiteste tot ... 1274 cuvinte
Dimensiune mica
- fara poza |
|
|
The SUM functions
the SUM functions Excel contains several SUM functions, which extend your capabilities far beyond the simple summing of a group of numbers in a range of cells. Even the lowly SUM function can take arguments. Listed below are the SUM functionsCiteste tot ... 880 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Work with standard number formats
work with standard number formats Number formats are applied to cells and affect the way numbers appear in them. They don't affect text entries in a cell. Examples of number formats include Currency, Date/Time, and Percent. The number format deCiteste tot ... 743 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Advanced formatting features
advanced formatting features automatic format copying Excel sometimes copies formatting for you automatically. To try this out, perform the following experiment: In cell A1, type Spring. In cell B1, type Fall. SCiteste tot ... 391 cuvinte
Dimensiune mica
+ cu imagini |
|
|
Alte pagini
