Excel 2007 The Basics

engl.-engl.

Von Anfang an - Tabellen erstellen und bearbeiten


Profitieren Sie von der übersichtlichen Darstellung und den praxisnahen Übungen des Excel-Klassikers. Erfahren Sie, wie Sie Tabellen gestalten, drucken und verwalten. Nutzen Sie gezielt Formeln und Funktionen für Ihre Tabellenkalkulationen. Rechnen Sie mit Datum und Uhrzeit. Visualisieren Sie Zahlenaufstellungen mit professionellen Diagrammen.


Die Autoren:
Peter Wies

Werfen Sie einen Blick ins Buch!
Edition: Revised edition, 1st April 2009
Match Code: EX2007EE
Isbn:
Pages Number: 205

Inhalt:

    • 1.1What you should know
    • 1.2Using spreadsheets with Excel
    • 2.1Starting and exiting Excel
    • 2.2The Excel program window
    • 2.3Accessing commands
    • 2.4Using dialog boxes
    • 2.5Quick reference
    • 3.1Moving around the worksheet
    • 3.2Entering data
    • 3.3Editing and deleting data in cells
    • 3.4Selecting cells
    • 3.5Undoing actions
    • 3.6Printing worksheets
    • 3.7Saving and closing workbooks
    • 3.8Creating and opening workbooks
    • 3.9Switching between open workbooks
    • 3.10Quick reference
    • 3.11Practice
    • 4.1Formula structure and entry
    • 4.2The SUM function
    • 4.3Inserting cell references in formulas by pointing
    • 4.4Editing formulas
    • 4.5Quick reference
    • 4.6Practice
    • 5.1Quickly getting help on how to use the program
    • 5.2Working with Excel Help
    • 5.3Quick reference
    • 5.4Practice
    • 6.1The basics of formatting
    • 6.2Specifying fonts and font attributes
    • 6.3Aligning cell contents
    • 6.4Using line breaks and merging cells
    • 6.5Using borders and lines
    • 6.6Assigning background colors/patterns
    • 6.7Formatting numbers
    • 6.8Quick formatting options
    • 6.9Quick reference
    • 6.10Practice
    • 7.1Repeating actions and the AutoComplete feature
    • 7.2Copying and moving data by dragging and dropping
    • 7.3Copying and moving using the Clipboard
    • 7.4Filling in data
    • 7.5Using relative, absolute and mixed references
    • 7.6Quick reference
    • 7.7Practice
    • 8.1Changing column width and row height
    • 8.2Hiding and unhiding columns/rows
    • 8.3Inserting and deleting columns/rows
    • 8.4Inserting or deleting cells
    • 8.5Quick reference
    • 8.6Practice
    • 9.1Function structure and input
    • 9.2Selecting simple functions
    • 9.3Using the Function wizard
    • 9.4Creating nested functions
    • 9.5Troubleshooting formulas
    • 9.6Using formula auditing
    • 9.7Quick reference
    • 9.8Practice
    • 10.1Assigning names
    • 10.2Using names in formulas
    • 10.3Useful tips when using names
    • 10.4Quick reference
    • 10.5Practice
    • 11.1Structure and uses of the IF function
    • 11.2Using nested IF functions
    • 11.3The VLOOKUP and HLOOKUP functions
    • 11.4Using the PMT function
    • 11.5Using mathematical and statistical functions
    • 11.6Practice
    • 12.1Entering and formatting dates and times
    • 12.2Performing simple time calculations
    • 12.3Working with date and time functions
    • 12.4Practical applications
    • 12.5Quick reference
    • 12.6Practice
    • 13.1Working with workbooks
    • 13.2Moving and copying worksheets
    • 13.3Worksheet view options
    • 13.4Using cell references to other worksheets
    • 13.5Using cell references to other workbooks
    • 13.6Protecting workbooks
    • 13.7Protecting worksheets and cells
    • 13.8Customizing the QUICK ACCESS toolbar
    • 13.9Quick reference
    • 13.10Practice
    • 14.1Organizing workbooks
    • 14.2Accessing folders quickly with Favorite Links
    • 14.3Specifying save options for workbooks
    • 14.4Specifying document properties
    • 14.5Using the file recovery feature
    • 14.6Importing and exporting data
    • 14.7Making Excel workbooks available on an intranet
    • 14.8Quick reference
    • 14.9Practice
    • 15.1Working with PRINT PREVIEW
    • 15.2Setting up the print area
    • 15.3Defining page breaks
    • 15.4Using headers and footers
    • 15.5Defining column and row titles
    • 15.6Quick reference
    • 15.7Practice
    • 16.1What are styles
    • 16.2Working with styles
    • 16.3What are templates
    • 16.4Working with templates
    • 16.5Quick reference
    • 16.6Practice
    • 17.1Basic information about charts
    • 17.2Creating charts
    • 17.3Selecting chart types
    • 17.4The basics of editing charts
    • 17.5Editing the display and structure of charts
    • 17.6Formatting and editing chart elements
    • 17.7Labeling charts
    • 17.8Printing charts
    • 17.9Quick reference
    • 17.10Practice
    • 18.1Inserting graphics
    • 18.2Editing graphics
    • 18.3Creating simple objects
    • 18.4Creating special objects
    • 18.5Editing objects
    • 18.6Working with multiple objects/graphics
    • 18.7Quick reference
    • 18.8Practice
    • 19.1Tips on creating spreadsheets
    • 19.2Moving quickly to specific cells
    • 19.3Using the zoom facility in worksheets
    • 19.4Dividing the worksheet window into sections
    • 19.5Freezing rows and columns
    • 19.6Sorting worksheets and worksheet sections
    • 19.7Using the AutoCorrect feature
    • 19.8Using the spelling checker
    • 19.9Finding and replacing specific cell data
    • 19.10Performing manual calculations
    • 19.11Quick reference
    • 19.12Practice
    • 20.1Using conditional formatting
    • 20.2Highlighting specific cells with conditional formatting
    • 20.3Showing value distributions with conditional formatting
    • 20.4Creating custom cell formats
    • 20.5Data checking as you type
    • 20.6Adding comments in workbooks
    • 20.7Using hyperlinks
    • 20.8Quick reference
    • 20.9Practice

als gedrucktes Buch

inkl. MwSt 7% EUR 21,29

als PDF Download

inkl. MwSt 19% EUR 15,35