Microsoft Office Excel 2007
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776816759
Table of contents: title: Content; title: 1. What is New in Excel 2007; title: 1.1. Ribbons and Tabs; title: 1.2. Larger workspace; title: 1.3. More Colours; title: 1.4. Colour Themes and Styles; title: 1.5. Improved Pivot Tables; title: 1.6. Improved Condi tional Formatting; title: 1.7. More and Better-Looking Charts; title: 1.8. New File Format; title: 1.9. Where can I find the Old Buttons?; title: 2. First Look at Excel; title: 2.1. The Screen and its Elements; title: 2.2. Navigating the spreadsheet; title: 2.3. wnnngin the Cells; title: 2.4. Adaptation of Cell Size; title: 2.5. Selecting Cells; title: 3. Calculations; title: 3.1. Formulas; title: 3.2. Formulas with references; title: 3.3. Functions; title: 4. Copying cells; title: 4.1. Simple Copying; title: 4.2. Series; title: 4.3. Copying Formulas; title: 5. Formatting; title: 5.1. Text and colours; title: 5.2. Number Formats; title: 5.3. Date and Time; title: 5.4. Formatting Tables; title: 6. Working with Tables; title: 6.1. Create a Table; title: 6.2. Filtering; title: 6.3. Sorting; title: 6.4. Pivot Tables; title: 7. Charts; title: 7.1. Bar Charts; title: 7.2. Line Charts; title: 7.3. Charts with both Columns and Lines; title: 7.4. Circle Charts; title: 7.5. Scatter Charts; title: 7.6. Chart Sheet; title: 7.7. Viewing and Printing; title: 7.8. Viewing; title: 7.9. Adjust Print Range; title: 8. Working with Multiple Spreadsheets; title: 8.1. working with Sheet Tabs; title: 8.2. Retrieve Data from Other workbooks; title: 9. Macros - Automation; title: 9.1. Recording a Macro; title: 9.2. Play a Macro; title: 9.3. A Button for Your Macro; title: 10. Advanced Excel; title: 10.1. Nested Functions; title: 10.2. Look-up; title: 10.3. Mathematical and Statistical Functions; title: 10.4. Logical functions; title: 10.5. Analyse Data with Analysis Toolpak; title: 10.6. Goal Seek; title: 11. II Concluding Remarks