noobhorizon.blogg.se

• #Free tutorials for excel series#

You can also view multiple pages in Page Layout view by reducing the size of the pages using the Zoom control. Because everything in Page layout view is fully editable, you can make data changes, select new for-matting options, and save and print in this view. Rulers along the top and left side of the work area enable you to plan for specific content areas on the page. Page layout view makes printing easier by taking away the guesswork. Display the worksheet in Page Layout view by clicking the View tab and selecting Page Layout View. Office Excel 2010 includes a new view, called Page Layout new which gives you the ability to see how your worksheet is shaping up while you’re working on it. Printing worksheets-getting the margins just right and including everything you want on the page-can be a bit of a challenge (and time-consuming!) for both new and experienced Office Excel users. Page Layout: A New View for Better Printing

Tip: To find out more about the new elements in the Microsoft Office system user interface- including the new command sets, contextual tools live preview, galleries, and more-refer to Chapter 2 “A New Look.” the ruler, the formula bar and more), magnifying or reducing the display, and working with the worksheet window. Hiding and redisplaying worksheet elements (gridlines. The View tab provides commands for choosing different workbook \views. The Review tab includes what you need to proof, comment on and share and protect the sheet. The Data tab offers commands for getting external data managing the connections to external links sorting and filtering your data removing duplicates, validating and consolidating your data, and grouping and ungrouping cells. The Formulas tab includes the Function Wizard, the Function Library, the commands you need for creating and working with named cells, commands for formula auditing, and calculation options. The Page Layout tab offers all things related to setting up the worksheet, including choosing themes, selecting page setup options, controlling the scaling of individual objects, selecting worksheet options, and arranging items on the sheet. The Insert tab houses the commands for the objects you add to your worksheets for example, tables, charts, illustrations, links, and various kinds of text items, such as column or row labels. The Home tab includes the commands you need to work with the Clipboard choose and change fonts control the alignment of cell content select number formats choose cell style and format and edit, sort, and search your data.

Here’s a list of the command tabs you’ll find in Office Excel 2010:

#Free tutorials for excel series#

The new results-oriented look of Office Excel 2010 brings to your work area the tools you need-and only the tools you need-to complete what you’re trying to create, analyze, or illustrate in your worksheet.Ĭonsistent with other major Microsoft Office system applications, the user interface is designed to help you be more productive by offering a series of command tabs, as well as command sets and contextual commands related to specific objects in your worksheet. This chapter introduces some of these significant changes.

Specifically, the additions and enhancements in Office Excel 2010 help users create better spreadsheets faster, understand, visualize, and share important information more easily with others, and make data analysis easier and more effective, resulting in better insight for those decisions that affect the bottom line. The major changes in Office Excel 2010 offer exciting possibilities that can simplify and extend the way users create, work with, and share financial documents-spreadsheets, work-books, reports, and more. This is not your grand-mothers calculator! Office Excel 2010 faces the same challenge that Microsoft* Office Word 2010 takes on: offering powerful, sophisticated tools in an accessible way that enables both experts and novices to find what they need easily and produce professional-quality, accurate, and insightful results. And share critical information that affects the entire business life cycle. Over the years, Office Excel has evolved from a basic spreadsheet tools to a major business application that enables information workers to create, analyze, consolidate, report on. Unless their job responsibilities demand a detailed working knowledge of spreadsheets right from the start, their earliest experiences with Office Excel 2010 might have been creating simple financial documents-maybe in response to a request from a manager, a need in their own business, or a question from a financial advisor. Extend Your Insight Office Excel 2010………………………………………02įor many people, Microsoft Office Excel 2010 is one of those programs you grow into.