*Bundle and Save
This courseware title is also available in a Bundle
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
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.
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.
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.
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).
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.
This course can be purchased individually or as part of the Microsoft Office 2007 Bundle. Also included in this bundle are: