Excel Essentials: A Step-by-Step Guide with Pictures for Absolute Beginners to Master the Basics and Start Using Excel with Confidence

Chapter 1: Introduction
1.1 The Value of Excel Training
1.2 A Summary of the Contents of the Book
1.3 Using the Excel User Interface
Chapter 2: Making and Saving Workbooks
2.1 Starting a Fresh Workbook
2.2. Save Your Work
2.3 Simple File Administration
Chapter 3: Working with Cells, Rows, and Columns
3.1 Addressing and Cell References
3.2 Choosing Rows, Columns, and Cells
3.3 Adding and Removing Columns and Rows
3.4 Modifying Column Width and Row Height
3.5 Cells that Merge and Unmerge
Chapter 4: Entering and Formatting Data
4.1 Text and Number Entry
4.2 Formatting Cells
4.3 Applying Number Formats
4.4 Making Use of Border and Fill Colors
Chapter 5: Basic Formulas and Functions
5.1 Developing Basic Formulas
5.2 Using Foundational Features
5.3 Understanding Relative and Absolute Cell References
5.4 Formulas for Copying and Pasting
Chapter 6: Sorting and Filtering Data
6.1 Data Sorting by One or More Columns
6.2 Using Filters to Show Particular Data
6.3 Eliminating Duplications
Chapter 7: Data Visualization with Charts and Graphs
7.1 Type of Graphs
7.2 Chart Design
7.3 Making Your Chart Your Own
7.4 Modifying and Editing Data for Charts
Chapter 8: Tips and Preparing Your Spreadsheet for Printing
8.1 Making the Print Area
8.2 Altering Page Size and Orientation
8.3 Addition of Headers and Footers
8.4 Checking Your Spreadsheet Out and Printing It
Chapter 9: Advice for Excel Newcomers
9.1 Keyboard shortcuts
9.2 Actions You Can Undo and Repeat
9.3 Utilizing the Help Function
9.4 Organizational Best Practices for Spreadsheets
Chapter 10: Conclusion and Next
Chapter 11: Bonus