Books & Videos

Table of Contents

  1. WORKSHEET BASICS

    1. Chapter 1 Creating and Navigating Worksheets

      1. Creating a Basic Worksheet
      2. Editing Data
      3. Navigating in Excel
      4. Saving Files
      5. Opening Files
    2. Chapter 2 Adding Information to Worksheets

      1. Adding Different Types of Data
      2. Quick Ways to Add Data
    3. Chapter 3 Moving Data Around a Worksheet

      1. Selecting Cells
      2. Moving Cells Around
      3. Adding and Moving Columns or Rows
    4. Chapter 4 Managing Worksheets and Workbooks

      1. Worksheets and Workbooks
      2. Find and Replace
      3. Spell Check
    5. Chapter 5 Formatting Cells

      1. Formatting Cell Values
      2. Formatting Cell Appearance
      3. Smart Ways to Apply Formatting
    6. Chapter 6 Viewing and Printing Worksheets

      1. Controlling Your View
      2. Printing
      3. Controlling Pagination
  2. WORKSHEET POWER

    1. Chapter 7 Building Basic Formulas

      1. Creating a Basic Formula
      2. Formula Shortcuts
      3. Copying Formulas
    2. Chapter 8 Tables: List Management Made Easy

      1. The Basics of Tables
      2. Sorting and Filtering a Table
    3. Chapter 9 Creating Basic Charts

      1. Charting 101
      2. Basic Tasks with Charts
      3. Practical Charting
      4. Chart Types
  1. Appendix A Customizing The Quick Access Toolbar

    1. The Quick Access Toolbar

  2. Colophon