Courseware.co.uk

Microsoft Excel 2007 Training Materials

Fully Customizable

Microsoft Office Excel 2007 is the newest version of Microsoft’s popular spreadsheet program. This four-level course explores nearly all of Excel’s many features. Whether you’re using Excel for the first time, or have been using it for years, this course will help you make the most of Excel 2007’s new features and interface.

Highlights of the course include complete coverage of the new interface, use of Excel functions, PivotTables, and publishing to PDF. Note: this is the info found at the top of each Velsoft site. For example: click here

Learn more... Course Outline 

 

Target Audience

Our courseware is primarily purchased by five types of trainer; HR managers, corporate trainers, private training firms, educational institutions, or private consultants. The target audience varies on the instructor and the type of training required by a particular organization.

The students for this course are usually training staff or managers involved in training.

Prerequisites

No previous experience or training in Excel is required, though students should possess basic numeracy and literacy and ideally have a basic understanding of using computers and software applications, such as Microsoft Word.

What You Actually Receive
  • Training Manual Customizable. Can be opened in Word and you can make any change you like. 1
  • Exercise Workbook Customizable. Separate book with hands-on exercises. Also includes review questions. 2
  • Exercise Files Customizable. We provide the sample files to use with the Exercise Workbook. 3
  • Instructor Guide Customizable. Offers additional instructor information. 4
  • PowerPoint Slides Customizable. We’ve even done your presentation slides for you. 5
  • Lesson Plans Customizable. Keep you class or workshop running smoothly with detailed lesson plans. 6

Courseware.co.uk is the only European organization authorized to sell Velsoft courseware. Velsoft Courseware offers training material as a customizable product and does so in a way that differentiates it in the workplace learning and performance market. Velsoft sells ‘courseware’. The term courseware has been around for years but, because of the Internet, courseware as a product has become a growing, preferred method of purchasing instructor-led training material. Courseware (short for course material in a software format) is considered software. In particular, it is software designed to eliminate prep time by providing proven, pre-written courses in an electronic format. The electronic aspect offers several key advantages such as instant access and customizable flexibility so the trainer can ‘localize’ the content.
 
As an instructor, you simply open this Microsoft Excel 2007 course material in Microsoft Word (or any word processing program). You have the rights (for your location) to edit the content to suite you or your students’ needs. Instantly you have your course… we have saved you hundreds of hours, thousands of dollars and given you the confidence to walk into the classroom. All you do is simply print-on-demand as many course workbooks as you need – when you need them.

You Also Receive
  • Customizable Rights are given on a per site location to edit the content to suit the training needs or corporate environment. 1
  • Instantly Available Courses are instantly available as a download or can be shipped on CD. 2
  • Proven Velsoft courses are used every day by thousands of trainers in countries all over the world.

    Before release, each Velsoft course is tested in the classroom and sent to beta testers. Some courses are also tested at St. Mary’s University via Kay Parker (for more detail see the last step in section titled How Courseware is Created).
    3
  • Easy to use All courses and materials are easily opened in Microsoft Word or any word processing program. 4
  • Print-on-demand Instructors only print what they need, when they need it. 5
  • Flexible Instructors can easily remove sections, combine courses, ‘localize’ examples, add new content, etc. 6
  • Unlimited number of users Rights are sold on a per location basis. Each location is permitted to use the material with as many staff at the location as they like (including future training). 7
  • No annual renewal fees Organizations are not required to pay renewal fees. 8
  • Unlimited re-printing rights Ongoing use means organizations are not limited to the number of times they can reprint the course material. 9

Microsoft Excel 2007 Training Outline

Getting Started To begin, participants will learn the basics of Excel: how to open and close it, how to use the interface, how to create a basic spreadsheet and workbook, how to save and open workbooks, and how to get help.

Excel Basics In this section, participants will learn more about creating spreadsheets, including how to work with cells, columns, rows, and ranges; adding worksheet labels; basic Excel features and functions; moving data; using Smart Tags; using option buttons; and using Excel’s review tools (including spell check, AutoCorrect, and Find and Replace).

The New Interface Next, participants will closely examine the new interface, including the Quick Access Toolbar and each of the default tabs.

Editing Your Workbook Participants will learn how to change the way their data appears, including using conditional formatting, the Format Painter, and styles. Participants will also receive an introduction to creating and editing charts.

Printing and Viewing your Workbook This section will focus on using the View tab, Print Preview, and Excel’s various printing commands.

Advanced File Tasks Participants will learn how to use My Computer within Excel, various ways to save their files, and how to use and create templates.

Working with Functions and Formulas This section will take an in-depth look at Excel formulas and functions, including the IF function. Participants will also learn how to use formula troubleshooting tools, named ranges, AutoCalculate, and array formulas.

Managing Tables Believe it or not, you can actually use Excel 2007 as a basic database application. This section will explain how to do that through a discussion of tables, records, fields, filters, and technical concerns.

Enhancing your Workbook Participants will learn how to add shapes, SmartArt, text boxes, WordArt, ClipArt, embedded objects, and signature lines to their workbook.

Finalizing your Workbook This section will explore some of Excel’s security tools, including the Protect Sheet command and the Lock command. We will also look at two new tools: the Compatibility Checker and the Document Inspector. Next, we will look at using Excel data in Word, Access, and Outlook, and at saving Excel data in common formats (including PDF) to be read by non-Office applications.

Advanced Topics Participants will learn how to use Excel Options to change their user name, default font, default file format, and screen theme. Participants will also learn how to use Office diagnostic tools and the Excel viewer.

Getting the Most from your Data This section will explore some of Excel’s data analysis tools, including the outlining feature, subtotals, PivotTables, scenarios, and what-if analysis.

Excel and the Internet This section will look at some tools used to link Excel data to the Internet, including hyperlinks, Web queries, and Excel services. Participants will also learn how to save their workbooks as web pages.

Advanced Excel Tasks Participants will learn how to create and use shared workbooks; use custom AutoFill lists; use VLOOKUP; and how to link, consolidate, and combine workbooks.

Add-Ins, Smart Tags and Digital Security Participants will explore how to use the Trust Center, how to manage add-ins, how to use Information Rights Management, how to add a digital signature to their workbook, and how to create custom Smart Tags.

Macros, VBA, and Excel Programming This section will introduce participants to macros and Visual Basic programming.

Expert Topics To conclude the course, participants will learn how to use Excel to create and program forms, how to publish Excel data to a SharePoint server, and how to use advanced functions (including PMT, FV, and logical functions).

Download a sample courseware title for FREE

Includes Instructor Guide, Student Workbook, PowerPoint Slides, Course Timings, Review Questions, plus more...

Soft Skills, Business Skills and Computer Training Courseware by The Couseware Company

The UK’s Number One choice for customizable Soft Skills, Business Skills and Computer Training courseware

Want to deliver the best Business Skills or Computer Training courses to your students? The Courseware Company is the UK’s leading supplier of fully customizable business skills courseware licences.


Content is available for many business disciplines as well as Microsoft Office, Adobe and many other training products. Essentially, we’ve packaged the classroom   prep time into an affordable, effective product.

Bundle and Save

This course can be purchased individually or as part of the Microsoft Office 2007 Bundle. Also included in this bundle are:

About Courseware.co.uk

The Courseware Company
Three Elysium Gate
126-128 New King’s Road
London SW6 4LZ
United Kingdom
+44(0)207 887 7999
Twitter Bird

Call The Courseware Company now at +44(0)207 887 7999 or Contact us