Instructor Led 2007 Basic Training
2007 Basic Training Provider? - Tell us about your Training!
From Wise Owl Business Solutions Ltd
Basic Querying in Access 2007




Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
For a full list of course topics, see our
more...
Basic Querying in Access 2007
From Software Training Academy, Inc
Microsoft Excel 2007 - Intermediate



This course builds on the skills and concepts taught in Excel 2007: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and
more...
Microsoft Excel - Advanced



This course builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external
more...
Microsoft Excel 2007 - Basic



This course teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn
more...
From Last Minute Training
Microsoft Office Access 2007 Foundation
Getting Started
Starting Out
What is Microsoft Access?
Whata s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Step-By-Step
Skill Sharpener
Using the Getting Started Window
Overview of the Window
Navigating Through the Window
Creating a
more...
From Computer Tutoring Ltd
Microsoft Word 2007 Beginners





This course is designed to help you gain the basic skills needed to use Microsoft Word. You will learn the basics of word processing including editing, formatting, saving & printing documents. You may also wish to add a picture or table to your document a this will also be covered. You will explore the basic concepts of Microsoft Word which will enable you to produce many various documents for
more...
From Training-2-Go
Excel 2007 - Basic
Getting started
Entering and editing data
Modifying a worksheet
Using functions
Formatting worksheets
Printing
Creating charts
Managing large workbooks
more...
From NetLearn
PowerPoint 2007 basic - advanced




Unit 1: Custom presentation options
Topic A: Application settings
A-1: Exploring the PowerPoint Options dialog box
A-2: Adding buttons to the Quick Access toolbar
A-3: Removing and rearranging buttons
Topic B: Custom themes
B-1: Creating and applying a custom theme
Topic C: Custom templates
C-1: Creating a custom template
C-2: Using a custom template
Topic D: Advanced
more...
Excel 2007 basic - advanced




Unit 1: Advanced functions
Topic A: Logical functions
A-1: Using the IF function
A-2: Using OR, AND, and NOT as nested functions
A-3: Using nested IF functions
A-4: Using the IFERROR function
Topic B: Math and statistical functions
B-1: Using SUMIF
B-2: Using COUNTIF
B-3: Using AVERAGEIF
B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
B-5: Using ROUND
Topic C: Financial functions
more...
