Information tech

About this tutorial

The procedures in this tutorial will work for all recent versions of Microsoft Excel, including Excel 2019, Excel 2016, and Office 365. There may be some slight differences, but for the most part these versions are similar. 

Introduction

Excel is a spreadsheet programthat allows you to store,organize, and analyzeinformation. While you may think Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerfulfeatures. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

For the GCFLearnfree Excel Tutorials assignment I want you to complete the tutorials listed below. At the end of each lesson is a Challenge!  You are required to view the whole tutorial (do as much of the hands-on activities as possible) and to do all of the Challenges at the end of the tutorials. You will only need to paste a screen shot of one specified step from the Challenge for each tutorial listed into a Word document to earn the points for this Word Assignment. Completing this Excel Assignment is worth 100 points.

Create a Word document with your name at the top. You could just do a “Save As,” to this document and format the top to delete the directions and type your name. Use the open labs on campus if you do not have MS Office 2016/2019 available to you. Type your name at the top and give the file an appropriate filename. Then log into the GCFLearnFree.org site. Complete each of the tutorials listed below. Take screen shot of your work in Excel at each specified step from the end of tutorial Challenge assignment. Paste the screen shot into your solution Word document. Be sure to properly label each screen shot in the solution document to receive full credit. Below the screen shot comment on the tutorial or Challenge assignment. Your comment could be about what you learned, what was difficult or what you found interesting. You must comment on at least 5 tutorials. Save the document with a short descriptive name and submit it into this assignment in Blackboard by the due date listed on your course Detailed Schedule.  

Excel Basics

1) Getting Started with Excel

- Screen shot after step 7.

3) Creating and Opening Workbooks

 - Use the practice workbook and screen shot after step 3

4) Saving and Sharing Workbooks

 - Use the practice workbook and screen shot during step 3

Working with Cells and Sheets

5) Cell Basics

 - Use the practice workbook and screen shot after step 7

6) Modifying Columns, Rows, and Cells

 - Use the practice workbook and screen shot after step 9

7) Formatting Cells

 - Use the practice workbook and screen shot after step 10. Your shot needs to show formatted cells and the task bar of your computer with the date and time visible.

8) Understanding Number Formats

 - Use the practice workbook and screen shot after step 8

12) Page Layout and Printing

 - Use the practice workbook and screen shot Print preview in backstage view after step 9

Formulas and Functions

13) Introduction to Formulas

 - Use the practice workbook and screen shot after step 7

14) Creating More Complex Formulas

 - Use the practice workbook and screen shot after step 6

15) Relative and Absolute Cell References

 - Use the practice workbook and do two screen shots after steps 5 and 9

16) Functions

 - Use the practice workbook and screen shot after step 9

Working with Data

18) Freezing Panes and View Options

 - Use the practice workbook and screen shot after step 8

23) Charts

 - Use the practice workbook and screen shot after step 9