eBook Idiot's Guides: Microsoft Excel 2013, 1st Edition

  • Michael Miller University of Texas, San Antonio
  • Published By:
  • ISBN-10: 161564542X
  • ISBN-13: 9781615645428
  • DDC: 005.54
  • Grade Level Range: 9th Grade - 12th Grade +
  • 320 Pages | eBook
  • Original Copyright 2014 | Published/Released August 2014
  • This publication's content originally published in print form: 2014
  • Price:  Sign in for price

Table of Contents

Front Cover.
Other Frontmatter.
Title Page.
Copyright Page.
Contents.
Introduction.
1: Getting Started with Excel 2013.
2: Exploring Excel 2013.
3: Exploring the Excel Web App.
4: Creating a New Blank Spreadsheet.
5: Creating a New Spreadsheet from a Template.
6: Saving Your Spreadsheet.
7: Opening an Existing Spreadsheet.
8: Changing Views.
9: Customizing the Ribbon.
10: Personalizing the Quick Access Toolbar.
11: Configuring Other Important Options.
12: Entering and Editing Data.
13: Understanding the Spreadsheet Layout.
14: Entering Numbers.
15: Entering Dates and Times.
16: Entering Text.
17: Editing Cell Data.
18: Deleting Data from a Cell.
19: Finding and Replacing Text.
20: Copying Cells.
21: Moving Cells.
22: Formatting Data.
23: Applying Bold, Italic, and Other Font Effects.
24: Changing Font and Font Size.
25: Aligning Text.
26: Aligning Text Vertically.
27: Wrapping Text within a Cell.
28: Centering Text across Multiple Columns.
29: Rotating Text.
30: Applying a Background Color.
31: Applying Number Formats.
32: Changing Currency Formats.
33: Displaying Decimal Places.
34: Using Automatic Number Formats.
35: Using Conditional Formatting.
36: Applying Cell Styles.
37: Creating a New Cell Style.
38: Adding Borders.
39: Copying Cell Formatting.
40: Working with Rows and Columns.
41: Understanding Rows and Columns.
42: Naming Cells, Rows, and Columns.
43: Changing Column Width.
44: Changing Row Height.
45: Inserting a New Row.
46: Inserting a New Column.
47: Deleting a Row.
48: Deleting a Column.
49: Inserting a Single Cell.
50: Deleting a Single Cell.
51: Copying a Row or Column.
52: Moving a Row or Column.
53: Hiding and Unhiding a Row or Column.
54: Freezing a Row or Column.
55: Merging Two or More Cells.
56: Splitting a Merged Cell.
57: Formatting Rows and Columns.
58: Sorting Data.
59: Working with Worksheets.
60: Understanding Worksheets and Workbooks.
61: Creating a New Worksheet.
62: Changing the Default Number of Worksheets.
63: Copying a Worksheet.
64: Moving a Worksheet.
65: Moving or Copying a Worksheet to a Different Workbook.
66: Renaming a Worksheet.
67: Changing the Tab Color.
68: Deleting a Worksheet.
69: Grouping Worksheets.
70: Splitting a Worksheet into Panes.
71: Hiding and Unhiding Worksheets.
72: Formatting Worksheets and Workbooks.
73: Changing Gridline Color.
74: Showing or Hiding Gridlines.
75: Showing or Hiding Row and Column Headings.
76: Formatting a Worksheet's Background Color.
77: Adding a Background Picture to a Worksheet.
78: Copying Formatting Between Worksheets.
79: Applying Visual Effects to a Workbook.
80: Changing Workbook Colors.
81: Setting Workbook Fonts.
82: Applying a Workbook Theme.
83: Working with Ranges.
84: Selecting a Range of Cells.
85: Naming a Range.
86: Navigating with Range Names.
87: Managing Names in a Workbook.
88: Moving a Range of Cells.
89: Copying a Range of Cells.
90: Deleting a Range.
91: Filling a Range of Cells with AutoFill.
92: Flash Filling a Range.
93: Using Quick Analysis to Format or Analyze a Range.
94: Using Formulas and Functions.
95: How Formulas Work.
96: Creating a Formula.
97: Editing a Formula.
98: Using Absolute Cell References in a Formula.
99: Using Ranges in a Formula.
100: Referencing Other Worksheets in a Formula.
101: Showing and Hiding Formulas.
102: Checking for Errors in Formulas.
103: Understanding Functions.
104: Using Functions in Formulas.
105: Using the AutoSum Function.
106: Using the AVERAGE Function.
107: Using the COUNT Function.
108: Creating Charts.
109: Exploring Excel's Chart Types.
110: Creating a Chart.
111: Moving and Resizing a Chart.
112: Moving a Chart to Its Own Chart Sheet.
113: Changing the Chart Type.
114: Changing a Chart's Source Data.
115: Adding and Removing Chart Elements.
116: Changing Chart Style and Color.
117: Formatting Chart Elements.
118: Formatting the Chart Area.
119: Formatting the Plot Area.
120: Formatting Axes.
121: Formatting Axis Titles.
122: Formatting the Chart Title.
123: Formatting Data Labels.
124: Formatting a Data Table.
125: Formatting Gridlines.
126: Formatting the Legend.
127: Formatting 3-D Rotation.
128: Formatting Data Series.
129: Formatting a Pie Chart.
130: Adding Graphics.
131: Inserting a Photo.
132: Inserting a Clip Art Image.
133: Inserting SmartArt.
134: Inserting a Shape.
135: Inserting a Text Box.
136: Inserting WordArt.
137: Working with Tables.
138: Converting a Range to a Table.
139: Adding New Data to a Table.
140: Removing Rows from a Table.
141: Inserting Table Columns.
142: Deleting Table Columns.
143: Sorting a Table.
144: Filtering Data in a Table.
145: Adding Column Totals.
146: Converting a Table to a Range.
147: Applying Table Styles.
148: Working with PivotTables.
149: How PivotTables Work.
150: Creating a PivotTable.
151: Adding Fields to a PivotTable.
152: Changing Value Calculations.
153: Changing the Source Data.
154: Sorting a PivotTable.
155: Filtering PivotTable Data with Slicers.
156: Filtering by Date with Timelines.
157: Other Ways to Filter PivotTable Data.
158: Creating a PivotChart.
159: Analyzing Data.
160: Using Goal Seek for What-If Analysis.
161: Using Scenario Manager.
162: Producing a Scenario Summary Report.
163: Showing Trends with Sparklines.
164: Printing.
165: Printing One or More Worksheets.
166: Printing Part of a Worksheet.
167: Changing Page Orientation.
168: Scaling the Spreadsheet to Fit.
169: Inserting Page Breaks.
170: Configuring Other Print Options.
171: Printing Row and Column Titles.
172: Adding a Header and Footer.
173: Sharing and Collaborating.
174: Sharing Online with SkyDrive.
175: Sharing a Workbook via Email.
176: Enabling Change Tracking.
177: Accepting and Rejecting Changes.
178: Adding Comments.
179: Collaborating Online with the Excel Web App.
Glossary.
Keyboard Shortcuts.
Index.
About the Author.