By Abbott Katz

Starting Microsoft Excel 2010 is a realistic, step by step consultant to getting all started with the world's so much widely-used spreadsheet program. The publication bargains a hands-on method of studying how one can create and edit spreadsheets, use numerous calculation formulation, hire charts / graphs, and get paintings performed successfully. Microsoft rolled out a number of new good points with Excel 2010 - possibly the main striking was once the facility to exploit Excel 2010 on-line and collaborate on a undertaking in actual time. starting Microsoft place of work 2010 retains you recent with all of those good points and extra.

Show description

Read or Download Beginning Microsoft Excel 2010 PDF

Similar business technology books

Learning Perl on Win32 Systems

During this tender, rigorously paced direction, top Perl running shoes and a home windows NT practitioner educate you to software within the language that can provide to end up the scripting language of selection on NT. Perl for Win32 is a language for simply manipulating textual content, records, consumer and staff profiles, functionality and occasion logs, and registry entries.

InfoPath with SharePoint 2010 How-To

This booklet is designed to hide all the elements of InfoPath 2010 inside a SharePoint 2010 setting with regard to making and constructing company recommendations. it truly is aimed toward either technical and semi-technical execs and doesn't require a level in machine programming to make use of. The scenario-based presentation of the fabric presents not just an outstanding educational but additionally an in-depth reference for achieving essential InfoPath 2010 initiatives in the SharePoint platform.

Extra resources for Beginning Microsoft Excel 2010

Sample text

Take a look at Figure 2–29: 39 CHAPTER 2 ■ GETTING STARTED AND GETTING AROUND THE WORKSHEET Figure 2–29. Auto-fill options The default selection, Copy Cells, really characterizes what we’ve just done. But assuming we’ve copied the number 3 as per the screen shot, from the D17 source cell down through D30, look then what happens when we click selection number two, Fill Series, as shown in Figure 2–30: Figure 2–30. A Fill Series I’ll bet that one got you to look up and stop texting. What Excel has done here is add an increment of one to each of the cells in the range to which we copied the original value, 3.

I know it because I can direct my attention to that long strip to the right of the name box, called the formula bar (and again, we’ll need to explain that name). Click cell A3 again and check out the formula bar—you’ll see Figure 2–18: Figure 2–18. The Formula Bar: recording the actual contents of a cell Note the visual relationship in force here. I’ve clicked on cell A3. The formula bar records what I’ve typed there, confirming that the phrase in A3 indeed occupies that cell, and only that cell.

And so here’s the point behind all this: if I want to change the font in a range of cells, I can select those cells I want as illustrated above, and then go ahead and issue a font-change command. And as a result, only the cells in the range will be affected. And how do you go about selecting cells in a range? It’s rather easy—and again, both mouse and keyboard approaches stand at the ready. If you’re mouse-inclined, click the first cell of the desired range—which is, typically, the upper-left cell in the block of cells you want to select.

Download PDF sample

Rated 4.35 of 5 – based on 19 votes