Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time.

**Contents of this Microsoft Excel 2010 In Depth advanced complete tutorial book**

Part I: Changes in User Interface

Chapter 1. The File Menu Becomes the Backstage View

Understanding “In” Versus “Out” Commands

Using Backstage View

Opening Recent Files

Getting Information About the Current Workbook

Creating a New Workbook from a Template

Printing and Print Preview

Sharing Your Workbook Using Save & Send

Getting Updates and Help

Chapter 2. The Ribbon Interface and Quick Access Toolbar

Using the Ribbon

The Ribbon Is Constantly Changing

Solving Common Ribbon Problems

Using the Quick Access Toolbar

Adding Favorite Commands to the Quick Access Toolbar

Customizing the Quick Access Toolbar

Chapter 3. Using Other Excel Interface Improvements

Using Live Preview

Previewing Paste Using the Paste Options Gallery

Using the Mini Toolbar to Format Selected Text

Expanding the Formula Bar

Zooming In and Out on a Worksheet

Using the Status Bar to Add Numbers

Switching Between Normal View, Page Break Preview, and Page Layout View Modes

Using the New Sheet Icon to Add Worksheets

Chapter 4. Customizing the Ribbon

Performing a Simple Ribbon Modification

Using a More Complex Ribbon Modification

Hiding/Showing Ribbon Tabs

Adding a New Ribbon Tab

Sharing Customizations with Others

Questions About Ribbon Customization

Chapter 5. Keyboard Shortcuts

Chapter 6. The Excel Options Dialog

Introducing the Excel Options Dialog

Ten Options to Consider

Guide to Excel Options

Chapter 7. The Big Grid and File Formats

Excel Grid Limits

Other Limits in Excel 2010

Tips for Navigating the Big Grid

Understanding the New File Formats

Version Compatibility

Opening Excel 2010 Files in Excel 2002 or 2003

Creating Excel 2010 File Formats in Excel 2003

Opening Excel 2010 Files in Excel 2007

Part II: Calculating with Excel

Chapter 8. Understanding Formulas

Getting the Most from This Chapter

Introduction to Formulas

Entering Your First Formula

Three Methods of Entering Formulas

Entering the Same Formula in Many Cells

Use the Table Tool to Copy a Formula

Chapter 9. Controlling Formulas

Formula Operators

Understanding Error Messages in Formulas

Using Formulas to Join Text

Copying Versus Cutting a Formula

Automatically Formatting Formula Cells

Using Date Math

Troubleshooting Formulas

Excel in Practice: Moving the Formula ToolTip

Chapter 10. Understanding Functions

Working with Functions

Getting Help with Excel Functions

Using AutoSum

Using the New General-Purpose Functions in Excel

Functions with New Variations in Excel 2010

Functions That Have Been Renamed

Cube Functions Introduced in Excel 2007

Chapter 11. Using Everyday Functions: Math, Date and Time, and Text Functions

Examples of Math Functions

Dates and Times in Excel

Examples of Date and Time Functions

Examples of Text Functions

Chapter 12. Using Powerful Functions: Logical, Lookup, and Database Functions

Examples of Logical Functions

Examples of Information Functions

Examples of Lookup and Reference Functions

Examples of Database Functions

Chapter 13. Using Financial Functions

Examples of Common Household Loan and Investment Functions

Examples of Functions for Financial Professionals

Examples of Depreciation Functions

Functions for Investment Analysis

Examples of Functions for Bond Investors

Examples of Miscellaneous Financial Functions

Chapter 14. Using Statistical Functions

Examples of Functions for Descriptive Statistics

Examples of Functions for Regression and Forecasting

Examples of Functions for Inferential Statistics

Using the Analysis ToolPak to Perform Statistical Analysis

Chapter 15. Using Trig, Matrix, and Engineering Functions

A Brief Review of Trigonometry Basics

Examples of Logarithm Functions

Working with Imaginary Numbers

Solving Simultaneous Linear Equations with Matrix Functions

Examples of Engineering Functions

Using the Analysis Toolpack to Perform Fast Fourier Transforms (FFTs)

Chapter 16. Connecting Worksheets, Workbooks, and External Data

Connecting Two Worksheets

Connecting to Data on a Web Page

Setting Up a Connection to a Text File

Setting Up a Connection to an Access Database

Setting Up SQL Server, XML, OLE DB, and ODBC Connections

Managing Connections

Chapter 17. Using Super Formulas in Excel

Using 3D Formulas to Spear Through Many Worksheets

Combining Multiple Formulas into One Formula

Calculating a Cell Reference in the Formula by Using the INDIRECT Function

Assigning a Formula to a Name

Replacing Multiple Formulas with One Array Formula

Chapter 18. Using Names in Excel

Use the Name Box to Define a Name for a Cell

Naming a Cell by Using the Name Dialog

Using the Name Box for Quick Navigation

Using Scope to Allow Duplicate Names in a Workbook

Using Named Ranges to Simplify Formulas

Managing Names

Using a Name to Simplify an Absolute Reference

Using a Name to Hold a Value

Assigning a Formula to a Name

Chapter 19. Fabulous Table Intelligence

