Today
Fri, Oct 16 · 32 min
- Th15
- Fr16
- Sa17
- Su18
- Mo19
- B13 SumProduct & Anchoring 10 min
- B14 Conditional Formulas 13 min
- B15 Conditional Formatting 9 min
Short video lessons and hands-on actuarial projects in Clear, our study app, planned to the date you want to finish. No experience needed.
$249Per course. 12 months of access.
Taught by Cedean Kematick, FSAVolunteers writing and grading SOA exams
Today
Fri, Oct 16 · 32 min
Short lessons, then a project that puts them to work, then the solution.
Each comes with 12 months of access and Cedean's answers in the course Q&A.
For beginners
Excel, VBA and SQL from the ground up, plus a first look at R and Python.
$249Full-time students $85
Buy Technical FoundationsNew to R and Python
R and Python for actuarial data, from preparing it to your first predictive models.
$249Full-time students $85
Buy Predictive Analytics IntroBoth coursesTechnical Foundations and Predictive Analytics Intro
$449Full-time students $150
Buy both courses
Post a question in the course Q&A and Cedean answers it.
StudentIs recording a macro and then editing the code viewed as unprofessional or unskilled, or a red flag by employers?
CedeanIn practice, my opinion is that there is certainly no expectation that a new entry level analyst would be able to do anything beyond what we introduce here. Being skilled at simply using record and build is likely a plus in most roles.
“I think the experience from this course will be a great talking point during my next actuarial interview.”
Something else?
Contact us →
Students, recent graduates, career changers and new entry-level analysts. You don't need any experience: both courses start from the beginning.
New to all of it? Start with Technical Foundations. Comfortable in Excel and want R and Python? Take Predictive Analytics Intro. Or take both for $449.
Microsoft Excel, on Windows or Mac. The SQL lessons use Microsoft Access, which is Windows only, but any SQL tool works, such as MySQL. R and Python are free.
No. TIA doesn't issue one. Send Cedean your finished projects and he'll serve as a reference for you.
12 months from the day you buy. Need longer? A one-year extension costs half what you paid.
Yes. Full-time students pay $85 per course, or $150 for both. Enter your school email and we'll send you a discount code.
$249 per course, or $449 for both · 12 months of access.