If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 3rd installment in said basics series, you'll learn how to use formulas that make reference to the values of a cell or multiple cells.
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS Excel.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
In this video, , peakDavid, demonstrates how to use and understand the APA (American Psychological Association) format for citing sources for references in papers, essays, and theses. You will learn the different types of citations used in APA format, and learn to understand how they are used to reference the works you used in your paper. Also, you will learn why you should use the APA format to cite your research, to avoid confusion by the reader, as well as any claims of plagiarism.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using cell references only. For more on textless concatenation, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
In this tutorial you will learn how to setup image-planes in your viewport in Blender that can be viewed in realtime, allowing you to load for example a hammer image and use it has reference when modeling a hammer.
Attention aspiring screenwriters! In this tutorial, learn how to sell that script. You may have written the next Hollywood blockbuster – but unless you can finance the film yourself, you’ll need to sell the screenplay to a producer who can make it come to life.
Hello there! This will probably be the final tutorial on functions where we will be looking over a method called pass by reference. This technique allows us to modify large amounts of data without the overhead and return multiple values. Let's go!
Thanks to the fact that Obsidian is filled with a ton of geeks and nerds (the right kind of people mind you!) there's all sorts of movie references scattered about the Mojave Wasteland in Fallout New Vegas just waiting for you to find them! In this video you will get the locations of a couple of obscurer Easter Eggs hidden around the Mojave Wasteland. The first is a Suave Gambler Hat sitting inside a blown apart refrigerator, which is obviously from the Indiana Jones movie that we will not di...
PowerPoint 2008 for Mac can help you turn boring old bulleted lists into something nobody would forget. With SmartArt graphics in PowerPoint you can now make your bullet lists pop using pre-formatted charts, graphs, and more. The Microsoft Office for Mac team shows you just how to make a bulleted list more visual in this how-to video.
Making a research paper is a lot of work. To keep a reference is not easy. Here is a good method: You will need:
With the holidays over, a lot of people with shiny new Google Homes are getting their first chance to explore the new Google Assistant. Before the Google Home's release, the Assistant was only available for the Google Pixel and Pixel XL, or in a text-based form with Google Allo—but now it's gone mainstream.
Over 2 million people are anxiously awaiting the arrival of their new iPhone 5, which has caused a few shipping problems, to say the least. There has been a considerable amount of confusion about when, exactly, the iPhone is going to ship, depending on where it was bought and how it's being delivered.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...
There are quite a few references in the Old World Blues DLC for Fallout New Vegas, and almost all of them require the Wild Wasteland perk. Take a look at this video to learn where to find these stealthily hidden easter eggs.
Dull and drab bulleted lists are no longer necessary with the help of PowerPoint 2008 for Mac. When you make a bullet list in PowerPoint, you can now transform those boring text charts with actual visual charts and graphs and more. The Microsoft Office for Mac team shows you just how to convert text to a SmartArt graphic in this how-to video.
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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...
Make your own art masterpiece of a professional basketball player: Watch this tutorial to learn how to draw Lebron James. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to use GPS maps and the compass on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
This software tutorial series teaches you how to box model in 3DS Max. Specifically, you will learn the basics of box modeling in 3D Studio Max, then box model a jet and animate it for PaperVision3D.
Following its dominance as a provider of silicon for smartphones, Qualcomm is eager to replicate that ubiquity with not only processors for augmented reality headsets but also reference designs to give device makers a head start.
In this tutorial, we learn how to draw curvy steps using pens. To start, you will first draw a horizontal line with a point in it. From here, you will need to draw lines coming out of the point. These lines will act as your reference point for the different items in the drawing. Next, draw the steps using the reference points. The one at the bottom should be larger, getting smaller as you work your way up. Draw these using the triangle shape in sort of a wedge. Shade in the bottom area to cre...
In this video, we learn how to draw Ino from Naruto. Start off by drawing a circle for the head, then drawing lines in the middle to create reference for where the facial features will go. After this, draw in the hair on the top of the head along with the eyes, eyebrows, and creases of the eye. Then, draw the jaw line around the face and erase the lines you used for reference. After this, add in additional lines and hair to make it look more realistic. Use shading around the face to show ligh...
In this video we learn how to draw hands without references. First, draw the basic structure of the hand using a photo to make sure it's true to size. After this, draw on boxes and circles to create the wrist, hand, and the knuckles. Then, you will draw on straight lines for the bones in the thumb. After this, start to add details of the fingers and make out their basic shape. As you continue with details, erase any background lines and start to add lines in for wrinkles on the skin. Finish t...
In this tutorial, we learn how to draw Ino Yamanaka. Start off by drawing the head, drawing lines in the center to use as reference points. After this, draw the rest of the body, including the hands, torso, and neck. Now start to draw in all of the details. Draw the eyes evenly apart, then add in frown lines, a mouth, eyebrows, and any other details of the face to make it complete. Next, start to erase the reference lines and draw in the hair of the character. Draw around your basic outline t...
In this tutorial, we learn how to draw Stitchpunk. Start out by drawing the outline of the entire body. After you do this, draw in the details of the feet and the hand. Next, start to draw in further details of the hands so you can clearly see the claws and the hand area. Once finished with this, draw in the details of the face. After you do this, you can erase any reference lines that you drew and fill in further details. Draw in any other details needed throughout the character, then erase ...
In order to create a bibliography with Microsoft Word 2007, you will need to access the reference tool bar, at the top of your screen. Click on references. Open your document. Put your cursor where you want to make the entry. Then, click on Manage sources. Fill in the pop-up that comes up. This will ask you for all of the information needed for the type of citation you are using. Click OK.
See how to insert a hyperlinked reference to a Wikipedia article in your blog post or page with this free video blogger's guide. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
This video tutorial will show you how to add citations and bibliographies in MS Word 2007. 1. Select desired text.
Matching a photo allows you to import and align the SketchUp axes to match the photo perspective you want to use as a modeling reference. With this done, you can create models using the photo as a direct reference. PART ONE covers the basics of importing and aligning the axis to start modeling in Google SketchUp.
There are some very powerful tools in CINEMA 4D that you can use very quickly to create some 3D graphic elements. Once you start practicing you'll find it may be easier to create your own reference than to find the "just right" one on the web. So, if you're in need of some barbed wire, for reference or otherwise, check this tutorial out. Of course, it takes quite a bit longer to actually SHOW you how to create the barbed wire (creating the barb, wrapping it around the wire, using MOGRAPH in o...
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
