|
|
|||
Any items that you buy from Amazon after following a link from this page will assist with the running costs of this site. Choose between either the US site (.com) or the British site (co.uk).
or 
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
A highly rated intermediate/advanced guide to developing professional quality applications using Excel. It includes many programming topics, presenting data and building a user interface.
Whether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2003. No matter what your level of expertise, you’ll benefit from hundreds of examples, exercises, tips, techniques, and workarounds, all served with a generous helping of the master’s expert advice.
Covers creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and sending worksheets via e-mail.
This practical, hands-on tutorial expertly builds your skills with Microsoft Office Excel 2003—one step at a time! With STEP BY STEP, you work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need. Master the tools for organizing, processing and presenting data; make data come alive with Microsoft PivotTable® and PivotChart® dynamic views; use data analysis tools for better decision making; tap external data sources; add hyperlinks; create macros; and help keep data secure as you share—and collaborate on—Excel documents over the Web. The book also helps you prepare for the Microsoft Office Specialist exam and makes a great on-the-job desk reference. The companion CD includes practice files you can use as you learn, as well as the Microsoft Office System Reference pack, which contains templates and clip art, an eBook of Step by Step, and four other eBooks: the Microsoft Office System Quick Reference; the Insider’s Guide to Microsoft Office OneNote 2003; the Microsoft Computer Dictionary, Fifth Edition; and Introducing the Tablet PC. Designed for beginning and intermediate level users, STEP BY STEP puts you in charge of developing the skills you need, exactly when you need them!
Excel Hacks: 100 industrial-strength tips and tools
You don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way.
Excel 2003 Power programming with VBA
Feel the power of VBA and Excel. No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.
Everything you need to know about:
(a) Creating and formatting high-impact charts for business, science, and education
(b) Selecting the correct chart for your data (c) Customizing your charts with pictures, graphics, and shapes
(d) Understanding the tricks of the trade that enable you to create "impossible" charts
(e) Creating easy-to-use interactive charts (f) Using VBA to create and modify charts
Excel 2003 Formulas by John Walkenbach
Everything you need to know about:(a) Mastering operators, error values, naming techniques, and absolute versus relative references (b) Debugging formulas and using the auditing tools (c) Importing and exporting XML files and mapping the data to specific cells (d) Using Excel 2003’s rights management feature (e) Working magic with array formulas (f) Developing custom formulas to produce the results you need
Business Analysis with Microsoft Excel
Take control of the bottom line using expert techniques and Excel's powerful financial capabilities! Whether you own a small business or work for a large corporation; whether you are looking for help making financial and business decisions - this book is for you. Professional advice and guidance from an experienced author provide the answers to your most pressing questions.
| Get this web site as a document accompanied by Excel worksheets |
 |
Click here for details about obtaining this file |
If you are using an older version of Excel and would like to see some links to older books, please click here.
|
Search for books on any topic | |
|
| file: Excel_adverts2.htm | Page last updated Jan08 |
|
