Excel Books

  • BSHMP
    • £34.00
    • RRP £42.50
    • Save £8.50Save 19.000000000000000426325641456060111522674560546875%
    The complete guide to Excel 2019Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.
  • BFXIY
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Take your Excel formulas to the next level with this updatedreference

    John Walkenbach's name is synonymous with excellence in computerbooks that decipher complex technical topics. Known as "Mr.Spreadsheet," Walkenbach provides you with clear explanations onall the methods you can use to maximize the power of Excel withformulas within the frameworks of all the new features ofExcel 2010.

    You'll learn how to create financial formulas, maximize thepower of array formulas, develop custom worksheet functions withVBA, debug formulas, and much more. This invaluable reference isfully updated for the new Microsoft Office release and providescomprehensive formulas coverage, delivering more than 800 pages ofExcel tips, tricks, and techniques you won't find anywhereelse. * Demonstrates how to use all the new features of Excel 2010 tomaximize your formulas * Shows how to develop custom worksheet functions with VBA, debugformulas, create financial formulas, and more * Serves as an indispensable reference no matter your skilllevel * Includes a valuable CD-ROM with sample files, templates andworksheets from the book, plus John Walkenbach's award-winningPower Utility Pak

    Prepare to excel with Excel when you have John Walkenbach andExcel 2010 Formulas by your side!

    Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

  • BKXJN
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Investors recognize that technology is a powerful tool for obtaining and interpreting financial data that could give them the one thing everyone on Wall Street wants: an edge. Yet, many don't realize that you don't need to be a programmer to access behind-the-scenes financial information from Bloomberg, IHS Markit, or other systems found at most banks and investment firms. This practical guide teaches analysts a useful subset of Excel skills that will enable them to access and interpret financial information-without any prior programming experience. This book will show analysts, step-by-step, how to quickly produce professional reports that combine their views with Bloomberg or Markit data including historical financials, comparative analysis, and relative value. For portfolio managers, this book demonstrates how to create professional summary reports that contain a high-level view of a portfolio's performance, growth, risk-adjusted return, and composition. If you are a programmer, this book also contains a parallel path that covers the same topics using C#. Topics include: Access additional data that isn't visible on Bloomberg screens Create tables containing corporate data that makes it possible to compare multiple companies, bonds, or loans side-by- side Build one-page analytic ("Tear Sheet") reports for individual companies that incorporates important financials, custom notes, relative value comparison of the company to its peers, and price trends with research analyst targets Build two-page portfolio summary report that contains a high-level view of the portfolio's performance, growth, risk-adjusted return, and composition Explore daily prices and facility information for most of the tradable corporate bond and loan market Determine the relationship between two securities (or index) using correlation and regression Compare each security's performance to a cohort made of up of securities with similar risk and return characteristics Measure portfolio risk-adjusted return by calculating variance, standard deviation, and Sharpe ratio Use Markit data to identify meaningful trends in prices, new issue spreads, and refinancings
  • BBWYY
    • £30.39
    • RRP £37.99
    • Save £7.60Save 20.00%
    Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations. * Covers Excel 2010 back to Excel 2003 * Shows how to develop consensus on strategy and operational plans with the executive teams * Details steps in creating tactical action plans * Gives step-by-step guidance in creating the most powerful management dashboards * Puts over ten years of experience in one book Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.
  • AGEAA
    • £30.39
    • RRP £37.99
    • Save £7.60Save 20.00%
    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 !
  • BTBEK
    • £30.39
    • RRP £37.99
    • Save £7.60Save 20.00%
    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-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
  • ABIJR
    • £26.19
    • RRP £33.49
    • Save £7.30Save 21.999999999999999005240169935859739780426025390625%
    Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams. With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for: * Exam 77-881: Microsoft Word 2010 * Exam 77-882: Microsoft Excel 2010 * Exam 77-883: Microsoft PowerPoint 2010 * Exam 77-884: Microsoft Outlook 2010 Use the book's easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you've learned hands-on-using the downloadable files for all the book's practice tasks.
  • AGLKY
    • £25.19
    • RRP £31.99
    • Save £6.80Save 21.00%
    Excel is the world's most popular spreadsheet program and the de facto standard for numerical analysis. But this complex program can take a lifetime to learn without the right guide. That's where Excel 2013: The Missing Manual comes in. With crystal-clear explanations, hands-on examples, and lots of undocumented tips, tricks, and workarounds, this jargon-free book helps you master Excel's raft of impressive features. The important stuff you need to know: Go from novice to ace. Learn everything from writing your first formula to analyzing data. Perform a variety of calculations. Enter raw data and have Excel perform financial analyses, math operations, and statistical analyses Illustrate trends. Bring your data to life using charting, summarizing, and data visualization options in the Quick Analysis feature Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Pinpoint the data you need. Use the handy timeline filter to browse specific date ranges in a mass of pivot table data Share your spreadsheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn
  • ARATZ
    • £27.19
    • RRP £33.99
    • Save £6.80Save 20.00%
    Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. * Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel * Create and use formulas that have the power to transform your Excel experience * Leverage supplemental material online, including sample files, templates, and worksheets from the book
  • BFVRJ
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
  • BFYZD
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
  • AFUBH
    • £25.59
    • RRP £31.99
    • Save £6.40Save 20.00%
    Pivot Table Data Crunching: Microsoft(r) Excel(r) 2013 CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours...understand exactly what's going on in your business...take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You'll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. * Create, customize, and change your pivot tables and pivot charts * Transform gigantic data sets into crystal-clear summary reports * Summarize and analyze data even faster with new Excel 2013 recommended pivot tables * Instantly highlight your most (and least) profitable customers, products, or regions * Quickly filter pivot tables using slicers * Use dynamic dashboards using Power View to see exactly where your business stands right now * Revamp analyses on the fly by simply dragging and dropping fields * Build dynamic self-service reporting systems your entire team can use * Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets * Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013
  • AQHDJ
    • £25.59
    • RRP £31.99
    • Save £6.40Save 20.00%
    Excel 2016 In Depth Full Color: Figures and code appear as they do in Excel 2016 Beyond the Basics...Beneath the Surface...In Depth Do more in less time! Experienced with Excel? Don't let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016's full power and updated interface. You'll discover how to leverage Excel's new tools for charting, business analysis, data visualization, forecasting, and more. * Quickly clean your data with Excel 2016's powerful Get & Transform tools * Discover Excel 2016's newest charts: waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker * Use Forecast Sheets to forecast the future, including seasonal adjustments * Pivot data on maps with 3D Maps, and animate your maps over time * Create formulas, charts, subtotals, and pivot tables faster than ever * Create amazing PowerPivot data mashups that integrate information from anywhere * Automate repetitive functions using Excel macros * Solve real-world business intelligence analysis problems * Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP * Share workbooks on the Web and social networks * Leverage Excel to create highly interactive web pages and online surveys * Quickly apply attractive, consistent formats This book is part of Que's Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.
  • BAVMI
    • £31.79
    • RRP £37.99
    • Save £6.20Save 15.99999999999999971578290569595992565155029296875%
    Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. * Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools * Reveals how to target and retain profitable customers and avoid high-risk customers * Helps you forecast sales and improve response rates for marketing campaigns * Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising * Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.
  • BTBGI
    • £23.99
    • RRP £29.99
    • Save £6.00Save 20.00%
    The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need
  • BTOEY
    • £23.99
    • RRP £29.99
    • Save £6.00Save 20.00%
    Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly 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
  • BTOHH
    • £23.99
    • RRP £29.99
    • Save £6.00Save 20.00%
    Excel(R) 2019 PIVOT TABLE DATA CRUNCHING CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2019 PIVOT TABLES! Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what's going on in your business... take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else! - Create, customize, and change pivot tables - Transform huge data sets into clear summary reports - Analyze data faster with Excel 2019's new recommended pivot tables - Instantly highlight your most profitable customers, products, or regions - Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map - Use Power View dynamic dashboards to see where your business stands - Revamp analyses on the fly by dragging and dropping fields - Build dynamic self-service reporting systems - Combine multiple data sources into one pivot table - Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot - Automate pivot tables with macros and VBA About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will - Dramatically increase your productivity-saving you 50 hours a year or more - Present proven, creative strategies for solving real-world problems - Show you how to get great results, no matter how much data you have - Help you avoid critical mistakes that even experienced users make Bill Jelen is MrExcel, the world's #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.
  • BTALA
    • £22.39
    • RRP £27.99
    • Save £5.60Save 20.00%
    Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!
  • ANBHI
    • £29.49
    • RRP £34.99
    • Save £5.50Save 14.99999999999999914734871708787977695465087890625%
    Master VBA automation quickly and easily to get more out ofExcel

    Excel VBA 24-Hour Trainer, 2nd Edition is thequick-start guide to getting more out of Excel, using Visual Basicfor Applications. This unique book/video package has been updatedwith fifteen new advanced video lessons, providing a total ofeleven hours of video training and 45 total lessons to teach youthe basics and beyond. This self-paced tutorial explains Excel VBAfrom the ground up, demonstrating with each advancing lesson howyou can increase your productivity. Clear, concise, step-by-stepinstructions are combined with illustrations, code examples, anddownloadable workbooks to give you a practical, in-depth learningexperience and results that apply to real-world scenarios.

    This is your comprehensive guide to becoming a true Excel poweruser, with multimedia instruction and plenty of hands-onpractice. * Program Excel's newest chart and pivot table object models * Manipulate the user interface to customize the look and feel ofa project * Utilize message boxes, input boxes, and loops to yieldcustomized logical results * Interact with and manipulate Word, Access, PowerPoint, andOutlook from Excel

    If you're ready to get more out of this incredibly functionalprogram, Excel VBA 24-Hour Trainer, 2nd Edition provides theexpert instruction and fast, hands-on learning you need.

  • BBZZE
    • £19.99
    • RRP £24.99
    • Save £5.00Save 20.00%
    The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. * Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions * Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse * Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
  • AUQVB
    • £19.99
    • RRP £24.99
    • Save £5.00Save 20.00%
    Learn all of Excel's statistical tools Test your hypotheses and draw conclusions Use Excel to give meaning to your data Use Excel to interpret stats Statistical analysis with Excel is incredibly useful and this book shows you that it can be easy, too! You'll discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and more. Tackle the technical aspects of Excel and start using them to interpret your data! Inside...* Covers Excel 2016 for Windows(R) & Mac(R) users * Check out new Excel stuff * Make sense of worksheets * Create shortcuts * Tool around with analysis * Use Quick Statistics * Graph your data * Work with probability * Handle random variables
  • AGHCN
    • £24.89
    • RRP £29.49
    • Save £4.60Save 15.0000000000000005684341886080801486968994140625%
    Your guide to quickly turn data into results. NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software. Transform your skills, data, and business - and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel(R) 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results - no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint(R)
  • BAPAV
    • £17.59
    • RRP £21.99
    • Save £4.40Save 20.00%
    See your way to Excel spreadsheet stardom with this visual guide If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time! Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel! * Tutorials and step-by-step screenshots make lessons easy to follow and understand * Helps you grasp the basic functions of Excel and beyond * Walks you through Excel s new features * Clearly demonstrates how to organize, present, analyze, and chart data with Excel Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.
  • AYPDQ
    • £17.59
    • RRP £21.99
    • Save £4.40Save 20.00%
    A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. * Demonstrates how Power Query is used to discover, connect to, and import your data * Shows you how to use PowerPivot to model data once it's been imported * Offers guidance on using these tools to make analyzing data easier * Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life and work easier.