Natural Gas Accounting Handbook

Get up to speed on Excel 2010 and discover a whole new way to crunch numbers!

Have you just discovered you need to use Excel for the first time? Or are you an Excel veteran who wants to understand the 2010 version in a hurry? Either way, this friendly book has everything you need to know about creating and editing worksheets, formatting cells, using formulas, adding hyperlinks, saving worksheets as Web pages, and more.

• Navigate effectively - see how the Ribbon interface andthe Backstage View give you access to all the tools you need for every task

• It's your Excel - customize the Ribbon and Quick Access toolbar to include the tools you use

• To err is human - but you can easily fix mistakes and make updates with Excel's editing functions

• Easy maintenance - make maintaining your worksheets easier with zoom, comments, cell names, and more

• Pivotal moments - create and format pivot tables to summarize your data effectively

• Making it pretty - include graphics, charts, and clip art to clarify the story your worksheets tell

• Macro magic - automate Excel commands by creating macros you can add to the Ribbon or Quick Access toolbar

• Collaborate online - share your worksheets via Windows Live SkyDrive and edit them from anywhere with Office Web Apps

Open the book and find:

• What's new in Excel 2010, including the Backstage View

• How to launch Excel fromWindows 7, Windows Vista,and Windows XP

• Tips for drag-and-drop editing

• Hints for perfect printouts

• How to use the Insert Function button

• Secrets for securing your data

• How to use Conditional Formatting and Sparklines minigraphs to highlight your data

• How to do "what-if" data analysis

Learn to:

• Create and edit worksheets, format cells, and enter formulas

• Add data tables and sort and filter records

• Create powerful charts with graphics

• Share worksheets via e-mailand SharePoint