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

Analyzing Business Data with Excel Język: 2

9780596100735

Cena Brutto: 143.33

Cena netto: 136.50

Ilość:
Wersja: Drukowana
Autor Gerald Knight
Liczba_stron 264
Wydawnictwo OReilly Media
Data_Wydania 2006-01-03
Poziom All Levels

Informacje podstawowe:

  • Wydawnictwo: O'Reilly Media
  • Data wydania: 3 stycznia 2006
  • Liczba stron: 264
  • Autor/autorzy:
    • Gerald Knight

Opis:

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues.

Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following:

  • Statistics
  • Pivot tables
  • Workload forecasting
  • Modeling
  • Measuring quality
  • Monitoring complex systems
  • Queuing
  • Optimizing
  • Importing data

If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.

O autorze/autorach:

Gerald Knight

Gerald Knight has nearly 30 years experience in the computer industry as a developer, teacher, and consultant. During an over twenty-year career at FedEx, he was a project leader and system architect working on imaging and revenue control systems. He has specialized in Excel development for the last ten years. Now retired, he consults and occasionally writes in Memphis, Tennessee.

View Gerald Knight's full profile page.

Zawartość (spis treści):

  1. Chapter 1 Excel and Statistics

    1. Array Formulas
    2. Addressing Cells Indirectly
    3. Statistical Functions
  2. Chapter 2 Pivot Tables and Problem Solving

    1. Pivot Table Basics
    2. Changing the Data
    3. Pivot Table Options
  3. Chapter 3 Workload Forecasting

    1. The Procedure
    2. Building an Application
  4. Chapter 4 Modeling

    1. Regression
    2. Defining the Problem
    3. Refining Metrics
    4. Analysis
    5. Building the Model
    6. Analyzing the Results
    7. Testing Non-Linear Relationships
  5. Chapter 5 Measuring Quality

    1. Statistical Process Control
    2. Running the Application
    3. Application Design
    4. Customizing the Application
  6. Chapter 6 Monitoring Complex Systems

    1. The Application
    2. The Data
    3. Settings
    4. Workarea
    5. Macros
  7. Chapter 7 Queuing

    1. The Data
    2. The Application
    3. The Logic
  8. Chapter 8 Custom Queuing Presentation

    1. The Application
    2. The Data
    3. The Logic
    4. VBA
    5. Extending the Application
  9. Chapter 9 Optimizing

    1. Goal Seek
    2. The Solver
  10. Chapter 10 Importing Data

    1. Text Files
    2. Databases
    3. XML
  11. Chapter 11 The Trouble with Data

    1. Numbers
    2. Dates
    3. Reports
    4. Equivalence
  12. Chapter 12 Effective Display Techniques

    1. Respect the Information and the Audience
    2. Large Worksheets
    3. Charts
    4. Pictures and Other Objects
    5. Complexity
    6. Repeated Elements
    7. Information Density
    8. Emphasis and Focus
  1. Colophon

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