This course is designed for Excel users who have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
How it works
The Excel 2007 Intermediate course is two hours in total length. However, the class is split up into two, one hour sessions. Each session is on a separate day.
Example: Tuesday, Thursday
Course Outline
Hour 1:
Lesson 1: Advanced Formulas
Cell and Range Names Calculate Across Multiple Worksheets Use individual Functions Utlizing Logical & Lookup Functions
Lesson 2:Working with Table Data
Working with Tables Format Tables Sort or Filter Calculate Data
Lesson 3: Charting
Create a Chart Modify Charts Format Charts
Hour 2:
Lesson 4: Pivot tables and PivotCharts
Create a PivotTable Report Create PivotCharts
Lesson 5: Working with graphics
Insert and Modify Pictures and ClipArt Draw & manipulate shapes Using SmartArt Graphics Layer and Group Objects
Lesson 6: Enhance Excel
Customize the Excel Enhance Workbooks Manage Themes Use Templates
