Curso basico de excel

e ecxelOffice 2010: Ultimate Tips and Tricks

Office 2010: Ultimate Tips and Tricks

By: Matt Smith http://smidgenpc.com/ Edited by: Justin Pot

This manual is the intellectual property of MakeUseOf. It must only be published in its original form. Using parts or republishing altered parts of this guide is prohibited.

http://smidgenpc.com | Matt Smith MakeUseOf.com

Page 2

Office2010: Ultimate Tips and Tricks

Table of Contents
Chapter 1: Introduction .......................................................................................................... 4 Welcome to Office 2010 ..................................................................................................... 4 Tips -Incoming!.................................................................................................................... 5 Backward Compatibility ..................................................................................................... 5 Chapter 2: Exploring Backstage ............................................................................................ 6 Customizing the Ribbon...................................................................................................... 6 Collaborate Backstage ...................................................................................................... 8 Fix Those Annoying File Blocks ............................................................................................ 8 Chapter 3: Word!................................................................................................................... 10 Making Repetitive Tasks Quicker ..................................................................................... 10 Learning to Use Building Blocks - Continued .................................................................. 11 Enjoying Word’s Improved Document Search .............................................................. 13 .Doc and .Docx Compatibility......................................................................................... 13 Chapter 4: Excel .................................................................................................................... 15 Present Data at a Glance with Sparklines...................................................................... 15 Groups Save Time.............................................................................................................. 16 Chapter 5: Power Up Powerpoint ....................................................................................... 18 The New Transitions Tab .................................................................................................... 18 Quick Application and Replication of Animations....................................................... 19 Go Beyond Animation with Video .................................................................................. 21 Live Broadcasting .............................................................................................................. 22 Chapter 6: Looking Out for Outlook ................................................................................... 24 SocialGatherings ............................................................................................................... 24 Follow Conversations ......................................................................................................... 25 Find Emails Easily with Search ........................................................................................... 26 Chapter 7:Conclusion .......................................................................................................... 27

http://smidgenpc.com | Matt Smith MakeUseOf.com

Page 3

Office 2010: Ultimate Tips and Tricks

Chapter 1: Introduction
Welcome to Office 2010

There are few names in PC software more iconic than Office. The word itself is generic, but the popularity of Microsoft’s...