Spreadsheets category: 384 books

Excel Techniques ManualTarget audience:Students, business professionals, anybody that is looking to improve there excel knowledge and capabilitiesTime to master:A couple of hours to complete the explanations. The more time you spend practising the examples the more proficient you will become.

From the author of “The Excel Answer Book” comes the fastest and easiest method to Master the Most Useful TEXT 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 learn how...

How would you like to work TEN TIMES FASTER? Do you ever say to yourself, I really wish Excel could do “this” or “that”? Or did you ever find yourself manually manipulating data over and over, or say “There has to be a formula I can use or an easier way to do this”? ...

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

From the author of “The Excel Answer Book” comes the fastest and easiest method to Master the Most Useful TEXT Formulas in Microsoft ExcelLet'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...

Excel is a software program that allows us to record and store data in an easy to understand way. It can be used for a wide range of data tracking and processing, such as inventory recording, statistics, reporting and analysis, income and expenditure and many, many other tasks. When you really...

Enjoy these detailed instructions of 13 functions in Microsoft Excel that no one should be without. These instructions are accompanied by descriptive screen shots. Intended to be reference material for beginners and intermediate users.  Make Excel work harder for you so that you can become a...

Five tips that will greatly reduce the amount of time that you have to spend on Excel based tasks. Quickly turn a day long project into an hour long project. Don't let formatting hold you back. Speed up your data entry. Don't spend so long looking for data. Take a look at five simple things that you...

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

This Is Not Your Average Beginners Guide Brought to you by the Katoch Ventures, this book provides you all the tips, tools and screenshots, to help you become a "frustration-free" excel user in no time. You'll learn: 1. Sorting and Filtering  2. Applying...

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

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

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample...

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel;...