""I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver."" -- David Brode of The Brode Group

A practical guide to understanding and implementing financial simulation modeling

As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. "Financial Simulation Modeling in Excel" contains the information you need to make the most informed decisions possible in your professional endeavors.

"Financial Simulation Modeling in Excel" contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner.Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in ExcelA companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progressKeith Allman is the author of other successful modeling books, including "Corporate Valuation Modeling" and "Modeling Structured Finance Cash Flows with Microsoft Excel"

Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you've yet to do extensive modeling up to this point in your professional or academic career.

To achieve the maximum control and flexibility from Microsoft® Excel often requires careful custom programming using the VBA (Visual Basic for Applications) language. Writing Excel Macros with VBA, 2nd Edition offers a solid introduction to writing VBA macros and programs, and will show you how to get more power at the programming level: focusing on programming languages, the Visual Basic Editor, handling code, and the Excel object model.

This book shows the capabilities of Microsoft Excel in teaching physical science statistics effectively. Similar to the previously published Excel 2016 for Physical Sciences Statistics, this book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical physical science problems. If understanding statistics isn't the reader's strongest suit, the reader is not mathematically inclined, or if the reader is new to computers or to Excel, this is the book to start off with. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in physical science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Physical Sciences Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. In this new edition, each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand physical science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned.

This book shows the capabilities of Microsoft Excel in teaching environmental science statistics effectively. Similar to the previously published Excel 2016 for Environmental Sciences Statistics, this book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical environmental science problems. If understanding statistics isn't the reader's strongest suit, the reader is not mathematically inclined, or if the reader is new to computers or to Excel, this is the book to start off with. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in environmental science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Environmental Sciences Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. In this new edition, each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand environmental science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned.

Do you use Excel for simple lists, but get lost when it comes to actually doing something useful with all that data, like functions? Revolutionize the way your use the information in your life! "Head First Excel" helps you move from a spreadsheet dabbler into a savvy user in just a short time. Whether you're completely new to Excel, or an experienced user looking to make the program work better for you, this book will help you incorporate Excel into every aspect of your workflow, from a scratch pad for data-based brainstorming, to exploratory analysis with PivotTables, optimizing outcomes with Goal Seek, and presenting your conclusions with sophisticated data visualizations. Organize and present information clearly in a spreadsheet. Make calculations across a number of worksheets. Change your point of view with sorting, zooming, and filtering. Manipulate numerical and data to extract and use the data you need. Leverage Excel as a grid-based layout program. Get the most out of writing the right formulas for the right functionality. Nest formulas for more complex operations. Create sophisticated data visualizations with charts and graphs. Use Goal Seek to optimize possible outcomes based on different assumptions. Create summaries from large data sets for exploratory data analysis with PivotTables. We think your time is too valuable to waste struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, "Head First Excel" uses a visually rich format designed for the way your brain works, rather than a text-heavy approach that will put you to sleep.

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel's Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets. Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources. Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world's leading analytics tool. What You Will Learn Connect to a range of external data, from databases to Azure sources Ingest data directly into your spreadsheets, or into PowerPivot data models Cleanse and prepare external data so it can be used inside Excel Refresh data quickly and easily to always have the latest information Transform data into ready-to-use structures that fit the spreadsheet format Execute M language functions for complex data transformations Who This Book Is For Excel users who want to access data from external sources-including the Microsoft Azure platform-in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs.

Newly revised for Excel 2019, this text is a step-by-step guide for students taking a first course in statistics for advertising and for advertising managers and practitioners who want to learn how to use Excel to solve practical statistics problems in the workplace, whether or not they have taken a course in statistics. Excel 2019 for Advertising Statistics explains statistical formulas and offers practical examples for how students can solve real-world advertising statistics problems. Each chapter offers a concise overview of a topic, and then demonstrates how to use Excel commands and formulas to solve specific advertising statistics problems. This book demonstrates how to use Excel 2019 in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel's drop-down formula menus (e.g., simple linear regression, multiple correlation and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific practical advertising statistics problem using Excel; the solution to each of these problems is also given in an appendix. This latest edition features a wealth of new end-of-chapter problems and an update of the chapter content throughout.

Excel at Excel with the help of this bestselling spreadsheet guide

John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.

Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013Provides essential coverage of all the newest features of Excel 2013Presents material in a clear, concise, logical format that is ideal for all levels of Excel experienceFeatures a website that includes downloadable templates and worksheets from the book

Chart your path to fantastic formulas and stellar spreadsheets with "Excel 2013 Bible"

Praise for Modeling Structured Finance Cash Flows with Microsoft(R) Excel(R)