Defining Suitable Data for Excel Tables

Adding a Total Row to a Table

Toggling Totals

Expanding a Table

Adding New Formulas to Tables

Selecting Only the Data in the Column

Using Table Data for Charts to Ensure Stickiness

Replacing Named Ranges with Table References

Creating Banded Rows and Columns with Table Styles

Dealing with the AutoFilter Drop-Downs

Part III: Business Intelligence

Chapter 20. Sorting Data

Introducing the Sort Dialog

Using Specialized Sorting

One-Click Sorting

Sorting Randomly

Chapter 21. Removing Duplicates and Filtering

Filtering Records

Sorting Filtered Results

Using the Advanced Filter Command

Using Remove Duplicates to Find Unique Values

Chapter 22. Using Automatic Subtotals

Adding Automatic Subtotals

Working with the Subtotals

Using Specialty Subtotal Techniques

Chapter 23. Using Pivot Tables to Analyze Data

Creating Your First Pivot Table

Dealing with the Compact Layout

Rearranging a Pivot Table

Finishing Touches: Numeric Formatting and Removing Blanks

Four Things You Have to Know When Using Pivot Tables

Calculating and Roll-Ups with Pivot Tables

Formatting a Pivot Table

Finding More Information on Pivot Tables

Chapter 24. Using Slicers and Filtering a Pivot Table

Filtering Using the Row Label Filter

Filtering Using Report Filter Fields

Filtering Using Slicers

Filtering Oddities

Sorting a Pivot Table

Chapter 25. Mashing Up Data with PowerPivot

Benefits and Drawbacks to PowerPivot

Installing PowerPivot

Case Study: Building a PowerPivot Report

Some Things Are Different

Two Kinds of DAX Calculations

Using DAX to Create New Measures

Other Notes

Chapter 26. Using What-If, Scenario Manager, Goal Seek, and Solver

Using What-If

Using Scenario Manager

Using Goal Seek

Using Solver

Chapter 27. Automating Repetitive Functions Using VBA Macros

Checking Security Settings Before Using Macros

Recording a Macro

Case Study: Macro for Formatting for a Mail Merge

Everyday-Use Macro Example: Formatting an Invoice Register

Understanding VBA Code—An Analogy

Using Simple Variables and Object Variables

Customizing the Everyday-Use Macro Example: GETOPENFILENAME and GETSAVEASFILENAME

From-Scratch Macro Example: Loops, Flow Control, and Referring to Ranges

Combination Macro Example: Creating a Report for Each Customer

Chapter 28. More Tips and Tricks for Excel 2010

Speeding Up Calculation by Using Multithreaded Calculation

Watching the Results of a Distant Cell

Opening the Same Files Every Day

Comparing Documents Side by Side with Synchronous Scrolling

Calculating a Formula in Slow Motion

Inserting a Symbol in a Cell

Edit an Equation

Adding a Digital Signature Line to a Workbook

Protecting a Worksheet

Sharing a Workbook

Separating Text Based on a Delimiter

Translating Text

Chapter 29. Tour of the Best Add-Ins for Excel

Charting Utilities from Jon Peltier

Creating Dashboards by Using Speedometer Chart Creator

Add Labels to XY Charts

Loading PDF Data to Excel by Using Able2Extract

Customizing the Ribbon Using CustomizeRibbon

Accessing More Functions by Using MoreFunc.dll

General Purpose Utility Suites

Part IV: Visual Presentation of Data

Chapter 30. Formatting Worksheets

Why Format Worksheets?

Using Traditional Formatting

Formatting with Styles

Understanding Themes

Other Formatting Techniques

Copying Formats

Chapter 31. Using Data Visualizations and Conditional Formatting

Using Data Bars to Create In-Cell Bar Charts

Using Color Scales to Highlight Extremes

Using Icon Sets to Segregate Data

Using the Top/Bottom Rules

Using the Highlight Cells Rules

Tweaking Rules with Advanced Formatting

Combining Rules

Clearing Conditional Formats

Extending the Reach of Conditional Formats

Special Considerations for Pivot Tables

Chapter 32. Using Excel Charts

Understanding the Components of a Chart

Setting Up Data for Charting

Inserting a Chart by Choosing a Chart Type

Choosing a Chart Layout to Further Customize the Chart Type

Customizing a Chart Using the Chart Tools Tabs

Charting Tips and Tricks

Using Pivot Charts

Chapter 33. Using Sparklines

Fitting a Chart into the Size of a Cell with Sparklines

Understanding How Excel Maps Data to Sparklines

Chapter 34. Using SmartArt, Shapes, WordArt, and Text Boxes

Using SmartArt

Using Shapes to Display Cell Contents

Using WordArt for Interesting Titles and Headlines

Using Text Boxes to Flow Long Text Passages

Chapter 35. Using Pictures and Clip Art

Using Pictures on Worksheets

Inserting Screen Clippings

Using Clip Art

Part V: Sharing

Chapter 36. Printing

Printing from Backstage View

Using Page Layout View

Using the Improved Headers and Footers

Using the Page Setup and Sheet Options

Working with Page Breaks

Chapter 37. Excel Web App and Other Ways to Share Workbooks

