Rabu, 29 Juni 2011

ebook - Microsoft® Excel® 2010 Step by Step

| Microsoft® Excel® 2010 Step by Step | Curtis D. Frye | Microsoft Press | 2011 | English | 480 p | pdf | 26.4 MB | ISBN : 0735626944 | This book has been designed to lead you step by step through all the tasks you’re most likely to want to perform in Microsoft Excel 2010. If you start at the beginning and work your way through all the exercises, you’ll gain enough proficiency to be able to create and work with all the common types of Excel workbooks. However, each topic is self contained. If you’ve worked with a previous version of Excel, or if you completed all the exercises and later need help remembering how to perform a procedure, the following features of this book will help you locate specific information: Detailed table of contents, Search the listing of the topics and sidebars within each chapter; Chapter thumb, tabs Easily locate the beginning of the chapter you want; Topic-specific running heads, Within a chapter, quickly locate the topic you want by looking at the running heads at the top of odd-numbered pages; Glossary, Look up the meaning of a word or the definition of a concept; Detailed index, Look up specific tasks and features in the index, which has been carefully crafted with the reader in mind. You can save time when reading this book by understanding how the Step by Step series shows exercise instructions, keys to press, buttons to click, and other information. |
ebook - Microsoft® Excel® 2010 Step by Step
Authors
:
Curtis D. Frye
Publisher
:
Microsoft Press
Year
:
2010
Language
:
English
Pages
:
480 p
File Format
:
pdf
File Size
:
26.4 MB
Introducing Microsoft Excel 2010
For those of you who are upgrading to Microsoft Excel 2010 from an earlier version of the program, this introduction summarizes the new features in Excel 2010. One of the first things you’ll notice about Excel 2010 is that the program incorporates the ribbon, which was introduced in Excel 2007. If you used Excel 2003 or an earlier version of Excel, you’ll need to spend only a little bit of time working with the new user interface to bring yourself back up to your usual proficiency.
Features and Conventions of This Book
This book has been designed to lead you step by step through all the tasks you’re most likely to want to perform in Microsoft Excel 2010. If you start at the beginning and work your way through all the exercises, you’ll gain enough proficiency to be able to create and work with all the common types of Excel workbooks. However, each topic is self contained. If you’ve worked with a previous version of Excel, or if you completed all the exercises and later need help remembering how to perform a procedure, the following features of this book will help you locate specific information:
  • Detailed table of contents Search the listing of the topics and sidebars within each chapter.
  • Chapter thumb tabs Easily locate the beginning of the chapter you want.
  • Topic-specific running heads Within a chapter, quickly locate the topic you want by looking at the running heads at the top of odd-numbered pages.
  • Glossary Look up the meaning of a word or the definition of a concept.
  • Detailed index Look up specific tasks and features in the index, which has been carefully crafted with the reader in mind.
You can save time when reading this book by understanding how the Step by Step series shows exercise instructions, keys to press, buttons to click, and other information.
Using the Practice Files
Before you can complete the exercises in this book, you need to copy the book’s practice files to your computer. These practice files, and other information, can be downloaded from the book’s detail page, located at:
go.microsoft.com/fwlink/?LinkId=191751
Display the detail page in your Web browser and follow the instructions for downloading the files.
Getting Help
Every effort has been made to ensure the accuracy of this book. If you do run into problems, please contact the sources listed in the following topics.
Getting Help with This Book
If your question or issue concerns the content of this book or its practice files, please first consult the book’s errata page, which can be accessed at:
go.microsoft.com/fwlink/?LinkId=191751
Getting Help with Excel 2010
If your question is about Microsoft Excel 2010, and not about the content of this book, your first recourse is the Excel Help system. This system is a combination of tools and files stored on your computer when you installed Excel and, if your computer is connected to the Internet, information available from Office.com. You can find general or specific Help information in the following ways:
  • To find out about an item on the screen, you can display a ScreenTip. For example, to display a ScreenTip for a button, point to the button without clicking it. The ScreenTip gives the button’s name, the associated keyboard shortcut if there is one, and unless you specify otherwise, a description of what the button does when you click it.
  • In the Excel program window, you can click the Microsoft Excel Help button (a question mark in a blue circle) at the right end of the ribbon to display the Excel Help window.
  • After opening a dialog box, you can click the Help button (also a question mark) at the right end of the dialog box title bar to display the Excel Help window. Sometimes, topics related to the functions of that dialog box are already identified in the window.
Contents at a Glance
Table of Contents
Introduction
1
Setting Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2010 Program Window
2
Working with Data and Excel Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining Excel Tables
3
Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
4
Changing Workbook Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Excel Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to Worksheets
5
Focusing on Specific Data by Using Filters
Limiting Data That Appears on Your Screen
Manipulating Worksheet Data
Defining Valid Sets of Values for Ranges of Cells
6
Reordering and Summarizing Data
Sorting Worksheet Data
Organizing Data into Levels
Looking Up Information in a Worksheet
7
Combining Data from Multiple Sources
Using Workbooks as Templates for Other Workbooks
Linking to Data in Other Worksheets and Workbooks
Consolidating Multiple Sets of Data into a Single Workbook
Grouping Multiple Sets of Data
8
Analyzing Alternative Data Sets
Defining an Alternative Data Set
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result by Using Goal Seek
Finding Optimal Solutions by Using Solver
Analyzing Data by Using Descriptive Statistics
9
Creating Dynamic Worksheets by Using PivotTables
Analyzing Data Dynamically by Using PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
10
Creating Charts and Graphics
Creating Charts
Customizing the Appearance of Charts
Finding Trends in Your Data
Summarizing Your Data by Using Sparklines
Creating Dynamic Charts by Using PivotCharts
Creating Diagrams by Using SmartArt
Creating Shapes and Mathematical Equations
11
Printing
Adding Headers and Footers to Printed Pages
Preparing Worksheets for Printing
Printing Worksheets
Printing Parts of Worksheets
Printing Charts
12
Automating Repetitive Tasks by Using Macros
Enabling and Examining Macros
Creating and Modifying Macros
Running Macros When a Button Is Clicked
Running Macros When a Workbook Is Opened
13
Working with Other Microsoft Office Programs
Including Office Documents in Workbooks
Storing Workbooks as Parts of Other Office Documents
Creating Hyperlinks
Pasting Charts into Other Documents
14
Collaborating with Colleagues
Sharing Workbooks
Managing Comments
Tracking and Managing Colleagues’ Changes
Protecting Workbooks and Worksheets
Authenticating Workbooks
Saving Workbooks for the Web
Glossary
Index

0 komentar:

Posting Komentar

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More