The 2011 version of the Microsoft Office productivity suite forthe Mac sports major changes from what Mac users are accustomed to.This soup-to-nuts guide gets the Mac crowd up to date quickly andeasily. Individual minibooks thoroughly cover the Project Gallery,Word, Excel, PowerPoint, Outlook (new for Mac), and the ProjectCenter. You’ll learn how the new Office integrates with theWindows version, how to use and customize the new Ribbon interface,and much more.
With Office 2011 for Mac All-in-One For Dummies,you’ll be ready to use the newest version of Office like apro.
James Gordon is a Microsoft MVP for Macintosh, creator ofthe InsertPicture add-in for Mac PowerPoint, and an Officetrainer.
This friendly book gets you started with the basics of Excel2010, such as creating a spreadsheet from scratch, selectingcommands from the Ribbon, customizing the Quick Access toolbar,creating simple formulas, moving and copying data with drag anddrop, using the AutoCorrect and AutoFill features, and more.
Navigate effectively — see how the Ribbon interface andthe Backstage View give you access to all the tools you need forevery task
Be a mover and a shaker — move and copy data with cut,copy, and paste or drag and drop
Summing up — total columns and rows of numbers with theAutoSum button
Making it pretty — format data tables, adjust columnwidths and row heights, hide columns and rows, and format withStyles or the Format Painter
Safety net — save your work and recover spreadsheets aftera computer crash
Open the book and find:
What's new in Excel 2010
How to surf an Excel 2010 worksheet and workbook
Instructions for entering data in a worksheet
Tips for keeping your data secure
How to enter and edit formulas with built-in functions
Tips for undoing or deleting data entry mistakes
Get comfortable with Excel 2010 and Backstage View
Create and edit spreadsheets
Format cells, create formulas, and fix data entry errors
Copy, cut, move, paste, or delete data