Customisable Instructor Materials

Training materials for

Microsoft Excel 2007 Training

Fully Customisable

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

  • Student manual Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs. 1
  • Student workbook Fully customisable. Additional book includes series of practical tasks and review questions. 2
  • Student workbook exercises Fully customisable. Sample exercises to accompany the student workbook. 3
  • Trainer manual Fully customisable. Includes invaluable information and tools to help the trainer. 4
  • Presentations Fully customisable. Complete set of PowerPoint slides for use by the trainer. 5
  • Timetable and lesson plans Fully customisable. Detailed timetable and plans ensure you deliver the best possible course. 6

The Courseware Company (established in the early 1990s and part of gtslearning) is the only European authorised reseller of Velsoft courseware materials and print licences. Velsoft offers fully customisable training materials, delivered online and fully supported with instructor resources and student study tools.

To get started, just open this 'Excel 2007' training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered 'off-the-peg' and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

You Also Receive

  • Fully customisable Sold on a site licence basis, you can tailor the courseware to meet specific learning or corporate requirements. 1
  • Instant download Content is available to download immediately after purchase. Backup CDs are also available. 2
  • Proven Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release. 3
  • Simple... No need to invest in expensive DTP applications - all files are easily editable in any word processor. 4
  • Print on demand You only need to print exactly what you need, when you need it. 5
  • Totally flexible Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need. 6
  • Unlimited users Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever! 7
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it. 8
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000, it doesn’t matter... 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).

Try before you buy!

Download for FREE

Microsoft Excel 2007 Courseware

  • Fully Customisable
  • Add your own name & logos
  • Unlimited reprinting rights
  • Unlimited number of users
  • No annual renewal fees

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

The UK’s Number One choice for Customisable 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 Customisable 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.