As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the debt ratio, debt to equity ratio, equity multiplier ratio and times interest earned ratio.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 19th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate return on equity, assets, and profitablility — return on investment (RoI).
In this Business & Money video tutorial you will learn how to read a balance sheet in accounting. Yu can learn to read it quickly and easily as to where the company’s came from, where it went and where it is now. There are four main financial statements; balance sheets, income statements, cash flow statements and statements of shareholder equity. In the balance sheet, under assets are listed things that the company owns that have value. Liabilities are amounts of money company owes to other...
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
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.
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. Take a look at this instructional video and learn how to create a column, hide a column, and show a column that you previously hid.
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 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.
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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.
This video explains how to easy add decimals. Adding decimals can seem to be a tedious job, and a single mistake can result in a completely different number. In reality, it is quite easy, and with a good method and some practice it can be done quickly. Write the two sets of numbers out, lining them up in columns. Keep the decimal points on top of each other and line up the non-decimals with non-decimals and the decimals with decimals. Start at the right-most column and add it up. If it become...
The Winogradsky column, invented by Sergei Winogradsky, is a device for culturing a large diversity of microorganisms. Pond mud and water are mixed into a column using carbon sources like newspapers and sulfur sources like egg yolks. Left in the sun for a few months, the column becomes a colony rich with microorganisms, bacteria, cyanobacteria, and algae. In this video, scientist Karen Dodson shows you how to make your own.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
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 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
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 375th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy non-contiguous columns of data and then paste all the columns at once.
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
Ever wonder how to read a binary clock? First, you must learn that in binary code there are only two numbers, one and zero. A binary clock has six columns and tells time in military time. The first two are for the hour. No light means zero. A light that is turned on is one. The first column has two dots the second column has four. if the second dot from the bottom in both columns is lit, it is 22:00 or ten o'clock. In the third column the light closest to the bottom is lit which means one. In...
Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this instructional video to see how to use the Convert Text to Columns Wizard to automatically break up a sing...
In this tutorial, we learn how to make a histogram chart in Excel. To create a vertical histogram, you will enter in data to the chart. Then, highlight all of the data and go to "insert", "chart", then choose a regular column chart. Grab a regular 2D column and then make sure your values are correct. Then, right click and go to "chart options", then take the legend off. Now, make these columns all touch each other by right clicking over the columns and formatting them. Go to "options" then ch...
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...
Need to know how to split and freeze columns in Excel 2011? Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
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 8th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a column of text and break it apart into separate columns using Excel's text-to-column tool.
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Layers TV Host RC creates a three column layout with a header in Dreamweaver CS3. This Dreamweaver tutorial goes over the basics of setting up classes and inserting DIV tags for layout as well as dumb things that trip you up. If you need help with CSS and DIV tags when working with columns on web page designs, watch this Dreamweaver tutorial for help.
In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This instructional video shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.
In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
With the Freeze Panes command in Microsoft Office Excel 2007, you can make sure specific rows and columns stay visible while you scroll. Take a look at this instructional video and learn how to freeze and unfreeze rows and columns, and make viewing your worksheet a snap.
Apple Font book is a utility included with Mac OS X. Font Book is a utility for managing and maintaining your fonts on your Mac computer. It allows you to enable or disable fonts. It also helps you in creating font collections. Using it you can create libraries consisting of different collections and also validate font files for fonts or inconsistency. You can also remove duplicate fonts using it. The font book display consists of three columns. The collection column, the font column, and the...
The Department of Biological Sciences at the University of Alberta brings you this video tutorial specifically relevant to your student laboratory courses, specifically microbiology. If you're a student at any school of biology, this information will be helpful for learning how to use Sephadex gel filtration for chromatography in the lab.
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 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
Professor ElvisZap teaches you about adding consecutive odd numbers. You can learn this faster by drawing squares near the numbers themselves. If you are doing 2x2, draw 4 squares. They will be arranged in columns of two. For 9 you will draw 3 columns of 3. 16 are 4 columns of 4. 16 is also 1+3+5+7, which are all odd consecutive numbers. 25 are 5 columns of 5, but also 1+3+5+7+9. If you start counting 1 as the zeros odd number, then 3 as the first odd number, the nth odd number will be (2xN+1).
Apple's iWork '09 is full of great features, including a simple and elegant way to add up a column of numbers in a spreadsheet. This detailed video shows you just what to do to get down and add up.
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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
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 639th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns.
See a very simple way to create a two-column layout with pure CSS. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.
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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special Values.
Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of Adobe InDesign CS5's most vital new features, you're sure to be well served by this from the folks at Lynda, which presents a detailed, step-by-step overview of how to span and split columns within Adobe InDesign CS5.
