Includes the incredibly useful newer functions XLOOKUP, IFS, and TEXTJOIN and over 65 screenshots. For users of Excel 2021 or Excel 365. One of the biggest strengths that Excel has is its wide range of...

From the author of the original Excel Essentials series which has been described as "perfect for Excel newbies."Contains Over 160 Screenshots. For Excel 365 or Excel 2021 Users. Microsoft Excel is an...

Contains Almost 200 Screenshots. For Excel 365 or Excel 2021 Users. Once you've mastered the basics of Microsoft Excel there are a number of additional tools that can take your use of Excel to the next...

If you're going to spend any amount of time working in Excel then you need to learn how to format cells, because inevitably your column won't be as wide as you want it to be or you'll want to have a cell...

Conditional formatting is a way to take a data set and apply special formatting to certain results. It makes it much easier to see patterns as well as sort and filter your data. This book will walk you...

Charts are a great way to visualize data. Sometimes numbers can be overwhelming, but a quick picture based on those numbers makes trends and patterns very clear. This book covers how to work with charts...

Excel's LOOKUP functions are some of the most popular and useful functions in Excel. VLOOKUP has been a staple function for forever, but the new XLOOKUP function is even more powerful and can replace...

Pivot tables are one of the most valuable tools in Microsoft Excel. They let you quickly summarize a large data table and slice and dice that data any way that you want. You can even create a dynamic...

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. Note...

There are plenty of easy-to-use book formatting options out there for self-publishers these days. And if all you want is a basic formatting solution, it's probably best to go with one of those. But if...

If you're going to self-publish, it helps to be able to create your own ad images and book covers. Even if you want to pay for a fancy cover for your main title there are going to be times when you want...

In this book 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...

In PowerPoint for Beginners, M.L. Humphrey introduced readers to the basics of working in Microsoft PowerPoint. Now in PowerPoint 2019 Beginner comes an introductory guide tailored specifically for users...

PowerPoint 2019 Intermediate picks up where PowerPoint 2019 Beginner left off. Here you'll learn how to create slides from an imported Word outline, how to add equations and other more specialized text...

Microsoft Office is one of the most powerful and widely-used software programs in the world. In many settings it is essential to know Microsoft Office in order to succeed in school or work.This guide...

If you've always wanted to learn Access and were a little intimidated, this is the series for you. Microsoft Access is the perfect tool for when you need to combine different sets of information and generate...

In Excel for Beginners, M.L. Humphrey introduced readers to the power of Microsoft Excel. Now in Excel 2019 Beginner comes a guide that is tailored specifically for users of Excel 2019. In this book,...

Excel 2019 Intermediate expands upon the basics taught in Excel 2019 Beginner. Written specifically for users of Excel 2019, this book teaches users how to take their knowledge of Excel to the next level...

In this final book of the Excel Essentials 2019 series, Excel 2019 Formulas and Functions, M.L. Humphrey takes a deeper dive into how formulas and functions work in Microsoft Excel. Learn the difference...

Word 2019 Intermediate expands upon the basics taught in Word 2019 Beginner. Written specifically for users of Word 2019, this book covers more advanced topics such as breaks, styles, tables, track changes,...

In Word for Beginners, M.L. Humphrey introduced readers to the power of Microsoft Word. Now in Word 2019 Beginner, Humphrey presents a guide tailored specifically for users of Word 2019. In this book,...

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...

PivotTables are one of the most powerful analysis tools available in Microsoft Excel. They let a user easily take a large table of data and summarize that data using any combination of fields in the table. Learning...

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....

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,...

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...

In Access for Beginners, M.L. Humphrey introduced readers to the power of Microsoft Access. Now in Access 2019 Beginner comes a guide that is tailored specifically for users of Access 2019. In this book,...

Access 2019 Intermediate starts where Access 2019 Beginner left off. Geared towards users of Access 2019, this book covers more complicated table and query issues such as how to include default values,...

Most self-publishers focus their time and attention on publishing ebooks. And when they do publish in print they tend to use either Word or Vellum or the print option provided by D2D.For those who want...

If you're going to print documents in Word then you need to master page formatting. This includes inserting headers and footers and page numbers, as well as more advanced skills such as the use of page...