Technical Skills: Excel, VBA, SQL, R and Python

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.

  • Both courses? $449 for the pair.
  • Full-time student? $85 per course with your school email.

Taught by Cedean Kematick, FSAVolunteers writing and grading SOA exams

Clear tia Target finish in 49 days

Today

Fri, Oct 16 · 32 min

  1. Th15
  2. Fr16
  3. Sa17
  4. Su18
  5. Mo19
  • B13 SumProduct & AnchoringSumProduct & Anchoring · 10 min 10 min
  • B14 Conditional FormulasConditional Formulas · 13 min 13 min
  • B15 Conditional FormattingConditional Formatting · 9 min 9 min
15+ projects like real actuarial tasks

From first lesson to finished project.

Short lessons, then a project that puts them to work, then the solution.

  1. Watch it.

    • 20+ hours of short video lessons
    • Files to follow along with as you watch
    • No experience needed
  2. Build it.

    • A project closes each Excel, VBA and SQL section
    • One for each R and Python section, then a final project in each
    • Real files and tasks, like the job
  3. Check it.

    • A video solution for each section project
    • The solution file, to compare with yours
    • Questions answered by Cedean in the Q&A
  4. Take it to work.

    • A plan that ends on a finish date you pick
    • Finished projects to talk about in interviews
    • Send Cedean your projects, and he'll serve as a reference

Take one course, or both.

Each comes with 12 months of access and Cedean's answers in the course Q&A.

For beginners

Technical Foundations

Excel, VBA and SQL from the ground up, plus a first look at R and Python.

  • Excel basics
  • Lookups and formulas
  • Charts
  • PivotTables
  • VBA and macros
  • SQL queries and joins
  • Intro to R and Python

10+ hours of video · 6 projects

$249Full-time students $85

Buy Technical Foundations

New to R and Python

Predictive Analytics Intro

R and Python for actuarial data, from preparing it to your first predictive models.

  • R and Python basics
  • Data preparation
  • Vector operations
  • Exploring and charting data
  • Predictive modeling

10+ hours of video · a project per section, plus two final projects

$249Full-time students $85

Buy Predictive Analytics Intro

Both coursesTechnical Foundations and Predictive Analytics Intro

$449Full-time students $150

Buy both courses
Cedean Kematick
Cedean Kematick, FSATeaches the Technical Skills Courses at TIA.FSA in 2018. Writes and grades SOA exams as a volunteer.

Stuck? Ask Cedean.

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.”
Technical Skills student · course Q&A

Questions?

Something else?
Contact us →

Who are the courses for?

Students, recent graduates, career changers and new entry-level analysts. You don't need any experience: both courses start from the beginning.

Which course should I take?

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.

What software do I need?

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.

Do I get a certificate?

No. TIA doesn't issue one. Send Cedean your finished projects and he'll serve as a reference for you.

How long do I have access?

12 months from the day you buy. Need longer? A one-year extension costs half what you paid.

Is there a student price?

Yes. Full-time students pay $85 per course, or $150 for both. Enter your school email and we'll send you a discount code.

Start building your skills today.

$249 per course, or $449 for both · 12 months of access.