Learning Microsoft Excel 2013, Student Edition -- CTE/School
Pearson
978-0-13-314910-4 (ISBN)
- Keine Verlagsinformationen verfügbar
- Artikel merken
Learning Microsoft Excel 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage students and help them work independently.
Learning Microsoft Excel 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage readers and help them work independently. This book is appropriate for Introductory Computing courses on Microsoft Office Applications or courses on Computer Concepts that include coverage of Excel 2013.This book is also suitable for individuals interested in learning to use Microsoft Excel 2013 effectively in their home life and career.
Using the Common Features of Microsoft Office 2013
Lesson 1 — Microsoft Office 2013 Basics
Lesson 2 — Saving, Printing, and Closing Microsoft Office Files
Lesson 3 — Working with Existing Files
Lesson 4 — Using Command Options
Lesson 5 — Managing Program Windows
Lesson 6 — Using Microsoft Office Help
Lesson 7 — Managing Information Technology
End-of-Chapter Activities 73
Chapter 1
Getting Started with Microsoft Excel 2013
Lesson 1 — Touring Excel
Lesson 2 — Worksheet and Workbook Basics
Lesson 3 — Adding Worksheet Contents
Lesson 4 — Worksheet Formatting
Lesson 5 — More on Cell Entries and Formatting
Lesson 6 — Working with Ranges
Lesson 7 — Creating Formulas
Lesson 8 — Copying and Pasting
Lesson 9 — Techniques for Moving Data
Lesson 10 — Sheet, Display, and Print Operations
End-of-Chapter Activities
Chapter 2
Working with Formulas and Functions
Lesson 11 — Getting Started with Functions
Lesson 12 — Using Excel Tables
Lesson 13 — Working with the NOW Function and Named Ranges
Lesson 14 — Working with IF Functions
Lesson 15 — Working with Text Functions
Lesson 16 — Using Frozen Labels and Panes
Lesson 17 — Using Conditional Formatting and Find and Replace
Lesson 18 — Rotating Entries and Resolving Errors
Lesson 19 — Managing Worksheets and Performing Multi-Worksheet Operations
Lesson 20 — Modifying Print Options
End-of-Chapter Activities
Chapter 3
Charting Data
Lesson 21 — Building Basic Charts
Lesson 22 — Showing Percentages with a Pie Chart
Lesson 23 — Enhancing a Pie Chart
Lesson 24 — Adding Special Elements to a Chart or Sheet and Updating a Chart
Lesson 25 — Completing Chart Format ting
Lesson 26 — Comparing and Analyzing Data
Lesson 27 — Char t Printing and Publishing
Lesson 28 — Using Charts in Other Files
Lesson 29 — Making Special Purpose Charts
End-of-Chapter Activities
Excel Chapter 4
Advanced Functions, PivotCharts, and PivotTables
Lesson 30 — Working with Hyperlinks
Lesson 31 — Using Advanced Sort
Lesson 32 — Using Advanced Filtering
Lesson 33 — Using Advanced Functions to Predict Trends
Lesson 34 — Using Advanced Functions for Data Analysis
Lesson 35 — Using LOOKUP Functions
Lesson 36 — Working with PivotTables and PivotCharts
Lesson 37 — Working with the Excel Data Model
Lesson 38 — Working with PowerPivot and Power View
End-of-Chapter Activities
Excel Chapter 5
Advanced Formatting and Workbook Features
Lesson 39 — Working with File Formats
Lesson 40 — Working with Graphics and Saving a Worksheet As a Web Page
Lesson 41 — Working with Web Data
Lesson 42 — Linking and Embedding Data
Lesson 43 — Working with Workbooks
Lesson 44 — Working with Comments and Modifying Page Setup
Lesson 45 — Using Copy and Paste Special
Lesson 46 — Moving and Linking Data Between Workbooks
Lesson 47 — Working with 3-D Formulas
Lesson 48 — Working with Data Validation and Macros
End-of-Chapter Activities
Excel Chapter 6
Managing Large Workbooks
Lesson 49 — Customizing the Excel Interface and Converting Text
Lesson 50 — Formatting Cells
Lesson 51 — Hiding and Formatting Workbook Elements
Lesson 52 — Customizing Styles and Themes
Lesson 53 — Customizing Data Entry
Lesson 54 — Formatting and Replacing Data Using Functions
Lesson 55 — Working with Subtotals
End-of-Chapter Activities
Chapter 7
Creating Charts, Shapes, and Templates
Lesson 56 — Formatting Chart Elements
Lesson 57 — Format ting the Value Axis
Lesson 58 — Creating Stacked Area Charts
Lesson 59 — Working with Sparklines and Trendlines
Lesson 60 — Drawing and Positioning Shapes
Lesson 61 — Formatting Shapes
Lesson 62 — Enhancing Shapes with Text and Effects
Lesson 63 — Working with Templates
End-of-Chapter Activities
Chapter 8
Creating Macros and Using Data Analysis Tools
Lesson 64 — Recording a Macro
Lesson 65 — Using Functions
Lesson 66 — Working with Absolute References and Using Financial Functions
Lesson 67 — Creating and Interpreting Financial Statements
Lesson 68 — Creating Scenarios and Naming Ranges
Lesson 69 — Finding and Fixing Errors in Formulas
End-of-Chapter Activities
Chapter 9
Importing and Analyzing Database Data
Lesson 70 — Importing Data into Excel
Lesson 71 — Working with Excel Tables
Lesson 72 — Using Advanced Filters, Slicers, and Database Functions
Lesson 73 — Using Flash Fill and Data Consolidation
Lesson 74 — Linking Workbooks
Lesson 75 — Using PivotTables
Lesson 76 — Using PivotCharts
Lesson 77 — Using PowerPivot and Power View
End-of-Chapter Activities
Chapter 10
Collaborating with Others and Preparing a Final Workbook for Distribution
Lesson 78 — Tracking Changes
Lesson 79 — Ensuring Data Integrity
Lesson 80 — Protecting Data
Lesson 81 — Securing a Workbook
Lesson 82 — Finalizing a Workbook
Lesson 83 — Sharing a Workbook
End-of-Chapter Activities
| Erscheint lt. Verlag | 18.10.2013 |
|---|---|
| Sprache | englisch |
| Maße | 10 x 10 mm |
| Gewicht | 1524 g |
| Themenwelt | Informatik ► Office Programme ► Excel |
| ISBN-10 | 0-13-314910-2 / 0133149102 |
| ISBN-13 | 978-0-13-314910-4 / 9780133149104 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