"You can roll up your sleeves, dive into this book, and shortly thereafter, you have a full-blown honest-to- goodness working model of a transaction. This sure beats the old method of slaving at the feet of gurus for years in the hopes that they'll throw you a scrap. It almost feels as though Allman has given away a shortcut through the 'hazing' period of learning, but then I am grateful I have a resource with which to train new analysts or remind myself how some things work."
--Omar Haneef, Global Securitized Markets, Citigroup

"Allman has written a book that reveals to the reader/user a robust framework for using Excel to model structured finance transactions. Both seasoned cash flow modelers and those new to, or curious about, how structured finance transactions are analyzed can benefit from this book."
--Henry Wilson, Bond Insurance Company Analyst

"A powerful, concise, and tiered approach. It's a bedrock foundation to build on for both the art and science of structured finance modeling. An excellent platform from which to leverage your financial knowledge and personal capital."
--William Preinitz, Managing Director, Citigroup

"An essential tool for any credit officer wishing to gain a general or in-depth understanding of cash flow modeling for new or existing deals."
--Joseph B. Keener, Structured Portfolio Management, Citigroup London

Written by industry expert Keith Allman, this well-rounded resource provides detailed guidance on constructing one of today's most adaptable models--the cash flow model. Filled with in-depth insight, expert advice, and illustrative examples, Modeling Structured Finance Cash Flows with Microsoft Excel explains individual functions and formulas, while also examining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is created in the text.

By combining specific application instruction with theory, Modeling Structured Finance Cash Flows with Microsoft Excel will teach you skills that can be instantly applied to professional-level modeling.

All the methods and tools you need to successfully program with Excel

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applicationsProvides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere elseIncludes a CD with templates and worksheets from the book

This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

For beginning to intermediate courses in construction estimating in two- and four-year construction management programs. A step-by-step, hands-on introduction to commercial and residential estimating Construction Estimating with Excel, 3/e, introduces readers to the fundamental principles of estimating using drawing sets, real-world exercises, and examples. The book moves step-by-step through the estimating process, discussing the art of estimating, the quantity takeoff, how to put costs to the estimate, and how to finalize the bid. As students progress through the text they are shown how Microsoft Excel can be used to improve the estimating process. Because it introduces spreadsheets as a way of increasing estimating productivity and accuracy, the book can help both beginning and experienced estimators improve their skills. The Third Edition gives students a broader understanding of construction estimating with a new chapter discussing the role that estimating plays in different project delivery methods and in the design process and how to use data from RSMeans. To bring the book up to date, the material and equipment costs and labor rates have been updated to reflect current costs, and the discussion of Excel (including the figures) is based on Excel 2016. Additionally, content throughout the book has been updated to align to ACCE and ABET student learning outcomes. Student resources are available on the companion website www.pearsonhighered.com/careersresources/.

Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016. In this book, you will learn: How to interact with key Excel objects, such as the application object, workbook object, and range object Methods for working with ranges in detail using code Usage of Excel as a database repository How to exchange data between Excel applications How to use the Windows API to expand the capabilities of Excel A step-by-step method for producing your own custom Excel ribbon Who This Book Is For:Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.

Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and describing the latest developments in Get & Transform and DAX. The example data set has also been updated to demonstrate all that Microsoft's self-service business intelligence suite is now capable of. High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition helps in harnessing the power of Microsoft's flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience's attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Get & Transform lets you load, shape and streamline data from multiple sources. Power Pivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones. Simple techniques take raw data and convert it into information. Slicing and dicing metrics delivers interactive insight. Visually arresting output grabs and focuses attention on key indicators. What You Will Learn Produce designer output that will astound your bosses and peers. Drive business intelligence from Excel using BI in the Cloud. Gather source data from corporate and public sources. Integrate charts, maps, and tables to deliver visually stunning information. Discover new insights as you chop and tweak your data as never before. Adapt delivery to mobile devices. Outshine competing products and enhance existing skills. Who This Book Is For Any Power BI Desktop, Excel or SharePoint user. Business Intelligence developers, power users, IT managers, finance experts, and more can use this book to outshine the competition by producing high-impact business intelligence reporting on a variety of devices from a variety of sources.

Now students can master the nuances of Microsoft (R) Office quickly with ILLUSTRATED MICROSOFT (R) OFFICE 365 & EXCEL 2019 COMPREHENSIVE, part of today's popular Illustrated Series. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Microsoft Excel 2016 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2016 for OS X by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2016 in order to get work done efficiently on OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks.

CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2019 PIVOT TABLES!

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelenand Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!

• Create, customize, and change pivot tables

• Transform huge data sets into clear summary reports

• Analyze data faster with Excel 2019’s new recommended pivot tables

• Instantly highlight your most profitable customers, products, or regions

• Quickly import, clean, and shape data with Power Query vBuildgeographical pivot tables with Power Map

