1. Get Started with Microsoft Excel
2. Find Your Way Around
3. Get Help
4. Spreadsheet Quick Start!
5. Save, AutoSave, and AutoRecover
6. Page Layout Options for Printing
7. Introduction
8. Work with Text
9. Use Borders, Fill Shading, and Cell Styles
10. Apply Number Formats
11. Create a Custom Number Format
12. Manage Rows and Columns
13. Set Up Multiple Sheets
14. Introduction
15. Basic Principles
16. Use the Mathematical Operators
17. Percentages
18. Absolute Cell References
19. Use Formulas Across Sheets
20. Introducing Functions
21. Introduction
22. Insert and Modify a Chart
23. Column, Bar, Line, and Area Charts
24. Pie, Pie of Pie, Bar of Pie, and Doughnut Charts
25. Treemap and Sunburst Charts
26. Histogram, Pareto, and Box-and-Whisker Charts
27. Scatter and Bubble Charts
28. Waterfall, Funnel, and Stock Charts
29. Surface and Radar Charts
30. Map Charts
31. Introduction
32. Navigate and Clean Up Your List
33. Sorting, Filtering, and Custom Views
34. Format as a Table
35. Grouping and Subtotals
36. Data Validation
37. Introduction
38. Insert and Format a PivotTable
39. Slicers, Timelines, and PivotCharts
40. Do More with PivotTables
41. Your PivotTable Challenge!
42. Introduction
43. Conditional Formatting
44. Sparklines
45. People Graph
46. Filled Map Charts or the Bing Maps Add-in
47. 3D Maps
48. Create a Dashboard
49. Introduction
50. Ensure Privacy, Accessibility, and Compatibility
51. Protect the File
52. Protect Parts of the Spreadsheet
53. Set Cloud Sharing Permissions
54. Edit Simultaneously with Co-Workers
55. Legacy Collaboration Tools
56. Introduction
57. Rounding
58. IF Functions
59. Lookups
60. Hiding Errors
61. Date Formulas
62. Text Functions
63. Introduction
64. Linear Forecasts
65. Forecasts with Seasonal Variation
66. Create a Forecast Sheet
67. Scenario Manager
68. Goal Seek and Solver
69. Data Tables
70. Introduction
71. Pictures and Graphics
72. Display a Picture Based on Cell Value
73. Shapes and Diagrams
74. Digital Ink
75. Themes
76. Introduction
77. Explore the Built-in Templates
78. Create Your Own Template
79. Share Templates
80. Set Defaults
81. Default Chart and Chart Templates
82. Customise the Excel Environment
83. Introduction
84. Use Excel Data in Other Office Applications
85. Manage Links
86. Basic Export Options
87. Connect to Data Sources with Power Query
88. Get Started with Power Pivot
89. Introduction
90. Worksheet Forms
91. Add a Macro Button
92. A First Look at Excel VBA
93. Create Your Own Function
94. Introducing Office Scripts
95. Introduction
96. Speed Up Data Entry
97. Navigation and Selection Shortcuts
98. Quick Tips for Formatting
99. Workarounds for Bulleted Lists
100. Options for Inserting Check Boxes
101. Charting Tips
102. Get Started
103. Enter Data and Apply Basic Formatting
104. Work with Formulas
105. Insert Charts and Graphs
106. Use Lists and PivotTables
107. Share and Collaborate
-main-resized.jpg)
