77612 Pro: Microsoft Office Budget Analysis and Forecasting

Microsoft Office Training Course for Sheffield, Leeds, Manchester and Yorkshire

• Home
• Training Services
• Course Schedules
• Microsoft Certifications
• Special Offers
• Room Hire
• Locations
• About Us
• Contact

• The training we received was amongst the best I've experienced. The pace was just right, allowing for varying abilities in our group. Nothing was too much trouble during the course and the pleasant training environment just added to the experience I have no hesitation in recommending Rezound training services and will definitely use them again.
  - Andy Wilton Profitmaster Systems Ltd

Course Information

Introduction

Course Outline

• Obtaining and Managing Data
  • Create a data input form to automate data collection.
  • Create a Microsoft Office Excel 2007 template for data input.
  • Connect to the data source.
  • Automate file-management processes.
  • Quickly locate specific information in a database.
  • Import and export data.
  • Validate data.
  • Schedule content disposition.
• Securing Information
  • Manage access to SharePoint sites and content.
  • Manage the security of Microsoft Office documents.
  • Manage database security.
  • Communicate securely.
• Managing Collaboration
  • Administer an Office SharePoint Server 2007 Collaboration environment.
  • Manage information stored in an Office SharePoint Server 2007 site.
  • Distribute deliverables to other people.
  • Publish a document.
• Manipulating and Analyzing Data
  • Sort and filter data.
  • Create and use named ranges in an Office Excel 2007 workbook.
  • Troubleshoot formulas in an Office Excel 2007 workbook.
  • Summarize and model data by using PivotTables.
  • Calculate business metrics.
  • Create a budget status report.
  • Calculate the historical return on investment (ROI).
  • Forecast the return on investment (ROI).
• Reporting and Presenting Data
  • Create and modify an Office Access 2007 report.
  • Create a visual representation of data in Office Excel 2007.
  • Display dynamically updated content on an Office SharePoint Server 2007 site.
  • Display dynamically updated business indicators in a Dashboard report.
  • Develop presentation resources for re-use.
  • Share data stored in a database with other people.

Copyright © & Design - Rezound Limited | Training Courses for Sheffield, Leeds, Manchester and Yorkshire