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