• Use Power View dynamic dashboards to see where your business stands

• Revamp analyses on the fly by dragging and dropping fields

• Build dynamic self-service reporting systems

• Combine multiple data sources into one pivot table

• Use Auto grouping to build date/time-based pivot tables faster vCreatedata mashups with Power Pivot

• Automate pivot tables with macros and VBA

This is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.

Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, "Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems" is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.

Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. "

Bearbeiten und verwalten Sie umfangreiche Tabellen am Computer? Dann kommen Sie um Excel nicht herum. In diesem kompakten Buch lernen Excel-Neulinge und -Umsteiger die aktuellste Version von Excel und die wesentlichen Funktionen in aller KA1/4rze kennen. Fangen Sie ganz einfach an und arbeiten Sie sich zu Diagrammen, Tabellen, Funktionen und Formeln vor. Sie finden in diesem Buch die besten Tipps und Tricks zu Excel, die Ihnen das Arbeiten sehr erleichtern werden.

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files PowerPivot for Business Intelligence Using Excel and SharePointis your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you'll encounter when using PowerPivot. Each chapter takes you through a solution technique that's been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence What you'll learn Install and verify the PowerPivot software Integrated existing, available data to deliver business intelligence Leverage Time Intelligence to report change over time Write Data Analysis Expressions (DAX) to create custom measures Identify and implement solutions for role-playing dimensions Recognize and work-around PowerPivot's missing features Who this book is for

PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone. Table of Contents Getting Started with PowerPivot for Excel Hello World, PowerPivot Style Combining Data Sources Data Analysis Expressions A Method to the Madness Installing PowerPivot for SharePoint Collaboration, Version Control, and Management PowerPivot As a Data Source PowerPivot and SQL Server Reporting Services PowerPivot and Predictive Analytics Tips, Tricks, and Traps

Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently. Microsoft is rolling out several new features with Excel 2010-perhaps the most notable is the ability to use Excel 2010 online and this collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these new features and more. What you'll learn* What distinguishes 2010 from its immediate predecessor* What distinguishes 2010 from Excel 2003* Get started with data entry and formatting* How to get started with formula writing skills* Get started with database capabilities, including pivot tables* How to get started with chartingWho this book is for This book is for those new to Excel and for those who have used Excel in the past but are new to Excel 2010.

Learn the business thinking behind financial modeling and execute what you know effectively using Microsoft Excel. Many believe that sales and profitability projections shown in financial models are the keys to success in attracting investors. The truth is that investors will come up with their own projections. The investor wants to understand the assumptions, structure, and relationships within the modeling of a startup. If the investor is satiated, the entrepreneur has successfully demonstrated a complete understanding of the business side of the enterprise. Pro Excel Financial Modeling provides the keys necessary to learn this thinking and to build the models that will illustrate it.Stepbystep approach to developing financial models in Excel Extensive case studies and Excel templates provided What you'll learn Learn the business thinking behind successful financial modeling aimed at investors. Communicate effectively with investors. Explore advanced modeling with Microsoft Excel, including cost of information technology, customer return on investment, cost of sales and marketing, cost of goods sold, team and staffing, profit and loss. Discover best practices for modeling using Microsoft Excel. Who this book is for

Anyone who wants to think critically about their business models, communicate these models to investors, and successfully build them in Microsoft Excel will find the information they need within this material. Additional readers who will benefit include entrepreneurs, technologists, and developers who wish to start a business utilizing their technology ideas, and business and technology consultants.

Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost. With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find: A visual guide to the new "Ribbon" interface that helps users find familiar tools A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data Convenient techniques for connecting data across worksheets and projects Help for moving from the basics of spreadsheet construction to more advanced features This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more. Don't let Excel 2007 baffle you. Pick upthis convenient pocket guide and learn to navigate this redesigned application with ease.

Pivot Tables are a huge growth area. This book gives people the fast-answers they need to succeed The book is far more detailed than any competing title. Readers of this book will be able to do more, and more quickly The book goes beyond basic explanations and includes real-world troubleshooting, performance and security information not provided elsewhere

This book is definitive. Though assuming no knowledge of VBA or Visual Basic, it covers every aspect of Excel programming. The emphasis is always on solving problems that professionals will encounter in their daily work. Whether it is automatically displaying different views of data through pivot tables or accessing databases through ADO, the latest Microsoft database technology, it's all here. The final chapter provides a reference on Excel objects that is equally definitive. It is important to note that this book is not an advertising brochure for Excel. If there are problems with the Excel object library (and unfortunately there are many of them), they are explained. Whenever possible, Kofler explains a work-around. Still, this book gives the reader a comprehensive look at what you can do with Excel - and despite some problems, the range of possible applications is huge.