Nicely Managed Spreadsheet Search Results

How To: Import Excel to a MySQL database with cPanel

This data management tutorial shows you how to take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin in cPanel. Being able to move data from Excel to MySQL is an important part of database content management, so if you use cPanel to manage your databases, you'll want to watch and learn how to import Excel spreadsheets into your MysQL databases.

How To: Add spreadsheet snippets in Microsoft Excel: Mac 2008

Not every client or coworker likes to mine through a spreadsheet to find all the important data. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. To do this, all you need to do is to use the "copy as picture" option. The Microsoft Office for Mac team shows you just how to insert a spreadsheet snippet in this how-to video.

How To: Cook Greek-style green beans with tomato

Sue Radd teaches the secrets to cook Greek style beans with tomato in simple steps. First cut the top and tail of your beans and clean them nicely with water. Now nicely chop a big onion and slice thinly some garlic. Now add some oil in a pressure cooker and add the onions and garlic when the oil is warm. Add some fresh black pepper, mix them well and add the green beans to it. Now mix some tomato paste with water rand add them to the beans. Add some diced tomatoes, mix everything well and co...

How To: Make white chocolate dipped strawberries

Betty teaches the secrets of making white chocolate dipped strawberries in simple steps. First take some fresh strawberries and a fresh canister of creamy chocolate. Now take a strawberry, dip it in the cream and whirl it nicely so that the cream fills nicely around it. Repeat the same process for all the strawberries and refrigerate them. Leave it in the refrigerator till the cream gets solid, then enjoy eating them.

How To: Manage ESX(i), booting ISO files and more

In this web TV presentation the host is talking about Grub 2. In Grub 2 you can mount an ISO file like a device with the loop back function. In Grub 1 you can use tack tack mem to mount iso files if the files are not fragmented by using the map command. Grub 2 is an application available for download that will be available after download as a chain from Grub 1 to Grub 2 to your operating system. Grub is a program that compresses all of your favorite boot programs into one.

How To: Print spreadsheets in Numbers '09

Check out this informative video tutorial from Apple on how to print spreadsheets in Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.

How To: Format spreadsheets in Microsoft Office Excel

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 Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.

How To: Run a VBA routine in a Microsoft Excel spreadsheet

This clip presents a general overview of how to execute a VBA routine within an MS EXcel spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

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 Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Merge spreadsheets in Excel

If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.

How To: Reverse first & last names by formula 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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.

How To: Use the Numbers spreadsheet app on an Apple iPad

One of the advantages of an iPad over, say, an iPhone is that you've ample space with which to display and manipulate complex documents. As such, it's a natural fit for Apple's popular spreadsheet application, Numbers. In this video guide from Apple, you'll learn how work with tables, charts, formulas, photos and graphics using the Numbers app on your own iPad.

How To: Fold a t-shirt using cardboard

In this tutorial, we learn how to fold a t-shirt using cardboard. First, cut out a piece of cardboard so the it's 72 cm x 25 cm, and make sure it's completely flat. Next, place two flaps on the side of the cardboard and one underneath. Now, place your shirt inside of it and fold the top down, then the sides. After this, fold up the bottom and you will have a nicely pressed and folded shirt! This will save you time over folding the shirt by yourself and it will also come out more nicely than f...

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 Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.

How To: Manage Office themes when using Microsoft Excel 2011

Need some help figuring out how to handle Office themes from within Excel 2011? This video will show you how it's done. 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 better managing Office theme settings yourself, watch the video.

How To: Remove outliers when averaging in Google Spreadsheets

Need a primer on how to discount outliers when calculating a statistical average within Google Spreadsheets? It's easier than you might think. And this free video tutorial presents an easy-to-follow, step-by-step guide of the entire process. For detailed instructions, and to get started lopping off outliers in Spreadsheets yourself, take a look!

How To: Export a MySQL database table to Excel with cPanel

In this short video we export a MySQL database table to a Microsoft Excel 2000 spreadsheet using cPanel and phpMyAdmin. You will need to have your login information for cPanel. Once you are in cPanel, go to phpMyAdmin in the database section and find the database you need to export, and export the database as a spreadsheet! See how to customize the exportation of a MySQL database to an Excel spreadsheet in this tutorial.

How To: Print an Excel worksheet or workbook with gridlines

In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...

How To: Speed up calculations with custom Excel formulas

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 very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.

How To: Use database functions in Microsoft Excel 1997-2003

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 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS 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 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in 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 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula 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 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Use the regression analysis module

Are you in real estate? Take a look at this instructional video and learn how to run your excel spreadsheet over a regression analysis module. An appraiser who's appraising a house decides to run a multiple regression analysis as an addition to the direct sales comparison approach. The spreadsheet used in this tutorial was written in excel, but could be rewritten in another format. The spreadsheet was exported from an MLS. Once the excel sheet is downloaded, the appraiser will open up the reg...

How To: Convert a formula to a value in Microsoft Excel 2010

Learn how to convert a formula to a value in a Microsoft Excel 2010 spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started converting formulas in your own MS Excel 2010 projects, watch this free video guide.

How To: Save an Excel 2010 document for use in Excel 2003

Learn how to make your Excel 2010 spreadsheets compatible with Excel 2003. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Create sparklines in Microsoft Excel 2010

Learn how to add sparklines to a Microsoft Excel 2010 spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using sparklines in your own MS Excel 2010 projects, watch this free video guide.

How To: Create a basic PivotTable in Microsoft Excel 2010

Learn how to create a simple PivotTable within Microsoft Excel 2010 spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using PivotTables (or Pivot Tables) in your own MS Excel 2010 projects, watch this free video guide.

How To: Insert SmartArt into Microsoft Excel 2010 spreadsheets

Learn how to add SmartArt to your Microsoft Excel 2010 workbooks. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using SmartArt in your own Excel projects, watch this free video guide.

How To: Filter data in eight different ways in Microsoft Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.

How To: Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

Prev Page