Self Paced Microsoft 2007 Training Course
Microsoft Excel 2007 - Level 3
Fee - $190 inc GST
Duration - Average Completion Time - 9 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 4
Excel 2007 Level 3 - 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 2 Course (or has equivalent knowledge) and is familiar with concepts such as working with cells, rows, and columns; using formulas; and creating charts.
Excel 2007 Level 3 - Learning Outcomes:
Section 1: Adanced Topics
In this section you will learn how to:
Change your user name in Excel
Change the default color scheme for Excel
Set up formula options
Change the default font for your workbooks
Change the default file format for your workbooks
Search for Excel documents
Use Office diagnostics
Check for updates
Download Excel viewer
Use the Excel viewer
Start Excel on Windows boot
Change the default color scheme for Excel
Set up formula options
Change the default font for your workbooks
Change the default file format for your workbooks
Search for Excel documents
Use Office diagnostics
Check for updates
Download Excel viewer
Use the Excel viewer
Start Excel on Windows boot
Section 2: Getting The Most From Your Data
In this section you will learn how to:
Use automatic outlining
Display and collapse levels
Group data manually
Create subtotals
Create a PivotTable
Specify data in a PivotTable
Rearrange PivotTable data
Modify PivotTable calculations
Format a PivotTable
Refresh a PivotTable
Chart a PivotTable
Create a PivotTable based on external data
Create a scenario
Create a scenario summary report
Save multiple scenarios
Use a one and two input data table
Use Goal Seek
Use the solver
Display and collapse levels
Group data manually
Create subtotals
Create a PivotTable
Specify data in a PivotTable
Rearrange PivotTable data
Modify PivotTable calculations
Format a PivotTable
Refresh a PivotTable
Chart a PivotTable
Create a PivotTable based on external data
Create a scenario
Create a scenario summary report
Save multiple scenarios
Use a one and two input data table
Use Goal Seek
Use the solver
Section 3: Excel and the Internet
In this section you will learn how to:
Insert a hyperlink
Modify a hyperlink
Use a hyperlink in Excel
Save a workbook as a Web page
Save a worksheet as a Web page
Save a chart as a Web page
Save a range as a Web page
Create a Web query
Save a Web query
Refresh a Web query
Prepare a workbook for Excel services
Publish to a document server
Save to a document management server
Modify a hyperlink
Use a hyperlink in Excel
Save a workbook as a Web page
Save a worksheet as a Web page
Save a chart as a Web page
Save a range as a Web page
Create a Web query
Save a Web query
Refresh a Web query
Prepare a workbook for Excel services
Publish to a document server
Save to a document management server
Section 4: Advanced Excel Tasks
In this section you will learn how to:
Create a shared workbook
Open and edit a shared workbook
Track changes in a shared workbook
Resolve conflicts in a shared workbook
Create a custom AutoFiIl list
Use a custom AutoFill list
Modify a custom AutoFill list
Use the VLOOKUP function
Use VLOOKUP for an exact match
Use VLOOKUP for a closest match
Consolidate workbooks
Link workbooks
Combine worksheets
Open and edit a shared workbook
Track changes in a shared workbook
Resolve conflicts in a shared workbook
Create a custom AutoFiIl list
Use a custom AutoFill list
Modify a custom AutoFill list
Use the VLOOKUP function
Use VLOOKUP for an exact match
Use VLOOKUP for a closest match
Consolidate workbooks
Link workbooks
Combine worksheets
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 9 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 3 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 2 Course (or has equivalent knowledge) and is familiar with concepts such as working with cells, rows, and columns; using formulas; and creating charts.
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 3 Training Course:
Section 1: Advanced Topics
Lesson 1.1: Setting Excel Options
Changing Your User Name
Changing your Default Font
Changing Your Default File Format
Setting Formula Options
Changing the Appearance of Your Excel Interface
Step-By-Step
Skill Sharpener
Lesson 1.2: Excel and Windows
Searching for Documents
Using Office Diagnostics
Checking for Updates
Starting Excel Automatically when Windows Boots
Step-By-Step
Skill Sharpener
Lesson 1.3: Using the Excel Viewer
What is the Excel Viewer?
Downloading the Excel Viewer
Using Excel Viewer
Step-By-Step
Skill Sharpener
Section 1: Review Questions
Section 2: Getting the Most From Your Data
Lesson 2.1: Getting the Most from Your Data
Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals
Step-By-Step
Skill Sharpener
Lesson 2.2: PivotTables
What is a PivotTable?
Creating a PivotTable
Creating a PivotTable Frame
Specifying PivotTable Data
Rearranging PivotTable Data
Step-By-Step
Skill Sharpener
Lesson 2.3: More About PivotTables
Modifying PivotTable Calculations
Formatting a PivotTable
Refreshing a PivotTable
Charting a PivotTable
Creating a PivotTable Based on External Data
Step-By-Step
Skill Sharpener
Lesson 2.4: Exploring Scenarios
What is a Scenario?
Creating a Scenario
Creating a Scenario Summary Report
Saving Multiple Scenarios
Step-By-Step
Skill Sharpener
Lesson 2.5: What If Analysis
Using a One and Two Input Data Table
Using Goal Seek
Using Solver
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Excel and the Internet
Lesson 3.1: Excel and Hyperlinks
What is a Hyperlink?
Inserting Hyperlinks
Modifying Hyperlinks
Using Hyperlinks in Excel
Step-By-Step
Skill Sharpener
Lesson 3.2: Saving Workbooks as Web Pages
HTM and MHTML Files
Saving a Workbook as a Web Page
Saving a Worksheet as a Web Page
Saving a Chart as a Web Page
Saving a Range as a Web Page
Step-By-Step
Skill Sharpener
Lesson 3.3: Getting Data from the Internet
Importing from an External Data Source
Creating a Web Query
Saving a Web Query
Refreshing a Web Query
Step-By-Step
Skill Sharpener
Lesson 3.4: Excel and Office Servers
Publishing to a Document Server
Saving to a Document Management Server
Using Excel with Excel Services
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Advanced Excel Tasks
Lesson 4.1: Creating and Using Shared Workbooks
Sharing a Workbook
Opening and Editing a Shared Workbook
Tracking Changes
Resolving Conflicts in a Shared Workbook
Step-By-Step
Skill Sharpener
Lesson 4.2: Using Custom AutoFill Lists
What is an AutoFill List?
Creating a Custom AutoFill List
Modifying a Custom AutoFill List
Using a Custom AutoFill List
Step-By-Step
Skill Sharpener
Lesson 4.3: Using the VLOOKUP Function
Using VLOOKUP to Find Data
How to Find an Exact Match with VLOOKUP
Finding the Closest Match with VLOOKUP
Step-By-Step
Skill Sharpener
Lesson 4.4: Linking, Consolidating, and Combining Workbooks
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: 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 |