Frandsen Torben Lage. Microsoft Office Excel 2007

Bookboon.com (Ventus Publishing ApS), 2010. – 135 p. – ISBN: 978-87-7681-675-9.A Small Reader’s Guide.
What is New in Excel 2007.
Ribbons and Tabs.
Larger Workspace.
More Colours.
Colour Themes and Styles.
Improved Pivot Tables.
Improved Conditional Formatting.
More and Better-Looking Charts.
New File Format.
Where can I find the Old Buttons?
First Look at Excel.
The Screen and its Elements.
Workbooks and Spreadsheets.
The Ribbon.
The Office Button.
Quick Access.
The Workspace.
Sheet Tabs.
Display Buttons
Start a New Spreadsheet
Navigating the spreadsheet
Navigating Large Spreadsheets
Cell Pointer and Auto Fill
Writing in the Cells
Adaptation of Cell Size
Selecting Cells
Compound Selection
Navigating Inside a Selection
Calculations
Formulas
Operators
Formulas with references
References to Other Spreadsheets
Functions
The SUM Function
The AVERAGE Function
Copying cells
Simple Copying
Series
Series with Numbers
Series that you define
Copying Formulas
Relative and Absolute References
Formatting
Text and colours
Formatting using the Ribbon
Formatting using the shortcut menu
Borders and Frames
Number Formats
Date and Time
Formatting Tables
Conditional Formatting
Themes and Styles
Working with Tables
Create a Table
Filtering
AutoFilter
Advanced Filter
Advanced Filter with Formulas
Sorting
Pivot Tables
Preserving Results
A Couple of Tips on Pivot Tables
Charts
Bar Charts
Charting Tools and Language Confusion Terminology - What does it mean?
Change of Scale Line Charts
Charts with both Columns and Lines
Circle Charts
Scatter Charts
Results of Measurements
Graphic Representation of Mathematical Expressions
Chart Sheet
Viewing and Printing
Printing
Print Preview
Page Setup
Viewing
Adjust Print Range
Managing Page Breaks
Working with Multiple Spreadsheets
Working with Sheet Tabs
Retrieve Data from Other Workbooks
Macros - Automation
Recording a Macro
Play a Macro
A Button for Your Macro
Advanced Excel
Nested Functions Look-up
VLOOKUP (Vertical Lookup)
HLOOKUP (Horizontal Lookup)
Mathematical and Statistical Functions
SUM
AVERAGE
SQROOT (Square Root)
Trigonometric Functions
PI
ABS (Absolute Value)
SHORTEN
ROUND OFF
MIN (Minimum Value)
MAX (Maximum Value)
SUMIF (Conditional Sum)
RAND (Random Numbers)
COUNT (Number of Cells with Numbers)
Logical functions
AND Function
OR Function
NOT Function
IF Function
IFERROR Function
Analyse Data with Analysis Toolpak
Installation of Analysis Toolpak
A Quick Analysis with Analysis Toolpak
Goal Seek
Concluding Remarks