Presentation_cornerstone_M1.pptx introduction

Its an introduction to excel.

1. Microsoft Excel a ssociate 2019 Module 1: Introduction Cornerstone: Helping a fellow intern with Microsoft Excel

2. Cornerstone overview In this Cornerstone, you will: Use AutoFill to automatically fill data into cells Save workbooks in alternate formats Search for data Navigate to named cells, ranges, or workbook elements

3. Cornerstone scenario One of the interns has been working on two workbooks containing data that summarizes the annual produce for various fruit and vegetables. The data needs to be ready for a meeting with your boss within the next hour. You need to examine the files before the meeting to ensure the data is correct and there is nothing missing from data.

4. Instructions Refer to your Student Guide for instructions Saving files Where? Your teacher will tell you where to save your files throughout this Cornerstone Naming your files: Append your first and last name to the end of the original filename. Ask your teacher for help as you need it When you’re finished with the Cornerstone Assess your work, noting the points you think you earned within the scoring sections of the Student Guide instructions Resources: Cornerstone_starter.xlsx Cornerstone2_starter.xls

5. Cornerstone wrap-up Three-two-one What are three ways can you enter data and complete the entry in a worksheet, without using the enter key? What are two ways to navigate to special elements within a workbook? What is the most useful feature you learned in this module and why?

6. Notes