Table of Contents

1 Preliminary Notes

2 Excel 2010 Program

2.1 Starting Excel
2.2 The Excel screen

3 Executing Commands

3.1 The ribbon
3.2 The File menu
3.3 Icons
3.4 Context menus and toolbars
3.5 Keys (shortcuts)
3.6 Help
3.7 Switching to other tasks
3.8 Exiting Excel

4 Workbook

4.1 Moving within the sheet
4.2 Zoom
4.3 Entering data
4.4 Saving entries
4.5 Canceling entries
4.6 Changing entries
4.7 Calculating sums

5 Saving the Workbook

5.1 The Save As Explorer window
5.2 The Save and Save As commands
5.3 Backup file
5.4 Automatic save
5.5 Exiting a file
5.6 Opening a file
5.7 Creating a new workbook
5.8 Summary: files and exiting Excel

6 Ranges

6.1 Selecting ranges
6.2 Clipboards
6.3 Copying cells
6.4 Undoing changes
6.5 Repeat
6.6 Exercises
6.7 Cutting cell contents
6.8 Pasting cell contents from a clipboard
6.9 Collecting and pasting
6.10 Drag & Drop
6.11 Deleting
6.12 Summary: ranges

7 Functions

7.1 Function structure
7.2 Statistical evaluations
7.3 Applying the functions

8 Formatting Sheets

8.1 Changing the column width
8.2 Changing the column width using the mouse
8.3 Changing the row height
8.4 Alignment
8.5 Formatting numbers
8.6 Inserting rows and columns
8.7 Font style
8.8 Centering headings
8.9 Borders
8.10 Fill color
8.11 Find and replace
8.12 Spell checking
8.13 Exercises
8.14 Summary: formatting sheets

9 Calculating Premiums

9.1 Locking columns and rows
9.2 Calculation signs of the 4 basic calculation types
9.3 Calculating with constants
9.4 Exercises
9.5 Calculating with variables
9.6 Relative and absolute addressing
9.7 Exercises
9.8 Errors in a workbook
9.9 Styles
9.10 Office themes
9.11 Range names
9.12 Exercise
9.13 Window commands
9.14 Calculations with the IF function
9.15 Exercises:
9.16 Conditional formatting
9.17 Data illustration with conditional formatting
9.18 Summary: Calculating premiums

10 Chart

10.1 Creating a new chart
10.2 Context tools
10.3 Plotting charts
10.4 Exercises
10.5 Changing the chart appearance
10.6 3-D pie charts
10.7 Drawing elements in the chart
10.8 Summary: Chart

11 Printing

11.1 Printer setup
11.2 Print preview
11.3 Page setup
11.4 Page break preview
11.5 Headers and footers
11.6 Page layout view
11.7 Printing

12 3-D Spreadsheets

12.1 Inserting and deleting worksheets
12.2 Copying and pasting in several worksheets
12.3 Group mode
12.4 3-D ranges
12.5 Exercise

13 Filling Data

13.1 Filling in date values
13.2 Autofill using the mouse

14 Database

14.1 Preliminary considerations – new database
14.2 Database ranges
14.3 Filters
14.4 Entering criteria
14.5 Exercise
14.6 Sorting
14.7 Summary: database

15 Appendix

15.1 Saving in another file type
15.2 Customizing the Quick Access Toolbar
15.3 Customizing the status bar
15.4 Keyboard shortcuts

16 Subject Index