Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Koszyk
Książki \ Aplikacje \ Kolory

Microsoft Excel 2010 Plain &Simple Język: 2

9780735627277

Cena Brutto: 100.80

Cena netto: 96.00

Ilość:
Wersja: Drukowana
Autor Curtis D. Frye
Liczba_stron 320
Wydawnictwo Microsoft Press
Data_Wydania 2010-06-14
Poziom All Levels

Informacje podstawowe:

  • Wydawnictwo: Microsoft Press
  • Data wydania: 14 czerwca 2010
  • Liczba stron: 320
  • Autor/autorzy:
    • Curtis D. Frye

Opis:

Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.

Here's WHAT you'll learn:

  • Manage your financial data and personal expenses
  • Get started quickly with prebuilt templates
  • Create formulas and functions to do the hard work
  • Sort, filter, update, and copy your data
  • Use charts and graphics to bring data to life
  • Collaborate with colleagues by sharing spreadsheets online

Here's HOW you'll learn it:

  • Jump in whenever you need answers
  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
  • Handy TIPS teach new techniques and shortcuts
  • Quick TRY THIS! exercises help apply what you learn right away

O autorze/autorach:

Curtis D. Frye

Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.

View Curtis D. Frye's full profile page.

Zawartość (spis treści):

  1. Chapter 1 Introduction: About This Book

    1. No Computerese!
    2. Useful Tasks…
    3. …And the Easiest Way to Do Them
    4. A Quick Overview
    5. A Few Assumptions
    6. A Final Word (or Two)
  2. Chapter 2 What's New and Improved in Excel 2010

    1. Managing Excel Files and Settings in Backstage View
    2. Previewing Data Using Paste Preview
    3. Customizing the Excel 2010 User Interface
    4. Summarizing Data Using More Accurate Functions
    5. Summarizing Data Using Sparklines
    6. Visualizing Data Using Improved Conditional Formats
    7. Creating and Displaying Math Equations
    8. Editing Pictures Within Excel 2010
  3. Chapter 3 Getting Started with Excel 2010

    1. Surveying the Excel Program Window
    2. Starting Excel
    3. Finding and Opening Existing Workbooks
    4. Using File Properties
    5. Creating a New Workbook
    6. Working with Multiple Workbooks
    7. Sizing and Viewing Windows
    8. Zooming In or Out on a Worksheet
    9. Viewing a Worksheet in Full-Screen Mode
    10. Saving and Closing an Excel Workbook
    11. Using the Excel Help System
  4. Chapter 4 Building a Workbook

    1. Understanding How Excel Interprets Data Entry
    2. Navigating the Worksheet
    3. Selecting Cells
    4. Entering Text in Cells
    5. Entering Numbers in Cells
    6. Entering Dates and Times in Cells
    7. Entering Data Using Fills
    8. Entering Data with Other Shortcuts
    9. Creating an Excel Table
    10. Editing Cell Contents
    11. Inserting a Symbol in a Cell
    12. Creating Hyperlinks
    13. Cutting, Copying, and Pasting Cell Values
    14. Clearing Cell Contents
    15. Using the Office Clipboard
    16. Undoing or Redoing an Action
    17. Finding and Replacing Text
    18. Checking the Spelling of Your Worksheet
  5. Chapter 5 Managing and Viewing Worksheets

    1. Viewing and Selecting Worksheets
    2. Renaming Worksheets
    3. Moving Worksheets
    4. Copying Worksheets
    5. Inserting and Deleting Worksheets
    6. Hiding or Showing a Worksheet
    7. Changing Worksheet Tab Colors
    8. Inserting, Moving, and Deleting Cells
    9. Inserting, Moving, and Deleting Columns and Rows
    10. Hiding and Unhiding Columns and Rows
    11. Entering Data and Formatting Many Worksheets at the Same Time
    12. Changing How You Look at Excel Workbooks
    13. Naming and Using Worksheet Views
  6. Chapter 6 Using Formulas and Functions

    1. Understanding Formulas and Cell References in Excel
    2. Creating Simple Cell Formulas
    3. Assigning Names to Groups of Cells
    4. Using Names in Formulas
    5. Creating a Formula That References Values in an Excel Table
    6. Creating Formulas That Reference Cells in Other Workbooks
    7. Summing a Group of Cells Without Using a Formula
    8. Creating a Summary Formula
    9. Summing with Subtotals and Grand Totals
    10. Exploring the Excel Function Library
    11. Using the IF Function
    12. Checking Formula References
    13. Debugging Your Formulas
  7. Chapter 7 Formatting the Cell

    1. Formatting Cell Contents
    2. Formatting Cells Containing Numbers
    3. Formatting Cells Containing Dates
    4. Adding Cell Backgrounds and Shading
    5. Formatting Cell Borders
    6. Defining Cell Styles
    7. Aligning and Orienting Cell Contents
    8. Formatting a Cell Based on Conditions
    9. Changing How Conditional Formatting Rules Are Applied
    10. Stop When a Condition Is Met
    11. Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values
    12. Deleting Conditional Formats
    13. Copying Formats with Format Painter
    14. Merging or Splitting Cells or Data
  8. Chapter 8 Formatting the Worksheet

    1. Applying Workbook Themes
    2. Coloring Sheet Tabs
    3. Changing a Worksheet's Gridlines
    4. Changing Row Heights and Column Widths
    5. Inserting Rows or Columns
    6. Moving Rows and Columns
    7. Deleting Rows and Columns
    8. Outlining to Hide and Show Rows and Columns
    9. Hiding Rows and Columns
    10. Protecting Worksheets from Changes
    11. Locking Cells to Prevent Changes
  9. Chapter 9 Printing Worksheets

    1. Previewing Worksheets Before Printing
    2. Printing Worksheets with Current Options
    3. Choosing Whether to Print Gridlines and Headings
    4. Choosing Printers and Paper Options
    5. Printing Part of a Worksheet
    6. Printing Row and Column Headings on Each Page
    7. Setting and Changing Print Margins
    8. Setting Page Orientation and Scale
    9. Creating Headers and Footers
    10. Adding Graphics to a Header or a Footer
    11. Setting and Viewing Page Breaks
  10. Chapter 10 Customizing Excel to the Way You Work

    1. Opening Ready-to-Use Workbook Templates
    2. Adding Commands to the Quick Access Toolbar
    3. Modifying the Ribbon User Interface
    4. Controlling Which Error Messages Appear
    5. Defining AutoCorrect and AutoFormat Entries
  11. Chapter 11 Sorting and Filtering Worksheet Data

    1. Sorting Worksheet Data
    2. Creating a Custom Sort List
    3. Filtering Data Quickly with AutoFilter
    4. Creating an Advanced Filter
    5. Validating Data for Correctness During Entry
  12. Chapter 12 Summarizing Data Visually Using Charts

    1. Displaying Data Graphically
    2. Creating a Chart Quickly
    3. Changing a Chart's Appearance
    4. Formatting Chart Legends and Titles
    5. Changing the Body of a Chart
    6. Customizing Chart Data
    7. Working with Common Charts
    8. Working with Uncommon Charts
    9. Adding a Trendline to a Chart
    10. Summarizing Data Using Sparklines
  13. Chapter 13 Enhancing Your Worksheets with Graphics

    1. Working with Graphics in Your Worksheets
    2. Adding Graphics to Worksheets
    3. Adding Drawing Objects to a Worksheet
    4. Adding Fills to Drawing Objects
    5. Adding Effects to Drawing Objects
    6. Customizing Pictures and Objects
    7. Aligning and Grouping Drawing Objects
    8. Using WordArt to Create Text Effects in Excel
    9. Inserting Clip Art into a Worksheet
    10. Inserting and Changing a Diagram
    11. Creating an Organization Chart
    12. Adding an Equation to a Shape
  14. Chapter 14 Sharing Excel Data with Other Programs

    1. Introducing Linking and Embedding
    2. Linking and Embedding Other Files
    3. Exchanging Table Data Between Excel and Word
    4. Copying Excel Charts and Data into PowerPoint
    5. Exchanging Data Between Access and Excel
    6. Importing a Text File
  15. Chapter 15 Using Excel in a Group Environment

    1. Sharing Workbooks in Excel
    2. Commenting in Cells
    3. Tracking Changes in Workbooks
    4. Accepting or Rejecting Changes
    5. Saving Worksheets to the Web
    6. Dynamically Update Worksheets Published to the Web
    7. Retrieving Web Data Using Excel
    8. Modifying Web Queries
    9. Introducing XML
    10. Interacting over the Web Using XML
