Excel 2016 Advanced
Publisher: Bookboon
Published: 2016
ISBN-13: 9788740311990
Table of contents: title: Content; title: Apply Conditional Logic in formula; title: IF Function (IF Statement); title: Nested IF Function; title: Countif Function; title: Sumif Function; title: Create and apply Range Names; title: Defining a Named Cell or Range of Cells; title: Using a Named Cell in a formula; title: Naming a range of cells; title: Editing and renaming a named range; title: Define a Name Using the Dialogue Box; title: Charts; title: Using Quick Analysis; title: Recommended Charts; title: Creating charts with the keyboard; title: Creating line charts; title: Creating and editing a column chart; title: Creating pie charts; title: Modifying charts using the Ribbon; title: Modifying charts using icons; title: Formatting charts – Task Pane; title: Apply and manipulate illustrations; title: Pictures in Excel; title: Resize the picture – dragging; title: Modify a picture; title: Reset a picture; title: SmartArt; title: SmartArt; title: Shapes; title: Inserting shapes into a workbook; title: Screenshots; title: Inserting a screenshot; title: Manage comments; title: Inserting and editing comments; title: Deleting comments; title: Show/Hide Comments; title: Moving between comments; title: Printing comments; title: Sorting data; title: Databases in Excel – introduction; title: Sort data; title: Sort on font colour; title: Sort on cell colour; title: Sort on cell icon; title: Filtering data; title: Filter data – the filter icon; title: Filter on text; title: Filter on more than one column; title: Remove the filter; title: Filter data on colour; title: Text filters; title: Number filters; title: Date filters; title: Format as table; title: Reasons to use Tables in Excel; title: Format as table icon; title: Insert a table; title: Change table style; title: Remove formatting; title: Name the table; title: Calculated columns; title: Add a total row; title: Convert back to a range (remove automatic functionality); title: Filter a table; title: Filter a table; title: Filter a table with a total row; title: Insert a slicer; title: Customize a slicer; title: Delete a slicer; title: Grouping and outlining; title: Outlining; title: Create an automatic outline; title: Subtotals; title: Why use subtotals?; title: Sort first; title: Remove subtotals; title: Apply conditional formatting; title: Conditional formatting; title: Top and bottom rules; title: Data bars; title: Colour scales; title: Icon sets; title: Clear conditional formatting; title: Use a formula to control conditional formatting; title: Sparkline charts; title: Sparkline line chart; title: Column spark lines; title: Creating a win/loss spark line chart; title: Remove a spark line chart; title: Text functions; title: Text functions – an introduction; title: Concatenate; title: Trim; title: Upper; title: Lower; title: Proper; title: Right; title: Left; title: Mid; title: Quick analysis; title: Quick analysis; title: Quick analysis Formatting; title: Quick analysis totals; title: Quick analysis Charts; title: Quick analysis Tables; title: Quick analysis sparklines; title: Macros; title: What is a Mmcro; title: Macro security; title: Get ready; title: Get set and go; title: Run the macro