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
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
Create dynamic dashboards and put your data on display with For Dummies
No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet ... Read More
Excel Data Analysis For Dummies, 2nd Editionis the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis. ... 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