AppShopper

Excel Tips & Tricks

       iOS iPhone

This quick and easy tutorial provides the most used tips and tricks for MS Excel 2007.

Outline:
• Change the color of the worksheet tabs
• Counting cell tips
• Define names for cells
• Display cells formulas instead of values
• Display dependents and precedents
• Display statistics from multiple cells
• Execute time and date calculations
• Expand the formula bar
• Implement Conditional Formatting
• Include a header and/or footer
• Insert a comment to a cell
• Insert a line break in a cell
• Insert special characters & symbols
• Keyboard shortcuts for navigating Excel
• Link data from Excel to Word
• Lock and unlock information on worksheet
• Perform multisheet referencing
• Perform relative and absolute cell referencing
• Sort columns of data
• Use paste special
• Verify for errors in the cell formula

What's new

Now compatible with iPhone OS 3.0

Screenshots

	Screenshot 1 of 3

Share with Others

Last changed:

Jul 06, 2010

Category:

Education

Developer:

Amazing eLearning LLC.

Version:

1.2

Average Rating:

3.00 (11)

Size:

1.4 MB

Other Apps By This Developer

• Amazing 123 Number Learn, Trace & Play
• Amazing ABC's Alphabet Learn and Play
• Amazing My First Puzzle - Animals and Fruits
• CSS A to Z
• Chinese Exercise QiGong
• Chinese Exercise QiGong HD
• Frases románticas
• InDesign CS3 Video Training
• Learn QuickBooks Pro 2009
• My First Addition and Subtraction for Kids
• My First Words - Shapes and Fruits
• Newcomer's Guide to Linux HD
• Photoshop CS4 Advanced Video Training
• Tips & Tricks for COD World at War Zombies and Saint's Row 2
• Tips and Tricks for Morton Kombat vs. DC Universe
• Tips and Tricks for Need for Speed: Hot Pursuit
• Tips and Tricks for Pro Evolution Soccer 2011
• U.S. Citizenship Exam Review
• Video Training for Access 2007
• Video Training for CSS Web Design
• Video Training for Corel WordPerfect X3
• Video Training for CorelDraw X3
• Video Training for Dreamweaver CS3
• Video Training for Dreamweaver CS4 HD
• Video Training for Excel 2007
• Video Training for Excel 2007 HD
• Video Training for Excel 2008 (Mac) HD
• Video Training for Flash CS3
• Video Training for Flash CS4 HD
• Video Training for Flex
• Video Training for Illustrator CS3
• Video Training for Illustrator CS3 HD
• Video Training for InDesign CS3 HD
• Video Training for InfoPath 2007 HD
• Video Training for Office Access
• Video Training for Office Accounting
• Video Training for Office Accounting Pro 2008 HD
• Video Training for Office Outlook
• Video Training for Office PowerPoint
• Video Training for Office Word
• Video Training for Outlook 2007
• Video Training for Photoshop CS3 HD
• Video Training for Photoshop CS4 Advanced HD
• Video Training for Powerpoint 2007
• Video Training for Project 2007
• Video Training for Project 2007 HD
• Video Training for Publisher 2007
• Video Training for Publisher 2007 HD
• Video Training for QuarkXPress 8 (iPad version)
• Video Training for QuickBooks Advanced Users
• Video Training for QuickBooks Pro/Premier 2010 Basic Level
• Video Training for Quickbooks 2008 HD
• Video Training for Quickbooks 2009 HD
• Video Training for Quicken Personal Finance
• Video Training for Sony Vegas Movie Studio 8 HD
• Video Training for Visio Pro 2007 HD
• Video Training for Windows 7 Advanced Level
• Video Training for Windows 7 OS
• Video Training for Word 2007
• Video Training for Word 2008 (Mac) HD
• Visio Pro 07 Video Training
• iPiqueo Perú