|
Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors. Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel's functionality to craft effective financial models and provide important information that informs good decision-making. Learn financial modelling techniques and best practice Master the formulas and functions that bring your model to life Apply stress testing and sensitivity analysis with advanced conditionals Present your results effectively, whether graphically, orally, or written A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice. Получить ссылку |
Использование MS Excel и VBA в экономике и финансах
Автор: Гарнаев А. Ю.
Год издания:
В этом учебном пособии рассмотрено использование Excel и языка Visual Basic for Applications для решения широкого круга задач: от составления простого финансового отчета до создания сценариев серьезных экономических проектов. Приведено большое количество примеров описания современного инструментария принятия оптимальных решений в экономике.
Это учебное пособие имеет выраженную учебную направленность, поэтому будет полезно не только экономистам, специалистам по менеджменту, финансам и коммерции, но и преподавателям, студентам экономических специальностей, предназначено для читателей, интересующихся применением вычислительной техники в менеджменте и экономике, а также для широкого круга пользователей.
Testing SAP R/3
A Manager’s Step-by-Step Guide
Автор: JOSE FAJARDO, ELFRIEDE DUSTIN
Год издания:
Planning, preparing, scheduling, and executing SAP test cycles is a
time-consuming and resource-intensive endeavor that requires participation
from several project members. SAP projects are prone to
have informal, ad-hoc test approaches that decrease the stability of
the production environment and tend to increase the cost of ownership
for the SAP system. Many SAP project and test managers cannot
provide answers for questions such as how many requirements have
testing coverage, the exit criteria for a test phase, the audit trails for
test results, the dependencies and correct sequence for executing test
cases, or the cost figures for a previously executed test cycle. Fortunately,
through established testing techniques predicated on guidelines
and methodologies (i.e., ASAP SAP Roadmap methodology,
IBM’s Ascendant methodology, and Deloitte’s ThreadManager
methodology), enforcement of standards, application of objective
testing criteria, test case automation, implementation of a requirements
traceability matrix (RTM), and independent testing and formation
of centralized test teams, many of the testing risks that plague
existing or initial SAP programs can be significantly reduced.
This book is written for SAP managers, SAP consultants, SAP
testers, and team leaders who are tasked with supporting, managing,
implementing, and monitoring testing activities related to test planning,
test design, test automation, test tool management, execution of
test cases, reporting of test results, test outsourcing, planning a budget
for testing activities, enforcing testing standards, and resolving
defects.
Microsoft Office Excel 2003. Учебный курс
Автор: В. Кузьмин
Год издания:
В книге описана новая версия популярной программы обработки электронных таблиц — Excel 2003. Прочитав ее, вы научитесь создавать, редактировать и выводить таблицы на печать, выполнять сложные расчеты и анализ данных. Формулы и функции, автоматическое создание итогов, консолидация данных, функция поиска решения и, конечно же, сводные таблицы и диаграммы — весь этот богатый арсенал средств программы Excel подробно рассмотрен автором. Большое внимание уделено вопросам, связанным с обменом данными и коллективной работой. Вы узнаете, как извлечь данные из внешнего источника, отправить таблицу по электронной почте, сохранить документ в формате Веб, защитить его от несанкционированного доступа.
Oracle Database 10g: A Beginner's Guide
Автор:
Год издания:
Two new Oracle instruction and resource titles from Osborne/McGraw-Hill are indispensable additions to personal and professional reference collections. Oracle Database 10g: A Beginner's Guide is the collective effort of Oracle experts Ian Abramson, Michael Abbey and Michael Corey. Oracle Database 10g provides neophytes with the fundamental concepts of Oracle Database 10g administration and programming. Through self-paced tutorials, readers will learn about database essentials, the role of the administrator, and large database features. Oracle Database 10g includes an in-depth introduction to SQL, PL/SQL, Java, and XML programming.
Display Interfaces. Fundamentals and Standards
Автор: Myers Bob, Myers Robert L.
Год издания:
Дисплейные интерфейсы. Основы и стандарты. Название говорит само за себя. Чтобы правильно понять эту книгу, знание английского - ОБЯЗАТЕЛЬНО.
Чтобы скачать книгу, отключите блокировку рекламы. Спасибо!