385円 Conditional Formatting is an excellent analysis tool that allows a user to change the formatting of their results when certain criteria are met. For example, the top 10% or values within a specified range. It allows a user to easily visually flag those results that are of most interest. * * * The...

385円 The IF Functions are some of the most powerful functions in Excel. A basic IF or IFS function can allow complex decision tree-style analysis and functions like SUMIFS and COUNTIFS allow you to calculate the sum or count of a series of results only when certain criteria are met. Learning how to ef...

285円 Charts are a fantastic tool for visualizing data. They can let you easily see patterns that a table of numbers doesn’t show. This book covers the most common types of charts, namely bar, column, pie, doughnut, and line charts as well as scatter plots and histograms. * * * The Easy Excel Essential...

550円 The Excel 2019 Formulas and Functions Study Guide is a companion book written to complement Excel 2019 Formulas & Functions by M.L. Humphrey. This guide contains a series of quizzes meant to test a reader’s knowledge of how formulas and functions work in Excel as well as approximately a hundred d...

1,344円 More and more organizations around the globe are expecting that professionals will make data-driven decisions. Employees, team leaders, managers, and executives that can think quantitatively should be in high demand. The goal of this book is to increase ability to identify a problem, collect data...

941円 Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well in the ele...

2,336円 Unlock the full potential of Microsoft Excel with expert tips and techniques. This comprehensive guide, updated for 2021, is designed for Excel users who want to take their skills to the next level. Learn how to streamline your workflow, automate tasks, and solve complex data problems with ease. ...

2,336円 Supercharge your Power BI skills with DAX! This guide empowers Power BI users to master Data Analysis Expressions (DAX), enhancing their Business Intelligence (BI) capabilities in Power BI, Power Pivot, and Excel. Updated for the new Power BI Ribbon interface, this third edition bridges the gap f...

4,611円 While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein--creator of xlwi...

2,324円 Met Microsoft Excel heeft u een gebruiksvriendelijk programma in handen, waarmee u op eenvoudige wijze adressenlijsten, grafieken, urenoverzichten en andere bedrijfsadministratieve modellen kunt opzetten en bijhouden. Op basis van een onderzoek hebben we gekeken welke Excel functionaliteiten door...

1,305円 Microsoft Excel is niet alleen een krachtige rekentool, maar kan ook heel goed gebruikt worden als (eenvoudige) database. In dit boek leert u hoe grote gegevenslijsten te beheren, te analyseren en managementinformatie te genereren. Met name de draaitabel is een krachtig hulpmiddel om vergelijking...

1,305円 Microsoft Excel is een krachtige rekentool met ontelbare mogelijkheden. Het gebruik van formules en functies is hier de basis van. In dit boek leert u onder andere het verschil tussen formules en functies, het gebruik van celnamen in formules, het verschil tussen absoluut en relatief adresseren e...