Excel 2016 Basics

Navigate to the Excel 2016 Basics Tutorials using this link https://edu.gcfglobal.org/en/excel/ (Links to an external site.) (Links to an external site.). You will use the material covered in these tutorials to submit assignments later in this unit and you will be quizzed on the material at the end of the unit.

• Getting Started with Excel
• Creating and Opening Workbooks
• Saving and Sharing Workbooks

Working with Cells and Sheets

Navigate to the Working with Cells and Sheets Tutorials using this link https://edu.gcfglobal.org/en/excel/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. Do not submit the assignment until all three files are attached. The documents you submit should look like the documents shown at the end of each Challenge.

• Cell Basics – Save the Challenge! Practice Document as YourUsername_CellBasics and attach to the assignment. (10 points)
• Modifying Columns, Rows, and Cells – Save the Challenge! Practice Document as YourUsername_Modify and attach to the assignment. (10 points)
• Formatting – Review the tutorial.
• Understanding Number Formats – Save the Challenge! Practice Document as YourUsername_NumFormat and attach to the assignment. (10 points)
• Working with Multiple Worksheets – Review the tutorial.
• Using Find & Replace – Review the tutorial.
• Checking Spelling – Review the tutorial.
• Page Layout and Printing – Review the tutorial.

Formulas and Functions

Navigate to the Formulas and Functions Tutorials using this link https://edu.gcfglobal.org/en/excel/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. The documents you submit should look like the documents shown at the end of each Challenge.

• Intro to Formulas – Save the Challenge! Practice Document as YourUsername_Intro and attach to the assignment. (10 points)
• Creating More Complex Formulas- Review the tutorial.
• Relative and Absolute Cell References – Review the tutorial.
• Functions – Review the tutorial.

Working with Data

Navigate to the Working with Data Tutorials using this link https://edu.gcfglobal.org/en/excel/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. Do not submit the assignment until all three files are attached. The documents you submit should look like the documents shown at the end of each Challenge.

• Freezing Panes and View Options – Review the tutorial.
• Sorting Data – Save the Challenge! Practice Document as YourUsername_Sort and attach to the assignment. (10 points)
• Filtering Data – Save the Challenge! Practice Document as YourUsername_Filter and attach to the assignment. (10 points)
• Groups and Subtotals – Review the tutorial.
• Tables – Review the tutorial.
• Charts – Review the tutorial.
• Conditional Formatting – After Step 7, Save the Challenge! Practice Document as YourUsername_Condition and attach to the assignment. (10 points)

Doing More with Excel

Navigate to the Doing More with Excel Tutorials using this link https://edu.gcfglobal.org/en/excel/ (Links to an external site.). Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well. Do not submit the assignment until the two files are attached. The documents you submit should look like the documents shown at the end of each Challenge.

• Track Changes and Comments – Review the tutorial.
• Inspecting and Protecting Workbooks -Review the tutorial.
• Intro to PivotTables- Save the Challenge! Practice Document as YourUsername_PivotTable and attach to assignment. (10 points)
• Doing More with PivotTables – Save the Challenge! Practice Document as YourUsername_PivotTable2 and attach to assignment. (10 points)
• What-If Analysis – Review the tutorial.