Contents
Microsoft- Excel
1. Getting Started with Excel
1.1. The Excel interface.
1.2. The Ribbon.
1.2.1. To change the Ribbon Display Options:
1.3. The Quick Access Toolbar.
1.3.1. To add commands to the Quick Access Toolbar:
1.3.2. How to use Tell me:
1.4. Worksheet views.
1.5. Backstage view..
1.5.1. To access Backstage view:
2. Creating and Opening Workbooks.
2.1. To create a new blank workbook:
2.2. To open an existing workbook:
2.3. To pin a workbook:
3. Saving and Sharing Workbooks.
3.1. Save and Save As.
3.2. To save a workbook:
3.3. Using Save As to make a copy.
3.4. To export a workbook as a PDF file:
4. Cell Basics.
4.1. Understanding cells.
4.2. To select a cell:
4.3. To select a cell range:
4.4. Cell content.
4.4.1. To insert content:
4.4.2. To delete (or clear) cell content:
4.4.3. To delete cells:
4.4.4. To copy and paste cell content:
4.4.5. To access more paste options:
4.4.6. To cut and paste cell content:
4.4.7. To drag and drop cells:
4.4.8. To use the fill handle:
4.4.9. To continue a series with the fill handle:
5. Modifying Columns, Rows, and Cells.
5.1. To modify column width:
5.2. To AutoFit column width:
5.3. To modify row height:
5.4. To modify all rows or columns:
6. Inserting, deleting, moving, and hiding.
6.1. To insert rows:
6.2. To insert columns:
6.3. To delete a row or column:
6.4. To move a row or column:
6.5. To hide and unhide a row or column:
7. Wrapping text and merging cells.
7.1. To wrap text in cells:
7.2. To merge cells using the Merge & Center command:
7.3. To access more merge options:
7.4. To center across selection:
8. Formatting Cells.
8.1. To change the font size:
8.2. To change the font:
8.3. To change the font color:
8.4. To use the Bold, Italic, and Underline commands:
9. Cell borders and fill colors.
9.1. To add a fill color:
9.2. To add a border:
10. Cell styles.
10.1. To apply a cell style:
11. Text alignment.
11.1. To change horizontal text alignment:
11.2. To change vertical text alignment:
11.3. Format Painter.
12. Number Formats.
12.1. Applying number formats.
12.2. Using number formats correctly.
12.3. Percentage formats.
12.4. Date formats.
12.4.1. Other date formatting options.
12.5. Increase and Decrease Decimal
13. Working with Multiple Worksheets.
13.1. To insert a new worksheet:
13.2. To copy a worksheet:
13.3. To rename a worksheet:
13.4. To move a worksheet:
13.5. To delete a worksheet:
13.6. Switching between worksheets.
13.7. To group worksheets:
13.8. To ungroup worksheets:
14. Using Find & Replace.
14.1. To find content:
14.2. To replace cell content:
15. Page Layout and Printing.
15.1. To access the Print pane:
15.2. To print a workbook:
15.3. To print active sheets:
15.4. To print the entire workbook:
15.5. To print a selection:
15.6. To adjust page breaks:
15.7. To modify margins in the Preview pane:
16. Intro to Formulas.
16.1. Mathematical operators.
16.2. Understanding cell references.
16.3. To create a formula:
16.4. Modifying values with cell references.
16.5. To create a formula using the point-and-click method:
16.6. Copying formulas with the fill handle.
16.7. To edit a formula:
17. Creating More Complex Formulas.
17.1. The order of operations.
17.2. Creating complex formulas.
17.3. To create a complex formula using the order of operations:
18. Relative and Absolute Cell Reference.
18.1. Relative references.
18.1.1. To create and copy a formula using relative references:
18.2. Absolute references.
18.2.1. To create and copy a formula using absolute references:
18.2.2. To create and copy a formula using absolute references:
18.3. Using cell references with multiple worksheets.
18.3.1. To reference cells across worksheets:
19. Functions.
19.1. The parts of a function.
19.2. Working with arguments.
19.3. Creating a function.
19.3.1. To create a function using the AutoSum command:
19.3.2. To enter a function manually:
20. Freezing Panes and View Options.
20.1. Freezing Panes.
20.2. View Options.
21. Sorting Data.
22. Filtering Data.
22.1. To filter data:
22.2. To apply multiple filters:
22.3. To clear a filter:
22.4. Advanced filtering.
22.4.1. To filter with search:
22.4.2. To use advanced text filters:
22.4.3. To use advanced number filters:
22.4.4. To use advanced date filters:
23. Groups and Subtotals.
23.1. Groups.
23.1.1. To group rows or columns:
23.1.2. To hide and show groups:
23.2. Subtotals.
23.2.1. To create a subtotal:
23.2.2. To view groups by level:
23.2.3. To remove subtotals:
24. Tables.
24.1. To format data as a table:
24.2. To add rows or columns to a table:
24.3. To change the table style:
24.4. To modify table style options:
24.5. To remove a table:
25. Charts.
25.1. Understanding charts.
25.2. To insert a chart:
25.3. Chart and layout style.
25.4. Other chart options.
25.4.1. To switch row and column data:
25.4.2. To change the chart type:
25.4.3. To move a chart:
25.4.4. Keeping charts up to date.
26. PivotTables.
26.1. Using PivotTables to answer questions.
26.2. To create a PivotTable:
26.3. Pivoting data.
26.3.1. To add columns:
26.3.2. To change a row or column:
