Project Includes

Teacher Guide
Student Workbook
Customizable Resources

Assessment Tools
Extension Activities
Sample Files

Templates
Parent Letters
Certificates

Details

TechnoExcel

Item Number: SNR-EXCEL
Technology Integration: Language Arts, Visual arts.
Technology Skill: Spreadsheet
Program: MS Excel
Includes: Navigate around your computer using Windows Explorer. Perform some basic file management tasks in Windows Explorer. View files ,Use the Navigation Pane, Auto Recover. Convert files in XLS format to the new XLSX format. Encrypt the contents of a workbook. Digitally sign a workbook. Manage file properties. Manage file versions. Use the Document Inspector, Accessibility Checker, and Compatibility Checker. Set compatibility options. Describe Pivot tables, modify tables, pivot chart, Add data in Pivot chart, change the chart type, format chart elements, PMT, FV functions, VLOOPKUP, HLOOKUP, record, edit and play macros, codes and comments in macros, keystrokes, variables, prompt for user input.

Session 1: Advance File task
Introduction to Window Explorer, publishing PDF, manage file properties.
Session 2: Pivoting Data
Create Pivot tables, Modify pivot tables, creating slicers, download and use of power pivot.
Session 3: Charting Pivoted Data
Create pivot chart from pivot table, chart types, styles, scenario based pivot chart.
Session 4: Advanced Excel Tasks
PMT and FV functions, IRERROR function with array function, VLOOKUP and HLOOKUP.
Session 5: Macros
Introduction of Macros, Visual basic Editor, keystroke.
Session 6: Visual Basic and Excel Programming
Declare variables, use of statements.

Optional Excel Lesson Plans

  • Introduction of Window Explorer in excel: navigation, Publishing PDF or XPS, using of File
  • Charting Pivot Data: Details on Pivot chart, Pivotchart tools and tabs, formatting Pivortchart.
  • Macros: Creation of Macros, understanding more about macro tasks.
  • Pivoting Data: Detail description about Pivot table, formatting in pivot tables.
  • Advanced Excel tasks: Explanation on using of advanced functions, using of VLOOKUP functions.
  • Visual basics and excel programming: Details on Visual basics and Excel Programming.

Learning Objectives

More with Excel

This curriculum deals with navigation Windows explorer with Excel. Teaching about the navigation tools, pivot tables, Pivot charts and its tools, advanced Excel tasks, macros and visual basics and excel programming.

  • Usage of Navigation pane in windows Explorer.
  • Perform some basic file management tasks in Windows Explorer.
  • Convert files in XLS format to the new XLSX format.
  • Encrypt the contents of the workbook.
  • Describe and create Pivot tables
  • Modify the Pivot Tables.
  • Manually format a pivot table.
  • Create a slicer and use the slicer tools tab.
  • Integrate Access and excel data using PowePivot.
  • Create a Pivot chart from a scratch or from an existing Pivot table.

Review

Customer Reviews

This curriculum deals with navigation Windows explorer with Excel. Teaching about the navigation tools, pivot tables, Pivot charts and its tools, advanced Excel tasks, macros and visual basics and excel programming.