Work-sheets

How To : Clear data & cell contents in Excel using a macro

In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number ...more

How To : Use VLOOKUP across worksheets in MS Excel 2007

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 VLOOKUP in one worksh ...more

How To : Share MS Excel 2010 documents through SharePoint

Learn how to take full advantage of MS Excel 2010's collaboration features. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be ...more

How To : Use worksheets in Microsoft Excel: Mac 2008

Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Off ...more

How To : Work with math equations in Microsoft Excel 2010

Learn how to store, use and manipulate equations in MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well serv ...more

How To : Copy and move worksheets in Microsoft Excel 2007

Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this vide ...more

How To : Knit a Fourth of July American flag baby hat

Fourth of July is coming up in just a few measly days, and while we're sure you've probably already fired up the grill and purchased aquarium-sized packs of hot dogs, ground beef, cole slaw, and potatoes for your potato salad, you can show your patriotism through more ways tha ...more

How To : Edit pictures within Microsoft Excel 2010

Learn how to work with digital images within MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by t ...more

How To : Navigate worksheets in Microsoft Excel 2007

Learn how to get get around worksheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this ...more

How To : Make a crochet star embellished American baby cap

Fourth of July is coming up in just a few measly days, and while we're sure you've probably already fired up the grill and purchased aquarium-sized packs of hot dogs, ground beef, cole slaw, and potatoes for your potato salad, you can show your patriotism through more ways tha ...more

How To : Record a macro in Excel 2007

This video demonstrates how to record a macro in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to record a macro in Excel 2007, For Dummies. ...more

How To : Fill out the child tax credit worksheet

If you have children who are still your dependents and have been living in your household for at least half of the year, and have their own social security number, you can actually get a major tax credit with a simple worksheet. In this video you will learn the requirements fo ...more

How To : Use Microsoft Excel 2007 for statistics

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 Excel ...more

How To : Use MS Excel Effectively

Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use. I would like to share an important tip…if you want to be fast with Excel, try to avoid using the mouse as much as you can. We will so ...more

How To : Use Microsoft Excel 2007 as a complete beginner

If you're a novice 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! This free video MS Excel lesson, the ...more

How To : Use keyboard shortcuts in MS Excel

Do you want learn some quick ways to hide columns in Excel? Or to move within worksheets? In this video tutorial you will find 10 great keyboard shortcuts to speed up your Excel workflow.

How To : Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more

How To : 11 Exercises to Do While Sitting at Your Computer

If you are sitting in front of a computer all day for your work, make the most of it by exercising your different muscle groups even while you are finishing a PowerPoint presentation or filling out cells in an Excel worksheet. Stretch your upper body muscles to keep your neck ...more

How To : Build a barrel rocket stove

A rocket stove is a "rocket" combustion approach to preparing meals, which provides high combustion efficiency and efficient heat transfer to the cooking pot. Research suggests (through practical experience) that by using a rocket stove, you could save at least 50% of fuelwood ...more

How To : Link two (multiple) workbooks & cells in Excel

In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign in ...more

How To : Lock & unlock cells in Excel

In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be ...more

How To : Create drop down menus in Excel

In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one ...more

How To : Create mailing labels in Microsoft Word 2007

In this first demo of a 4-part series, learn how to set up labels for mass mailings using the Mail Merge feature in Word 2007. In this second demo learn how to select recipients to be part of the mass mailings by using a Microsoft Office Excel 2007 worksheet as the data source ...more

How To : Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula ...more

How To : Build up tones with cross hatching when drawing

Watch this tutorial to learn how to build up tones with cross hatching when drawing. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing. Check out the Shading Resource. "I will teach you about drawing pencils and when ...more

How To : Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, ...more

How To : Freeze or unfreeze rows and columns in Excel 2007

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.

How To : Create a column line graph in Microsoft Excel 2007

In this software video tutorial you will learn how to create a column line graph in Microsoft Excel 2007. First you type in the data in to the work sheet. Then highlight the data and click 'insert' on the menu bar. Here you select the 'column' option and go down and click on t ...more

How To : Hide or unhide rows and columns in Excel 2007

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 te ...more

How To : Create a graph or chart in Excel 2007

This video demonstrates how to create a graph or chart in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create a graph or chart in Excel 20 ...more

How To : Create a formula timer in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula E ...more

How To : Generate an Microsoft Excel sheet using XML

Check out this video tutorial on how to generate an Excel worksheet using XML. There's a free library from CarlosAG.net, and you need to get the free dll file from there. This video will show you how to use it. You need to use CreateExcelFile in Microsoft Visual Studio to use ...more

How To : Generate a dynamic list from a table in MS 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from ...more

How To : Create a simple line chart in Excel 2007

Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the li ...more

How To : Create an organization chart in Visio 2007

Take a look at this instructional video and learn how to use a Microsoft Office Excel worksheet that contains employee data to create shapes, connect them according to your organization's structure, and add data to each shape in your drawing automatically.

How To : Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" se ...more

How To : Use the if Function in Excel

Video: . IF function This article describes the formula syntax and usage of the IFfunction in Microsoft Excel. Description The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the ...more

How To : Determine the Value of a Used Car

Everyone hates to feel like they've been taken advantage of, especially when buying a used vehicle. The thought comes across every car buyer's mind... "Did I just get taken by that smooth-talking salesman?" When it comes to cars, how do you know if you're really getting a good ...more

Prev Page
  • Hot
  • Latest