KuTenk 2000 - ITOT110133-John Walkenbach’s Favorite Excel 2007 Tips & Tricks

by John Walkenbach 

2007 (528 pages)

ISBN:9780470137666

Consisting of a series of non-trivial tips and tricks that cover all aspects of Excel, this guide will help you deal with function arguments, create charts and pivot tables, tame the new Ribbon, create add-ins, change data entry orientation, and more.

John Walkenbach’s Favorite Excel 2007 Tips & Tricks

Introduction

Part I

-

Basic Excel Usage

Part II

-

Data Entry

Part III

-

Formatting

Part IV

-

Basic Formulas and Functions

Part V

-

Useful Formula Examples

Part VI

-

Conversions and Mathematical Calculations

Part VII

-

Charts and Graphics

Part VIII

-

Data Analysis and Lists

Part IX

-

Working with Files

Part X

-

Printing

Part XI

-

Spotting, Fixing, and Preventing Errors

Part XII

-

Basic VBA and Macros

Part XIII

-

Sources for Excel Information