Home >Books >Excel 2016 from Scratch, contents kalmstrom.com site map icon Site map  

Excel 2016 from Scratch Contents

This is the table of contents for Excel 2016 from Scratch :

1 Overview

2 Introduction and Navigation

2.1 Structure

2.1.1 Workbook

2.1.1.1 Create a Blank Workbook

2.1.1.2 Save a Workbook

2.1.2 Sheets

2.1.2.1 Create a new sheet

2.1.2.2 Rename a Sheet

2.1.2.3 Delete a Sheet

2.1.2.4 Navigate between Sheets

2.1.2.5 Space

2.1.3 Protect Workbook and Sheet

2.1.3.1 Protect a Sheet

2.2 Rows, Columns and Cells

2.2.1 Characterization

2.2.2 Selection

2.2.2.1 Select one Cell

2.2.2.2 Select Multiple, Separated Cells

2.2.2.3 Select a Range

2.2.2.4 Select Rows

2.2.2.5 Select Columns

2.2.3 Insert and Delete Rows and Columns

2.2.3.1 Insert a Row or Column

2.2.3.2 Delete Rows or Columns

2.2.4 Hide and Unhide Rows and Columns

2.2.4.1 Hide and Unhide Rows

2.2.4.2 Hide and Unhide Columns

2.2.5 Cell Names

2.2.5.1 Default Cell Name

2.2.5.2 Custom Cell Name

2.2.6 Range Name

2.2.7 Move Cells

2.3 Entering cell values

2.3.1 Resize Rows and Columns

2.3.1.1 Manually Resize Columns and Rows

2.3.1.2 Automatically Resize a Column

2.3.2 Cell Content Alignment

2.4 Conclusion

3 Calculation A

3.1 Formulas Introduction

3.2 The Benefit of Using Formulas

3.3 Sort

3.4 Formulas for Basic Calculation

3.4.1 Write or Select

3.4.2 AutoSum

3.4.3 Addition Formulas

3.4.4 Subtraction Formula

3.4.5 Multiplication Formula

3.4.6 Division Formula

3.4.7 Combinations

3.5 Check Formulas

3.6 Relative and Absolute References

3.6.1 Relative Reference

3.6.2 Absolute Reference

3.7 Filling

3.7.1 Fill Series

3.8 Conclusion

4 Cell Formatting

4.1 Office Tools

4.2 Cell Styles

4.3 Number Formatting

4.4 The Format Cells Dialog

4.4.1 Number

4.4.2 Alignment

4.4.3 Font

4.4.4 Border

4.4.5 Fill

4.4.6 Protection

4.5 Custom Cell Format

4.5.1 Add Sort to Number

4.5.2 Calculate Weekdays

4.6 Conditional Formatting

4.6.1 Quick Analysis

4.6.2 Conditional Formatting Rules

4.7 Copy Formatting

4.7.1 Copy Format to One Cell

4.7.2 Copy Format to Multiple Cells

4.8 Conclusion

5 Basic Visualization

5.1 Insert Sparklines

5.1.1 The Quick Analysis

5.1.2 The Insert Tab

5.2 Insert a Chart

5.2.1 Quick Analysis

5.2.2 The Insert Tab

5.3 Resize a Chart

5.4 Customize a Chart

5.4.1 Office Tools

5.4.2 Chart Formatting Shortcuts

5.4.2.1 Elements

5.4.2.2 Style and Color

5.4.2.3 Filters

5.4.3 The Chart Tools, Design Tab

5.4.3.1 Add Chart Elements

5.4.3.2 Quick Layout

5.4.3.3 Chart Styles Group

5.4.3.4 Data Group

5.4.3.5 Move a Chart to Another Sheet

5.4.4 The Chart Tools, Format Tab

5.4.4.1 Current Selection

5.4.4.2 Insert Shapes

5.4.4.3 Arrange Charts

5.5 Conclusion

6 Miscellaneous

6.1 Text Boxes

6.1.1 Insert a Text Box

6.1.2 Move a Text Box

6.1.3 Delete a Text Box

6.1.4 Customize a Text Box

6.1.4.1 Home Tab Commands

6.1.4.2 Format Tab Commands

6.1.5 kalmstrom.com Exercises

6.2 Copy and Paste Cell Data

6.2.1 Copy

6.2.2 Paste

6.2.2.1 Paste Special

6.3 Data Validation

6.4 Conclusion

7 Tables and Table Tools

7.1 Format a Range as a Table

7.2 Sort and Filter

7.3 Use Column Header in Formulas

7.4 Table Tools

7.4.1 Table Name

7.4.1.1 Slicer

7.4.2 External Table Data

7.4.2.1 Export to SharePoint

7.4.3 Table Style Options

7.4.3.1 Total Row

7.5 Conclusion

8 Calculation B

8.1 Calculate Time Differences

8.2 Functions

8.2.1 AutoSum options

8.2.2 Write Formulas with Functions in a Cell

8.2.2.1 Examples with MAX, MIN, MEDIAN and AVERAGE

8.2.2.2 Examples with TRUNC and ROUND

8.2.2.3 Examples with TODAY, NOW and WEEKNUM

8.2.3 The Function Wizard

8.2.3.1 Logical IF Example

8.2.3.2 VLookup Example

8.2.3.3 Examples with DAVERAGE and DSUM

8.3 Bind datasheets

8.3.1 Connect Sheets in the Same Workbook

8.3.2 Connect Sheets in Different Workbooks

8.4 What-If Analysis

8.4.1 The Scenario Manager

8.4.2 The Goal Seek

8.4.3 The Data Table

8.5 Conclusion

9 Advanced Visualization

9.1 Pivot Table

9.1.1 Show Values as Percentage of Total

9.1.2 Create a Pivot Table

9.1.3 Create a Pivot Table View

9.1.4 Drilling – Expand and Collapse

9.1.5 Show Values as Percentage of Total

9.2 Pivot Chart

9.3 Timeline

9.4 Scroll Bar/Slider

9.4.1 Create a Scroll Bar

9.5 Power View

9.5.1 First time use

9.5.2 Use

9.6 Conclusion

10 Text Manipulation

10.1 Import Text

10.1.1 Step 1

10.1.2 Step 2

10.1.2.1 Step 2 Delimited

10.1.2.2 Step 2 Fixed width

10.1.3 Step 3

10.1.4 Step 4

10.2 Text Functions

10.2.1 LEN

10.2.2 MID

10.2.3 Left and Right

10.2.4 Split Text into Columns

10.3 Conclusion

Products Buy FAQ Services Apps Tips Books Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved