Excel Lessons
Complete the lessons below. Download each practice workbook to work on with the lesson. Complete the challenge at the end of the lesson. Save each Challenge file into your Office folder. DO NOT PRINT
Excel 2016 Basics 2 Understanding OneDrive (nothing to save for this one) 3 Creating and Opening Workbooks 4 Saving and Sharing Workbooks (two files for this one) Working with Cells and Sheets 6 Modifying Columns, Rows, and Cells 8 Understanding Number Formats 9 Working with Multiple Worksheets 12 Page Layout and Printing (do not actually print but save the document) Formulas and Functions 14 Creating More Complex Formulas 15 Relative and Absolute Cell References Working with Data 18 Freezing Panes and View Options Lessons below are extra credit Doing More with Excel 26 Inspecting and Protecting Workbooks 28 Doing More with PivotTables
|