Books by M L Humphrey

Track changes is a great tool for working collaboratively in Word and almost essential for identifying and discussing changes to a document in a group setting. But in order to use it effectively, you have to understand it. And that's what this guide will do for you.The Easy Word Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Word and are drawn from the Word Essentials series which consists of Word for Beginners and Intermediate Word.

Tables are an incredibly useful tool to use in Microsoft Word. They allow you to easily organize and display data and information. This guide covers how to use them, including formatting them and sorting data stored in them.The Easy Word Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Word and are drawn from the Word Essentials series which consists of Word for Beginners and Intermediate Word.

If you're going to use Word in a professional setting, chances are at some point you'll need to master how to insert numbered and bulleted lists. This guide covers the basis of doing so as well as how to use multi-level lists in Word.The Easy Word Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Word and are drawn from the Word Essentials series which consists of Word for Beginners and Intermediate Word.

If you want to print a document from Word, chances are you'll need to know how to format that document including adding headers, footers, and page numbering. This guide covers that as well as page and section breaks and more.The Easy Word Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Word and are drawn from the Word Essentials series which consists of Word for Beginners and Intermediate Word.

One of the key skills you need to master to effectively use Microsoft Word is how to format text and paragraphs--such as changing your font or font size, bolding, italicizing, or underlining text, or changing the alignment or spacing of a paragraph. This guide covers all of that as well as how to use Styles and the Format Painter.The Easy Word Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Word and are drawn from the Word Essentials series which consists of Word for Beginners and Intermediate Word.

Knowing how to print documents that you've created in Excel is an essential skill.Think how many pieces of paper have been wasted over the years because someone didn't know how to format an Excel document for printing. Or how many people have had to sit there and hold a second page with just one last column on it up to the first page to see the row labels for the data table they printed.These mistakes can be avoided if you just understand the basics of printing in Excel.In this guide you'll learn how to print a header row or identifying column on each page, how to scale your document so that you never have one column or one row that prints on an extra page all by itself, how to add page numbers to your documents, and much much more.It's not hard to master and it's well worth learning. So do it today.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions. In that series, printing is covered in Excel for Beginners.

It's not enough to enter information into Excel. If you really want to work effectively with your data, you need to format it.That could mean anything from adding borders to adding fill color in the header row of a table to simply formatting your numbers as currency or percentages.So if you're ready to learn how to format the data you enter into Excel, then this is the guide for you. It'll show you how to do all of that and more with clear, easy to follow instructions.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions. In that series, formatting is primarily covered in Excel for Beginners.

The IF functions are some of the most powerful functions in Excel.A basic IF function lets you build a simple decision tree so that you have one outcome under one set of circumstances and another outcome if those circumstances aren't met. You can then nest IF functions to make a multi-level decision tree that covers as many different scenarios as you want. (Or close to it.)Then there are the COUNTIFS, SUMIFS, and AVERAGEIFS functions that let you count, sum, or average a list of values, but only when your specified conditions are met.Want to know how many customers you have in Nevada who bought widgets and spent over $50? You can do that.Want to know how much you sold to those customers? You can do that, too.And want to know what each one spent on average? Yep, that too.So what are you waiting for? Learn the power of the IF functions today.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, IF functions are covered in 50 Useful Excel Functions.

Charts are a fantastic way to visualize your data. They add a level to your analysis that just isn't possible with data tables and number-crunching.Plus, they're great for presentations where you need to show someone else what you're talking about.And they're easy to learn and use in Excel.So what are you waiting for?Learn how to use column, bar, pie, doughnut, and scatter charts today.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions. In that series, charts are covered in Intermediate Excel.

Have you ever wanted to flag results in a data table that matched your criteria? Or wanted to see just by glancing which result in a list of values was the largest value or the smallest value? That's what conditional formatting will let you do.Conditional formatting allows you to take a range of cells and highlight those that are above or below a certain value. Or to add icons or bars or colored shading to a cell to show which are your largest or smallest values.And you can either let Excel determine where to apply those criteria or you can set your own.Once you learn how to use conditional formatting you will see just how powerful it is for analyzing data. So don't hesitate. Learn about conditional formatting today.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions. In that series, conditional formatting is covered in Intermediate Excel.

Pivot Tables are one of the most powerful tools in Excel. They allow you to easily take a large amount of data and summarize or analyze that data in mere moments.If you don't know how to use Pivot Tables yet, you need to learn them.This guide will walk you through them step-by-step in an easy, clear, straight-forward manner.The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, pivot tables are covered in Intermediate Excel.

A mail merge is a great time-saver for when you need to print out a series of personalized letters, envelopes, or mailing labels. This introductory guide to mail merge will walk you through how to use Microsoft Word and an Excel-based list to create a customized letter, envelope, or mailing label.The guide is written using Office 2013 and assumes a basic understanding of Microsoft Word and Microsoft Excel. If you're not familiar with one or the other, you should probably start with Word for Beginners and/or Excel for Beginners first.