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...

• 125

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

Excel 2016 Expert Corporate Training Materials
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
Workshop Objectives Understand document information Utilize multiple formats Understand master documents Create and edit forms
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
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
Save a Workbook as a Template
Reference Data in Another Workbook
Reference Data by using Structured References
Display Hidden Ribbon Tabs
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
Mark a Workbook as Final
Encrypt a Workbook with a Password
Protect a Worksheet
Protect Workbook Structure
Manage Workbook Versions
Setting Calculation Options
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) <
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?
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
Module Two: Review Questions 7. Which option allows you to restrict editing of the workbook to specific activities like formatting?

#### You've reached the end of your free preview.

Want to read all 125 pages?

• Fall '14
• FloCiancheiti

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern