Indirect Charges Search Results

How To: Use direct and indirect reining

Rick Gore explains the differences between direct reining and indirect reining to have better control over the horse and have him go where you desire. Direct reining, also referred as plow reining, is when pressure is applied directly to the horse by pulling the rein. Apply as much pressure as you want to have the horse turn the way you want. Indirect reining on the other hand, is without pressure, laying the rein on the horses' neck to give him an indirect cue to go a certain way, instead of...

How To: Begin drawing using indirect lighting and enclosure

What do you do with those inky black shadow regions in your drawing? When you are drawing areas of shadow, a space that appears black may not actually be entirely black. Add interest to your drawing by adding subtlety to the shadows and reflections of light. This three part instructional drawing video demonstrates how to draw indirect lighting and enclosed spaces using silhouettes, direct light, shadow, and diffuse reflections.

How To: Use indirect objects & object pronouns in Spanish

In this video, we learn how to use indirect objects & object pronouns in Spanish. When you have a noun that is coming after a pronoun, you will have to change the first word that comes after it. If you are saying "yo compro", then you will use "las" after this, to describe the pronoun that you are purchasing. Indirect objects answer the question of who or what. If you want to say "I buy the flowers for you" you would say "Yo compro las flores para ti". Use these simple rules while speaking Sp...

How To: Solve scale and indirect measurement problems

This video walks you through the steps of solving scale and indirect measurement problem. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.

How To: Look up data from different Excel tables with INDIRECT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel

ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.

How To: Understand the sequence of tenses for English

This video tutorial in the Language category will show you how to understand the sequence of tenses for English. This is useful when you want to change direct speech to indirect speech and also for understanding conditional sentences. When the sentence is originally in the present tense, it can be changed to past tense. For example Paul said, "I am hungry". You can change this to indirect speech either in the present tense or in the past tense. So, the sentence can be said as Paul says he is ...

How To: Extract part of a table from a larger table in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Use indirect illumination in modo

Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...

How To: Count dates with an array formula in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.

How To: Count whole and half workdays in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 535th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, ROW, INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.

How To: Understand polyatomic chemical formulas

This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write the charges, cross-over the charges from top to bottom, remove the charge and simplify the numbers and remove the 1s. for example, iron (II) phospahate. The "ate" ending implies that phosphate is polyatomic. The symbol ...

How To: Extract only numbers from a text string array forumla

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.

How To: Create augmented reality apps

In this video, viewers learn how to create augmented reality applications, using Papervision 3D version 2.0. Augmented reality is a term for a live direct or indirect view of a physical real-world environment whose elements are merged with virtual computer-generated imagery - creating a mixed reality. To create augmented reality applications, users require the following programs and software: Adobe Flex Builder 3, TortoiseSVN and FLARToolkit. This video tutorial is not recommended for beginne...

How To: Use "gustar" to express likes and dislikes in Spanish

In this video, we learn how to use "gustar" to express likes and dislikes in Spanish. By practicing examples, you will be able to learn this concept easily. In English, you would say that you like something. But, the equal to this in Spanish is "gustar". You will need to use the appropriate indirect object pronouns while you are saying this in your sentences. To say Me, you will say "a mi" and "to you" is "a ti". When you are speaking to someone about yourself or a group of people, etc your t...

How To: Run a chart lookup with defined names in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.

How To: Look up a picture in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Extract records that meet certain criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...

How To: Write a literature review for thesis writers

In this tutorial, we learn how to write a literature review for thesis writers. The three elements are: discuss the most relevant theory, introduce and define key terms, and discuss recent research in the field. You will need to include the most important literature, quote directly only if you discuss at some length, and use indirect quotes as well. Focus on notions you will use in your empirical study. It should be ten pages or less and sources of all quotes must appear in your works cited p...

How To: Use reference words in reported speech in English

In this video, we learn how to speak English: Reported Speech/Reference Words. Reported speech is reporting another person's words or telling what someone else said. Indirect speech doesn't use the use the exact words that we use. Examples of reference words are: her, she, herself, him, and himself. Types of references can be pronouns or possessive adjectives. Listen to who the speaker is so you can change the reference words so that the statement is logical. Use this example as a reference: ...

How to Speak English: Reported speech/Indirect speech

In this Language video tutorial you will learn how to report another person's words. In other words how to restate what someone else said. This video focuses on two aspects. #1. What's the difference between quoted and reported speech? #2. When can we use say and tell? In quoted speech you quote the exact words spoken by a person within inverted commas or quotation marks. It is also called direct speech. Here is an example. Jennifer said, "I like birthdays." Whereas, reported speech does not ...

How To: Count Mondays between 2 dates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Extract the top five records from a table in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.

How To: Find a formula describing direct variation

In this video the instructor shows how to find a formula describing direct variation between two variables. Variation between two variables can be either direct variation or indirect variation. If a variable y is in direct variation with a variable x we can write the general equation between them as y = k * x. That is as x varies, y varies directly in relation to x, as a multiple of x. Now if you have the values of y and x, you can substitute them in this general equation which gives you the ...

Prev Page