The IF functions are some of the most powerful functions in Microsoft Excel. With IF, IFS, COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS you can perform almost any conditional calculation you want.* * *This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.If you want a more general introduction to Excel, the...

Microsoft Excel is an incredibly powerful program that allows for the storage and manipulation of vast amounts of data. From the author of the Excel Essentials series this short book highlights some of the most valuable shortcuts and tricks to know. Such as how to have multiple lines of text in a cell, how to keep a row or column visible on the screen at all times, how to print with a repeating row or column on each page, and more.If you want to really learn Excel from the ground u...

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 effectively use the IF Functions can save a substantial amount of time and effort as well as supporting more complex decision-making and analysis.* * *The Easy Excel Essent...

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 Essentials 2019 series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functio...

My life turned upside down when Uncle Fred showed up at our door one bright spring day. "Heard you needed someone to take care of Mike for a couple of weeks?" He told my parents.It was only supposed to be for two weeks, but by the end of the first week I wanted to spend the rest of the summer with Uncle Fred. Sure, he lured me there on a pretext, but he got more than he expected when Julie became part of my life. Our mothers would have really been upset to hear that we'd spent two ...

Microsoft Excel is an incredibly powerful tool, both for business and personal use. From budgeting to data analysis, it can do it all.But sometimes learning Excel can be a little overwhelming. It's so powerful, it's hard to know where to focus. That's where this book comes in. It gives you what you need to know to use Excel on a day-to-day basis.It covers the absolute basics of navigating Excel and inputting information, but also covers formatting, filtering, sorting, basic...

So you wrote a book. Congratulations.Now, if you're like a lot of us, you want to sell that book. You're ready to try to become a professional author.This book is meant to help you navigate that next stage of your writing career regardless of whether you want to find a publisher or self-publish. It will give you a high-level discussion of what you need to start thinking about now regardless of the path you choose.

M.L. Humphrey draws upon twenty years of experience with regulatory compliance, and AML compliance in particular, as both a regulator of broker-dealers and a consultant to some of the largest financial institutions in the world, to give an overview of the main AML compliance requirements, with a particular focus on customer identification and suspicious activity monitoring and reporting.This book is meant to be a high-level overview of AML compliance requirements, which means it fo...

We live in a regulated world. And for someone whose role is in regulatory compliance or regulatory enforcement knowledge is often gained on an ad hoc basis through trial and error, via on the job training, or through conversations with others in a similar role.In Regulatory Compliance Fundamentals M.L. Humphrey has taken twenty years of experience as a regulator and a consultant in the financial services industry and boiled it down to the basic fundamental principles every individu...

These days the business world is full of talk about data science, big data, and how data analysis can transform your business.And it's absolutely true that collecting the right information, in the right way, analyzing that information, and then using it effectively to manage your business can give your business a competitive edge.But most businesses don't need to go so far as big data and data science. They just need to understand and implement some basic steps for gathering the right info...

Conditional formatting is an easy way to flag results that you need to pay special attention to such as duplicate values, your top ten results, or outcomes that are in your preferred range.* * *The Easy Excel Essentials series of titles are meant to cover one specific topic that is excerpted from the main Excel Essentials series. This content was taken from Intermediate Excel which also covers pivot tables, charts, and more.

Microsoft PowerPoint is a great program for presenting information to an audience. It has a number of incredibly useful tools and templates that allow a new user to quickly and easily create a professional-level presentation.PowerPoint Essentials 2019 contains two titles, PowerPoint 2019 Beginner and PowerPoint 2019 Intermediate, which combined are designed to take a new PowerPoint user from beginner to an advanced intermediate level using a straight-forw...