Filter
Excel
Filter
Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel …
Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. …
Formulas and functions are among what Excel does best, and the most commonly used aspect of the program that is in use on 750 million desktops, but with as many as 455 functions …
Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each …
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is …
Excel's VLOOKUP function is useful when merging two data sets and this handy laminated card has all the tips needed to perform it. The tip card first explains how and why VLOOKUP …
Microsoft’s revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used …
Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing …
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business …
Designed for the intermediate Excel user, this handy laminated card has tips for useful functions and customizing all future workbooks with favorite settings. It covers functions …