Teach Yourself Visually Excel 2013

The step-by-step, visual way to learn Excel 2013 Excel can be complicated, but this Visual guide shows you exactly how to tackle every essential task with full-color screen shots and step-by-step instructions. You'll see exactly what each step should look like as you learn to use all the new tools in this latest release of the world's most popular spreadsheet program. In easy two-page lessons, author Paul McFedries shows you how to organize, present, analyze, and chart data, over the web or on a network. The Visual learning system is perfect for teaching Excel; previous editions of this book have sold more than 230,000 copies Covers common Excel 2013 tasks such as creating spreadsheets and charts, filtering and sorting data, and working with PivotTables Provides step-by-step instructions for each task Each step is illustrated with full-color screenshots Teach Yourself VISUALLY Excel 2013 offers visual learners the ideal way to master this popular but complex spreadsheet program.

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including: * Using the Ribbon and galleries * Entering data and resizing columns * Applying formulas and functions * Formatting worksheets * Adding clip art and 3D effects * Interpreting data with charts * Helpful sidebars offer practical tips and tricks * Succinct explanations walk you through step by step * Full-color screen shots demonstrate each task * Two-page lessons break big topics into bite-sized modules

Get the basics of Excel and then go beyond with this new instructional visual guide While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more. Offers step-by-step instructions on a variety of tasks, some everyday and some more unique Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.

Learn the new Microsoft Office suite the easy, visualway Microsoft Office 2013 is a power-packed suite of officeproductivity tools including Word, Excel, PowerPoint, Outlook,Access, and Publisher. This easy-to-use visual guide covers thebasics of all six programs, with step-by-step instructions andfull-color screen shots showing what you should see at each step.You'll also learn about using Office Internet and graphics tools,while the additional examples and advice scattered through the bookgive you tips on maximizing the Office suite. If you learn bestwhen you can see how things are done, this book is for you. Shows you how to use Microsoft Office 2013 with easy-to-follow,step-by-step instructions illustrated with full-color screenshots Covers Word, Excel, PowerPoint, Outlook, Access, andPublisher Includes additional information on using Office Internet andgraphics tools Designed to help visual learners read less and learn more Teach Yourself VISUALLY Office 2013 shows you how to useall six tools in the Office suite, step by step.

The complete visual reference on Excel basics Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You'll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document. This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks. Features beginning, intermediate andadvanced visual coverage of Excel 2010 Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks You're encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.

The easy, visual way to learn this popular database program Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you'll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more. While it is the most widely used database application, Access is not particularly intuitive; the Visual system's two-page lessons and full-color screen shots make this complex software easier to learn Concise, step-by-step instructions and clear illustrations show you exactly what to expect Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.

Get up to speed on the newest version of Word with visual instruction Microsoft Word is the standard for word processing programs, and the newest version offers additional functionality you'll want to use. Get up to speed quickly and easily with the step-by-step instructions and full-color screen shots in this popular guide! You'll see how to perform dozens of tasks, including how to set up and format documents and text; work with diagrams, charts, and pictures; use Mail Merge; post documents online; and much more. Easy-to-follow, two-page lessons make learning a snap. Full-color, step-by-step instructions show you how to perform all the essential tasks of Microsoft Word 2013 Explains how to set up and format documents, edit them, add images and charts, post documents online for sharing and reviewing, and take advantage of all the newest features of Word Previous editions have sold more than 220,000 copies The Visual learning system makes it easy to learn more while reading less Teach Yourself VISUALLY Word 2013 helps you master the most popular word processing program quickly, easily, and visually.