Title: Using Excel Macros to Process Real Time Data Acquired by the Excel Server from LowCostBoards.com
Video:
Description:This video shows how to use an Excel macro and a very small VBA program to display a scrolling chart of real time data aquired by the Excel Server from LowCostBoards.com
Title: Data Validation 8 - Custom Error Messages in ExcelVideo:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to create custom error messages with this free Excel video tutorial. This shows you how to change the default data validation error messages to something that actually describes the error that was encountered. This is a particularly important feature to use when you need to let users know exactly what the error was that they caused so that they know how to correct the error. This tutorial shows you how to change the error message image, title, and error message itself. This is a very important feature of data validation that should be implemented in most cases where there is data validation present in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 6 - Run Macros from Drop Down Menus in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that teaches you how to run macros from drop down menus in Excel. This Excel video tutorial walks you through the steps you need to take in order to make a macro run when you select an option from a data validation drop down menu in Excel. This includes teaching you how to create the drop down menu in Excel; how to create the basic macro to run based off of the drop down menu; and, how to change the macro to run your own macro code. This is a really great tutorial to view in order to perform more powerful tasks with your drop down menus and lists in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that describes how to enter data into cells that contain drop down menus using data validation. This method teaches you how to be able to enter data into a data validated drop down menu cell that is not contained within the drop down menu. Basically, you will be able to enter values that are not contained in the drop down menu into a cell with a drop down menu. This allows you to simply use the data validation drop down menu feature in Excel in order to make entering values in cells easier for users while at the same time not preventing them from entering other values. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel. This method of entering text into cells allows you to avoid using the text box to enter large amounts of text in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Create drop down menus in Excel with source (list) data from separate tabs within Excel. This Excel video tutorial shows you how to create a drop down menu that uses data from separate worksheets within Excel. This is a great tutorial to view because of the fact that you can just point to a range in a separate worksheet in Excel through data validation. Instead, you have to use named ranges with data validation in order to reference data that is not on the same worksheet as the drop down menu that you want to create. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 1 - Create Drop Down Menus in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Step by step guide to creating drop down menus in Excel. This Excel video tutorial shows you how to use data validation in Excel in order to make a drop down menu that displays from any cell within a worksheet. This is a great tutorial for anyone who is not familiar with data validation but who still needs to make a drop down menu in Excel. The real benefit to using drop down menus in Excel is that you can make it easier for a user to enter the correct value into a cell. This works well when creating a user form from an Excel worksheet. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Excel Dynamic Chart #10: OFFSET Function Dynamic Range
Video:
Description:See how to use the OFFSET function for two different types of dynamic ranges for a chart: 1)Dynamic Range that adds latest records 2)Dynamic Range that shows only last 4 Months of data Learn about named formulas that use OFFSET function to create dynamic ranges and see how to insert named ranges into a chart. Learn about the OFFSETs 5 arguments: 1)Starting point 2)How many rows (up or down) do you want to move the starting point? 3)How many columns (left or right) do you want to move the starting point? 4)How tall is the range? 5)How wide is the range?
Title: How to Create a Barcode in Microsoft Excel 2007
Video:
Description:***NEW EXCEL and WORD ADD-IN AVAILABLE*** To QUICKLY CREATE BARCODES, please use our EXCEL-WORD ADD-IN. This free tool allows you to select a barcode option to encode and select the barcode font. It is for Windows users creating barcodes in Excel or Word. Word Video: www.youtube.com Excel Video : www.youtube.com Written Tutorial and Add In Download: www.idautomation.com is a tutorial for creating barcodes in Microsoft Excel using IDAutomation's Barcode Fonts and Barcode Macro's. This is a tutorial for creating barcodes in Microsoft Excel 2007 using IDAutomation's Barcode Fonts and Barcode Macros by adding the Developer Tab to Excel. For UPCa, use =UPCa(cell location) For UPCe, use =UPCe(cell location) For Interleaved 2 of 5, use =I2of5(cell location) For POSTNET, use =POSTNET(cell location) For Intelligent Mail, use =IntelligentMail(cell location) For Code128 A, use =Code128A(cell location) For Code128 B, use =Code128B(cell location) For Code128 C, use =Code128C(cell location) For Code128 Auto, use =Code128(cell location)
Title: Printing in Excel 7 - Repeat Row and Column Titles on Every Printed Page from Excel - Page Setup
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to repeat title rows and columns in Excel for every page that is printed. This allows you to view the same rows at the top of a column on each page so that you know what every column stands for in the printed spreadsheet. You will also see how to do this for columns when your data is organized left to right instead of up to down. This is a great tutorial to view to increase the usability of printed spreadsheets and simply to make them much easier to read and understand. This tutorial shows you how to repeat single rows and columns as well as multiple rows and columns on every page of the printed Excel spreadsheets. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 6 - Adjust Margins in Excel - Spreadsheets that Will be Printed - Page Setup
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to adjust the page margins for an Excel spreadsheet when printing that spreadsheet. This allows you to fit more information or data, or less information or data, onto a printed Excel spreadsheet or worksheet. This tutorial shows you how to increase and decrease the size of margins within Excel. When you decrease the size of the margins, that means that there is less white space between the printed information and the edge of the page. Margins in Excel are just like those in Microsoft Word and are just as easy to adjust. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 5 - Fit More Data on a Printed Page - Scale Data for Printing
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This video tutorial shows you how to scale data in Excel so that more of it will fit on a printed page. This method effectively shrinks the data when it is printed while leaving everything looking the same within Excel and is called scaling. Using scaling in Excel allows you to put more information on a printed page; however, that information will be a smaller size and font than if you did not scale it. This is great for formatting spreadsheets for printing and helps to make your spreadsheets look just at good on paper as on the computer screen. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 4 - Prevent Specific Cells in Excel from Printing
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you three different ways that you can quickly and easily prevent a specific cell, a row, or a column from printing or from showing up when you print a worksheet or workbook in Excel. You will learn how to effectively hide a cell, row, or column as well as to group them or change the font color. This tutorial teaches you ways that you can keep data private when you go to print a worksheet or to just help you clean up the document before it's printed. This tutorial covers some tips for hiding the data that you don't want to be printed from Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 3 - Add Headers and Footers in Excel
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Add headers and footers to Excel files when printing. This Excel video tutorial shows you how to quickly and easily add headers and footers to your worksheets and workbooks in Excel. You will learn how to add a header and footer for Excel 2007 and previous versions of Excel. Also, you will learn exactly what you can add as a header; how to print the first page's header different than the rest of the pages; how to add the time, date, file name, page number, total pages, and more to the header and footer; and, how to add custom text to the header and footer in Excel. You also learn about the new page layout view for Excel 2007. This feature allows you to intuitively and easily add headers and footers to your documents. This is a great printing tutorial for Excel that walks you through what you can do to add headers and footers in Excel when printing a worksheet or workbook. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 2 - Print Specific Data from a Worksheet in Excel - Set Print Area Excel 2007
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Print only selected or desired data in Excel. This excel video tutorial shows you how to select a single section or multiple sections within a worksheet or workbook in Excel and then to print that area. This video tutorial covers the Print Area feature in Excel. You will learn how to print a single area of a worksheet, set multiple print areas within the worksheet, and how to clear all print areas from the worksheet so that you can print the entire Excel worksheet. This is a very useful tutorial for printing in Excel and allows you to print only the data that you need printed. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
Video:
Description:Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to print an Excel worksh...
Title: Import RSS Feeds - News Headlines - into ExcelVideo:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to import RSS feeds into Excel. Specifically, you will learn how to import Yahoo News story RSS feeds into Excel. This will allow you to quickly and easily read up-to-date headlines in Excel and to then follow a link to the full story if it interests you. Specifically, you will learn how to import and create and XML map in Excel. This is due to the fact that RSS feeds are simply XML files. As a result, you will also learn how to import XML files into Excel from the web. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to install add-ins in this Excel video tutorial. You will learn how to install add-ins such as the Analysis Toolpak and Solver in Excel. This is a very good tutorial to learn if you just upgraded to Excel 2007 or just need to find out where to install add-ins in Excel. Installing the Analysis toolpak will allow you to perform regression analysis and t-stat and anova analysis in Excel in a much more efficient fashion than just using functions such as LINEST(). For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. View Twitter updates from Excel 2007. This Excel video tutorial walks you through all of the steps that you need to follow in order to be able to view all of your Twitter updates from Excel 2007. This means that you will be able to view your Twitter account activity from any computer with an internet connection and Excel. This is a great feature to use in Excel if you need to use Twitter in a discrete fashion or if you just want to do it through Excel. The real benefit of this tutorial is that you don't have to have your browser open in order to check Twitter. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Functions-Formulas in Excel 9 - Highlight Cells With Formulas Without a Macro in Excel
Video:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial showing you how to highlight all cells that contain formulas within a worksheet in Excel. The benefit of this tutorial is that you will learn how to highlight cells with formulas without using an Excel macro. This is a really useful feature of Excel, especially when you need to find out what is going on in a spreadsheet that you haven't used in a long time or that someone else sent you. This tutorial is the first part in a series of formula auditing tutorials and serves to help you better troubleshoot problems and errors with formulas and functions in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Excel Formatting 12 - Quickly Copy Formats to Other Cells in Excel
Video:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that shows you how to quickly and easily copy formatting from one cell or table to another cell or table. Specifically this tutorial shows you how to copy the formatting from an entire table and paste only the formatting onto other similar sized tables in Excel. This allows you to very quickly make many professional looking tables and worksheets in Excel without having to create your own theme in Excel. This is a great Excel tip that will save you time and improve the look of your spreadsheets. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Excel Formatting 11 - Quickly Clear ALL Formatting From a Worksheet in Excel
Video:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to remove formatting from an entire worksheet in Excel with the press of one button. You will see how to remove fonts, bold, italics, colors, alignment, borders, underlines, etc. This method allows you to remove in seconds what it would take you minutes to do by hand. This is a great tip in Excel that not many people know about and that just about everyone can benefit from. Learn this Excel formatting tip and you will save yourself a lot of time. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total
Video:
Description:See how to extract grant records with highest point value and only extract enough records collectively that are under the Total Funding Ceiling: 1.AND function for 2 criteria 2.Running Total Formula with SUM function and Range half relative and half absolute 3.Sort 4.Delete Columns 5.Macro Recorder 6.Advanced Filter
Description:este video nos introduce a lo que seria word 2007 de microsoft office, sigan nuestros videos para que aprendan a utilizar los programas como verdaderos profesionales.
Title: DoubleClick Fill Macro - 1152 - Learn Excel Video Podcast
Video:
Description:Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle.Episode 1152 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Title: Finance Basics 11 - Annuity Due Calculation in Excel - Present Value and Future Value
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the Annuity Due in Excel. You will learn how to calculate the annuity due for the present value and future value functions in Excel. Annuity due simply means that any annuity payments are made at the end of the period instead of the default situation where annuity payments are made at the beginning of the period. This is a great tutorial for all of those just starting out in finance or for people who need to learn how to calculate an annuity due in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 12 - Perpetuity Calculation in Excel
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate a perpetuity in Microsoft Excel. You will learn the mathematical formula for calculating a perpetuity as well as how to calculate a perpetuity using the PV() or present value function in Excel. This is a must see tutorial for people studying finance or those who need to understand perpetuity payments. Basically, a perpetuity is just a series of payments that is never ending or that goes out for a very long time into the future - such as a series of payments for the rest of a person's life. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the present value of a security or investment which compounds interest at a rate more frequent than once per year. This is intra-year compounding. You will learn how to change the present value function in Excel in order to account for compounding interest on a monthly basis, quarterly basis, and semi-annual basis. This is a great tutorial for anyone needing to learn about finance. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 9 - Future Value Calculation With Intra-Year Compounding of Interest in Excel
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the future value of a security or investment that compounds on a basis more frequent that once a year. This is called intra-year compounding of interest. You will learn how to change the basic future value function and formula to account for compounding periods that are more frequent than just once a year. This is a great finance basics tutorial. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 8 - Future Value of a Principal Amount With Recurring Annuity Payments in Excel
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the Future Value of a series of annuity payments in Microsoft Excel. You will learn what an annuity is and how to figure out the future value of that annuity. The main method you will learn to do this is the FV() or future value function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: How To Use MS Office (Navigating Excel Menu) Episode 1
Video:
Description:Hi, guys, my name is Hope, and I'm here to show you just a basic overview of the new 2007 Excel version. So, I'm going to show you where things are that you might have been looking for, and kind of some of the new things that are available now in this new version. So lets' get started. The first thing that I'm going to show you is what I like to call the fancy button. It's up here in the left hand corner. The reason I call it the fancy button is it just looks really pretty. If you click on this fancy button, that is actually your file menu. So if you've been looking for your "save as," that's where it's located. You're going to see a lot more options underneath the "save as" version. You're going to see that you can actually save it as a macro-enabled workbook, which we can get into later. Also, the older versions -- if someone doesn't have a conversion packet, you can save it as Excel 97/2003 workbook, and they'll be able to open it. So if you have any friends out there who are getting your Excel workbook and they can't open it, you can just save it in this version and then they'll be able to open it in their old way. Print button is also here, if you've been looking for that. Some other things that we can get into later are just some "prepare" options. And then "send," if you've ever sent any of your Excel workbooks as an attachment, you can just click on "e-mail" right here and it will open up your Outlook and send it as an attachment in your e-mail. Down here is ...
Title: Finance Basics 7 - Future Value Examples in Excel - How much something is worth in the future
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial presents 3 Future Value examples and shows you how to solve them using the FV() function in Excel. You will learn how to solve a basic simple future value problem; a simple annuities problem; and then an asset valuation problem. These are great examples to use to help learn and understand what future value means and how you can use it. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 6 - Present Value Examples in Excel - How much something is worth today.
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial goes through 3 Present Value problems and shows you how to solve them using the PV() function in Excel. You will learn some of the basic applications for the present value function and also the different uses for this function. The three examples include how to figure out what a future amount is worth today; valuing annuity payments in the future for today; and how to value an asset with the present value function. This is a great tutorial for all of those just learning finance or for people who need to more accurately find the value of and asset or cash flow. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 5 - Learn Present Value and what it Means and Does
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial will explain what the Present Value concept means and how you can use it in Excel. You will learn the standard mathematical formula in order to calculate the present value as well as the Excel PV() function. This is a great tutorial for all finance majors or for people who simply need to learn and understand what present value is and means. The present value of anything is simply what the current value or worth of that item is today. In order to figure this out, you do need to know the annuity payments or future value of the item. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 4 - Calculating Annuities in Excel - Future Value for Annuities
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the total future value of a series of annuity payments. This is a must for finance majors as well as people who need to know the future value of and series of payments which they may be receiving. This tutorial covers this basic finance concept and shows you how to solve annuity problems by hand in Excel and also using the fv() future value function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 3 - Custom Compound Interest Function Made in Excel - Macro - Custom Functions
Video:
Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to create a custom Compound Interest Function in Excel. This is a UDF or User Defined Function. It is written within a macro in Excel. This tutorial will show you how to create compound interest future value function in Excel since there is no default compound interest function in Excel. This is a must view tutorial for people who often need to calculate the future value of a series of payments with compound interest. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Finance Basics 2 - Compound Interest in Excel
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the future value of an investment with compounded interest. You will learn how to do this by hand in Excel and also how to use the mathematical formula for compounding interest in Excel. This two methods will equip you with the skills necessary to compute compound interest payments and total value for any given period of time and all within Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: How to Record a Macro in Excel 2007 For Dummies
Video:
Description:Excel macros allow you to perform repetitive tasks quickly through a keyboard shortcut. This Excel video tutorial shows you how to record a simple macro to help automate your Excel 2007 tasks.
Title: How to Create a Data List in Excel 2007 For Dummies
Video:
Description:Creating a data list, or Excel table, can help you store a large amount of data consistently, as well as give you the ability to easily read, sort, and filter that information. This video tutorial shows you how to create a simple data list in Excel 2007.
