474 products were found matching your search for Microsoft Excel 2019 in 3 shops:

Fairly worn, but readable and intact. If applicable: Dust jacket, disc or access code may not be included.

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

The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots 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 Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines Visualize data with 3D maps, funnel charts, and other powerful tools  Import, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power Query Build powerful data models and use them in business intelligence  Look up just the tasks and lessons you need

Emerging from numerous Excel courses, this book is not a collection of material, but a proper training book. It lead you to working with Excel from the beginning with many exercises. As it progresses step by step in the material, advanced exercises and applications are finally achieved. So also suitable for self-study! Completely colored printed! From the content: basics tables and workbooks, formula and coordinates, the function assistant, invoice, comment, calculations with date, a budget planning, expect interest, credit with PMT, advanced formatting (hide, templates ...), evaluate a test series (mean value ....), create a diagram, advanced applications: travel expensescurrency table, score evaluation with VLOOKUP, monthly salaries with bonuses, logic with conditions If-then, trend calculation, pivot table, external data, protect data...

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.  Solve real business problems with Excel—and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics  Use PowerQuery or Get & Transform to connect, combine, and refine data sources  Leverage Office 365’s new Geography and Stock data types and six new functions   Illuminate insights from geographic and temporal data with 3D Maps  Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts  Use Excel trend curves, multiple regression, and exponential smoothing  Delve into key financial, statistical, and time functions  Master all of Excel’s great charts  Quickly create forecasts from historical time-based data  Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams  Run Monte Carlo simulations on stock prices and bidding models  Learn about basic probability and Bayes’ Theorem  Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook  Automate repetitive analytics tasks by using macros

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables.    Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 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.  By reading this book, you will:  · Master easy, powerful ways to create, customize, change, and control pivot tables  · Control all future pivot tables using new pivot table defaults  · Transform huge data sets into clear summary reports  · Instantly highlight your most profitable customers, products, or regions  · Use Power Query to quickly import, clean, shape, and analyze disparate data sources  · Build geographical pivot tables with 3D Map  · Construct and share state-of-the-art dynamic dashboards  · Revamp analyses on the fly by dragging and dropping fields  · Build dynamic self-service reporting systems  · Share your pivot tables with colleagues  · Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365  · Automate pivot tables with macros and VBA  · Save time by adapting reports with GetPivotData  · Discover today’s most useful pivot table tips and shortcuts   

paperback/cd-rom edition. 1038 pages. 9.00x7.00x2.25 inches. In Stock.

Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.    Use Excel 2019 and Office 365 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 the latest improvements to arrays, formula error handling, and statistics. 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  · Radically simplify complex calculations with Office 365’s new dynamic arrays  · 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 net present value and internal rate of return  · Sort, filter, and analyze tabular data, from customers to inventory  · Easily analyze huge data sets with PivotTable calculations    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 

Like New condition. Great condition, but not exactly fully crisp. The book may have been opened and read, but there are no defects to the book, jacket or pages. 0.66

Conquer Microsoft Excel 2019–from the inside out! Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarize millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualization techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excel’s new artificial intelligence Collaborate via Excel 2019’s breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data

Paperback 100% of proceeds go to charity! Good condition with all pages in tact. Item shows signs of use and may have cosmetic defects.

The Benchmark Series is designed for students to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving, which challenge students to execute strategies they will encounter in today's workplace. Complete course content is delivered in the Cirrus learning environment through a series of scheduled assignments that report to a grade book to track student progress and achievements.

The Benchmark Series is designed for students to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving, which challenge students to execute strategies they will encounter in today's workplace. Complete course content is delivered in the Cirrus learning environment through a series of scheduled assignments that report to a grade book to track student progress and achievements.

The Benchmark Series is designed for students to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving, which challenge students to execute strategies they will encounter in today's workplace. Complete course content is delivered in the Cirrus learning environment through a series of scheduled assignments that report to a grade book to track student progress and achievements.

The Benchmark Series is designed for students to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving, which challenge students to execute strategies they will encounter in today's workplace. Complete course content is delivered in the Cirrus learning environment through a series of scheduled assignments that report to a grade book to track student progress and achievements.

For courses covering introductory Microsoft® Excel™. Beyond point-and-click The Exploring Microsoft® Office 365® series moves students beyond rote tasks to a deeper comprehension of how, when, and why to apply Office skills. A market leader for over 20 years, the collection helps students achieve high-level learning outcomes by engaging them in the way they learn best – through hands-on practice. A dozen exercises in each chapter range from multiple-choice questions to open-ended projects. Revised to reflect Microsoft Office 365, the 2019 edition is Mac compatible and adds new critical thinking assignments to help students build fundamental 21st-century skills. Also available with MyLab IT By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek. Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information. If you would like to purchase both the physical text and MyLab IT, search for: 0135825288 / 9780135825280 Exploring: Microsoft Excel 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e Package consists of: 0135402468 / 9780135402467 MyLab IT with Pearson eText -- Access Card -- for Exploring Microsoft Office 2019, 1/e 0135452759 / 9780135452752 Exploring Microsoft Office Excel 2019 Comprehensive, 1/e

Introduce your students to the latest advancements that Microsoft Office and Excel have to offer with MICROSOFT OFFICE 365 & EXCEL 2019 -- new to the acclaimed Shelly Cashman Series. MICROSOFT OFFICE 365 & EXCEL 2019 continues the series' strong history of innovation with a hallmark learning approach enhanced to address the varied learning styles of today's students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought, and personalization. This new edition and accompanying resources are designed to engage readers and improve retention while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Exact ISBN match. Immediate shipping. No funny business. Pics available upon request.

Now students can master the nuances of Microsoft Office quickly with ILLUSTRATED MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE, part of today's popular Illustrated Series. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Develop the Microsoft Office 365 and Excel 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE demonstrates the importance of what students are learning while strengthening your skills and helping students transfer those skills to other applications and disciplines for further success. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.