background preloader

Study

Facebook Twitter

Free downloadable Computers Video Lecture courses. Khan Academy. Science & Nature - Human Body and Mind. Free History Video Lecture courses. Internet Encyclopedia of Philosophy. Free Social Teaching and Learning Network focused solely on education. Philosophy since the Enlightenment, by Roger Jones. Free university lectures - computer science, mathematics, physics, chemistry. Whether your goal is to earn a promotion, graduate at the top of your class, or just accelerate your life, lectures can help get you there.

Our archives of lectures cover a huge range of topics and have all been handpicked and carefully designed by experienced instructors throughout the world who are dedicated to helping you take the next step toward meeting your career goals. Lifelong learns can turn their free time turn into self-improvement time. The online lectures on this list are more than lecture notes or a slideshow on a topic -- they were designed for audiences like you, with carefully sequenced themes and topics taught by veteran educators, and often with additional resources for your own independent study.

The lectures are available to anybody, completely free of charge. Lecture courses are a valid and vital learning tool, and may be one of the best methods of learning available. Excel VBA Basic Tutorial 2. Excel VBA Basic Tutorial 2 This page contains the 2nd lesson on the Excel VBA Basic Tutorial series. It covers topics in the most used Excel objects and collections. Beginners in VBA programming are encouraged to go through the 1st lessons in this series if they had not already done so. This document contains information about the following topics.

Objects and Collections Workbook and Worksheet Object Range Object and Cells Property Methods and Property Assigning Object Variables and Using Named Argument Microsoft Support site or the Excel VBA Help section on your computer contains comprehensive examples on most the issues covered on this page. For more information, please refer to them. Objects and Collections Microsoft Support Objects are the fundamental building blocks of Visual Basic. Workbooks is a collection of all Workbook objects. The following figure shows all the objects mentioned. Workbook and Worksheet Object A workbook is the same as an Excel file. Worksheets("Sheet1") Anthony's Excel VBA Page - Excel Tutorial - Excel Consultant - Excel Consulting.