|
|
[Language:English] [Channel: Excel] [Post By itren] |
Updating the previous edition's tips to make them compatible with Excel 2007, and featuring new tips that are only available in Excel 2007, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through through the specific steps to solve the issue. Alternate strategies are also provided, along with commo... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007.
* Minimal text and maximum illustrations
*Task-oriented, step-by-step appr... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Microsoft® Office Excel® 2007 Programming
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:
*Assigning digital signatures to macros
*Setting properties for a project
*Assigning values to a variable
*Changing the properties of an object
*Formatting a numeric express... |
|
|
| |
|
|
| |
|
[Language:English] [Channel: Excel] [Post By itren] |
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:
* Identifying trends in your data
*Sorting, filtering, and identifying lists
*Creating, editing, and checking formulas
*Calculating interest rates and depreciation
*Performing simple sorts and filters
*Hiding rows or columns in a PivotTable
*Adding and... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Beginning PivotTables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.
*Carefully explains the benefits of using Pivot Tables for fast data analysis
*Provides a step-by-step approach to those new to Pivot Tables
*Offers tips and tricks that cannot... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007. Covering object–oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development.
This book is unique insomuch that author Jim DeMarco is a true expert in the field of Exc... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
The author presents tips and techniques in this collection of recipes that can’t be found in Excel’s Help section, while carefully explaining the most confusing features of PivotTables to help you realize their powerful potential.
The chapters in this book have been organized into a collection of recipes to take you step by step from the problem you are experiencing to the solution you are aiming for. Without fuss, you’ll find clear and precise information to help you assess your si... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Excel 2007 Dashboards & Reports For Dummies fills the gap between handling data and synthesizing data into meaningful reports. This title shows readers how to think about their data in ways other than columns and rows.
What are the most meaningful ways to show trending? How do you show relationships in data? When is showing variances more valuable than showing actual data values? How do you deal with outliers? How do you bucket data in the most meaningful way. How do you show impossi... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Microsoft Excel is the world's most-popular spreadsheet program--used by schools, offices, and home users. In Excel 2007, Microsoft has completely redesigned the user interface, making it more intuitive and more attractive. But anyone needing to get started quickly without learning all the ins and outs of the software still needs a handy guide. And with Creating Spreadsheets and Charts in Microsoft Excel 2007: Visual QuickProject Guide they've got one. Excel expert Maria Langer walks readers thr... |
|
|
|
[Language:English] [Channel: Excel] [Post By itren] |
Leverage the power of SQL and Excel to perform business analysis
Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the... |
|
|
| |
| 1 2 3 4 5 6 7 |
| |
Weekly Top Hot 10