|
Microsoft Excel 2007 Tutorial |
| Microsoft Excel 2007 Tutorial |
|
 FREE DOWNLOAD THIS TUTORIAL
Tutorial in pdf format so you can save it to your PC, e-book reader or print.
Sponsored link
Note: The tutorial you are about to download is compressed format. Rar, if you do not have a decompressor rar files you can download 7-zip and you can display the Foxit PDF Reader.
|
|
Index Microsoft Excel 2007 Tutorial |
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
CHAPTER 1
What’s New in Excel 2007?
From Excel to XXL
Excel Gets a Makeover
The Ribbon
The Microsoft Office Button
The Quick Access Toolbar
Access Keys
Enhanced ScreenTips
Page Layout View
Better-Looking Documents
Themes and Styles
More Templates
SmartArt
Easier Analysis
Rich Conditional Formatting
Excel Tables
PivotTables and PivotCharts
Sorting and Filtering
Changes to Charts
Simplified Formula Writing
More Functions
Finishing Touches
External Connections
New File Formats
New Ways to Share Data
CHAPTER 2
Customizing Excel
Excel Options
Customizing the Quick Access Toolbar
Customizing the Status Bar
Custom Views
Customizing Your Excel Windows
Freezing Panes
Splitting Panes
Working with Multiple Windows
Comparing Windows Side by Side
CHAPTER 3
Excel Essentials
Entering and Editing Data
Custom Lists
Creating a Series
Working with Paste
Paste Special
Paste Options
Defining Names
Defining a Name
Managing Names
Creating a Name from a Selection
Creating a Dynamic Range
Working with Multiple Worksheets
Inserting Worksheets
Renaming Worksheets
Deleting Worksheets
Moving and Copying Worksheets
Entering and Formatting Data in Multiple Worksheets Simultaneously
CHAPTER 4
Styles and Formatting
Document Themes
Applying a Document Theme
Customizing a Document Theme
Cell Styles
Applying a Cell Style
Modifying a Cell Style
Creating a Custom Cell Style
Table Styles
Applying a Table Style
Changing or Removing a Table Style
Creating a Custom Table Style
Manually Formatting Worksheets
Formatting Numbers
Custom Number and Date Formats
Creating Custom Number Formats
Creating Custom Date and Time Formats
Deleting a Custom Number or Date Format
Conditional Formatting
Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales and Icon Sets
Creating Custom Rules
Removing Conditional Formats
Managing Conditional Formatting Rules
CHAPTER 5
Sorting and Filtering
Sorting Data
Filtering Data
Using Filter
Advanced Filtering
CHAPTER 6
Analyzing Data Using Subtotals, Consolidations, and Tables
Inserting Subtotals and Outlining Data
Calculating Subtotals
Removing Subtotals
Outlining Data
Consolidating Data
Consolidating by Formula
Editing a Data Consolidation
Excel Tables
Creating a Table
Adding and Removing Table Rows and Columns
Using Calculated Columns in a Table
Using Structured References in a Table
Removing an Excel Table
CHAPTER 7
Creating PivotTables and PivotCharts
Pivoting
What Are PivotTables?
What Type of Data Can Be Summarized in PivotTables?
Creating a PivotTable Report
Adding and Removing Fields
Switching Between Automatic and Manual Updating
Selecting Data in a PivotTable
Grouping and Ungrouping Fields
Expanding and Collapsing Fields
Formatting a PivotTable
PivotTable Styles
Creating a Custom PivotTable Style
Changing the Layout and Cell Display
Adding and Removing Subtotals
and Grand Totals
Creating a PivotChart Report
CHAPTER 8
Editing PivotTables and PivotCharts
Sorting a PivotTable or PivotChart Field
Filtering Data in a PivotTable or PivotChart
Using the Report Filter Area
Changing Field Settings
Refreshing a PivotTable Report or PivotChart Report
Changing the Data Source for a PivotTable
Changing the Location of a PivotTable or PivotChart
Creating Formulas Using Calculated Fields or Calculated Items
Inserting a Calculated Field
Inserting a Calculated Item
PivotTable Options
Deleting a PivotTable or a PivotChart Report
CHAPTER 9
What-If Analysis
Data Tables
Creating a One-Variable Data Table
Creating a Two-Variable Data Table
Scenarios
Displaying a Scenario and Creating a Summary Report
Editing and Deleting a Scenario
Merging Scenarios
Goal Seek
Solver
CHAPTER 10
Formulas and Functions
Constructing Formulas
Error Values in Formulas
Formula AutoComplete
Using Relative and Absolute Referencing
Formulas and Defined Names
Referring to Cells in Other Worksheets and Workbooks
Array Formulas
Controlling When Formulas Are Calculated
Using Functions
Financial Functions
Logical Functions
Text Functions
Date and Time Functions
Lookup and Reference Functions
Math and Trigonometry Functions
Statistical Functions
Information Functions
Database Functions
CHAPTER 11
Charts
Creating Charts
Chart Types in Excel
Creating a Chart from Data in a Worksheet
Charting Data from a Different Worksheet
Editing Charts
Changing the Location of a Chart
Changing the Type of a Chart or Data Series
Changing the Data Source for a Chart
Adding a Secondary Axis
Analysis Features for Charts
Formatting Charts
Selecting a Chart Layout and Style
Manually Changing a Chart’s Layout
Manually Changing a Chart Element’s Style
Saving a Chart As a Template
Deleting a Chart or a Chart Element
CHAPTER 12
Adding Graphics to a Worksheet
Inserting Pictures and Clip Art
Inserting a Picture from a File
Inserting Clip Art
Formatting Pictures
Adjusting Pictures
Changing the Style of Pictures
Inserting Shapes
Formatting Shapes
Changing the Style of Shapes
Displaying Text or Cell Contents in Shapes
Resizing Pictures and Shapes
Cropping Pictures
Rotating or Flipping Pictures or Shapes
Filling a Shape or Chart Element with a Picture
Creating and Editing SmartArt
Changing the Structure and Layout of SmartArt
Displaying Cell Contents in SmartArt
Formatting SmartArt
Resizing SmartArt
Changing the Style of SmartArt
Using WordArt
Changing the Stacking Order of Objects
Aligning and Distributing Objects
CHAPTER 13
Preventing and Correcting Errors
Data Validation
Allowing Numbers in a Range
Allowing Values from a List
Allowing Dates or Times in a Range
Allowing Text of a Particular Length
Creating Custom Validation Criteria
Displaying an Input Message and an Error Alert
Changing or Removing Data Validation
Removing Duplicate Values
Formula Auditing
Identifying Errors in Formulas
Error Checking
Dealing with Circular References
Viewing and Hiding Formulas
Viewing the Relationships Between Cells
Evaluating Formulas
Watching Formulas
CHAPTER 14
Protection and Security
Protecting Worksheets and Workbooks
Protecting the Contents of a Workbook
Protecting the Contents of a Worksheet
Protecting the Structure of a Workbook
Protecting a Shared Workbook
Digital Signatures
Using a Signature Line
Viewing a Digital Signature
The Trust Center
Adding, Viewing, and Removing Trusted Publishers
Adding, Changing, and Removing Trusted Locations
Managing Application Add-ins
Changing Settings for ActiveX Controls
Changing Settings for Macros
Turning the Message Bar On and Off
Changing Settings for External Content
Changing Privacy Options
CHAPTER 15
Getting Data from External Sources
Connecting to External Data Sources
Importing Data from an Existing Connection
Importing Data from a Microsoft Access Database
Importing Data from the Web
Importing a Text File
Importing Data from Other Sources
Managing Data Connections
Refreshing External Data
Editing Workbook Connections
Changing the Format and Layout of an External Data Range
CHAPTER 16
Sharing, Reviewing, and Distributing Data
Sharing and Reviewing Workbooks
Creating a Shared Workbook
Editing a Shared Workbook
Tracking Changes
Using Comments
Adding a Comment to a Cell
Viewing Comments
Printing Comments
Editing and Deleting Comments
Preparing a Worksheet for Printing
Using Headers and Footers
Changing the Layout for Printing
Using Print Preview
Preparing a Document for Distribution
Changing the Document Properties
Inspecting a Document
Protecting and Finalizing a Document
Compatibility Issues and Saving in Other Formats
CHAPTER 17
SharePoint and Excel Services
Microsoft Office SharePoint Server 2007
Excel Services
Excel Services Architecture
Publishing a Workbook to a Server
Displaying an Excel Workbook in Excel Services
Supported and Unsupported Features in Excel Services
Interacting with Spreadsheets Generated by Excel Services
Editing a Workbook Published in Excel Services
Removing a Workbook Published to Excel Services
APPENDIX A
Location of Popular Excel 2003 Commands in Excel 2007
APPENDIX B
Selecting Data in a PivotTable Report
Index
Download the file decompressor 7-zip.
Download the PDF reader Foxit PDF Reader.
|
|
| |
|
