Excel 2010 simplified [electronic resource] / by Paul McFedries.

Format:

Book

Author/Creator:

McFedries, Paul.

Series:

Visual read less, learn more.

Read less, learn more

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Electronic spreadsheets.

Physical Description:

1 online resource (258 p.)

Edition:

1st ed.

Place of Publication:

Indianapolis, IN : Wiley, c2010.

Language Note:

English

Summary:

Get going with Excel 2010 quickly and easily with this Simplified guide Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away. With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier tha

Contents:

Microsoft® Excel® 2010 Simplified®; Credits; About the Author; Author's Acknowledgments; How to Use This Book; Table of Contents; Chapter 1: Working with Excel; Getting to Know Excel; Start Excel; Tour the Excel Window; Work with Excel's Ribbon; Work with Excel's Galleries; Customize the Quick Access Toolbar; Customize the Ribbon; Work with Smart Tags; Change the View; Configure Excel Options; Chapter 2: Entering and Editing Excel Data; Learning the Layout of a Worksheet; Understanding the Types of Data You Can Use; Enter Text into a Cell; Enter a Number into a Cell

Enter a Date or Time into a CellInsert a Symbol; Edit Cell Data; Delete Data from a Cell; Chapter 3: Working with Excel Ranges; Select a Range; Fill a Range with the Same Data; Fill a Range with a Series of Values; Move or Copy a Range; Insert a Row or Column; Insert a Cell or Range; Delete Data from a Range; Delete a Range; Hide a Row or Column; Freeze Rows or Columns; Merge Two or More Cells; Transpose Rows and Columns; Chapter 4: Working with Range Names; Define a Range Name; Use Worksheet Text to Define a Range Name; Navigate a Workbook Using Range Names; Change a Range Name

Delete a Range NameChapter 5: Formatting Excel Ranges; Change the Font and Font Size; Apply Font Effects; Change the Font Color; Align Text Within a Cell; Center Text Across Multiple Columns; Rotate Text Within a Cell; Add a Background Color to a Range; Apply a Number Format; Change the Number of Decimal Places Displayed; Apply an AutoFormat to a Range; Apply a Conditional Format to a Range; Apply a Style to a Range; Change the Column Width; Change the Row Height; Wrap Text Within a Cell; Add Borders to a Range; Chapter 6: Building Formulas and Functions; Understanding Excel Formulas

Build a FormulaUnderstanding Excel Functions; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Chapter 7: Manipulating Excel Worksheets; Navigate a Worksheet; Rename a Worksheet; Create a New Worksheet; Move a Worksheet; Copy a Worksheet; Delete a Worksheet; Change the Gridline Color; Toggle Worksheet Gridlines On and Off; Toggle Worksheet Headings On and Off; Chapter 8: Dealing with Excel Workbooks; Create a New Blank Workbook

Create a New Workbook from a TemplateSave a Workbook; Open a Workbook; Arrange Workbook Windows; Find Text in a Workbook; Replace Text in a Workbook; Chapter 9: Formatting Excel Workbooks; Modify the Workbook Colors; Set the Workbook Fonts; Choose Workbook Effects; Apply a Workbook Theme; Chapter 10: Analyzing Excel Data; Sort a Range; Filter a Range; Set Data Validation Rules; Convert a Range to a Table; Create a Data Table; Summarize Data with Subtotals; Chapter 11: Visualizing Data with Excel Charts; Examining Chart Elements; Understanding Chart Types; Create a Chart; Add Chart Titles

Add Data Labels

Notes:

"Visual"-- T.p.

Includes index.

ISBN:

1-118-07928-0

1-282-54876-X

9786612548765

0-470-64651-9

OCLC:

609861476