Excel 2013 Core: Advanced
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740307184
Table of contents: title: Content; title: 1. Apply Conditional Logic in formula; title: 1.1. IF Function (IF Statement); title: 1.2. Nested IF Function; title: 1.3. COUNTIF Function; title: 1.4. SUMIF Function; title: 2. Create and apply Range Names; title: 2.1. Defining a Named Cell or Range of Cells; title: 2.2. Using a Named Cell in a formula; title: 2.3. Naming a range of cells; title: 2.4. Editing and renaming a named range; title: 2.5. Define a Name Using the Dialogue Box; title: 2.6. Sum a range; title: 3. Charts; title: 3.1. Using Quick Analysis; title: 3.2. Recommended Charts; title: 3.3. Creating charts with the keyboard; title: 3.4. Creating line charts; title: 3.5. Creating and editing a column chart; title: 3.6. Creating pie charts; title: 3.7. Modifying charts using the Ribbon; title: 3.8. Modifying charts using icons; title: 3.9. Formatting charts – Task Pane; title: 4. Apply and manipulate illustrations; title: 4.1. Pictures in Excel; title: 4.2. Resize the picture – dragging; title: 4.3. Modify a picture; title: 4.4. Reset a picture; title: 5. SmartArt; title: 5.1. SmartArt; title: 6. Shapes; title: 6.1. Inserting shapes into a workbook; title: 7. Screenshots; title: 7.1. Inserting a screenshot; title: 8. Manage comments; title: 8.1. Inserting and editing comments; title: 8.2. Deleting comments; title: 8.3. Show/Hide Comments; title: 8.4. Moving between comments; title: 8.5. Printing comments; title: 9. Sorting data; title: 9.1. Databases in Excel – introduction; title: 9.2. Sort data; title: 9.3. Sort on font colour; title: 9.4. Sort on cell colour; title: 9.5. Sort on cell icon; title: 10. Filtering data; title: 10.1. Filter data – the filter icon; title: 10.2. Filter on text; title: 10.3. Filter on more than one column; title: 10.4. Remove the filter; title: 10.5. Filter data on colour; title: 10.6. Text filters; title: 10.7. Number filters; title: 10.8. Date filters; title: 11. Format as table; title: 11.1. What is format as table; title: 11.2. Format as table icon; title: 11.3. Insert a table; title: 11.4. Change table style; title: 11.5. Remove formatting; title: 11.6. Name the table; title: 11.7. Calculated columns; title: 11.8. Add a total row; title: 11.9. Convert back to a range (remove automatic functionality); title: 12. Filter a table; title: 12.1. Filter a table; title: 12.2. Filter a table with a total row; title: 12.3. Insert a slicer; title: 12.4. Customize a slicer; title: 12.5. Delete a slicer; title: 13. Grouping and outlining; title: 13.1. Outlining; title: 13.2. Create an automatic outline; title: 14. Subtotals; title: 14.1. Why use subtotals?; title: 14.2. Sort first; title: 14.3. Subtotals command; title: 14.4. Remove subtotals; title: 15. Apply conditional formatting; title: 15.1. Conditional formatting; title: 15.2. Top and bottom rules; title: 15.3. Data bars; title: 15.4. Colour scales; title: 15.5. Icon sets; title: 15.6. Clear rules; title: 15.7. Use a formula to control conditional formatting; title: 16. Sparkline charts; title: 16.1. Sparkline line chart; title: 16.2. Column spark lines; title: 16.3. Creating a win/loss spark line chart; title: 16.4. Remove a spark line chart; title: 17. Text functions; title: 17.1. Text functions – an introduction; title: 17.2. Concatenate; title: 17.3. Trim; title: 17.4. Upper; title: 17.5. Lower; title: 17.6. Proper; title: 17.7. Right; title: 17.8. Left; title: 17.9. Mid; title: 18. Quick analysis; title: 18.1. Quick analysis; title: 18.2. Quick analysis Formatting; title: 18.3. Quick analysis totals; title: 18.4. Quick analysis Charts; title: 18.5. Quick analysis Tables; title: 18.6. Quick analysis sparklines; title: 19. Macros; title: 19.1. What is a Mmcro; title: 19.2. Macro security; title: 19.3. Get ready; title: 19.4. Get set and go; title: 19.5. Run the macro; title: 20. Index