Tutorial Downloads .com

Home

Microsoft Excel 2010 In Depth advanced complete tutorial book

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

Most used EXCEL Tutorials

Microsoft Excel 2010 In Depth advanced complete tutorial book
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.
Excel 2007 For Dummies tutorial book
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.
MS Excel 2010 Introduction Quick Reference Guide Cheat Sheet Tips Shortcuts
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010.

Latest added EXCEL Tutorials

Microsoft Excel 2010 In Depth advanced complete tutorial book
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.
MS Excel 2010 Introduction Quick Reference Guide Cheat Sheet Tips Shortcuts
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010.
Excel 2007 For Dummies tutorial book
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.