Instruction
Navigate to the Excel 2016 Basics Tutorials using this link https://edu.gcfglobal.org/en/excel/. Complete each tutorial and attach files to assignment. Do not submit assignments until all files are attached.
Getting Started with Excel - Save the Challenge! Practice Document as YourUsername_GettingStarted after step 6 and attach to assignment.Creating and Opening Workbooks - Save two screenshots and paste into Microsoft Word. Screenshot 1: Dialog box with Yes chosen for Step 2. Screenshot 2: Showing the Pinned file in the Backstage View for Step 3. Save as both screenshots in one document - YourUsername_CreateWorkbook and attach to assignment.Saving and Sharing Workbooks – Export workbook as PDF for Step 3. Save as YourUsernameSavingPracticeChallenge.pdf and attach to assignment.
Cell Basics - Save the Challenge! Practice Document as YourUsername_CellBasics nad attach to assignment.
Modifying Columns, Rows, and Cells - Save the Challenge! Practice Document as YourUsername_Modify and attach to assignment.Formatting Cells - Save the Challenge! Practice Document as YourUsername_Formatting and attach to assignment.Understanding Number Formats - Save the Challenge! Practice Document as YourUsername_NumFormat and attach to assignment.Working with Multiple Worksheets - Save the Challenge! Practice Document as YourUsername_Multiple and attach to assignment.Using Find & Replace - Save the Challenge! Practice Document as YourUsername_FindReplace and attach to assignment.Checking Spelling - Include Bonus Step and Save the Challenge! Practice Document as YourUsername_Spelling and attach to assignment.Page Layout and Printing - Save a screenshot of the Print Pane for the Practice Document and paste it into a Word doc and save as YourUsername_Printing and attach to assignment.
Intro to Formulas - Save the Challenge! Practice Document as YourUsername_Intro and attach to assignment.Creating More Complex Formulas- Save the Challenge! Practice Document as YourUsername_Complex and attach to assignment.Relative and Absolute Cell References - Save the Challenge! Practice Document as YourUsername_References and attach to assignment.Functions - Save the Challenge! Practice Document as YourUsername_Functions and attach to assignment
Freezing Panes and View Options - Submit a screenshot showing the result of Challenge Step 8, paste into Word, as YourUsername_Panes and attach to assignment.Sorting Data - Save the Challenge! Practice Document as YourUsername_Sort and attach to assignment.Filtering Data - Save the Challenge! Practice Document as YourUsername_Filter and attach to assignment.Groups and Subtotals - Save the Challenge! Practice Document as YourUsername_Groups and attach to assignment.Tables - Save the Challenge! Practice Document as YourUsername_Tables and attach to assignment.Charts - Save the Challenge! Practice Document as YourUsername_Charts and attach to assignment.Conditional Formatting - After Step 7, Save the Challenge! Practice Document as YourUsername_Condition and attach to assignment.
Comments and Co-authoring– Save the Challenge! Practice Document as YourUsername_Changes and attach to assignment.Inspecting and Protecting Workbooks - Save the Challenge! Practice Document as YourUsername_Inspect and attach to assignment.Intro to PivotTables- Save the Challenge! Practice Document as YourUsername_PivotTable and attach to assignment.Doing More with PivotTables - Save the Challenge! Practice Document as YourUsername_PivotTable2 and attach to assignment.What-If Analysis - Submit a screenshot of Goal Seek for Step 4 and paste into a Word document. Save workbook as YourUsername_WhatIf and attach both files to assignment.
The documents you submit should look like the documents shown at the end of each Challenge.