Learn how to use the advanced features of Excel 2013 and get into the more advanced features of Excel 2013. Excel 2013 is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive - and better information leads to better decision making! Topics Covered Include:* Use SmartArt and other objects in worksheets* Trace precedent cells and dependent cells, as well as use other auditing tools* Create and work with charts* Create Pivot Tables and Pivot Charts * Record and run macros* Solve formula errors* Use What If Analysis tools* Use tools to manage rows, columns, duplicates, and validation* Group and outline data

"Maps to Microsoft Office Specialist (MOS) exam objectives for Excel 2013. Realistic, hands-on exercises. Downloadable ancillaries at 30bird.com"--Cover.

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here’s WHAT You’ll Learn Manage your data quickly and efficiently Filter, sort, summarize, and crunch your numbers Use formulas and functions to do the heavy lifting Bring data to life with charts and graphics Share data between Microsoft Office documents Work as a team, online and in the cloud Here’s HOW You’ll Learn It Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away

In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft. You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow. By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.