SynopsisThis Excel 2013 book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel 2013. Here are just four of the many ways in which this book is unique: The book will equip you with excellent Excel 2013 skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book. Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses. Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book). Each lesson has a sample file that models a real-world business problem. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. From the Back Cover Amongst other things you'll learn how to: Use the new Excel 2013 Flash Fill feature to split and concatenate text Use the new Excel 2013 Apps to add new functionality to worksheets Use the new Excel 2013 Cloud Computing features to share data Use the Versions feature to recover lost data Understand absolute, relative and mixed cell references Create stunning, professional, presentation-quality charts Use the Themes feature to create visually excellent worksheets Use Sparklines to visually represent large data sets Bring your data alive with Visualizations Create custom conditional formatting rules with the Rules Manager Create your own formulas with the Formula Autocomplete feature Master Excel 2013's Fluent User Interface and Ribbon Companies who have taken Smart Method courses include: AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others., This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. Amongst other things you'll learn how to: ¿ Use the new Excel 2013 Flash Fill feature to split and concatenate text ¿ Use the new Excel 2013 Apps to add new functionality to worksheets ¿ Use the new Excel 2013 Cloud Computing features to share data ¿ Use the Versions feature to recover lost data ¿ Understand absolute, relative and mixed cell references ¿ Create stunning, professional, presentation-quality charts ¿ Use the Themes feature to create visually excellent worksheets ¿ Use Sparklines to visually represent large data sets ¿ Bring your data alive with Visualizations ¿ Create custom conditional formatting rules with the Rules Manager ¿ Create your own formulas with the Formula AutoComplete feature ¿ Master Excel 2013¿s Fluent User Interface and Ribbon, Learn Excel 2013 Essential Skills With The Smart MethodWho is this book for?This book provides the fastest possible route to mastering Excel 2013.The book is for Excel 2013 users who are:• Absolute beginners needing to quickly acquire Excel 2013 skills• Moving to Excel 2013 from an earlier version• Self-taught but want to learn the correct professional techniques• Teachers who wish to run Excel 2013 training coursesWhy this book is differentAt The Smart Method we've trained a vast number of people, from all ability levels and backgrounds, to be thoroughly competent with Excel in a single day. Even if they have never seen Excel before!We've used years of experience from our classroom courses to perfect our teaching method. This book uses the same teaching techniques to enable you to master Excel in a fraction of the time needed when learning from conventional text books.This is the book we use to teach our Excel 2013 Essential Skills course. The content of the book has been carefully chosen to cover what it is reasonably possible to learn in one, intensive day's course. All of the most important skills needed in the workplace are covered.What you will learnAmongst other things you'll learn how to:• Use the new Excel 2013 Flash Fill feature to split and concatenate text• Use the new Excel 2013 Apps to add new functionality to worksheets• Use the new Excel 2013 Cloud Computing features to share data• Use the Versions feature to recover lost data• Understand absolute, relative and mixed cell references• Create stunning, professional, presentation-quality charts• Use the Themes feature to create visually excellent worksheets• Bring your data alive with Visualizations• Create custom conditional formatting rules with the Rules Manager• Create your own formulas with the Formula AutoComplete feature• Master Excel 2013's Fluent User Interface and Ribbon
LC Classification NumberHF5548.4.M523