Добро пожаловать на сайт электронной библиотеки!
Здесь можно найти произведения русских и зарубежных авторов.
Скачать множество книг и журналов различных жанров и направлений.
Большой выбор художественной, бизнес, учебной и технической литературы.
Все представленные здесь книги и журналы имеют подробное описание и обложку.
Наша библиотека регулярно пополняется только новыми и интересными материалами!

«Подробнее о сайте»            «Правила сайта»            «Написать нам»            «Статьи» Excel 2010 Advanced Formulas and Functions ( link fix)


Разместил: gorodoksmol

30-08-2012, 19:01

Просмотров: 798 Excel 2010 Advanced Formulas and Functions ( link fix)

В Excel 2010 Advanced Формулы и функции, автор Деннис Тейлор демистифицирует некоторые из самых сложных формул и около 400 функций в Excel и показывает, как применить их в лучшем использовании.



Using the exercise files

1. Formula and Function Tips and Shortcuts
Using the entire row/column references
Copying column formulas instantly
Converting formulas to values with a simple drag
Creating 3D formulas to gather data from multiple sheets
Updating values without formulas
Displaying and highlighting formulas
Simplifying debugging formulas
Enhancing readability with range names

2. Formula and Function Tools
Reviewing function basics
Using and extending AutoSum
Using absolute and relative references
Using mixed references

3. IF and Related Functions
Exploring IF logical tests and using relational operators
Creating and expanding the use of nested IF statements
Using the AND, OR, and NOT functions with IF to create compound logical tests
4. Lookup and Reference Functions
Looking up information with VLOOKUP and HLOOKUP
Finding approximate matches with VLOOKUP
Finding exact matches with VLOOKUP
Nesting LOOKUP functions
Finding table-like information within a function with CHOOSE
Locating data with MATCH
Retrieving information by location with INDEX
Using MATCH and INDEX together

5. Power Functions
Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF
Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS

6. Statistical Functions
Finding the middle value with MEDIAN
Ranking data without sorting with RANK
Finding the magnitude data with LARGE and SMALL
Tabulating blank cells with COUNTBLANK

7. Data Functions
Understanding Excel date/time capabilities in formulas
Identifying the day of the week with WEEKDAY
Counting working days with NETWORKDAYS
Determining a completion date with WORKDAY
Tabulating date/time differences with DATEDIF

8. Math Functions
Working with rounding functions
Finding the remainder with MOD and using MOD with conditional formatting
Building random number generators with RAND and RANDBETWEEN
Converting a value between measurement systems with CONVERT
Using the powerful new AGGREGATE function to bypass errors and hidden data

9. Array Formulas and Functions
Extending formula capabilities with arrays
Counting unique entries in a range with an array formula
Determining frequency distributions with FREQUENCY
Flipping row/column orientation with TRANSPOSE
Building analysis via regression techniques with TREND and GROWTH
Combining multiple functions in arrays

10. Text Functions
Locating and extracting data with FIND and MID
Extracting specific data with LEFT and RIGHT
Removing excess spaces with TRIM
Using CONCATENATE with functions
Adjusting case within cells with PROPER, UPPER, and LOWER
Adjusting character content with REPLACE and SUBSTITUTE
Reviewing additional text functions

11. Financial Functions
Calculating payments with PMT
Finding future values with FV
Determining total amount of future payments with PV

12. Information Functions
Working with the IS information functions
Using error-checking functions: ISERR, ISERROR, IFERROR

13. Reference Functions
Getting data from remote cells with OFFSET
Returning references with INDIRECT


Final thoughts

Год: 2012
Язык: английский
Формат: h264 | 960x540 | 15fps | 16:9 | Mp3 95kbps 48000hz
Размер: 1.28 Gb

Скачать Excel 2010 Advanced Formulas and Functions ( link fix)

Похожие публикации

Large Scale and Big Data: Processing and Management Large Scale and Big Data: Processing and Management
Large Scale and Big data: Processing and Management provides readers with a central source of reference on the data management techniques currently available for large-scale data processing. Presenting chapters written by leading researchers,

Microsoft Business Intelligence Tools for Excel Analysts Microsoft Business Intelligence Tools for Excel Analysts
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and

Access 2010 All-in-One For Dummies Access 2010 All-in-One For Dummies
What kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables,

Greg Harvey - Excel 2013 All-in-One For Dummies Greg Harvey - Excel 2013 All-in-One For Dummies
As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide

1300 Math Formulas 1300 Math Formulas
This handbook is a complete desktop reference for students and engineers. It has everything from high school math to math for advanced undergraduates in engineering, economics, physical sciences, and mathematics.

The Transform and Data Compression Handbook The Transform and Data Compression Handbook
Data compression is one of the main contributing factors in the explosive growth in information technology.

Advanced Excel for Scientific Data Analysis Advanced Excel for Scientific Data Analysis
Excel is by far the most widely distributed data analysis software but few users are aware of its full powers. Advanced Excel For Scientific Data Analysis takes off from where most books dealing with scientific applications of excel end. It focuses

Excel Dashboards and Reports Excel Dashboards and Reports
The go to resource for how to use Excel dashboards and reports to better conceptualize data Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report.” What they don’t offer is

Real World Instrumentation with Python: Automated Data Acquisition and Control Systems Real World Instrumentation with Python: Automated Data Acquisition and Control Systems
Learn how to develop your own applications to monitor or control instrumentation hardware. Whether you need to acquire data from a device or automate its functions, this practical book shows you how to use Python's rapid development capabilities to

Jaffar S., Meyer Y.-Wavelets Tools for Science & Technology Jaffar S., Meyer Y.-Wavelets Tools for Science & Technology
Автор: Jaffar S., Meyer Y. Описание: This long-awaited update of Meyer's Wavelets: Algorithms and Applications includes completely new chapters on four topics: wavelets and the study of turbulence, wavelets and fractals (which includes an analysis

Отзывы и Комментарии

Добавление комментария

Ваше Имя:
Ваш E-Mail:(необязательно)
  • bowtiesmilelaughingblushsmileyrelaxedsmirk