Visio Level 2: Advanced Diagrams & Data

Level 2Full Day1 DayVersion 365Official CPE Provider

Create advanced, data-connected diagrams in Visio. Build 3-D shape styles and custom stencils, link drawings to Excel and Project data for org charts and Gantt charts, and extend Visio with macros and ShapeSheets.

Course Objective

Students will build advanced plans and 3-D shapes, create custom shapes, stencils, and templates, connect drawings to Excel and Project data, use development tools such as macros and ShapeSheets, and review, export, and share drawings.

Prerequisites

To ensure your success, we recommend that you have experience with creating and styling basic diagrams in Visio. Students can obtain this level of skill through our Visio Level 1 course.

Course Outline

6 lessons · 20 topics

1Designing Advanced Plans and Diagrams

Build Advanced Plans
Build Advanced Diagrams

2Enhancing the Look of Drawings

Use 3-D Shapes
Work with Shape Styles
Define Shape Styles
Apply Backgrounds, Borders, and Titles

3Creating Custom Shapes, Stencils, and Templates

Create Simple Custom Shapes
Create Custom Stencils
Create Custom Templates

4Connecting Drawings to External Data

Make an Organization Chart from an Excel Spreadsheet
Generate a PivotDiagram from an Excel Spreadsheet
Create a Gantt Chart from a Project File
Create a Timeline from a Project File

5Leveraging Development Tools

Create Macros
Modify ShapeSheets
Build Advanced Shapes

6Sharing Drawings

Review Drawings
Insert Drawings into Other Office Files
Export Drawings
Print Drawings

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals