Part 1: Introduction to Excel 2007

The first part of the book Excle 2007 with Excel Master is concerned with the basic things that everyone needs to know. The contents of chapter one essentially start you off at the very beginning. This includes anyone who might know Excel 2003 and even earlier editions but who have never used the Office 2007 ribbon.

Contents of Part One of the Book

At the time I am writing this, I have not finished writing the book and so what you are about to read is still subject to change. However, it gives you a good idea of what I am preparring. Here is the content of part one of the book:

 

Introductory

  • Chapter 1
  • Chapter 2
  • Chapter 3

Basics

  • Introduction
  • Pencil and Paper
  • Basic Functionality
  • The Ribbon
    • Screen Resolution
    • Minimise the Ribbon
  • The Quick Access Toolbar: the QAT
  • Basic Rules
    • Add Subtract Multiply Divide
    • More Complex Calculations
    • Try it!
    • Built in Functions: SUM ... AVERAGE ... MIN ... MAX
    • Auto Fill
    • Auto Fill Menu
  • Formatting Cells
  • Moving Around your Workbook
  • Changing Column and Row Sizes
  • Moving a Column or Row
  • Formatting Text
  • Cell Border
  • Try it!
  • Consolidation Exercise
  • Selecting non Contiguous Ranges
    • Why Select Non contiguous Ranges?
    • Print Areas
  • Transposing Data
  • Cell and Range Addressing
  • Range Names
  • Array formulas

Charting

  • Introduction
  • The Rules of Charting
  • Setting up a Chart the Easy Way: the F11 key
    • Default Chart Change
    • Creating a Template Char
  • Embedding a Chart with the Chart Wizard
    • Embedding by Moving
  • Titles and Axes Labels
    • Copy Charts: make clones an move them
  • Other Charts
    • Category Axis Contains Labels from Three Columns
    • Conditional Colours
    • Waterfall Chart
      • Create a Stacked Column Chart
      • Finished Waterfall Chart
      • Alternatives
      • Percentage Waterfall Chart
    • Radar Chart
    • Self Expanding Chart
    • Excel 2007 Solution 1
    • Excel 2007 Solution 2a
    • Excel 2007 Solution 2b
    • Selecting Data from a Combo Box
    • Spreadsheet Allowing the User to Highlight Alternative Scenarios
    • Table and Chart Selection Including a Combobox
    • Charts with Scroll Bars
    • Basic Chart and Rates of Change Chart
      • Ten year financial review of a company
      • Double Vertical Axes
  • Additional Charting Exercises
    • Text to Columns
    • Deriving Values from Published Charts
    • Dashboards
      • More Advanced Chart

Introduction to Pivot Tables

  • Introduction
  • Definition of a Pivot Table
  • Why you need a Pivot Table
  • Example PTs
  • Copying a Pivot Table
    • A Copy of a PT is a Clone of a PT
    • Copying your PT
  • Changing Sum of to Average of to Count of ...
  • Moving a Field from Row to Column
  • Drag and Move Within the PT
  • Drag and move the chosen field within the Task Pane
  • Filtering a Field
  • Sorting a Pivot Table
  • Formatting Fields
  • Calculated Fields
  • Drilling Down
  • Calculated Item
  • Other Calculated Item Features
    • Adjusting the Formula
    • More Complex Formulas
    • Forecasting with a Calculated Item
  • Values
  • Show Values As
  • Grouping PT Data
    • Starting or Setting up a PT
    • The Grouping Process
  • When Grouping is a Problem
  • Pivot Chart
  • Formatting a Pivot Chart
  • A Pivot Chart with a Data Table
  • Formatting
  • Page Fields
  • Multiple Page Fields
  • Reporting with Page Fields
  • Pivot Table from an External Source

 

 

Once the table of contents has been finalised, there will be a PDF Format copy of it available here