Excel 2007
Download free ebooks at bookboon.com
2
Excel 2007
© 2010 Torben Lage Frandsen & Ventus Publishing ApS
ISBN 978-87-7681-675-9
Download free ebooks at bookboon.com
3
Contents
Excel 2007
Contents
Introduction
A Small Reader’s Guide
9
9
1.
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
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?
11
11
11
11
11
11
12
12
12
12
2.
2.1
2.1.1
2.1.2
2.1.3
2.1.4
First Look at Excel
The Screen and its Elements
Workbooks and Spreadsheets
The Ribbon
The Office Button
Quick Access
13
13
14
14
15
16
Please click the advert
Fast-track your career
Masters in Management
Stand out from the crowd
Designed for graduates with less than one year of full-time postgraduate work experience, London Business School’s Masters in Management will expand your thinking and provide you with the foundations for a successful career in business.
The programme is developed in consultation with recruiters to provide you with the key skills that top employers demand. Through 11 months of full-time study, you will gain the business knowledge and capabilities to increase your career choices and stand out from the crowd.
London Business School
Regent’s Park
London NW1 4SA
United Kingdom
Tel +44 (0)20 7000 7573
Email mim@london.edu
Applications are now open for entry in September 2011.
For more information visit www.london.edu/mim/ email mim@london.edu or call +44 (0)20 7000 7573
www.london.edu/mim/
Download free ebooks at bookboon.com
4
Contents
Excel 2007
16
16
17
18
19
19
19
20
21
21
22
22
Calculations
Formulas
Operators
Formulas with references
References to Other Spreadsheets
Functions
The SUM Function