Guide to Excel Spreadsheets

Get help with Excel Microsoft Excel is the defacto standard for spreadsheet software. Let our guide introduce you to the basic ways you can use it to work with data or get organized, and even discover new uses you haven't thought of before. Learn the tricks to importing data into an Excel spreadsheet from other programs and exporting data from your Excel files. Find out how to convert file formats such as CSV for use in Excel, learn about creating and manipulating charts, and get tips on using the many other features and functions. Do simple calculations or complex statistical analysis, and check out our templates that give you a head start in creating your own Excel spreadsheet.

A Step-By-Step Guide To Importing Excel Data Into a SQL Server Database Importing data from Excel to SQL Server is not difficult as you might think. If you have data in an Excel spreadsheet that you want to import into SQL Server, this article will walk...	Open Channel Flow over V-Notch Weir Calculations The Excel spreadsheet templates provided in this article will help you make open channel flow measurement calculations for water flow rate over a V notch weir. Formulas are given for...
How to Import an Excel Spreadsheet into Publisher 2010 For years Microsoft Office users have struggled with latent incompatibilities between its core applications. Also for years, Publisher users have been copying and pasting Excel spreadsheets...	How to Use an Excel Spreadsheet to Track and Itemize Monthly Home Office Expenses You need to track what you're spending in your home office, but the box full of receipts isn't working anymore. Don't worry. We have a simple and easy way to track all of...

Importing Excel Data into Microsoft Word 2007

Sometimes, it’s a lot easier to create your initial tables and charts in Microsoft Excel, and then insert the results into your Microsoft Word document. We’ll walk through how to perform such...

Developing a Sales Forecast in Excel

Even if you're not preparing a full business plan, it's important to develop certain financial goals and reports. In this guide, we'll show how to use Excel to produce a sales forecast that...

Convert Excel 2007 Spreadsheets to CSV Files

If you have data in an Excel spreadsheet that you want to use in another application, you may need to convert that information to a text file before the other program can read it. In this tutorial, we’ll...

Microsoft Excel’s Frequency Function

The frequency function in Microsoft Excel provides a special way to count items that fall within in a specified range. In this segment, we’ll show how the frequency function can be used to group...

Creating Project Timelines in Excel 2007

Preparing a graphical project timeline is a great way to give an overview of all that needs to be accomplished in a project as well as how much time it will take to complete. In this article, we’ll...

Get Organized with Excel!

Organization is key to a productive life. But, getting organized can be a huge problem for many of us. So, use some tools to get you there! Excel gives you the ability to save important...

FileMaker Pro 10 for Windows: Importing Data to a New FileMaker Database

Importing tables of data to a new FileMakerPro 10 database is a straightforward and intuitive process. However, it does require some advance planning both at the data export and import...