Microsoft ® Excel ® Workbook 2nd Edition – Ebook Instant Download/Delivery ISBN(s): 9781119832164,1119832160,9781119832171,1119832179

Product details:

• ISBN-10: 1119832179
• ISBN-13: 9781119832171
• Author: Paul McFedries, Greg Harvey

Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you’ve been waiting for.

This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you’ll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.

Table contents:

Part 1: Building Worksheets 

Chapter 1: Getting Familiar with the Excel Interface

Chapter 2: Entering the Worksheet Data

Chapter 3: Formatting the Worksheet

Chapter 4: Printing Worksheet Reports

Chapter 5: Modifying the Worksheet

Part 2: Using Formulas and Functions 

Chapter 6: Building Formulas

Chapter 7: Copying and Correcting Formulas

Chapter 8: Creating Date and Time Formulas

Chapter 9: Financial Formulas and Functions

Chapter 10: Using Math Functions

Chapter 11: Using Common Statistical Functions

Chapter 12: Using Lookup Functions

Chapter 13: Using Logical Functions

Chapter 14: Text Formulas and Functions

Part 3: Working with Graphics 

Chapter 15: Charting Worksheet Data

Chapter 16: Adding Graphics to Worksheets

Part 4: Managing and Securing Data 

Chapter 17: Building and Maintaining Tables

Chapter 18: Protecting Workbooks and Worksheet Data

Part 5: Doing Data Analysis 

Chapter 19: Performing What-If Analysis

Chapter 20: Generating PivotTables

Part 6: Macros and Visual Basic for Applications 

Chapter 21: Using Macros

Chapter 22: Using the Visual Basic Editor

Part 7: The Part of Tens 

Chapter 23: Top Ten Features in Excel

Chapter 24: Top Ten Tips for Using Excel Like a Pro

People also search:

Microsoft ® Excel ® Workbook

What is Microsoft Excel workbook

What do you know about workbook

use of Excel workbook

How workbook is created in MS Excel