Course
Explain the purpose and use of macros, data models and pivot tables
Explore macros, data models and pivot tables and their use.
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.
Syllabus
Demo — Alerts and lookup files
Video - 00:09:00
Demo: Configure alert and lookups.
Demo — Reports
Video - 00:15:00
Demo: Create reports and dashboards.
Theory — Reports and alerts
Video - 00:07:00
Theory: Understand the use of reports and alerts.
Demo — Pivot Editor
Video - 00:14:00
Demo: Design pivot charts and visualizations with the Pivot Editor.
Demo — Datasets and data models
Video - 00:09:00
Demo: Demonstrate how to create and use datasets and data models.
Theory — Datasets and data models
Video - 00:11:00
Theory: Describe the use of datasets and data models.
Run & troubleshoot a macro
Video - 00:07:00
Demo: Run and troubleshoot a macro.
Create a macro
Video - 00:07:00
Theory: Understand and define a macro.
Unlock 7 days of free training
- 1,400+ hands-on courses and labs
- Certification practice exams
- Skill assessments
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
Award-winning training you can trust




