I. Beginning Guide to Microsoft Excel 2007
a. Make a Rainfall Graph
b. Create a Price Sheet
c. Calculate Revenue

II. Intermediate Guide to Microsoft Excel 2007
a. Mail Merge with Excel
b. Create a Time Sheet
c. Calculate Revenue

III. Advanced Guide to Microsoft Excel 2007
a. Absolute and Relative References
b. Create Filters, Subtotals, Use the Lookup Function
c. Analyze Data with a PivotTable



    • Course Overview/Description Course Objectives Course Outline Prerequisites/Audience PC Requirements/Materials Included Instructor Bio FAQs See a Demo
  •  
  • 3ds max
  • Administrative Professional with Microsoft Certified Application Specialist Training
  • Administrative Professional with Microsoft Office Specialist
  • ASP.NET Training
  • AutoCAD 2007
  • AutoCAD 2009
  • Cisco® CCENT™ Authorized Certification Training
  • Cisco® CCNA® Authorized Certification Training
  • CompTIA™ A+ Certification Training
  • CompTIA™  Linux+/LPI Level One Certification Training
  • CompTIA™ Network+/Server+ Certification Training
  • CompTIA™ Security+ Certification Training
  • eBusiness Certificate
  • English as a Second Language - Global English
  • Forensic Computer Examiner
  • Help Desk Analyst: Tier 1 Support Specialist
  • Microsoft Access 2007
  • Microsoft Certified Application Specialist Training (MCAS)
  • Microsoft Certified Database Administrator (MCDBA)
  • Microsoft Certified Desktop Support Technician (MCDST)
  • Microsoft Certified System Administrator 2003 (MCSA)
  • Microsoft Certified System Administrator Plus 2003 (MCSA+)
  • Microsoft Certified System Engineer 2003 (MCSE)
  • Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)
  • Microsoft Office Specialist 2003 (MOS)
  • Microsoft Outlook 2007
  • Microsoft PowerPoint 2007
  • Microsoft Vista Business
  • Microsoft Word 2007
  • Pay Per Click Marketing
  • RFID (Radio Frequency Identification) on the Web™
  • Search Engine Marketing
  • Search Engine Optimization
  • Web Database Developer
  • Webmaster

Microsoft Excel 2007

GES 810 -- 35 hours

Course Outline


    I. Beginning Guide to Microsoft Excel 2007
    a. Make a Rainfall Graph
    b. Create a Price Sheet
    c. Calculate Revenue

    II. Intermediate Guide to Microsoft Excel 2007
    a. Mail Merge with Excel
    b. Create a Time Sheet
    c. Calculate Revenue

    III. Advanced Guide to Microsoft Excel 2007
    a. Absolute and Relative References
    b. Create Filters, Subtotals, Use the Lookup Function
    c. Analyze Data with a PivotTable



Find a School