Buy or Rent advanced Training

Good afternoon everyone,

I'm hoping to pick people's brains on here as to if anyone knows of any effective advanced VBA courses offered in the domectic US.

I've been able to self teach myself using google, message boards, and alot of trial and error. Now that I've been able to delve into some of the more advanced aspects (class modules, collections, withevents ect), I would like to find an instrunction course where I can have face to face interation to become more structured in my use and have specific questions answered.

Any suggestions as to worthwhile classes would be greatly appreciated.

Thank you,

-R

Hi there,

Do you know of any affordable Excel training in South Africa Jhb, online courses in developing Pivot tables?
How can I better my knowledge of Pivot tables?
Macros?

I have a list of about 10,000 odd training records and I need to find, for each of the approx 300 course codes, the earliest and latest dates the course has been run.

Columns of data a

Course Code
Course Name
Start Date
Finish Date
User name

So for each of the 300 course codes, I need to get the earliest Start Date and the latest Finish Date.

I'm familiar with Max/Min functions, Named Ranges and how to find the unique Course Codes from the list. But not so sure about how to set up a formula to find the records for one course code against which I can apply the max/min function.

Any help would be appreciated.

Ward
in Perth

Hi everyone,

I just wanted to give you a heads up about Dunamis Training, LLC. We are dedicated solely to Excel/Access VBA programming. If you are interested in having a 2 day VBA class at your site or come to an offsite class, contact us. We are in the Pittsburgh area! Our instructors have decades of proven experience in VBA solutions at companies like FedEx and GM. We target business professionals, so you don't have to be a programming expert to participate.

Check out our web site: dunamistraining.com

If you have any questions, shoot them to us from our website "contact us", or call us. Thanks.

Chad Marinelli
Owner/Trainer
Dunamis Training, LLC
1-412-628-9464
chad@dunamistraining.com

I am just beginning to learn how to make macros but I need help in a big way. what I need is a macro that will figure out how to schedule people for training based off their schedule and available training classes. I.e. i have a list of dates, times and number of people that can attend. I need something that would base the persons schedule on the available time and assign the class, then when it maxes the class out it moves to the next class. I know it is a lot to ask for but i am in desperate need for some help.

To Whomever can help me,

I have a worksheet I can't make work...

I have attached a spreadsheet that completely explains what I want. There are three sheets.

The first one is a basic value look of the third sheet and works fine, if there are values in the third sheet.

The Second sheet is where the user inputs data. If the boxes are grey, they are either manually input or have a working formula. On this sheet, all you have to worry about the white filled cells in the borders. The comments explain what I need, as best as I can get it across. Though some of these have formulas in them, they may not work right and need tweaking.

The Third sheet is a break-out of all the rent paid by each tenant for every month of their leases. The numbers here and in the Input sheet have to match.

Here is the key to the formatting:

Grey fill : Manual input data (don't worry about them)
Red fill : Contains comment directions for the set of cells that are in the bold borders
No fill : will be calculated from formulas requested in red fill cell

Italicized : Should not be used as a reference to any formulas


Be sure to read the comments. I would be more than happy to go over any aspect of this with you. THANKS very, very much!

So I am managing some rented properties for someone. I have one house that has from between 4-8 tenants in it, (this changes frequently) and four other houses with one tenant per house. I previously had a worksheet per tenant. they pay monthly and each person pays a different amount. Can someone give me a formula so i can keep this all in one worksheet and so I can see at a glance who is in arrears? I don't need a complicated sheet the only details I need to have on it are the person's name and amount of rent paid & owed.

Has anyone seen a good spread sheet which weighs the cost benefit of renting vs. buying? If so I would love to take a look at it. I've seen a few but none seem to take into account all variables (i.e. real estate commission when selling, opportunity cost of down payment ivestment etc.).

Much appreciated.

- greenmtn

Check out this rent vs buy calcualator:

http://www.nytimes.com/interactive/b...alculator.html


I need to replicate this in excel but cannot figure out how to have the model adjust for the varying number of years to stay in the house. Attached is what I got so far.

Hi all,

I'm trying to create a rent roll covering the next 5 years. So I have unit
numbers down the left hand column and sequential months across the top row.

My problem is charting periodic rent increases, say every 12 months, for
instance. As well, different units have different lease dates, so not all
units will change rent in the same months.

Help!

Thank you,
Zach