Self Paced Microsoft 2007 Training Course
Microsoft Excel 2007 - Level 1
Fee - $190 inc GST
Duration - Average Completion Time - 14 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 2 - Excel 2007 Level 3 - Excel 2007 Level 4
Excel 2007 Level 1 - Instructor Note: While no special knowledge of the Excel program is required for this course, we do presume that the user has basic Windows knowledge, including how to use the Start menu, how to use the mouse, and how to use the keyboard.
Excel 2007 Level 1 - Learning Outcomes:
Section 1: Getting Started
In this section you will learn:
What Microsoft Excel 2007 is
How to open Microsoft Excel
How to interact with Excel
How to close Excel
How to create a new workbook
How to open a workbook
How to save a workbook
How to close a workbook
About Excel file types
How to switch worksheets
About the active cell
How to select cells
How to explore a worksheet
How to use the zoom feature
How to use the Help screen
How to use Online Help
How to use Offline Help
How to open Microsoft Excel
How to interact with Excel
How to close Excel
How to create a new workbook
How to open a workbook
How to save a workbook
How to close a workbook
About Excel file types
How to switch worksheets
About the active cell
How to select cells
How to explore a worksheet
How to use the zoom feature
How to use the Help screen
How to use Online Help
How to use Offline Help
Section 2: The New Interface
In this section you will learn about:
The default Quick Access toolbar buttons
Adding buttons
Removing buttons
Changing icon size
The Home tab
The Insert tab
The Page Layout tab
The Formula tab
The Data tab
The Review tab
Adding buttons
Removing buttons
Changing icon size
The Home tab
The Insert tab
The Page Layout tab
The Formula tab
The Data tab
The Review tab
Section 3: Excel Basics
In this section you will learn how to:
Work with columns, rows, cells, and ranges
Create worksheet labels
Enter and delete data
Print your worksheet
Use the AutoFill feature
Use the AutoSum feature
Use AutoComplete
Work with basic formulas
Drag and drop cells
Cut, copy, and paste cells
Copy and paste multiple items
Use paste special
Insert and delete cells, rows, and columns
Use undo, redo, and repeat
Use Smart Tags
Use the error option button
Use the AutoFill option button
Use the Paste Option button
Use AutoCorrect
Use Spell check
Use Find and Replace
Document a worksheet with comments
Create worksheet labels
Enter and delete data
Print your worksheet
Use the AutoFill feature
Use the AutoSum feature
Use AutoComplete
Work with basic formulas
Drag and drop cells
Cut, copy, and paste cells
Copy and paste multiple items
Use paste special
Insert and delete cells, rows, and columns
Use undo, redo, and repeat
Use Smart Tags
Use the error option button
Use the AutoFill option button
Use the Paste Option button
Use AutoCorrect
Use Spell check
Use Find and Replace
Document a worksheet with comments
Section 4: Editing Your Workbook
In this section you will learn how to:
Change the size of rows or columns
Adjust cell alignment
Rotate text
Create custom number or date formats
Use conditional formatting
Use the Format Painter
Merge cells
Use AutoFit
Find and replace formatting
Add patterns and colors
Add borders
Work with styles
Create charts
Format charts
Enhance charts with drawing tools
Change the chart type
Change the source data for a chart
Work with chart axes and data series
Create a chart template
Adjust cell alignment
Rotate text
Create custom number or date formats
Use conditional formatting
Use the Format Painter
Merge cells
Use AutoFit
Find and replace formatting
Add patterns and colors
Add borders
Work with styles
Create charts
Format charts
Enhance charts with drawing tools
Change the chart type
Change the source data for a chart
Work with chart axes and data series
Create a chart template
Section 5: Printing and Viewing your Workbook
In this section you will learn how to:
Use normal view
Use the Page Break Preview
Use the Page Layout view
Use the Full Screen view
Manage a single window
Create a window
Hide a window
Freeze a pane
Manage multiple windows
Switch between open workbooks
Arrange windows
Compare workbooks side by side
Reset windows
Save a workspace
Use Print Preview
Use the Print dialog
Use the Page Setup dialog
Use Quick Print
Use the Page Break Preview
Use the Page Layout view
Use the Full Screen view
Manage a single window
Create a window
Hide a window
Freeze a pane
Manage multiple windows
Switch between open workbooks
Arrange windows
Compare workbooks side by side
Reset windows
Save a workspace
Use Print Preview
Use the Print dialog
Use the Page Setup dialog
Use Quick Print
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 14 hours on average.
Prerequisites:
This Excel 2007 Level 1 course presumes no special knowledge of the Excel program is required for this course, we do presume that the user has basic Windows knowledge, including how to use the Start menu, how to use the mouse, and how to use the keyboard.
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 1 Training Course:
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
Step-By-Step
What is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
Step-By-Step
Lesson 1.2: About Workbooks
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Step-By-Step
Skill Sharpener
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.3: Exploring your Workbook
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature
Step-By-Step
Skill Sharpener
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature
Step-By-Step
Skill Sharpener
Lesson 1.4: Getting Help in Excel 2007
Using the Help Screen
About Online Help
About Offline Help
Step-By-Step
Skill Sharpener
Using the Help Screen
About Online Help
About Offline Help
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 1: Review Questions
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: The Home Tab
Clipboard
Font
Alignment
Number
Style
Cells
Editing
Step-By-Step
Skill Sharpener
Clipboard
Font
Alignment
Number
Style
Cells
Editing
Step-By-Step
Skill Sharpener
Lesson 2.3: The Insert Tab
Tables
Charts
Illustrations
Shapes
Links
Text
Step-By-Step
Skill Sharpener
Tables
Charts
Illustrations
Shapes
Links
Text
Step-By-Step
Skill Sharpener
Lesson 2.4: The Page Layout Tab
Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener
Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener
Lesson 2.5: The Formulas Tab
The Function Library
Defined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener
The Function Library
Defined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener
Lesson 2.6: The Data Tab
Get External Data
Connections
Sort and Filter
Data Tools
Outline
Step-By-Step
Skill Sharpener
Get External Data
Connections
Sort and Filter
Data Tools
Outline
Step-By-Step
Skill Sharpener
Lesson 2.7: The Review Tab
Proofing
Comments
Changes
Step-By-Step
Skill Sharpener
Proofing
Comments
Changes
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 2: Review Questions
Section 3: Excel Basics
Lesson 3.1: Working With Excel 2007
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet
Step-By-Step
Skill Sharpener
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet
Step-By-Step
Skill Sharpener
Lesson 3.2: Basic Excel Features
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Step-By-Step
Skill Sharpener
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Step-By-Step
Skill Sharpener
Lesson 3.3: Moving your Data
Dragging and Dropping Cells
How to Cut, Copy, and Paste Cells
How to Cut, Copy, and Paste Multiple Cells and Items
How to Use Paste Special
How to Insert and Delete Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Step-By-Step
Skill Sharpener
Dragging and Dropping Cells
How to Cut, Copy, and Paste Cells
How to Cut, Copy, and Paste Multiple Cells and Items
How to Use Paste Special
How to Insert and Delete Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Step-By-Step
Skill Sharpener
Lesson 3.4: Smart Tags and Options Buttons
What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Setting Smart Tag Options
Step-By-Step
Skill Sharpener
What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Setting Smart Tag Options
Step-By-Step
Skill Sharpener
Lesson 3.5: Editing Tools
Using AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments
Step-By-Step
Skill Sharpener
Using AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 3: Review Questions
Section 4: Editing Your Workbook
Lesson 4.1: Modifying Cells and Data
Changing the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Step-By-Step
Skill Sharpener
Changing the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Step-By-Step
Skill Sharpener
Lesson 4.2: Cell Formatting
Conditional Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Step-By-Step
Skill Sharpener
Conditional Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Step-By-Step
Skill Sharpener
Lesson 4.3: Enhancing a Worksheet’s Appearance
Adding Patterns and Colors
Adding Borders
Working with Styles
Step-By-Step
Skill Sharpener
Adding Patterns and Colors
Adding Borders
Working with Styles
Step-By-Step
Skill Sharpener
Lesson 4.4: Working With Charts, Part 1
Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Tab
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics
Step-By-Step
Skill Sharpener
Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Tab
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics
Step-By-Step
Skill Sharpener
Lesson 4.5: Working with Charts, Part 2
Changing the Type of Chart
Changing the Source Data
Working with the Chart Axis and Data Series
Saving a Chart as a Template
Step-By-Step
Skill Sharpener
Changing the Type of Chart
Changing the Source Data
Working with the Chart Axis and Data Series
Saving a Chart as a Template
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 4: Review Questions
Section 5: Printing and Viewing your Workbook
Lesson 5.1: Using the View Tab
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Step-By-Step
Skill Sharpener
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Step-By-Step
Skill Sharpener
Lesson 5.2: Managing a Single Window
Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Step-By-Step
Skill Sharpener
Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Step-By-Step
Skill Sharpener
Lesson 5.3: Managing Multiple Windows
Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Step-By-Step
Skill Sharpener
Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Step-By-Step
Skill Sharpener
Lesson 5.4: Printing your Workbook
Opening Print Preview
Using the Print Preview Tab
Quick Printing
The Print Dialog
Using Page Setup
Step-By-Step
Skill Sharpener
Opening Print Preview
Using the Print Preview Tab
Quick Printing
The Print Dialog
Using Page Setup
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
Index
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 |