powrót
 
Produkty Podobne
Microsoft Office for iPad Step by Step
ABC Word 2013 PL
Informatyka Europejczyka. Podręcznik do zajęć komputerowych dla szkoły podstawowej, kl. 5. Edycja: Windows XP, Linux Ubuntu, MS Office 2003, OpenOffice.org (Wydanie II)
Analiza statystyczna. Microsoft Excel 2010 PL
Tablice informatyczne. VBA dla Excela
Informatyka Europejczyka. Zeszyt ćwiczeń do zajęć komputerowych dla szkoły podstawowej, kl. 4. Edycja: Windows XP, Linux Ubuntu, MS Office 2003, OpenOffice.org (Wydanie II)
Informatyka Europejczyka. Podręcznik do zajęć komputerowych dla szkoły podstawowej, kl. 4. Edycja: Windows XP, Linux Ubuntu, MS Office 2003, OpenOffice.org (Wydanie II)
Informatyka Europejczyka. Zeszyt ćwiczeń do zajęć komputerowych dla szkoły podstawowej, kl. 4. Edycja: Windows 7, Windows Vista, Linux Ubuntu, MS Office 2007, OpenOffice.org (Wydanie II)
Working with Microsoft Office 365: Running Your Small Business in the Cloud
Elektronika z Excelem
Więcej produktów