Programming with Excel

This clip offers a general introduction to using VBA within MS Excel. 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 sof ...more

Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel: VBA in Depth, Excel and VBA ...more

Converting an Excel spreadsheet to a single PDF file is quite easy, even if there are multiple worksheets in your document. This tutorial even demonstrates a common Excel error and how adjust your program's dpi settings to avoid double spooling.

Not only is Microsoft Office Excel handy for drafting documents, it can also be used to make simple illustrations. Quite easily at that. The program's drawing tools are so easy to utilize, in fact, that this free video software tutorial can present a complete overview of the p ...more

Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an ...more

PrimoPDF is a free program that will allow you to convert any document (Microsoft Word, Excel, PowerPoint and more) into a usable PDF file. This tutorial walks you through downloading, installing and using the PrimoPDF program to convert your files to PDFs. PrimoPDF even allow ...more

Xtracharts, a control for Winforms, allows the user to easily export charts made using the program into a PDF, HTML or MHT, Excel spreadsheet or standard image. This tutorial shows the Winforms user how to properly code and then export the chart.

When converting an Excel file to an Adobe PDF document, you might sometimes accidentally export several pages of empty space. This tutorial briefly explains how to use the Acrobat program to convert your spreadsheet or worksheet to PDF format and avoid the blank gaps.

The DeskPDF programs, published by DocuDesk, offer several methods for converting files in one format to an entirely different format - such as turning an HTML table on a web page into an Excel file or turning an RSS feed into an ebook file.

Cordell Connect is useful software for managing projects for your business. One of the functions of this program is being able export your reports to either an Excel spreadsheet or a PDF document for a greater ease of data manipulation and communication.

See how to apply custom picture styles in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to ...more

See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iterat ...more

See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration ...more

Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you'r ...more

In this video, learn how to export reports to Word, PDF, Excel, and/or TXT formats. Learn step-by-step how to export your reports to any program or format in just a few easy steps.

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video w ...more

This video demonstrates how to use the ISLEAPYEAR determining function in a spreadsheet. This determines whether a date falls in a leap year within a spreadsheet program.

This tutorial demonstrates how to use the Excel function SQRT. This allows you to determine the square root of any number, within a spreadsheet program.

See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned busi ...more

In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, clic ...more

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

This video tutorial will teach you how to format percentage numbers in MS Excel. Excel is a spreadsheet application that allows you to use calculations, graphs, pivot tables and much more to create the spreadsheet you want. You can learn how to avoid common mistakes that occur ...more

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other fil ...more

MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. Moti ...more

This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big dis ...more

This video teaches you how to use APT (Arbitrage Pricing Theory) models and formulas. This video shows two specific parts of the APT models the first being the after the fact version and the before the fact version. The before the fact version is focused on as being the most i ...more

Some times when you upgrade your Microsoft Excel software to Excel 2007 your old macros may stop working. Some times this may be due to the settings and by enabling the macros you can get your old macros to work. Macros are turn off by default in Excel 2007. You can turn this ...more

To customize the over all design of a specified document, you need to adjust Page Layout settings. This is easily done by clicking the Page Layout button and customizing settings such as orientation, scaling, and margins. With this tutorial, learn how to open the Page Setup d ...more

So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. Probability valu ...more

This tutorial shows the use of the Excel program PROPER. This capitalizes the first letter of every word of a text stream in a spreadsheet program.

This video demonstrates how to use the Excel function ASINH. This program determines the inverse hyperbolic sine of a number within a spreadsheet program.

NovaPDF is a computer program that will allow you to export your Excel spreadsheets into the popular PDF format. This brief tutorial walks you through how to use the Print command in Excel to get a usable PDF using NovaPDF.

This video demonstrates how to use the Excel function ATAN to determine the inverse trigonometric tangent function in a spreadsheet program.

This video tutorial shows how to use the Excel function ACOT. This function determines the inverse cotangent of a number within a spreadsheet program