Excel 2013 Formulas

Download Excel 2013 Formulas PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 1118490452
Total Pages : 864 pages
Book Rating : 4.1/5 (184 download)

DOWNLOAD NOW!


Book Synopsis Excel 2013 Formulas by : John Walkenbach

Download or read book Excel 2013 Formulas written by John Walkenbach and published by John Wiley & Sons. This book was released on 2013-03-13 with total page 864 pages. Available in PDF, EPUB and Kindle. Book excerpt: Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more. Demonstrates how to use all the latest features in Excel 2013 Shows how to create financial formulas and tap into the power of array formulas Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges Includes links to the "Mr. Spreadsheet" website, which contains all the templates and worksheets used in the book, plus access to John Walkenbach's award-winning Power Utility Pak. From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success.

Excel 2013 Formulas - Advanced

Download Excel 2013 Formulas - Advanced PDF Online Free

Author :
Publisher :
ISBN 13 : 9781423222903
Total Pages : 0 pages
Book Rating : 4.2/5 (229 download)

DOWNLOAD NOW!


Book Synopsis Excel 2013 Formulas - Advanced by : BarCharts, Inc

Download or read book Excel 2013 Formulas - Advanced written by BarCharts, Inc and published by . This book was released on 2014-12-31 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Data is only powerful if you know what you are doing with it, use it efficiently, and know how to present it. Excel is the quintessential tool to use your data. Reach power user status with one of our most advanced guides in our Excel series. The guide is based on Excel 2013 and assumes intermediate knowledge of Excel formulas, or that you have used the QuickStudy Excel Formulas guide.

Excel Formulas and Functions For Dummies

Download Excel Formulas and Functions For Dummies PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 0470770244
Total Pages : 332 pages
Book Rating : 4.4/5 (77 download)

DOWNLOAD NOW!


Book Synopsis Excel Formulas and Functions For Dummies by : Ken Bluttman

Download or read book Excel Formulas and Functions For Dummies written by Ken Bluttman and published by John Wiley & Sons. This book was released on 2010-04-15 with total page 332 pages. Available in PDF, EPUB and Kindle. Book excerpt: Put the power of Excel formulas and functions to work for you! Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work. You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well Includes essential coverage of an additional 85 functions In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.

Microsoft Excel 2013 Inside Out

