http://www.keystonelearning.com/courses/microsoft_excel_2007_training_course/
Follow the link above for a course outline, product details, and options for purchasing the full Excel 2007 course.
KeyStone Learning Systems has Enterprise solutions for Companies, Government, and Education. www.keystonelearning.com
Duration : 0:4:27
Improvements to Excel 2010′s SmartArt functionality. In Episode 1068, I show how to make your SmartArt text dynamically generate from cells in the worksheet.
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!
Duration : 0:4:32
=(VLOOKUP(B9,Master!D:E,2) if the cell i vlookup is blank = 0 or blank instead of what i am getting now … #NA ?
You have two options:
1. Edit the lookup data so that the blank cells all contain a zero or something similar, so the lookup will return something
2. Wrap an "if" statement around the vlookup to return a zero or a blank if the formula errors out:
=IFERROR(VLOOKUP(B9,Sheet1!D:E,2),0)
I’m trying to design a simple program to pick random questions from an array, unfortunately however I have no idea on how to limit how many programs are chosen. What I would like to do, is after five questions have been given, is for a message box to pop up and say that no more questions can be given.
Also, to keep the same questions from reappearing, what code do I use to remove the question from the array? I already know it would be something like
question.removeat("question here")
However since I’m using an array list I can’t use something like
For 1 to 9…
because when the question is removed it would result back in an error. I’ve tried this however
For ubound to lbound…
but to no success. Also, as you can probably imagine, I’m kind of new at this, so some examples would help along with the explanation.
I typed this in, and it didn’t quite work out. Any suggestions?
Counter = 0
If Counter < 2 Then
Randomize()
For i = 1 To 6
j = Int(Rnd() * i)
lblQ.Text = questions(j)
Next
Counter = Counter + 1
ElseIf Counter = 2 Then
MsgBox("Restart Program")
End If
Use a dictionary to store the questions. The key can be the question number, the entry can be a class that has the question and an "already asked" boolean.
When you ask a question, mark it as already asked. You’ll be able to filter the list for alreadyAsked=False using LINQ, that will keep only unasked questions in the list.
Public Class MyQuestionsClass
Public Question as String
Public AlreadyAsked as Boolean = False
Public Sub New(ByVal inQuestion as String)
Me.Question=inQuestion
Me.AlreadyAsked=False
End Sub
End Class
Dim myQuestions as new Dictionary(Of Integer, MyQuestionsClass)
For q = 1 to 10
myQuestions.add(q, new MyQuestionsClass("Question #" & q)
Next
Then let’s say you ask question #4
myQuestions(4).AlreadyAsked = True
If you need more help you can email me.
See how to record a MACRO to copy data to a new location, and then edit the code. See the VBA functions RANGE and OFFSET.
rcaldwell1http://gdata.youtube.com/feeds/api/users/rcaldwell1EducationMacroExcel Macro 2003
Learn to harness the power of simple formulas in this free Excel 2010 tutorial.
Learn how to leverage the Special Cells property to quickly select all rows to hide or delete.
For basic understanding of using Excel on Mac in Biology 1107 laboratory course at University of Connecticut.
Pivot tables: You’ll learn what a Pivot Table is, and how to use one in Excel 2003. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.