Excel 2016 Expert PowerPoint Slides.pptx - Excel 2016 Expert Corporate Training Materials Module One Getting Started Education is not received It is

Excel 2016 Expert PowerPoint Slides.pptx - Excel 2016...

This preview shows page 1 - 21 out of 125 pages.

Excel 2016 Expert Corporate Training Materials
Image of page 1
Module One: Getting Started Welcome to the Excel 2016 Expert workshop. This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert. Education is not received. It is achieved. Anonymous
Image of page 2
Workshop Objectives Understand document information Utilize multiple formats Understand master documents Create and edit forms
Image of page 3
Module Two: Manage Workbook Options and Settings This module introduces students to a Word document and the different ways of creating documents. We’ll introduce the Ribbon so that students are familiar with the tool terminology. Then we’ll look at ways of navigating through a document. A journey of a thousand miles must begin with a single step. Lao-Tsu
Image of page 4
Lesson: Manage Workbooks In this lesson, we’ll introduce the following topics: Save a workbook as a template Reference data in another workbook Reference data by using structured references Display hidden ribbon tabs
Image of page 5
Save a Workbook as a Template
Image of page 6
Reference Data in Another Workbook
Image of page 7
Reference Data by using Structured References
Image of page 8
Display Hidden Ribbon Tabs
Image of page 9
Lesson: Manage Workbook Review In this lesson, we’ll introduce the following topics: Mark a workbook as final Encrypt a workbook with a password Protect a worksheet Protect workbook structure Manage workbook versions Setting calculation options
Image of page 10
Mark a Workbook as Final
Image of page 11
Encrypt a Workbook with a Password
Image of page 12
Protect a Worksheet
Image of page 13
Protect Workbook Structure
Image of page 14
Manage Workbook Versions
Image of page 15
Setting Calculation Options
Image of page 16
Module Two: Review Questions 1. When you choose Excel Template as the file type when saving a file, using the default location makes the item available on the New page when creating a new workbook. a) True b) False 2. To show a value from a cell in another workbook, what do you type before clicking on the cell to reference? a) $ b) = c) + d) <
Image of page 17
Module Two: Review Questions 3. You should enter exact cell ranges when referencing table data to make sure that the formula stays up to date if column or rows are added or removed from the table. a) True b) False 4. How do you show the Developer tab?
Image of page 18
Module Two: Review Questions 5. Which of the following is not a true statement when marking a workbook as final? a) A warning message displays when the workbook is opened. b) Data entry is not allowed. c) Most Ribbon commands are unavailable. d) The workbook can only be opened with a password. 6. If you lose the password selected when password protecting a workbook, you can still retrieve the workbook from your Microsoft Account. a) True b) False
Image of page 19
Module Two: Review Questions 7. Which option allows you to restrict editing of the workbook to specific activities like formatting?
Image of page 20
Image of page 21

You've reached the end of your free preview.

Want to read all 125 pages?

  • Fall '14
  • FloCiancheiti

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes