Excel 2016 Tables

Data in an Excel worksheet is easier to analyze when formatted as a table. To help you understand tables and their many features, including sorting, filtering, slicers, and calculated columns, Belleyre Books has published a new video. 0:04 Excel 2016 Table from the book Microsoft Excel 2016 In 90 Pages by Beth Brown 0:10 In this … Continue reading Excel 2016 Tables

Excel 2016 The IF Function

Are you trying to create a formula that performs different actions depending on the value in a cell? Then you're in need of the IF function. To help you understand the IF function, nested IF functions, and using other functions in an IF, Belleyre Books has published a new video. 0:03 Excel 2016 The If Function … Continue reading Excel 2016 The IF Function

Excel 2016 Relative, Absolute, and Mixed Cell References

Have you ever created a formula and then have the cell references change unexpectedly when you copied the formula to another cell? It may be a problem with the type of cell references you used in your formula. To help you nail cell references, Belleyre Books has published a new video showing you just how to … Continue reading Excel 2016 Relative, Absolute, and Mixed Cell References

Microsoft Excel 2016 In 90 Pages

The essential guide, Microsoft Excel 2016 In 90 Pages ($8.95/$7.95) is now available at Amazon.com. Perfect for anyone using Microsoft Excel 2016 for Windows. Basic through advanced topics are covered for every level of computer user. Implement formulas, functions, charts, tables, PivotTable reports, and other advanced features. Microsoft Excel 2016 In 90 Pages guides you through … Continue reading Microsoft Excel 2016 In 90 Pages