Microsoft Office Tutorials and References
In Depth Information
No computerese!
the main task are arranged in a loose progression from the
simplest to the more complex.
that you haven’t made any errors in your workbook, and finding
and replacing text to update changes in information, such as
customer addresses or product names.
Section 1 (this section) introduces the topic, while Section 2,
“What’s new and improved in Excel 2013,” fills you in on the
most important new features of Excel 2013, which include the
program’s seamless integration with Microsoft Windows 8. Excel
2013 also gives you new ways to analyze your data quickly,
whether using the Quick Analysis tool, Recommended Charts,
Recommended PivotTables, and editing and sharing your data
on the web by using SkyDrive and Excel Web App.
Section 5, “Managing and viewing worksheets,” is all about
using worksheets—the “pages” of a workbook. In this section,
you’ll find out about selecting, renaming, moving, copying,
inserting, and deleting worksheets, rows, columns, and cells. In
Section 6, “Using formulas and functions,” you’ll get to know
formulas and functions. You use formulas to calculate values,
such as finding the sum of the values in a group of cells. After
you’re up to speed on creating basic formulas, you’ll learn how
to save time by copying a formula from one cell and pasting it
into as many other cells as you like. Finally, you’ll extend your
knowledge of formulas by creating powerful statements using
the function library in Excel 2013.
Section 3, “Getting started with Excel 2013,” and Section 4,
“Building a workbook,” cover the basics: starting Excel 2013
and shutting it down, sizing and arranging program windows,
navigating in a workbook, using the user interface ribbon to
have Excel do what you want it to do, and working with multiple
Excel documents at the same time. Section 3 also introduces
galleries, which are collections of preset formats that you can
apply to worksheets, charts, and other Excel objects, and shows
you how to get help from within Excel and on the web. Section
4 contains a lot of useful information about entering text and
data, including shortcuts you can use to enter an entire series of
numbers or dates by typing values in just one or two cells. You’ll
also learn about using the Office Clipboard to manage items
that you cut and paste, running the spelling checker to ensure
Section 7, “Formatting the cell,” focuses on making your
workbooks’ cells look great. Here’s where you’ll learn techniques
to make your data more readable, such as by changing font
sizes and font colors and by adding colors and shading to
cells. Section 8, “Formatting the worksheet,” describes similar
techniques you can apply to your worksheets, such as moving,
Search JabSto ::

Custom Search