Жанры
Авторы
Контакты
О сайте
Книжные новинки
Популярные книги
Найти
Главная
Авторы
Paul McFedries
Excel Data Analysis For Dummies
Читать книгу Excel Data Analysis For Dummies - Paul McFedries - Страница 1
Оглавление
Предыдущая
Следующая
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
53
Оглавление
Купить и скачать книгу
Вернуться на страницу книги Excel Data Analysis For Dummies
Оглавление
Страница 1
Страница 2
Excel® Data Analysis For Dummies® To view this book's Cheat Sheet, simply go to
www.dummies.com
and search for “Excel Data Analysis For Dummies Cheat Sheet” in the Search box. Table of Contents
List of Tables
List of Illustrations
Guide
Pages
Страница 8
Страница 9
Страница 10
Learning Basic Data-Analysis Techniques
What Is Data Analysis, Anyway?
Cooking raw data
Dealing with data
Building data models
Performing what-if analysis
Analyzing Data with Conditional Formatting
Highlighting cells that meet some criteria
Showing pesky duplicate values
Highlighting the top or bottom values in a range
Analyzing cell values with data bars
Analyzing cell values with color scales
Analyzing cell values with icon sets
Creating a custom conditional-formatting rule
HIGHLIGHT CELLS BASED ON A FORMULA
Editing a conditional-formatting rule
Removing conditional-formatting rules
Summarizing Data with Subtotals
Grouping Related Data
Consolidating Data from Multiple Worksheets
Consolidating by position
Consolidating by category
Страница 33
Working with Data-Analysis Tools
Working with Data Tables
Creating a basic data table
Creating a two-input data table
Skipping data tables when calculating workbooks
Analyzing Data with Goal Seek
Analyzing Data with Scenarios
Create a scenario
Apply a scenario
Edit a scenario
Delete a scenario
Optimizing Data with Solver
Understanding Solver
The advantages of Solver
When should you use Solver?
Loading the Solver add-in
Optimizing a result with Solver
Adding constraints to Solver
Save a Solver solution as a scenario
{buyButton}
Подняться наверх
