Posts Tagged ‘tutorial’
XHTML-CSS Online Training – Video 6
November 4, 2010
Working With Cascading Style Sheets
Video 2 of 2
Working with CSS (Cascading Style Sheets) is not difficult and is actually one of the more fun things about being a professional website designer. Here is the first of two videos covering the basics including some XHTML coding.
If you need any advice or have any questions, we can help
right here and right now!
http://makingyourwebsitework.com
Duration : 0:7:41
Option Trading Tutorial Equity “Online Trading” Training Video
September 2, 2010
http://www.stockmarketfunding.com 10-12-2009 GOOG Option Trade Jan 550 Call 15 contracts money management trade. each tutorial ends with a short, … Learn about fast markets and unusual trading situations. … Prior to buying or selling an option, a person must receive a copy of … S&P 100 Strategies (OEX) Buying OEX Puts · Equity Option Strategies – Covered Combinations Options Spreads Tutorial … Options Trading Bookshelf. Equity options Stock Options Tutorial What Is A Call Option? What Is A Put Option? … What is a Put Option? star trading system options training Free Seminar Stock Trading Options Trading Class Tutorial Video Reviews … Options Trading System Stock Trading Training
Stock Market Talk Radio Show
http://www.blogtalkradio.com/stock-radio-show
Follow us on Twitter:
http://www.twitter.com/TradingSchool
Follow us on Facebook:
http://www.facebook.com/OnlineTradingPlatform
Free Trial Signup
http://onlinetradinginvesting.eventbrite.com
Video Alert Signup
http://www.stockmarketfunding.com/evideosignup.htm
Duration : 0:7:19
Understanding User Defined And Constants Types In Excel VBA
August 26, 2010
There will be times within your Excel VBA code where you want to lock down the value of a variable but make it a variable nevertheless. For example, if your application makes reference to a tax rate, having the rate in a variable will offer you a mechanism for changing the rate wherever you have used it in your application. Thus, instead of entering code like “TaxAmount = SubTototal * 0.15″, you would use statements like “TaxAmount = SubTototal * TaxRate”, where tax rate would be a constant.
Constants have to be declared and initialised in one statement: for example “Const TaxRate as Currency = 0.15″. This is the only time that a value can be placed in the constant and herein lies one of its key benefits; the value it contains cannot later be accidentally overwritten because the programmer confuses this variable with another. The other key benefit is the ease with which constants allow us to update our applications. Thus, in the tax rate example, when the tax rate changes, we only need to modify one line of code and that change will update our entire application.
Another variable technique which allows us to “tighten up” the values which may be entered into a variable is to use User Defined Types (UDTs) which, essentially, allow you to define your own variable types. You can then declare as many variables of this given type as you need. Type definitions must be placed at the top of a module; they cannot be placed inside sub routines or functions. The definition consists of a code block inside which the various elements of the type are detailed as well as the data type associated with it. Here is an example of a type definition.
Type Employee
Name As String
Department As String
JobTitle As String
DateOfBirth As Date
StartDate As Date
Salary As Long
End Type
To use your UDT in our code, we use statements like the following:
Dim empNew As Employee
With empNew
.Name = “Gillian Spencer”
.Department = “Information Technology”
.JobTitle = “Web Developer”
.DateOfBirth = 12/05/1982
.StartDate = 25/03/2010
.Salary = 27500
End With
UDTs provide a very useful way of storing related variables in one place. In this regard, they resemble arrays; but, unlike arrays, the elements they contain are named rather than simply referred to by a numerical index.
You can get up to date information on Excel VBA training courses, visit Macresource Computer Training, an independent computer training company offering Excel VBA Classes in London and throughout the UK.
Online Training from BASF Professional Turf & Ornamentals
August 18, 2010
In the last three years, BASF Professional Turf & Ornamentals has underscored its commitment to the industry by developing a family of online training Modules to ensure our distribution partners and end users understand the features and benefits of our products, as well as the dos and don’ts of proper pesticide use. Whether it’s products for use on turfgrass or nursery and greenhouse use—or products that are used in both markets—BASF has brought informative, simple and intuitive training to the market via these online modules. See for yourself by visiting betterplants.basf.us.
Duration : 0:1:21
Online Training from BASF Professional Turf & Ornamentals
August 17, 2010
In the last three years, BASF Professional Turf & Ornamentals has underscored its commitment to the industry by developing a family of online training Modules to ensure our distribution partners and end users understand the features and benefits of our products, as well as the dos and don’ts of proper pesticide use. Whether it’s products for use on turfgrass or nursery and greenhouse use—or products that are used in both markets—BASF has brought informative, simple and intuitive training to the market via these online modules. See for yourself by visiting betterturf.basf.us.
Duration : 0:1:21
Microsoft Excel Text Alignment Options Are More Flexible Than You Might Think
July 14, 2010
The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three relating to the horizontal position your data: left, centre and right. However you’ll notice that when you click in the cells of an unformatted worksheet, none of these three icons is highlighted, which indicates that none of them is the default. The reason for this is that Excel treats data differently depending on the data type.
If you type text in a cell, your text is aligned on the left; if you type a number, the number is aligned on the right; if you type a date, it is also aligned on the right. To change the horizontal alignment, either select a range of cells or click on a column letter to highlight the entire column then click on one of the alignment icons.
Haven chosen one type of horizontal alignment, you can change it in two ways. You can either click on a different form of alignment or click again on the already selected alignment. For example, if your text is centred and you click on the Centre button a second time, this deactivates centre alignment and returns you to the default alignment which, for text, is left. Thus we have, effectively, four types of horizontal alignment: left, centre, right and unspecified (or default), which is the alignment that applies when none of the alignment buttons is highlighted.
Excel also allows you to specify vertical alignment. This setting normally only becomes apparent when you increase the height of the cell and this time there is a definite default which is that text is aligned at the bottom of the cell. This setting applies to text, dates and numbers alike.
To set the vertical alignment, either make a selection or click on the row number to select the entire row then click on one of the buttons to make the change: align middle, align top and so forth.
Excel also features the ability to change the orientation of text within the cell. This is particularly useful in those situations where your column headings are wider than the data in the cells. To change the vertical orientation of your text, just select the cells in question and then choose the appropriate angle in the Alignment dialogue.
If you rotate your column headings by 90 degrees, you can usually make the columns much narrower. Excel has a very useful way of doing this: simply select all the columns that contain data then in the Cell group of the Home Tab of the Excel Ribbon, choose Format then AutoFit Columns. This command makes each of the highlighted columns no wider than it needs to be in order to display all the data it contains.
If you would like to learn more about Excel VBA training courses, visit Macresource Computer Training, an independent computer training company offering Excel VBA training courses in London and throughout the UK.
Informatica Training by TrainOvation – FREE lesson on “Workflow Properties”
July 11, 2010
Watch ALL of our FREE Informatica training videos. Innovative, online training – Learn Informatica at your own pace! www.trainovation.com We offer both a Basics course as well as a Performance and Tuning class.
Duration : 0:9:28
Informatica Training by TrainOvation – FREE lesson on “Lookup Transformation”
May 4, 2010
Watch ALL of our FREE Informatica training videos. Innovative, online training – Learn Informatica at your own pace! www.trainovation.com We offer both a Basics course as well as a Performance and Tuning class.
Duration : 0:8:43
Computer: Basic computer skills course: Video Training (1 of 24)
April 30, 2010
http://www.TechnophobicsAnonymous.net Enjoy these Video Tutorials on Basic Computer skills. Improve your productivity, your skills AND your confidence! Perfect
for Beginners, Boomers, and Seniors. Computer
Duration : 0:6:29
Standalone Versus Embedded Microsoft Excel Charts
April 24, 2010
To create any chart in Microsoft Excel, you must begin by selecting the data that you want to plot including any headings. You then have the choice of creating either a stand-alone chart or an embedded chart. To create a stand-alone chart, right-click on one of your worksheet tabs and choose Insert. Next, click on the chart icon and click OK. Excel creates a chart using the default chart type.
Having just created a chart, you will notice that Excel displays three contextual tabs headed “Chart Tools”. The contextual tabs consist of Design, Layout and Format. The Design contextual tab enables you to change the chart type and the basic information about the chart such as the underlying data.
The Layout tab offers you a more intricate level of control over the various components of your chart. For example, by default, Excel adds a legend to each new chart. If a chart has only one series of data, we don’t need a legend to tell us what the chart colours mean. We can therefore click on the Legend drop-down menu and choose None.
The Format contextual tab gives us the most primitive control over the chart elements. It is here that we are able to click on individual elements and change them at the object level. In other words, we are working on these elements purely as drawing objects rather than as elements of the chart. However, even at this primitive level, Excel still shows us the relationship between the chart elements and the underlying data. Thus, for example, when an individual data point is highlighted, Excel displays the corresponding worksheet address in the formula bar.
When creating a standalone chart, you are not given the option of choosing the chart type during the chart creation process. If you want to change the chart type, you have to do so at a later stage by choosing a Chart Type option in the Design contextual menu.
As regards the chart sheet which contains the chart, it behaves in much the same way as Excel worksheets. For example, it can be renamed or deleted by right-clicking the sheet tab and choosing Rename or Delete from the context menu.
If you would like to learn more about Excel and Excel VBA training courses, visit On Site Training Courses . Com, a UK IT training web site offering Excel Classes all over the UK.