Description:This video shows you a hidden tool in Mac Word which allows you to open up a userform similiar to visual basic (a Microsoft application which isn't available for macs)...its called macros... enjoy
Title: Microsoft Excel, SQL and Internet Tips : How to Use a Do-While Loop in Excel VBAVideo:
Description:When using Excel's VBA, or visual basic editor, create a code that runs when a worksheet is activated and use a do-while loop that has an end condition. Use a do-while loop in Excel VBA withtips from a software developer in this free video on using Microsoft Excel. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown
Description:www.contextures.com How can you send Excel data to a different sheet, without a macro, and no copying and pasting? Use an advanced filter -- and you can see how, in this video. With an Excel Advanced Filter, you can filter the data in place, or you can filter it to a different location. In this Excel video tutorial, you'll see the steps for setting up the advanced filter so the results are moved to a different worksheet, and the key steps for making this technique work.
Description:i-teach-u Excel Buttons and ComboBox Buttons and Combo Box. I have named the 4 worksheets, Title, Dashboard, Questions and Results. You are asked to write your name and college details on the Title sheet, then write in your questions on the Question sheet. On the results sheet you should create a table so that you can fill in the details of your results, (when you get them from your Questionnaires). On the Dashboard I have created one combo Drop Down Menu so that you can select your students and the see details of their choices on the Dashboard sheet. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.
Description:i-teach-u Excel Button Macros I tried to show the simplest way possible to create a button to turn pages or perform simple macro tasks on an excel sheet. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.