| Feedback | Excel Index | |
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.
Bestselling author John Walkenbach has written a comprehensive reference guide to Excel 2010. This perennial bestseller is indispensable no matter your level of skill, from Excel beginners and intermediate users to potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive coverage, delivering over 900 pages of Excel tips and techniques. Includes a CD that contains all the templates and worksheets used in the book plus John's award–winning Power Utility Pak
In the friendly and non–threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features. The book includes everything you need to know to perform basic Excel 2010 tasks.
It covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records.
Also covers printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and much more
Quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you practice the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
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 2010 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 : Microsoft Excel 2010
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 this book can offer guidance ranging from financial statements to marketing and quality decision making. Updated to include examples of new Excel features such as sparklines. 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 | |
![]() |
MeadInKent is a participant in the Amazon EU Associates Programme, an affiliate advertising programme designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.co.uk
file: Excel_adverts2.htm | Page last updated Feb14 |