Course

Explain the purpose and use of macros, data models and pivot tables

Explore macros, data models and pivot tables and their use.

    Syllabus

  • Demo — Alerts and lookup files Video — 00:08:30
    • Demo: Configure alert and lookups.

  • Theory — Reports and alerts Video — 00:07:07
    • Theory: Understand the use of reports and alerts.

  • Demo — Datasets and data models Video — 00:08:55
    • Demo: Demonstrate how to create and use datasets and data models.

  • Run & troubleshoot a macro Video — 00:07:10
    • Demo: Run and troubleshoot a macro.

  • Demo — Reports Video — 00:14:39
    • Demo: Create reports and dashboards.

  • Demo — Pivot Editor Video — 00:14:24
    • Demo: Design pivot charts and visualizations with the Pivot Editor.

  • Theory — Datasets and data models Video — 00:11:01
    • Theory: Describe the use of datasets and data models.

  • Create a macro Video — 00:06:59
    • Theory: Understand and define a macro.

Syllabus

Course description

Learn about macros, data models and pivot tables. View easy-to-understand explanations and demonstrations about macros, data models and pivot tables and their use.

You're in good company

CY

We use Infosec Skills to provide continuous training to our technicians and to prepare them for various certifications. Infosec Skills allows us to create personalized training programs that focus on each of our technicians’ particular roles and see their progress as they take courses. We also, recommend it to clients to make their IT support teams better.

Caleb Yankus

DS

This has been utilized to bridge the skills gap across our cyber team and to aid them as they prepare for their various certifications. It also has provided a nice learning foundation for our various cyber team members to utilize as we continue to find ways for cross-utilization with operations while minimizing the downtime needed to ensure everyone’s knowledge is the same.

Daniel Simpson

IS

We use Infosec Skills to provide base level knowledge for employees. We also use the services to provide in depth learning for employees as they encounter new technologies. If an employee is is assigned to a new project, we can rely on Infosec Skills to provide a rapid concentrated learning environment. This rapid concentrated learning positions our employees for success.

Infosec Skills Teams client

Plans & pricing

  • Infosec Skills Personal

    $299 / year

    • 190+ role-guided learning paths (e.g., Ethical Hacking, Threat Hunting)
    • 100s of hands-on labs in cloud-hosted cyber ranges
    • Custom certification practice exams (e.g., CISSP, Security+)
    • Skill assessments
    • Infosec peer community support
  • Infosec Skills Teams

    $799 per license / year

    • Team administration and reporting
    • Dedicated client success manager
    • Single sign-on (SSO)
      Easily authenticate and manage your learners by connecting to any identity provider that supports the SAML 2.0 standard.
    • Integrations via API
      Retrieve training performance and engagement metrics and integrate learner data into your existing LMS or HRS.
    • 190+ role-guided learning paths and assessments (e.g., Incident Response)
    • 100s of hands-on labs in cloud-hosted cyber ranges
    • Create and assign custom learning paths
    • Custom certification practice exams (e.g., CISSP, CISA)
    • Optional upgrade: Guarantee team certification with live boot camps

Unlock 7 days of free training

  • 1,400+ hands-on courses and labs
  • Certification practice exams
  • Skill assessments

Award-winning training that you can trust

Comprehensive Cybersecurity Training - Infosec Skills
Cybersecurity Education and Training Gold Award - Infosec IQ
Top Rated Award - Infosec Skills
2021 G2 Summer - Leader - Tech Skills Dev, Online Course, eLearning Content
Top 20 Company - Online Learning Library