Download Microsoft Excel 2013 Inside Out PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0735674299
Total Pages : 1741 pages
Book Rating : 4.7/5 (356 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel 2013 Inside Out by : Craig Stinson

Download or read book Microsoft Excel 2013 Inside Out written by Craig Stinson and published by Pearson Education. This book was released on 2013-04-15 with total page 1741 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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. Learn how the experts tackle Excel 2013—and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

101 Excel 2013 Tips, Tricks and Timesavers

Download 101 Excel 2013 Tips, Tricks and Timesavers PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 111864218X
Total Pages : 327 pages
Book Rating : 4.1/5 (186 download)

DOWNLOAD NOW!


Book Synopsis 101 Excel 2013 Tips, Tricks and Timesavers by : John Walkenbach

Download or read book 101 Excel 2013 Tips, Tricks and Timesavers written by John Walkenbach and published by John Wiley & Sons. This book was released on 2013-07-01 with total page 327 pages. Available in PDF, EPUB and Kindle. Book excerpt: Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robust applications Draws on John Walkenbach's years of experience using Excel and writing more than 50 books Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables 101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

Microsoft Excel 2013 Plain & Simple

Download Microsoft Excel 2013 Plain & Simple PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0735672687
Total Pages : 939 pages
Book Rating : 4.7/5 (356 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel 2013 Plain & Simple by : Curtis Frye

Download or read book Microsoft Excel 2013 Plain & Simple written by Curtis Frye and published by Pearson Education. This book was released on 2013-04-15 with total page 939 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

101 Most Popular Excel Formulas

Download 101 Most Popular Excel Formulas PDF Online Free

Author :
Publisher : 101 Excel Series
ISBN 13 : 9788409378630
Total Pages : 380 pages
Book Rating : 4.3/5 (786 download)

DOWNLOAD NOW!


Book Synopsis 101 Most Popular Excel Formulas by : John Michaloudis

Download or read book 101 Most Popular Excel Formulas written by John Michaloudis and published by 101 Excel Series. This book was released on 2022-02-17 with total page 380 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, plus Many More! You'll learn to apply the Top Excel Formulas to make your data analysis easier.

Microsoft Excel 2013 Data Analysis and Business Modeling

Download Microsoft Excel 2013 Data Analysis and Business Modeling PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0735681074
Total Pages : 1167 pages
Book Rating : 4.7/5 (356 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel 2013 Data Analysis and Business Modeling by : Wayne Winston

Download or read book Microsoft Excel 2013 Data Analysis and Business Modeling written by Wayne Winston and published by Pearson Education. This book was released on 2014-01-15 with total page 1167 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Microsoft Excel 2013 Functions and Formulas Quick Reference Card (4-Page Cheat Sheet Focusing on Examples and Context for Intermed

Download Microsoft Excel 2013 Functions and Formulas Quick Reference Card (4-Page Cheat Sheet Focusing on Examples and Context for Intermed PDF Online Free

Author :
Publisher :
ISBN 13 : 9781936220779
Total Pages : pages
Book Rating : 4.2/5 (27 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel 2013 Functions and Formulas Quick Reference Card (4-Page Cheat Sheet Focusing on Examples and Context for Intermed by : Beezix

Download or read book Microsoft Excel 2013 Functions and Formulas Quick Reference Card (4-Page Cheat Sheet Focusing on Examples and Context for Intermed written by Beezix and published by . This book was released on 2013-03-26 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: Geared toward the intermediate to advanced Excel 2013 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2013 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Topics include: Controlling Order of Precedence Conditionally Summing/Counting Data (SUMIF, COUNTIF) Being Precise (Rounding functions) Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT) Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) Changing Results: IF, AND, OR, NOT Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) Error Recovery (ISNA, ISERROR) Array Formulas (Single Cell & Multi-Cell Arrays) Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS) Using a Formula for Data Validation Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

Download Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) PDF Online Free

Author :
Publisher : Microsoft Press
ISBN 13 : 0137559399
Total Pages : 1169 pages
Book Rating : 4.1/5 (375 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) by : Paul McFedries

Download or read book Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) written by Paul McFedries and published by Microsoft Press. This book was released on 2022-03-25 with total page 1169 pages. Available in PDF, EPUB and Kindle. Book excerpt: Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier! By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models Replace cumbersome formulas with convenient predefined functions Use modern lookups to make your formulas more powerful and flexible Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021 Use conditional formatting to reveal anomalies, problems, or opportunities Calculate loan payments, interest costs, terms, and amortization schedules Project the future value of investments, and plan to achieve investment goals Master essential discounting and cash-flow analysis tools, including NPV and IRR Sort, filter, and analyze any tabular data, from customers to inventory Easily analyze huge datasets with PivotTable calculations Perform sophisticated what-if analyses, scenario planning, and forecasting Optimize profit, cost, or operational efficiency with Solver About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Microsoft Excel 2010 Inside Out

Download Microsoft Excel 2010 Inside Out PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0735652376
Total Pages : 1711 pages
Book Rating : 4.7/5 (356 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel 2010 Inside Out by : Craig Stinson

Download or read book Microsoft Excel 2010 Inside Out written by Craig Stinson and published by Pearson Education. This book was released on 2010-08-31 with total page 1711 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

101 Best Excel Tips & Tricks

Download 101 Best Excel Tips & Tricks PDF Online Free

Author :
Publisher : 101 Excel Series
ISBN 13 : 9788409385201
Total Pages : 540 pages
Book Rating : 4.3/5 (852 download)

DOWNLOAD NOW!


Book Synopsis 101 Best Excel Tips & Tricks by : John Michaloudis

Download or read book 101 Best Excel Tips & Tricks written by John Michaloudis and published by 101 Excel Series. This book was released on 2022-03-09 with total page 540 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn the Best Excel Tips & Tricks Ever: FORMULAS, MACROS (VBA), PIVOT TABLES, FORMATTING, DATA, MICROSOFT OFFICE 365 plus Many More! With this book, you'll learn to apply the must know Excel features and tricks to make your data analysis & reporting easier and will save time in the process. With this book you get the following: ✔ 101 Best Excel Tips & Tricks To Advance Your Excel Skills & Save You Hours ✔ New Excel Tips & Tricks for Microsoft Office 365 ✔ Easy to Read Step by Step Guide with Screenshots ✔ Downloadable Practice Excel Workbooks for each Tip & Trick ✔ You also get a FREE BONUS downloadable PDF version of this book! ✔ Exclusive to Hardcover: You also get a FREE BONUS 20+ Hour Excel Course with 77 video tutorials! This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Microsoft Excel FAST & stand out from the crowd!

Excel 2013 In Depth

Download Excel 2013 In Depth PDF Online Free

Author :
Publisher : Que Publishing
ISBN 13 : 0133259323
Total Pages : 1247 pages
Book Rating : 4.1/5 (332 download)

DOWNLOAD NOW!


Book Synopsis Excel 2013 In Depth by : Bill Jelen

Download or read book Excel 2013 In Depth written by Bill Jelen and published by Que Publishing. This book was released on 2013-01-08 with total page 1247 pages. Available in PDF, EPUB and Kindle. Book excerpt: Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013’s new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you’ll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!

Ctrl+Shift+Enter Mastering Excel Array Formulas

Download Ctrl+Shift+Enter Mastering Excel Array Formulas PDF Online Free

Author :
Publisher : Tickling Keys, Inc.
ISBN 13 : 1615473297
Total Pages : 443 pages
Book Rating : 4.6/5 (154 download)

DOWNLOAD NOW!


Book Synopsis Ctrl+Shift+Enter Mastering Excel Array Formulas by : Mike Girvin

Download or read book Ctrl+Shift+Enter Mastering Excel Array Formulas written by Mike Girvin and published by Tickling Keys, Inc.. This book was released on 2013-08-01 with total page 443 pages. Available in PDF, EPUB and Kindle. Book excerpt: Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.

Microsoft Excel Functions & Formulas

Download Microsoft Excel Functions & Formulas PDF Online Free

Author :
Publisher :
ISBN 13 :
Total Pages : 397 pages
Book Rating : 4.:/5 (115 download)

DOWNLOAD NOW!


Book Synopsis Microsoft Excel Functions & Formulas by : Bernd Held

Download or read book Microsoft Excel Functions & Formulas written by Bernd Held and published by . This book was released on 2010 with total page 397 pages. Available in PDF, EPUB and Kindle. Book excerpt: Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and lookup and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions. This book's extensive examples make it an excellent tutorial for all Excel users who want to understand, create, and apply formulas. Intermediate and advanced users will find Microsoft Excel Functions & Formulas an excellent reference to many of the program's advanced formulas and functions.

Excel 2013 Bible

Download Excel 2013 Bible PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 1118490304
Total Pages : 1056 pages
Book Rating : 4.1/5 (184 download)

DOWNLOAD NOW!


Book Synopsis Excel 2013 Bible by : John Walkenbach

Download or read book Excel 2013 Bible written by John Walkenbach and published by John Wiley & Sons. This book was released on 2013-02-05 with total page 1056 pages. Available in PDF, EPUB and Kindle. Book excerpt: Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!

Advanced Formulas and Functions Excel 2013

Download Advanced Formulas and Functions Excel 2013 PDF Online Free

Author :
Publisher :
ISBN 13 : 9789792920659
Total Pages : 0 pages
Book Rating : 4.9/5 (26 download)

DOWNLOAD NOW!


Book Synopsis Advanced Formulas and Functions Excel 2013 by : Wahana Komputer

Download or read book Advanced Formulas and Functions Excel 2013 written by Wahana Komputer and published by . This book was released on 2018-11-30 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Perkembangan dunia bisnis saat ini berkembang dengan sangat pesat. Seiring dengan perkembangan dunia bisnis, komputasi dalam hal pengolahan data merupakan sarana yang tergolong vital. Salah satu ujung tombak dunia bisnis adalah sistem laporan keuangan yang baik, teliti, dan rapi. Untuk melengkapi tuntunan dasar, maka microsoft telah meluncurkan versi Microsoft Office Excel. Versi paling baru dari microsoft excel adalah versi 2013. Pada versi yang paling baru, kemampuan komputasi microsoft excel semakin ditingkatkan dari segi tampilan grafis, kecepatan, dan variasi formula yang ditawarkan. Banyak pengguna awam yang belum mengetahui mengenai formula-formula tingkat lanjut yang telah dibenamkan oleh Microsoft Excel. Formula-formula advanced diklaim dapat semakin memudahkan pengguna microsoft excel dalam mengolah data berupa data numerik, string, tanggal, dan waktu. Dengan menggunakan formula-formula advanced yang terdapat pada microsoft excel, memungkinkan sistem pengolahan data yang dilakukan akan semakin cepat, efektif, dan efisien. Lebih lengkap, buku ini akan membahas: 1. Bab 1: Fungsi Advanced Non Numerik 2. Bab 2: Counting dan summing formula 3. Bab 3: Advanced Lookup Function 4. Bab 4: Lebih lanjut dengan advanced lookup function 5. Bab 5: Pivot Table Tentang Penulis Wahana Komputer merupakan lembaga kursus komputer yang didirikan pada tahun 1992. Wahana Komputer kerap bekerja sama dengan berbagai penerbit dalam menyebarluaskan tulisannya mengenai aplikasi dan teknologi terkini. Pada buku Advanced Formulas and Functions Excel 2013, Wahana Komputer bekerja sama dengan Penerbit Andi. Buku ini diterbitkan pada tahun 2013.