Spreadsheets Videos

Microsoft Excel lets you create, calculate and organize data. You can create tables, charts and records quickly using the inbuilt tools that come with Excel or create your own. As your data grows,...

A pie chart can be made in Microsoft Excel by typing in data, clicking on "Insert Chart" and selecting "Pie," which can be displayed in a flat view or a 3D view. Create a pie chart with data with...

In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "Sum." Add several pieces of data together in Excel with help from an employee of an IT...

This video will show you how to record a macro in Excel 2007. Macros are quite powerful in that they allow you to combine a sequence of commands or functions under one keystroke. The biggest tip...

Excel tutorials are available in the form of the Help menu, which offers many troubleshooting solutions, or searching online for Excel tutorials via a Google or Yahoo search. Find Excel tutorials...

Using Excel Visual Basic for applications requires going to the Tools menu, clicking on Macro and then selecting Visual Basic Editor to alter an entire workbook or individual worksheets. Use...

VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to an HLookup formula, which searches horizontally. Apply the VLookup formula to a...

A pull handle in Excel is the same thing as a fill handle, where a series of cells can be filled with serial numbers of a certain range. Use a pull handle, also known as a fill handle, with tips...

To work out percentages in Excel, simply enter a formula in the function box that divides one cell value by the other to achieve a percentage. Use a fill handle, or pull handle, to determine...

Writing macro coding in MS Excel is possible by going to the Tools menu, clicking on Macros and entering in the new code for a new or edited macro. Create macro coding in Excel with tips from an...

Using Excel for accounts involves entering in account information into each cell, such as last name, first name, address and other contact information. Expand each cell to better view the account...

Using Excel for project management organizes products, customers and accounts by entering information into each cell. Organize project information by highlighting and formatting the cells with...

Excel macros are shortcuts within a worksheet that are accessed by going to the Tools menu, clicking on macro and then clicking on Record a New Macro. Name a new macro and use it across several...

Using Excel pivot tables is possible by going to the Data menu, selecting Pivot Table and Pivot Chart Report and following the instructions on the pop-up wizard window. Use Excel pivot tables,...

Using Excel templates involves formatting a worksheet, going to the File menu and selecting Save As, naming the template and saving it as a Template file type. Apply templates to a variety of...

Excel is used for statistics by going to the Tools menu, clicking on Data Analysis and choosing the type of data analysis tool that will bring up the desired type of statistics. Analyze statistics...

To write a reset macro for Excel, click on Macro from the Visual Basic editor, label a new macro as Clear Sheet and designate a key to activate the macro. Clear an Excel spreadsheet with a reset...

Making a form in Excel is possible by going to the Data menu, clicking on Form and entering in the desired information. Create simple forms with Excel with tips from an experienced Excel user in...

A mail merge in Excel is possible by opening Microsoft Word, clicking on Mail Merge under the Tools menu and finding the worksheet in Excel to enter the desired information. Create a mail merge...

Making a calendar using Excel is simple by typing in the month in the first cell, entering the days of the week below it and formatting the cells to be centered and spaced out. Use the Fill and...

To create an Excel Auto New Macro, go to the Tools menu, click on Macro and type in the key to activate the automatic macro. Make a new automatic macro, pressing Control, Alt and the designated...

Connecting VB, Visual Basic, to Excel requires opening up Visual Basic and clicking on Code, typing in the code and then clicking Run. Link Visual Basic editor to a worksheet with tips from an...

Spreadsheet templates in Excel are created to prevent work duplication. Create spreadsheet templates in Excel with tips from an assistant certified public accountant in this free video on...

Make a circle graph in Excel by highlighting the entire project, going to the toolbar, clicking on the chart wizard button and selecting the pie chart option. Make a pie chart in Excel with tips...

Create a message box based on visual base codes, or VBA's, in Excel by going to tools and then selecting macros. Create a message box for VBA's in Excel with tips from an assistant certified...

Defining cell names in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell names in Excel with tips from an assistant certified public...

Defining cell ranges in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell ranges in Excel with tips from an assistant certified public...

Using cell ranges in Excel formulas is done by highlighting the range and typing the name in the box below the font type. Use cell ranges in Excel formulas with tips from an assistant certified...

The autofill function in Excel works by putting the cursor on the bottom right corner until it changes appearance and then dragging the box all the way across. Use the autofill function in Excel...

Use the freeze pane command in Excel to create static headings by highlighting the targeted row, going to window on the menu and selecting freeze panes. Use the freeze pane command in Excel to...

Save an Excel worksheet as HTML by going to format on the top menu and clicking options and choosing HTML after saving the document first. Save an Excel worksheet as an HTML document with tips...

Headers and footers in Excel documents are added by clicking on file, then page setup and selecting header and footer. Add headers and footers in Excel documents with tips from an assistant...

Add custom menus to an Excel toolbar by going to tools, customize, customize toolbar menus and selecting options. Add custom menus to an Excel toolbar with tips from an assistant certified public...

Align text cells in Excel by highlighting the cell and choosing to align format from the toolbar. Align a text cell to the left, right or center in Excel with tips from an assistant certified...

Add background color or patterns to Excel cells by highlighting the cell and choosing a color from the tool menu. Choose a color or pattern in Excel with tips from an assistant certified public...

Protect Excel cells from modification by highlighting the entire sheet, going to tools on the menu bar and going to protection and then clicking protect sheet. Protect Excel cells from...

Rows and columns in Excel are formatted by highlighting either and double clicking on the selection. Format rows and columns in Excel with tips from an assistant certified public accountant in...

Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and specifying which cells are being added. Add totals and subtotals with Excel with tips from...

Excel workbooks are used for complicated analysis, and worksheets are for simpler Excel assignments. Learn when to use worksheets and workbooks in Excel with tips from an assistant certified...

Adding or deleting an Excel worksheet is done by going to one of the bottom tabs, right-clicking the mouse and choosing insert or delete. Insert or delete Excel worksheets with tips from an...

Rename an Excel worksheet by either clicking on the name part of the file and retyping a new name or by right clicking the file and renaming it. Change the name of an Excel worksheet file with...

Format cell numbers in Excel by highlighting the cells and clicking one of the format icons on the toolbar. Format cell numbers in Excel with tips from an assistant certified public accountant in...

Sum columns or rows in an Excel spreadsheet by highlighting the row or column and clicking auto sum. Add columns or rows in an Excel spreadsheet with tips from an assistant certified public...

Insert a column or row in an Excel spreadsheet by first highlighting the column to the left or the row on top and clicking on the toolbar, selecting insert and then columns. Insert columns or rows...

Sort a row or column in an Excel spreadsheet by highlighting the row or column, clicking data on the toolbar and clicking options and sort. Sort Excel spreadsheet columns and rows with tips from...

Create a bar graph from an Excel spreadsheet by highlighting the information and clicking chart wizard from the toolbar. Make a bar graph with Excel with tips from an assistant certified public...

Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound function. Use formulas in Excel with tips from an assistant certified public accountant in...

Excel macros speed up the work process by recording functions and words that are repetitively typed. Use Excel macros with tips from an assistant certified public accountant in this free video on...

Add two cells in an Excel spreadsheet by selecting the auto sum key or manually highlighting the brackets and clicking equal sum. Add two cells in an Excel spreadsheet with tips from an assistant...

To make invitations on the computer, open Microsoft Word, select the text font, size and color, center the text, enter the invitation information, and insert images onto the page. Use the "Print...