Sharing Workbooks with Others

Sending a Workbook via Email

Publishing to Excel Services on SharePoint

Interacting with Other Office Applications

Chapter 38. Saving Time Using the Easy-XL Program

Downloading and Installing Easy-XL

Doing Away with VLOOKUP

Text to Columns on Steroids

Sorting Columns Left to Right

Summarizing Data

Transforming Data Instead of TRIM(), PROPER(), CLEAN()

There’s More

Resource: http://www.amazon.com/gp/product/0789743086?ie=UTF8&tag=wwwitguidetk-20&linkCode=xm2&camp=1789&creativeASIN=0789743086

Posted By : advanced excel trainee

On date : 03.05.11

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time.

If you have never worked with a computer spreadsheet, or had some experience with earlier versions of Excel but need help transitioning, here you can find everything you need to create, edit, format, and print your own worksheets.Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010.

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010.

If you have never worked with a computer spreadsheet, or had some experience with earlier versions of Excel but need help transitioning, here you can find everything you need to create, edit, format, and print your own worksheets.Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

JAVA Tutorial Downloads

SAP Tutorial Downloads

BSD Tutorial Downloads

CPP Tutorial Downloads

ECLIPSE Tutorial Downloads

FIREWALLS Tutorial Downloads

J2EE Tutorial Downloads

J2ME Tutorial Downloads

JBOSS SERVER Tutorial Downloads

Visual Basic ( VB ) Tutorial Downloads

VB.NET & ASP.NET Tutorial Downloads

LINUX Tutorial Downloads

MYSQL Tutorial Downloads

ORACLE Database Tutorial Downloads

PERL Tutorial Downloads

PHP Tutorial Downloads

PYTHON Tutorial Downloads

SOLARIS Tutorial Downloads

SYMBIAN Tutorial Downloads

UML Tutorial Downloads

XML Tutorial Downloads

MAINFRAME Tutorial Downloads

COBOL Tutorial Downloads

SQL Tutorial Downloads

UNIX Tutorial Downloads

WebLogic Server Tutorial Downloads

Photoshop Tutorial Downloads

CCNA Tutorial Downloads

MCSE Tutorial Downloads

System Administration Tutorial Downloads

Flash Tutorial Downloads

Dreamweaver Tutorial Downloads

Fireworks Tutorial Downloads

Web Content Management Tutorial Downloads

osCommerce Tutorial Downloads

Software Testing Tutorial Downloads

Adobe illustrator Tutorial Downloads

SOA Architecture Tutorial Downloads

JSP Tutorial Downloads

JavaFX Tutorial Downloads

GIMP Tutorial Downloads

Multimedia Tutorial Downloads

Networking Tutorial Downloads

C# Tutorial Downloads

Peoplesoft Tutorial Downloads

AutoCAD Tutorial Downloads

HTML Tutorial Downloads

EXCEL Tutorial Downloads

Android Tutorial Downloads

UBUNTU Tutorial Downloads

CATIA Tutorial Downloads

Adobe InDesign Tutorial Downloads

Adobe AIR Tutorial Downloads

ACCESS Tutorial Downloads

SAP Tutorial Downloads

BSD Tutorial Downloads

CPP Tutorial Downloads

ECLIPSE Tutorial Downloads

FIREWALLS Tutorial Downloads

J2EE Tutorial Downloads

J2ME Tutorial Downloads

JBOSS SERVER Tutorial Downloads

Visual Basic ( VB ) Tutorial Downloads

VB.NET & ASP.NET Tutorial Downloads

LINUX Tutorial Downloads

MYSQL Tutorial Downloads

ORACLE Database Tutorial Downloads

PERL Tutorial Downloads

PHP Tutorial Downloads

PYTHON Tutorial Downloads

SOLARIS Tutorial Downloads

SYMBIAN Tutorial Downloads

UML Tutorial Downloads

XML Tutorial Downloads

MAINFRAME Tutorial Downloads

COBOL Tutorial Downloads

SQL Tutorial Downloads

UNIX Tutorial Downloads

WebLogic Server Tutorial Downloads

Photoshop Tutorial Downloads

CCNA Tutorial Downloads

MCSE Tutorial Downloads

System Administration Tutorial Downloads

Flash Tutorial Downloads

Dreamweaver Tutorial Downloads

Fireworks Tutorial Downloads

Web Content Management Tutorial Downloads

osCommerce Tutorial Downloads

Software Testing Tutorial Downloads

Adobe illustrator Tutorial Downloads

SOA Architecture Tutorial Downloads

JSP Tutorial Downloads

JavaFX Tutorial Downloads

GIMP Tutorial Downloads

Multimedia Tutorial Downloads

Networking Tutorial Downloads

C# Tutorial Downloads

Peoplesoft Tutorial Downloads

AutoCAD Tutorial Downloads

HTML Tutorial Downloads

EXCEL Tutorial Downloads

Android Tutorial Downloads

UBUNTU Tutorial Downloads

CATIA Tutorial Downloads

Adobe InDesign Tutorial Downloads

Adobe AIR Tutorial Downloads

ACCESS Tutorial Downloads