This book provides an innovative, integrated, and methodical approach to understanding complex financial models, integrating topics usually presented separately into a comprehensive whole. The book brings together financial models and high-level mathematics, reviewing the mathematical background necessary for understanding these models...
Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author ...
Database design involves how to best structure the tables and queries that are used with databases in order to provide optimum performance, storage, manageability, and flexibility. With relational databases, you can use those tables to organize your data and retrieve information from your database. This book provides you with an easy-to-understand...
Find all the answers to a Microsoft Office user's questions in one big, easy-to-use book. Sams Teach Yourself Office Productivity All in One is designed to teach the new computer user how to get the most out of an Office productivity suite. It does not assume the reader wants to learn how to use just one product,...
PowerShell is becoming the de facto administration tool for Microsoft
Server products. The ability to script out reusable steps and code makes life
easier for administrators, developers, and managers alike. With the latest
release of Microsoft SharePoint Server 2010, PowerShell is the recommended
administration...
The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly...
From formulas to functions to the latest features — practice and plan Excel tasks with ease
Confused by Excel? Want to make the most of its capabilities? No worries — this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas,...
If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner,...
Need to learn FileMaker Pro fast? Try a Visual QuickStart Guide!
If you've recently upgraded to FileMaker Pro 8, teach yourself this powerful database software the quick and easy way! Using pictures rather than lengthy explanations, this Visual QuickStart Guide...
When I first started developing information systems at Microsoft, I often looked at Microsoft Excel and lamented that it was not packaged as a collection of reusable components that I could simply pick up and integrate into my applications. At that time, the current version of Excel had a new revolutionary user interface element called a...
Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you’ll learn to write Visual Basic code that automates Access database tasks, creates standalone...
Equipped with a variety of functions and easy to use, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient....