Easy Excel 365 Essentials

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 that many of the functions covered in this book are functions that were not available in earlier versions of Microsoft Excel, so if you're using a version of Excel prior to Excel 2019, you may want the original IF Functions title that is part of the original Easy Excel Essentials series instead. 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, then you should check out the Excel 365 Essentials titles instead. In this case, 102 Useful Excel 365 Functions which covers many more functions.

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 through the various options for applying conditional formatting to your data.* * *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, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers conditional formatting as well as a number of other topics, such as pivot tables and 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 not only VLOOKUP but also HLOOKUP and potentially other functions such as INDEX and MATCH.* * *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, then you should check out the Excel 365 Essentials titles instead. In this case, 102 Useful Excel 365 Functions which covers many more functions. Note that because this book covers XLOOKUP in detail, if you have an older version of Excel that does not have XLOOKUP, you should instead consider Excel 2019 Formulas & Functions or 50 Useful Excel Functions, which focus on VLOOKUP.

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 with red-colored text or to use bolding or italics or something that isn't Excel's default. That's what this book is for. It's a listing of different things you might want to do to format your data in Excel. 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, then you should check out the Excel 365 Essentials titles instead. In this case, Excel 365 for Beginners which covers formatting as well as a number of other topics, such as sorting and filtering.

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 chart from that data using pivot charts. This book provides a detailed introduction to using pivot tables as well as pivot charts, although it does presume prior familiarity with regular charts in Excel. 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, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers pivot tables as well as a number of other topics, such as charts and conditional formatting.

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 in Excel on a general basis as well as some of the more popular chart types, specifically bar and column charts, pie and doughnut charts, line and area charts, scatter and bubble plots, and histograms.* * *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, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers charts as well as a number of other topics, such as pivot tables and conditional formatting.