Excel 2010 Workbook For Dummies
Reinforce your understanding of Excel with these Workbook exercises
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, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you.
Excel 2010 Workbook For Dummies helps you get comfortable with Excel so you can take advantage of all it has to offer.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Doing Data Analysis 283
Entering the Spreadsheet Data
Formatting the Spreadsheet
Printing Spreadsheet Reports
Modifying the Spreadsheet
Using Formulas and Functions
Text Formulas and Functions
Working with Graphics
Adding Graphics to Spreadsheets
Managing and Securing Data
Protecting the Spreadsheet
Performing WhatIf Analysis
Generating Pivot Tables
Macros and Visual Basic for Applications
Copying and Correcting Formulas
Creating Date and Time Formulas
Financial Formulas and Functions
Using Math Functions
Using Common Statistical Functions
Using Lookup Functions
Using Logical Functions