Self Paced Microsoft 2007 Training Course
Microsoft Excel 2007 - Level 2
Fee - $190 inc GST
Duration - Average Completion Time - 12 Hours Self Paced
Click on the link above & a fillable Adobe PDF form will download to your computer
Or Click Here to Request a Registartion Form & Further Information Today.
Microsoft Excel 2007 is one of the most powerful and widely used spreadsheet applications available today. Microsoft Excel 2007's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world.
Our TBST Excel 2007 Training Courses are comprehensive enough to meet the needs of beginners and experienced users alike. With Excel 2007 you can perform a wide range of tasks, from building basic spread sheets to performing advanced data analysis. Excel can help you process, interpret, and extract meaningful conclusions from your information.
What does the course include?
This is a Self Paced Microsoft Excel 2007 Training Course. We will send you all your course materials including a very comprehensive course training manual, a CD with all your training files, assignments and exercises and review questions. You will work through the manual and all the exercises at you own pace and submit your review questions back to us upon completion of your course.
Included with your course you will receive:
A Comprehensive Training Manual
Step By Step Exercises
Skills Sharpener Assignments
Case Study Exercises
CD Rom Containing All Practical Exersise Course Files
Review Questions
Certificate of Completion - Presented upon successful completion of post course assessment.
This Microsoft Office 2007 Training Course contains several sections.
Each section is devoted to a different theme.
Each section has a number of lessons, a case study assignment and review questions.
| Concepts | A specific portion of the overall theme. For example, a section may focus on using toolbars, while a concept would address a specific toolbar. |
| Step-By Step | A walkthrough of the concepts covered in the lesson. |
|
Skill Sharpener |
A free-form assignment focusing on the concepts covered in the lesson. |
| Case Study | A larger free-form assignment focusing on all concepts taught in the section. |
|
Review Questions |
A formal test for students. |
Follow Up Courses: Excel 2007 Level 1 - Excel 2007 Level 3 - Excel 2007 Level 4
Excel 2007 Level 2 - Instructor Note: This course presumes that the user has a basic knowledge of Windows, including concepts such as using the mouse and keyboard. It also presumes that the user has completed Level 1 of this course (or has equivalent knowledge) and is familiar with concepts such as working with rows and columns and entering basic formulas.
Excel 2007 Level 2 - Learning Outcomes:
Section 1: Advanced File Tasks
In this section you will learn how to:
Navigate with My Computer
Perform basic tasks with My Computer
Change views with My Computer
Use the My Places toolbar
Use file formats
Use file properties
Use AutoRecover
Upgrade a workbook
Open a template
Use a template
Download a template
Create a template
Perform basic tasks with My Computer
Change views with My Computer
Use the My Places toolbar
Use file formats
Use file properties
Use AutoRecover
Upgrade a workbook
Open a template
Use a template
Download a template
Create a template
Section 2: Working with Functions and Formulas
In this section you will learn about:
Relative and absolute cell references
Basic mathematical operators
Using formulas with multiple cell references
Fixing formula errors with the formula auditing tools
Displaying and printing formulas
Functions
Finding the right function
Some useful and simple functions
Inserting functions
Using the If function
Using nested functions
Working with range names
Selecting non adjacent ranges
Array formulas
Using functions with array formulas
Using the If function with array formulas
Basic mathematical operators
Using formulas with multiple cell references
Fixing formula errors with the formula auditing tools
Displaying and printing formulas
Functions
Finding the right function
Some useful and simple functions
Inserting functions
Using the If function
Using nested functions
Working with range names
Selecting non adjacent ranges
Array formulas
Using functions with array formulas
Using the If function with array formulas
Section 3: Managing Tables
In this section you will learn how to:
Use tables
Create tables
Modify tables
Work with the total row
Work with records and fields
Add fields by inserting columns
Add records by inserting rows
Delete records
Sort table entries
Use an AutoFilter
Use a custom AutoFilter
Use an advanced filter
Copy filtered records
Use wildcard characters
Validate data
Work with database functions
Create tables
Modify tables
Work with the total row
Work with records and fields
Add fields by inserting columns
Add records by inserting rows
Delete records
Sort table entries
Use an AutoFilter
Use a custom AutoFilter
Use an advanced filter
Copy filtered records
Use wildcard characters
Validate data
Work with database functions
Section 4: Enhancing your Workbook
In this section you will learn how to:
Insert a symbol or special character
Add and edit shapes
Alter diagrams
Change diagram types
Change diagram designs
Incorporate text into a diagram
Add a signature line to a worksheet
Add a text box
Select a text box
Delete a text box
Move, resize, and format a text box.
Add WordArt to a spreadsheet
Change the outline color and font color of WordArt
Add effects to WordArt
Search for, insert, and format ClipArt
Insert a photo
Create a new embedded object
Embed part of a file
Embed an entire file
Edit embedded objects
Add and edit shapes
Alter diagrams
Change diagram types
Change diagram designs
Incorporate text into a diagram
Add a signature line to a worksheet
Add a text box
Select a text box
Delete a text box
Move, resize, and format a text box.
Add WordArt to a spreadsheet
Change the outline color and font color of WordArt
Add effects to WordArt
Search for, insert, and format ClipArt
Insert a photo
Create a new embedded object
Embed part of a file
Embed an entire file
Edit embedded objects
Section 5: Finalizing Your Workbook
In this section you will learn how to:
Protect a workbook
Protect a sheet
Protect Excel files
Unlock cells
Use the document inspector
Use the compatibility checker
Mark a workbook as final
Insert Excel data into Word
Modify Excel data after insertion
Link Excel data in word
Link an Excel chart in Word
Link an Excel workbook to an Access database
Import table, PivotTable, and PivotChart data from Access
Transform an Excel workbook into an Access database
Use Outlook to send an Excel worksheet
Publish a workbook as a PDF file
Fax an Excel workbook
Open Excel data in different formats
Import data from a text file
Import data from an external data source
Protect a sheet
Protect Excel files
Unlock cells
Use the document inspector
Use the compatibility checker
Mark a workbook as final
Insert Excel data into Word
Modify Excel data after insertion
Link Excel data in word
Link an Excel chart in Word
Link an Excel workbook to an Access database
Import table, PivotTable, and PivotChart data from Access
Transform an Excel workbook into an Access database
Use Outlook to send an Excel worksheet
Publish a workbook as a PDF file
Fax an Excel workbook
Open Excel data in different formats
Import data from a text file
Import data from an external data source
Who should do this course?
Microsoft Excel 2007 is one of the most powerful and widely used spreadsheet applications available today. Excel’s functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world.
If you are new to Excel 2007, the extensive array of features and capabilities that it provides may seem daunting at first, but don’t worry. The keys to becoming proficient with Excel are patience, practice, and a solid foundation built on the basics.
Although Excel is often used for managing financial information, it is just as well suited to scientific data, sports statistics, or practically any other kind of information you need to work with.
Excel 2007 provides a wealth of financial, mathematical, and statistical functions that you can apply to your data. Excel 2007 also offers numerous formatting and presentation options that will help you create slick, professional looking reports. You can use Excel as a database, a graphing and charting tool, a means of evaluating complex formulas, and as a way of sharing data and collaborating with others. When you change data in an Excel spreadsheet, Excel will recalculate your totals, functions, and formulas accordingly.
Our TBST Excel 2007 Training Course is comprehensive enough to meet the needs of beginners and experienced users alike. With Excel you can perform a wide range of tasks, from building basic spread sheets to performing advanced data analysis. Excel can help you process, interpret, and extract meaningful conclusions from your information. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want.
Duration:
Total duration of the course is approximately 12 hours on average.
Prerequisites:
This course presumes that the user has a basic knowledge of Windows, including concepts such as using the mouse and keyboard. It also presumes that the user has completed Level 1 of this course (or has equivalent knowledge) and is familiar with concepts such as working with rows and columns and entering basic formulas.
Click on the link above & a fillable Adobe PDF form will download to your computer
Or Click Here to Request a Registartion Form & Further Information Today.
Units Covered in the Microsoft Excel 2007 - Level 2 Training Course:
Section 1: Advanced File Tasks
Section 1: Advanced File Tasks
Lesson 1.1: Using My Computer within Excel
Using the My Places Toolbar
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views
Step-By-Step
Skill Sharpener
Lesson 1.2: Saving your Files
File Formats
File Properties
AutoRecover
Upgrading a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.3: Using Templates
Opening a Template
Downloading a Template
Using a Template
Creating a Template
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Working with Functions and Formulas
Using the My Places Toolbar
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views
Step-By-Step
Skill Sharpener
Lesson 1.2: Saving your Files
File Formats
File Properties
AutoRecover
Upgrading a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.3: Using Templates
Opening a Template
Downloading a Template
Using a Template
Creating a Template
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Step-By-Step
Skill Sharpener
Lesson 2.2: Exploring Excel Functions
What are Functions?
Finding the Right Function
Some Useful and Simple Functions
Step-By-Step
Skill Sharpener
Lesson 2.3: Using Functions in Excel
Inserting Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Step-By-Step
Skill Sharpener
Lesson 2.4: Working with Names and Ranges
What Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate
Step-By-Step
Skill Sharpener
Lesson 2.5: Working with Array Formulas
What are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Managing Tables
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Step-By-Step
Skill Sharpener
Lesson 2.2: Exploring Excel Functions
What are Functions?
Finding the Right Function
Some Useful and Simple Functions
Step-By-Step
Skill Sharpener
Lesson 2.3: Using Functions in Excel
Inserting Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Step-By-Step
Skill Sharpener
Lesson 2.4: Working with Names and Ranges
What Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate
Step-By-Step
Skill Sharpener
Lesson 2.5: Working with Array Formulas
What are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Managing Tables
Lesson 3.1: Working with Tables
What is a Table?
Creating Tables
Modifying Tables
What is the Total Row?
Step-By-Step
Skill Sharpener
Lesson 3.2: Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data table
Deleting Records or Fields
Step-By-Step
Skill Sharpener
Lesson 3.3: Working with Tables and Filters
Sorting Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records
Step-By-Step
Skill Sharpener
Lesson 3.4: Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
What are Database Functions?
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Enhancing your Workbook
What is a Table?
Creating Tables
Modifying Tables
What is the Total Row?
Step-By-Step
Skill Sharpener
Lesson 3.2: Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data table
Deleting Records or Fields
Step-By-Step
Skill Sharpener
Lesson 3.3: Working with Tables and Filters
Sorting Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records
Step-By-Step
Skill Sharpener
Lesson 3.4: Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
What are Database Functions?
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Enhancing your Workbook
Lesson 4.1: Customizing your Workbook
Inserting a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Step-By-Step
Skill Sharpener
Lesson 4.2: Working with Text Boxes
Adding a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box
Step-By-Step
Skill Sharpener
Lesson 4.3: WordArt
Adding WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects
Step-By-Step
Skill Sharpener
Lesson 4.4: ClipArt
Finding ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image
Step-By-Step
Skill Sharpener
Lesson 4.5: Using Objects
Creating New Embedded Objects
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 5: Finalizing Your Workbook
Inserting a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Step-By-Step
Skill Sharpener
Lesson 4.2: Working with Text Boxes
Adding a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box
Step-By-Step
Skill Sharpener
Lesson 4.3: WordArt
Adding WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects
Step-By-Step
Skill Sharpener
Lesson 4.4: ClipArt
Finding ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image
Step-By-Step
Skill Sharpener
Lesson 4.5: Using Objects
Creating New Embedded Objects
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 5: Finalizing Your Workbook
Lesson 5.1: Protecting your Workbook
Protecting your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files
Step-By-Step
Skill Sharpener
Lesson 5.2: Finishing Your Workbook
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Step-By-Step
Skill Sharpener
Lesson 5.3: Using Excel in Word
Inserting Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document
Step-By-Step
Skill Sharpener
Lesson 5.4: Using Excel and Access
Linking an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database
Step-By-Step
Skill Sharpener
Lesson 5.5: Using Excel With other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
Index
Protecting your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files
Step-By-Step
Skill Sharpener
Lesson 5.2: Finishing Your Workbook
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Step-By-Step
Skill Sharpener
Lesson 5.3: Using Excel in Word
Inserting Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document
Step-By-Step
Skill Sharpener
Lesson 5.4: Using Excel and Access
Linking an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database
Step-By-Step
Skill Sharpener
Lesson 5.5: Using Excel With other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
Index
Click on the link above & a fillable Adobe PDF form will download to your computer
Or Click Here to Request a Registartion Form & Further Information Today.
| Send us an enquiry or comment |