Book Description :
Genre : Educational/ Software
Written By : Torben Lage Frandsen
Book Size : 16.7 Mb
Nothing is difficult once you have learned it. That applies to Microsoft Office Excel 2007 as well, and once you have learned it, you will be able to do things you never dreamed of! In this Excel 2007 ebook you will learn how to use formulas, tables and charts. Furthermore, chapters in this ebook focus on how to do calculations, how to format and how to use Excel 2007 functions.
Content :
What is New in Excel 2007
Ribbons and Tabs
Larger workspace
More Colours
Colour Themes and Styles
Improved Pivot Tables
Improved Condi tional Formatting
More and Better-Looking Charts
New File Format
Where can I find the Old Buttons?
First Look at Excel
The Screen and its Elements
Navigating the spreadsheet
wnnngin the Cells
Adaptation of Cell Size
Selecting Cells
Calculations
Formulas
Formulas with references
Functions
Copying cells
Simple Copying
Series
Copying Formulas
Formatting
Text and colours
Number Formats
Date and Time
Formatting Tables
Working with Tables
Create a Table
Filtering
Sorting
Pivot Tables
Charts
Bar Charts
Line Charts
Charts with both Columns and Lines
Circle Charts
Scatter Charts
Chart Sheet
Viewing and Printing
Viewing
Adjust Print Range
Working with Multiple Spreadsheets
working with Sheet Tabs
Retrieve Data from Other workbooks
Macros - Automation
Recording a Macro
Play a Macro
A Button for Your Macro
Advanced Excel
Nested Functions
Look-up
Mathematical and Statistical Functions
Logical functions
Analyse Data with Analysis Toolpak
Goal Seek
II Concluding Remarks
Download Links :
No comments:
Post a Comment