Computers & Internet
* Mastering operators, error values, naming techniques, and absolute versus relative references
* Debugging formulas and using the auditing tools
* Importing and exporting XML files and mapping the data to specific cells
* Using Excel 2003's rights management feature
* Working magic with array formulas
* Developing custom formulas to produce the results you need
Here's the formula for Excel excellence
Formulas are the lifeblood ... Read More
If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one place—no flipping pages!
Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel ... Read More
--Loren Abdulezer, Author of Excel Best Practices for Business
Everything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* ... Read More
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized ... Read More
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 programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.
Discover how ... Read More
Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency.
Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, ... Read More
Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice ... Read More
This online course covers the basics of creating Excel spreadsheets, creating and using formulas and functions, and formatting worksheets. You will move at your own pace through three interactive lessons, discovering how worksheets work, how to add and edit content, what formulas and functions do, and how to format your spreadsheet to best demonstrate your data.
In this online course, you'll learn how to create and format several types of Excel charts, present data clearly, use financial functions, work with math, statistical, and text functions, store and manage data in tables and lists, work with PivotTables and PivotCharts, and correct, protect, and share your workbook data. The seven interactive lessons take you step-by-step through the process, so you learn at your own pace.
Whether you have just discovered Excel for the first time or you are an Excel veteran who wants to understand the 2010 version in a hurry, this digital edition provides a real time learning experience. Learn Excel through instructional videos, audio clips, shared notes, embedded links, and interactive images that provide everything you need to know about creating and editing worksheets, formatting cells, using formulas, adding hyperlinks, saving worksheets ... Read More
Using Excel for this kind of stuff is what ... Read More
Learn to use Excel for practical, day-to-day calculations
Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also ... Read More
Excel Sales Forecasting For Dummies shows you how to use the number one workbook program, Microsoft Excel, ... Read More
Now that you've mastered Excel basics, it's time to move to the next level—creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize ... Read More
Take control of your spreadsheets and use VBA to create your own custom Excel applications
Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to ... Read More
Excel Workbook For Dummies is specially designed to give you the hands-on experience you need to start using this great ... Read More
If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets ... Read More