Spreadsheets category: 384 books

This must-have textbook for students in mechanical, civil, and electrical engineering departments addresses issues not sufficiently covered by existing engineering economics texts. Clearly presenting fundamental concepts that engineering students need to master in one semester, the author effectively...

The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot...

Do you want a better job?Yes!How do you get a better job?Deafening silence.Oh… People don’t stay on the same path nowadays; they have many jobs and often a few careers. Corporate loyalty is disappearing as people feel uncertain about the stability of the company they belong to and actually,...

Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on...

From the author of “The Excel Answer Book” comes the fastest and easiest method to Master the Most Useful Date & Time Formulas in Microsoft Excel Let's face it. Using Microsoft Excel as glorified typewriter isn't it's intented purpose. To make Excel a truly useful tool you need to...

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples...

There is a fair number of stand alone applications as well as add on’s to Microsoft Excel in the market used to run Monte Carlo Simulation (MCS) models. However, out of the box, Excel has all the functions you need to develop such models. What is needed are robust modeling procedures, techniques...

For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures...

This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Excel 2010's new features - and, with Easy Microsoft Excel 2010, you'll find exactly what you're looking for. This full-color, utterly simple, step-by-step book has been carefully crafted...

Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness.   How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the...

Excel at predicting sales and forecasting trends using Microsoft Excel! If you're a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job. Unlike other books on the subject, Excel Sales Forecasting For Dummies, 2nd Edition leaves...

There is a fair number of stand alone applications as well as add on’s to Microsoft Excel in the market to be used to run Monte Carlo Simulation (MCS) models. However, out of the box, Excel has all the functions you need to develop such models. What is needed are robust modeling procedures, techniques...

Information visualization is a language. Like any language, it can be used for multiple purposes. A poem, a novel, and an essay all share the same language, but each one has its own set of rules. The same is true with information visualization: a product manager, statistician, and graphic designer...

Crunch Big Data to optimize marketing and more!   Overwhelmed by all the Big Data now available to you? Not sure what questions to ask or how to ask them? Using Microsoft Excel and proven decision analytics techniques, you can distill all that data into manageable sets—and use them to optimize a...