Native Land

Only available on StudyMode
  • Download(s) : 110
  • Published : April 12, 2013
Open Document
Text Preview
Torben Lage Frandsen

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
The AVERAGE Function

23
23
24
25
26
27
27
29

You’re full of energy
and ideas. And that’s
just what we are looking for.

© UBS 2010. All rights reserved.

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

3.
3.1
3.1.1
3.2
3.2.1
3.3
3.3.1
3.3.2

Please click the advert

2.1.5
2.1.6
2.1.7
2.1.8
2.2
2.2.1
2.2.2
2.3
2.4
2.5
2.5.1
2.5.2

Looking for a career where your ideas could really make a difference? UBS’s Graduate Programme and internships are a chance for you to experience for yourself what it’s like to be part of a global team that rewards your input and believes in succeeding together.

Wherever you are in your academic career, make your future a part of ours by visiting www.ubs.com/graduates.

www.ubs.com/graduates

Download free ebooks at bookboon.com
5

Contents

Excel 2007

Copying cells
Simple Copying
Series
Series with Numbers
Series that you define
Copying Formulas
Relative and Absolute References

30
30
31
33
33
36
38

5.
5.1
5.1.1
5.1.2
5.1.3
5.2
5.3
5.4
5.5
5.6

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

42
42
42
43
46
49
50
52
54
57

6.
6.1
6.2

Working with Tables
Create a Table
Filtering

62
62
63

Please click the advert

4.
4.1
4.2
4.2.1
4.2.2
4.3
4.3.1

Download free ebooks at bookboon.com
6

Contents

Excel 2007

6.2.1
6.2.2
6.2.3
6.3
6.4
6.4.1
6.4.2

AutoFilter
Advanced Filter
Advanced Filter with Formulas
Sorting
Pivot Tables
Preserving Results
A Couple of Tips on Pivot Tables

64
67
72
73
76
82
82

7.
7.1
7.1.1
7.1.2...
tracking img