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 Step by Step Język: 2

9780735626942

Cena Brutto: 121.80

Cena netto: 116.00

Ilość:
Wersja: Drukowana
Autor Curtis D. Frye
Liczba_stron 480
Wydawnictwo Microsoft Press
Data_Wydania 2010-06-10
Poziom Dla początkujących

Informacje podstawowe:

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

Opis:

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

O autorze/autorach:

Curtis D. Frye

Curtis D. Frye is the author of several books on Microsoft® Access® and Excel®, including Microsoft® Office Excel® 2007 Step by Step and Microsoft® Office Excel® 2003 Step by Step, along with numerous online training courses.

View Curtis D. Frye's full profile page.

Zawartość (spis treści):

  1. Chapter 1 Setting Up a Workbook

    1. Creating Workbooks
    2. Modifying Workbooks
    3. Modifying Worksheets
    4. Customizing the Excel 2010 Program Window
    5. Key Points
  2. Chapter 2 Working with Data and Excel Tables

    1. Entering and Revising Data
    2. Moving Data Within a Workbook
    3. Finding and Replacing Data
    4. Correcting and Expanding Upon Worksheet Data
    5. Defining Excel Tables
    6. Key Points
  3. Chapter 3 Performing Calculations on Data

    1. Naming Groups of Data
    2. Creating Formulas to Calculate Values
    3. Summarizing Data That Meets Specific Conditions
    4. Finding and Correcting Errors in Calculations
    5. Key Points
  4. Chapter 4 Changing Workbook Appearance

    1. Formatting Cells
    2. Defining Styles
    3. Applying Workbook Themes and Excel Table Styles
    4. Making Numbers Easier to Read
    5. Changing the Appearance of Data Based on Its Value
    6. Adding Images to Worksheets
    7. Key Points
  5. Chapter 5 Focusing on Specific Data by Using Filters

    1. Limiting Data That Appears on Your Screen
    2. Manipulating Worksheet Data
    3. Defining Valid Sets of Values for Ranges of Cells
    4. Key Points
  6. Chapter 6 Reordering and Summarizing Data

    1. Sorting Worksheet Data
    2. Organizing Data into Levels
    3. Looking Up Information in a Worksheet
    4. Key Points
  7. Chapter 7 Combining Data from Multiple Sources

    1. Using Workbooks as Templates for Other Workbooks
    2. Linking to Data in Other Worksheets and Workbooks
    3. Consolidating Multiple Sets of Data into a Single Workbook
    4. Grouping Multiple Sets of Data
    5. Key Points
  8. Chapter 8 Analyzing Alternative Data Sets

    1. Defining an Alternative Data Set
    2. Defining Multiple Alternative Data Sets
    3. Varying Your Data to Get a Desired Result by Using Goal Seek
    4. Finding Optimal Solutions by Using Solver
    5. Analyzing Data by Using Descriptive Statistics
    6. Key Points
  9. Chapter 9 Creating Dynamic Worksheets by Using PivotTables

    1. Analyzing Data Dynamically by Using PivotTables
    2. Filtering, Showing, and Hiding PivotTable Data
    3. Editing PivotTables
    4. Formatting PivotTables
    5. Creating PivotTables from External Data
    6. Key Points
  10. Chapter 10 Creating Charts and Graphics

    1. Creating Charts
    2. Customizing the Appearance of Charts
    3. Finding Trends in Your Data
    4. Summarizing Your Data by Using Sparklines
    5. Creating Dynamic Charts by Using PivotCharts
    6. Creating Diagrams by Using SmartArt
    7. Creating Shapes and Mathematical Equations
    8. Key Points
  11. Chapter 11 Printing

    1. Adding Headers and Footers to Printed Pages
    2. Preparing Worksheets for Printing
    3. Printing Worksheets
    4. Printing Parts of Worksheets
    5. Printing Charts
    6. Key Points
  12. Chapter 12 Automating Repetitive Tasks by Using Macros

    1. Enabling and Examining Macros
    2. Creating and Modifying Macros
    3. Running Macros When a Button Is Clicked
    4. Running Macros When a Workbook Is Opened
    5. Key Points
  13. Chapter 13 Working with Other Microsoft Office Programs

    1. Including Office Documents in Workbooks
    2. Storing Workbooks as Parts of Other Office Documents
    3. Creating Hyperlinks
    4. Pasting Charts into Other Documents
    5. Key Points
  14. Chapter 14 Collaborating with Colleagues

    1. Sharing Workbooks
    2. Managing Comments
    3. Tracking and Managing Colleagues’ Changes
    4. Protecting Workbooks and Worksheets
    5. Authenticating Workbooks
    6. Saving Workbooks for the Web
    7. Key Points
  1. Glossary

  2. AppendixKeyboard Shortcuts

    1. Ctrl Combination Shortcut Keys
    2. Function Keys
    3. Other Useful Shortcut Keys
  3. AppendixAbout the Author

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