Explain the purpose and use of macros, data models and pivot tables Course
1 hour, 19 minutes
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.![](/contentassets/d65de3a5bb034993b7cf1ea5e1eab9f3/prerequisites-graphic.png)
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
![](/contentassets/591f43d72c6b4d0bb8ba22cad75d6c48/2x.png?height=122&rmode=Max&bgcolor=transparent)
![](/contentassets/68cc0229d91e4a62be8622c213529754/users-love-us-3.png?height=122&rmode=Max&bgcolor=transparent)
![](/contentassets/419c2404d29e4e61a554acee7d04beb0/winners-badge-png.png?height=122&rmode=Max&bgcolor=transparent)
![](/contentassets/8ef988d8aac34badb0d4c655253d16b2/onlinecourseproviders_leader_leader.png?height=122&rmode=Max&bgcolor=transparent)
![](/contentassets/49843374d7924a2fac275eca5ed2e8cc/csgea-2022-bronze-png.png?height=122&rmode=Max&bgcolor=transparent)