Excel for Security Analysts Series


Excel for Security Analysts is a series of blog posts for Security, Data and BI analysts. In this series we demonstrate the powerful analytic capabilities of Excel.

Most of the posts are focused on the data acquisition and transformation phase, which are achieved with Power Query technology in Excel, which is now integrated into the Data ribbon in the Get & Transform group in Excel 2016 (Preview).

Here are the episodes:

Excel for Security Analysts – Intro

Episode I – Analyzing Web Traffic Logs (W3C ELFF)

Transform multiline records into a table

Episode II – Analyzing SSH Logs

Coming soon (This page will be updated as we publish new episodes):

Episode III – Analyzing IPTables Firewall Logs

What do yo like to see next?

Please share your ideas and feedbacks in the comments below.

Comments (3)

  1. Anonymous says:

    In today’s post, there is a nice Power Query trick to transform multiline record data into a table

  2. Anonymous says:

    In this walkthrough we will show step-by-step how to turn web traffic logs ( W3C Extended Log File Format

  3. Anonymous says:

    Excel for Security Analysts

Skip to main content