Автор: Paul McFedries
Издательство: Que
Год издания: 2010
isbn: 978-0-7897-4306-0
Количество страниц: 512
Язык: english
Формат: PDF
Excel expert Paul McFedries shows how to use Excel 2010’s core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.
Автор: Л. В. Рудикова
Издательство: БХВ-Петербург
Год издания: 2007
isbn: 978-5-94157-480-3, 5-94157-480-0
Количество страниц: 368
Язык: русский
Формат: PDF
Рассматриваются математические задачи (работа с массивами, задачи оптимизации, численное решение задачи Коши для обыкновенного дифференциального уравнения первого порядка и др.), экономические задачи (нахождение платы по процентам, расчет регулярных выплат по займу, оценка эффективности капиталовложений и др.), задачи построения различных графиков и поверхностей, задачи обработки однотипных данных (списков). В книге более 60-ти разобранных примеров и свыше 250-ти задач для самостоятельного решения, даны пошаговые инструкции по профессиональному оформлению рабочего листа, что позволяет использовать книгу не только как учебное пособие, но и как практическое руководство для автоматизации многих прикладных задач пользователей. Материал, представленный в книге, ориентирован на MS Excel 2002, но полностью применим и для MS Excel 2003, MS Excel 2000, MS Excel 97. Для широкого круга пользователей.
Автор: Джон Уокенбах
Издательство: Вильямс
Год издания: 2003
isbn: 5-8459-0474-9
Количество страниц: 448
Язык: русский
Формат: PDF
В настоящее время эта книга - единственное всеобъемлющее руководство по созданию диаграмм графическими средствами Excel. В книге подробно рассмотрены типы диаграмм, способы их создания, форматирования и настройки, устранение неполадок в диаграммах, интерактивные диаграммы, добавление линий тренда, сглаживание и прогнозирование зависимостей, анимация и автоматизация диаграмм средствами Visual Basic и другие вопросы. Рассматриваемые темы иллюстрируются многочисленными примерами диаграмм. Книга будет полезна как для начинающих, так и для опытных пользователей Excel. Для ее понимания требуется знание элементарных основ работы в Excel.
Автор: John Walkenbach
Издательство: Wiley Publishing
Год издания: 2010
isbn: 978-0-470-47487-7
Количество страниц: 1058
Язык: english
Формат: PDF
An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else. - Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel - Delivers essential coverage of all the newest features of Excel 2010 - Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Excel 2010 Bible serves as an excellent resource on all things Excel!
Автор: Colin Banfield, John Walkenbach
Издательство: Wiley Publishing
Год издания: 2010
isbn: 978-0-470-52755-9
Количество страниц: 240
Язык: english
Формат: PDF
Find the answers to your most important Excel questions with this reference John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference. You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily. Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions Offers information in a highly organized, easy-to-understand format so you can find exactly what you need Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!
Автор: Paul McFedries
Издательство: Visual
Год издания: 2010
isbn: 978-0-470-57763-9
Количество страниц: 256
Язык: english
Формат: PDF
Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away. With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier than ever before. Excel is the world's leading spreadsheet and data analysis tool; Excel 2010 includes numerous new features, a redesigned interface, a new focus on collaboration and application servers, and much more Its complexity makes Excel a perfect subject for the step-by-step visual instruction in this guide Numbered steps illustrated with full-color screen shots teach dozens of Excel 2010 tasks Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more A quick and easy way to get up to speed on Excel 2010 for both novice users and those upgrading from an earlier version Excel 2010 Simplified tames this complicated application and gives you the skills to start using Excel with confidence.
Автор: Bill Dalton
Издательство: Cambridge University Press
Год издания: 2008
isbn: 978-0521682220
Количество страниц: 408
Язык: english
Формат: PDF
Financial Products provides a step-by-step guide to some of the most important ideas in financial mathematics. It describes and explains interest rates, discounting, arbitrage, risk neutral probabilities, forward contracts, futures, bonds, FRA and swaps. It shows how to construct both elementary and complex (Libor) zero curves. Options are described, illustrated and then priced using the Black Scholes formula and binomial trees. Finally, there is a chapter describing default probabilities, credit ratings and credit derivatives (CDS, TRS, CSO and CDO). An important feature of the book is that it explains this range of concepts and techniques in a way that can be understood by those with only a basic understanding of algebra. Many of the calculations are illustrated using Excel spreadsheets, as are some of the more complex algebraic processes. This accessible approach makes it an ideal introduction to financial products for undergraduates and those studying for professional financial qualifications.
Автор: Robert de Levie
Издательство: Oxford University Press
Год издания: 2004
isbn: 019517089X
Количество страниц: 638
Язык: english
Формат: PDF
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 on three areas-least squares, Fourier transformation, and digital simulation-and illustrates these with extensive examples, often taken from the literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. These macros and functions are provided in uncompiled, computer-readable, easily modifiable form; readers can therefore use them as starting points for making their own personalized data analysis tools. Detailed descriptions and sample applications of standard and specialized uses of least squares for fitting data to a variety of functions, including resolving multi-component spectra; standard processes such as calibration curves and extrapolation; custom macros for general "error" propagation, standard deviations of Solver results, weighted or equidistant least squares, Gram-Schmidt orthogonalization, Fourier transformation, convolution and deconvolution, time-frequency analysis, and data mapping. There are also worked examples showing how to use centering, the covariance matrix, imprecision contours, and Wiener filtering and custom functions for bisections, Lagrange interpolation, Euler and Runge-Kutta integration.
Автор: Kim Heldman, William Heldman
Издательство: Sybex
Год издания: 2007
isbn: 0470047178
Количество страниц: 363
Язык: english
Формат: PDF (scan)
We have written this book for those of you who have some experience in project management and are looking for a quick and efficient way to manage your projects. When combined, Excel 2007 and Microsoft Office SharePoint Server (MOSS)—two components of the Office 2007 initiative that Microsoft has developed—are great for managing all phases of a project, creating templates, collaborating on planning processes, tracking project progress, and sharing information with all interested parties. The project management field has grown exponentially over the last decade. Run a query on your favorite job-hunting site and you’ll see that project management experience is a requirement (or at a minimum, a desired skill set) for tens of thousands of job postings. In addition, many of you have upwards of half a dozen to a dozen independent projects running at the same time. This book will show you how to organize the management of those projects using templates we’ve built for Excel 2007 and how to take advantage of the power of SharePoint to communicate and share that information with team members and stakeholders. If you find that this topic interests you and project management seems like a career worth pursuing, we strongly recommend that you consider obtaining your Project Management Professional (PMP) certification through the Project Management Institute (PMI). PMI is the de facto standard in project management methodologies. You will find that many organizations now require a PMP certification for positions related to project management.
Автор: Г. З. Гарбер
Издательство: Солон-Пресс
Год издания: 2008
isbn: 978-5-91359-003-9
Количество страниц: 192
Язык: русский
Формат: DJVU
Рассматриваются основные элементы среды разработки программ, а также базовые конструкции алгоритмических языков Visual Basic и VBA (Visual Basic для приложений). В качестве пользовательского интерфейса программы (макроса) используются стандартные окна Windows, текстовые файлы, формы, таблица Excel. Рассматривается также вопрос разработки пользовательских функций Excel. Продемонстрированы приемы работы с отладчиком программ, справочными системами, макрорекордером и личной книгой макросов. Опыт программирования не является обязательным. Книга ориентирована на преподавателей информатики, студентов вузов и колледжей, а также на широкий круг читателей, имеющих желание научиться программировать в табличном процессоре Excel 2007 и тем самым существенно расширить круг решаемых задач.