Self Paced Microsoft 2007 Training Course
Microsoft Excel 2007 - Level 4
Fee - $190 inc GST
Duration - Average Completion Time - 7 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. |
Additional Courses: Excel 2007 Level 1 - Excel 2007 Level 2 - Excel 2007 Level 3
Excel 2007 Level 4 - 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 the Level 3 Course (or has equivalent knowledge) and is familiar with concepts such as formulas, operators, and scenarios.
Excel 2007 Level 4 - Learning Outcomes:
Section 1: Add-ins, Smart Tags, and Digital Security
In this section you will learn how to:
Use COM add-ins
Manage add-ins
Install add-ins
Use the Trust Center
Download and install the IRM client software
Use IRM to protect a workbook
View an IRM protected workbook
Obtain a digital signature
Attach a signature to your workbook
Insert a Smart Tag into your workbook
Set up Smart Tag options
Create your own custom Smart Tag
Manage add-ins
Install add-ins
Use the Trust Center
Download and install the IRM client software
Use IRM to protect a workbook
View an IRM protected workbook
Obtain a digital signature
Attach a signature to your workbook
Insert a Smart Tag into your workbook
Set up Smart Tag options
Create your own custom Smart Tag
Section 2: Macros, VBA, and Excel Programming
In this section you will learn how to:
Record macros
Play macros
Set up macro security
Delete macros
Copy macros from other workbooks
Record a relative reference macro
Assign a macro to a keystroke
Open the Visual Basic Editor
Add code to your macro
Add comments to your code
Declare variables
Prompt for user input
Iterate over a worksheet range
Use If Then Else statements
Play macros
Set up macro security
Delete macros
Copy macros from other workbooks
Record a relative reference macro
Assign a macro to a keystroke
Open the Visual Basic Editor
Add code to your macro
Add comments to your code
Declare variables
Prompt for user input
Iterate over a worksheet range
Use If Then Else statements
Section 3: Expert Topics
In this section you will learn:
What a form control is
How to add a form control to a worksheet
How to use a form control
How to assign a macro to a form control
How to use the PMT function
How to use the FV function
How to use logical functions and tests
How to create a workspace on a SharePoint server
How to access a SharePoint workspace
How to publish to a SharePoint workspace
How to add a user form
How to add ActiveX controls to a user form
How to add VBA to ActiveX controls
How to start a user form with a macro
How to add a form control to a worksheet
How to use a form control
How to assign a macro to a form control
How to use the PMT function
How to use the FV function
How to use logical functions and tests
How to create a workspace on a SharePoint server
How to access a SharePoint workspace
How to publish to a SharePoint workspace
How to add a user form
How to add ActiveX controls to a user form
How to add VBA to ActiveX controls
How to start a user form with a macro
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 7 hours on average.
What does the course include?
Included with your course you will receive:
A Comprehensive Training Manual - 200+ pages
Step By Step Exercises
Skills Sharpener Assignments
Case Study Exersises
CD Rom Containing All Practical Exersise Course Files
Review Questions
Certificate of Completion - Presented upon successful completion of post course assessment.
A Comprehensive Training Manual - 200+ pages
Step By Step Exercises
Skills Sharpener Assignments
Case Study Exersises
CD Rom Containing All Practical Exersise Course Files
Review Questions
Certificate of Completion - Presented upon successful completion of post course assessment.
Prerequisites:
This Excel 2007 Level 4 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 the Level 3 Course (or has equivalent knowledge) and is familiar with concepts such as formulas, operators, and scenarios.
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 4 Training Course:
Section 1: Add-ins, Smart Tags, and Digital Security
Lesson 1.1: Add-ins and the Trust Center
What is a COM Add-in?
Add-In Management
Installing Add-ins
Using the Trust Center
Add-Ins
Step-By-Step
Skill Sharpener
Lesson 1.2: Information Rights Management
What is IRM?
Requirements for IRM
Downloading and Installing the Rights Management Client Software
Using IRM
Opening an IRM Protected Document
Step-By-Step
Skill Sharpener
Lesson 1.3: Digital Signatures
What is a Digital Signature?
Obtaining a Digital Signature
Attaching your Signature to a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.4: Smart Tags and XML
What is a Smart Tag?
Inserting Smart Tags into a Worksheet
Setting Smart Tag Options
Creating Custom Smart Tags
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Macros, VBA, and Excel Programming
Lesson 2.1: Macros
Recording Macros
Playing a Macro
Macro Security
Step-By-Step
Skill Sharpener
Lesson 2.2 More Macro Tasks
Recording a Relative Reference Macro
Running a Relative Reference Macro
Assigning a Keystroke to a Macro
Copying a Macro from a Workbook or Template
Step-By-Step
Skill Sharpener
Lesson 2.3: Visual Basic and Macros
Opening the Visual Basic Editor
Adding Code to your Macro
Adding Comments to VBA Code
Declaring Variables
Prompting for User Input
Iteration over a Range
Using IF Then Else Statements
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Expert Topics
Lesson 3.1: Form Controls
What is a Form Control?
Adding a Control to a Worksheet
Assigning a Macro to a Control
Using Form Controls
Step-By-Step
Skill Sharpener
Lesson 3.2: Advanced Functions
Using Financial Functions (PMT and FV)
Understanding Logical Functions
Applying Logical Functions
Step-By-Step
Skill Sharpener
Lesson 3.3: Using SharePoint
Creating a Document Workspace
Accessing a Workspace
Publishing to a Document Workspace
Step-By-Step
Skill Sharpener
Lesson 3.4: User Forms and ActiveX Controls
Creating a Blank User Form
Adding Controls to the Form
Adding Buttons and VBA Code
Starting the User Form with a Macro
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Index
Lesson 1.1: Add-ins and the Trust Center
What is a COM Add-in?
Add-In Management
Installing Add-ins
Using the Trust Center
Add-Ins
Step-By-Step
Skill Sharpener
Lesson 1.2: Information Rights Management
What is IRM?
Requirements for IRM
Downloading and Installing the Rights Management Client Software
Using IRM
Opening an IRM Protected Document
Step-By-Step
Skill Sharpener
Lesson 1.3: Digital Signatures
What is a Digital Signature?
Obtaining a Digital Signature
Attaching your Signature to a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.4: Smart Tags and XML
What is a Smart Tag?
Inserting Smart Tags into a Worksheet
Setting Smart Tag Options
Creating Custom Smart Tags
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Macros, VBA, and Excel Programming
Lesson 2.1: Macros
Recording Macros
Playing a Macro
Macro Security
Step-By-Step
Skill Sharpener
Lesson 2.2 More Macro Tasks
Recording a Relative Reference Macro
Running a Relative Reference Macro
Assigning a Keystroke to a Macro
Copying a Macro from a Workbook or Template
Step-By-Step
Skill Sharpener
Lesson 2.3: Visual Basic and Macros
Opening the Visual Basic Editor
Adding Code to your Macro
Adding Comments to VBA Code
Declaring Variables
Prompting for User Input
Iteration over a Range
Using IF Then Else Statements
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Expert Topics
Lesson 3.1: Form Controls
What is a Form Control?
Adding a Control to a Worksheet
Assigning a Macro to a Control
Using Form Controls
Step-By-Step
Skill Sharpener
Lesson 3.2: Advanced Functions
Using Financial Functions (PMT and FV)
Understanding Logical Functions
Applying Logical Functions
Step-By-Step
Skill Sharpener
Lesson 3.3: Using SharePoint
Creating a Document Workspace
Accessing a Workspace
Publishing to a Document Workspace
Step-By-Step
Skill Sharpener
Lesson 3.4: User Forms and ActiveX Controls
Creating a Blank User Form
Adding Controls to the Form
Adding Buttons and VBA Code
Starting the User Form with a Macro
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: 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 |