If you join AAMD as a Full CMD Member and add the Member Plus option for only $100 more, you will have the opportunity to earn a minimum of 20 online CE credits per year. For 2014, there will be 12 credits through CE modules and 9 credits through webinars. International members (from any country outside the US) can join AAMD at $150 and take advantage of the Member Plus online CE credits-and receive a subscription to the AAMD journal, Medical Dosimetry. For full topics and details click here.
To get the most out of Excel in the quickest time, you should learn the most useful formulas first. This course is aimed at teaching you the functions that you are most likely to use and that you will get the most benefit from. The course is divided into 5 sections: Basic functions like SUM and SUBTOTAL. Fixed and variable formula references.
Excel 2007 has three new functions that you can use to SUM, COUNT, or AVERAGE using multiple criteria. In earlier versions of Excel, you had to use slow-calculating, hard-to-understand array formulas or SUMPRODUCT to use multiple criteria. The new functions are easy to use and fast to calculate.n Excel 2007, you should always use the SUMIFS, COUNTIFS, and AVERAGEIFS functions instead of array formulas wherever you can because they are much faster to calculate. In versions before Excel 2007, array formulas are often used to calculate a sum with multiple conditions.