Manage Workbook options and settings

Select a chapter above and press 'Show Content'. Click a video topic below to view.

    Chapter 1 Manage Workbook options and settings ( 18 videos)  (Practice Test)

      1.1: Manage Workbooks (Practice Test)
      Save workbook as a template/Show and hide ribbons
    1. Save workbook as a template/Show and hide ribbons
      2. Enable Macros in a document
    2. Enable Macros in a document
      3. Reference data in another cell book
    3. Reference data in another cell book
      4. Reference data using query
    4. Reference data using query
      5. Reference data using structured reference
    5. Reference data using structured reference
      6. Refer to a single value in a table field
    6. Refer to a single value in a table field
      7. Section exercise 1.1 Project 1
    7. Section exercise 1.1 Project 1
      8. Section exercise 1.1 Project 2
    8. Section exercise 1.1 Project 2
      9. Section exercise 1.1 Project 3
    9. Section exercise 1.1 Project 3
      1.2: Manage workbook review (Practice Test)
      Restrict edititing in a document
    1. Restrict edititing in a document
      2. Protect Workbook structure
    2. Protect Workbook structure
      3. Manage Workbook versions
    3. Manage Workbook versions
      4. Configure formula calculation option
    4. Configure formula calculation option
      5. Circular reference in Excel
    5. Circular reference in Excel
      6. Section exercise 1.2 Project 1
    6. Section exercise 1.2 Project 1
      7. Section exercise 1.2 Project 2
    7. Section exercise 1.2 Project 2
      8. Section exercise 1.2 Project 3
    8. Section exercise 1.2 Project 3
      9. Section exercise 1.2 Project 4
    9. Section exercise 1.2 Project 4