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 Excel 2013¿s new data model feature to create table relationships ¿Master dynamic tables and structured table references ¿Completely understand Excel 2013¿s new ability to create OLAP cubes ¿Use Excel 2013¿s new OLAP Pivot Tables to present OLAP cube data ¿Perform What-If analysis to model and compare business scenarios ¿Record macros and then execute them from button controls ¿Create intuitive user interfaces using form controls ¿Enforce complex business rules using function-driven custom validations ¿Use advanced functions to solve real-world business problems ¿Understand and use all of Excel¿s security features ¿Use Excel 2013¿s new timeline slicers to quickly filter date ranges ¿Create and use dynamic and table-based range names

This book is suitable for both Excel beginners and seasoned experts. In this Excel 2016 book you'll learn how to use and apply advanced Excel skills to construct a robust Excel business application that would be well beyond the powers of most advanced Excel users. Even if you only have very basic Excel skills, the book is designed in such a way that you'll be able to construct a complex, polished professional Excel 2016 application. In constructing this project you'll discover new and interesting ways to use many of Excel 2016's more powerful and complex features. This book will teach you best-practice when applying your Excel skills to large real-world projects. This book won't only teach you Excel skills. You'll also learn a best-practice design and development methodology that will stand you in good stead when working on future Excel projects. What you will learn Most Excel tutorials and reference books teach how to use individual Excel features but don't show how you can combine them into a robust and complex Excel application. In this book you will combine 80 key Excel skills to produce a single advanced Excel application. Here are just a few of the skills you'll use: Create a custom color set. Use custom formats. Use Spin Button and Check Box form controls. Define named ranges and named cells. Use the Name Manager to view, delete and edit range names. Create a drop-down list using a list validation. Use and understand the practical use of over 20 Excel functions including VLOOKUP, COUNTIF, DAY, MONTH, DATE, IFERROR, CHAR, IF, IFERROR, LEN, MOD, ROW, TEXT and WEEKDAY. Understand date serial numbers. Understand precedence rules. Format date serial numbers using a custom format. Create a formula-driven conditional format. Use the conditional format Rules Manager. Calculate the correct date (in any year) for Martin Luther King Day, President's Day, Labor Day, Columbus Day, Thanksgiving Day, New Year's Day, Independence Day, Christmas Day and Veterans Day, Easter Sunday and Memorial Day. Use structured table references. Concatenate text. Calculate the phases of the moon using Synodic Months and the MOD function. Create user-friendly validation error messages. Use Smart Tags. Lock cells, hide columns, hide entire worksheets and protect worksheets to prevent users from making unwanted changes. 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, The British Museum, The National Gallery, Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functions-or write your own-and carry out complex calculations Use rich charting and graphic capabilities to visualize data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share and collaborate with others-while managing sensitive data Link and embed Excel data into other documents Create macros with Microsoft Visual Basic for Applications Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support

Data Science gets thrown around in the press like it'smagic. Major retailers are predicting everything from when theircustomers are pregnant to when they want a new pair of ChuckTaylors. It's a brave new world where seemingly meaningless datacan be transformed into valuable insight to drive smart businessdecisions. But how does one exactly do data science? Do you have to hireone of these priests of the dark arts, the "data scientist," toextract this gold from your data? Nope. Data science is little more than using straight-forward steps toprocess raw data into actionable insight. And in DataSmart, author and data scientist John Foreman will show you howthat's done within the familiar environment of aspreadsheet. Why a spreadsheet? It's comfortable! You get to look at the dataevery step of the way, building confidence as you learn the tricksof the trade. Plus, spreadsheets are a vendor-neutral place tolearn data science without the hype. But don't let the Excel sheets fool you. This is a book forthose serious about learning the analytic techniques, the math andthe magic, behind big data. Each chapter will cover a different technique in aspreadsheet so you can follow along: Mathematical optimization, including non-linear programming andgenetic algorithms Clustering via k-means, spherical k-means, and graphmodularity Data mining in graphs, such as outlier detection Supervised AI through logistic regression, ensemble models, andbag-of-words models Forecasting, seasonal adjustments, and prediction intervalsthrough monte carlo simulation Moving from spreadsheets into the R programming language You get your hands dirty as you work alongside John through eachtechnique. But never fear, the topics are readily applicable andthe author laces humor throughout. You'll even learnwhat a dead squirrel has to do with optimization modeling, whichyou no doubt are dying to know.

Friendly advice on leveraging the power of the new Nexus 7 Google tablet! The arrival of the new Nexus 7 Google tablet is eagerly awaited, thanks to its cutting-edge software, top-notch hardware, unprecedented abilities, and nine-hour battery life. This easy-to-understand, engaging guide covers everything you need to know about this amazing Android tablet. Bestselling Dummies author Dan Gookin uses his friendly writing style to deliver clear instructions for setting up, navigating, and using the device. You'll learn to use all your favorite Google applications that come loaded on the device, personalize it, and much more. Walks you through the touchscreen, wireless access, and software updates Demonstrates how to download, shop for, and fill your Nexus 7 with movies, e-books, games, and music Helps you keep on top of your schedule and appointments and pursue your interests and hobbies with the latest apps and websites Offers guidance on using your device to navigate from here to there and stay connected with friends and family while you're away Nexus 7 For Dummies is an essential companion to your other new companion: the Nexus 7!

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

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in