Course Description
In these lessons, you will learn how to review, summarize, and visualize data using pivot diagrams. We’ll show you how to use pivot diagrams to aggregate and visually display data from a database, then show any connections in Visio.
After first reviewing the structure of a pivot diagram, you’ll learn how to import data into Visio from a multitude of sources to create your own diagram. Then you’ll see how easy it is to manipulate and shape the data to fit your needs. We’ll also show you how to share a pivot diagram through other Microsoft applications like Word and PowerPoint, so you can link your data, connect it, and update it whenever you make changes to the source document.
What You'll Learn
- Review the structure of a pivot diagram in Visio
- Create a pivot diagram using source data from Excel
- Import data into Visio from a multitude of sources to build your own diagram
- Manipulate and shape imported data to fit your needs
- Use Visio with other Microsoft applications like Word and PowerPoint
- Link, connect, and update pivot diagram data when the source document changes
Key Takeaways
- Pivot diagrams in Visio let you review, summarize, and visualize data while showing the connections between it.
- A pivot diagram can be created with source data drawn from Excel.
- Data can be imported into Visio from many different sources and then manipulated and shaped to fit your needs.
- Pivot diagrams can be ingested and linked to other Microsoft applications such as Word and PowerPoint.
- Linked data can be connected and updated whenever changes are made to the source document.
Frequently Asked Questions
What will this course teach me about pivot diagrams?
It teaches you how to review the structure of a pivot diagram, create one using source data from Excel, import and shape data from multiple sources, and share pivot diagrams through other Microsoft applications.
Does this course cover using Visio with other applications?
Yes. It shows how to share a pivot diagram through other Microsoft applications like Word and PowerPoint, so you can link your data, connect it, and update it whenever you make changes to the source document.
Which lessons are included in this course?
The course includes three lessons: Review a Pivot Diagram, Create a Pivot Diagram, and Using Visio With Other Applications.
What skills will I gain from this course?
You will build skills in data visualization, database diagrams, Microsoft Visio, pivot grids, pivot tables and charts, and visualization.
Can I bring in data from outside Visio to build a diagram?
Yes. You will learn how to import data into Visio from a multitude of sources to create your own diagram and then manipulate and shape that data to fit your needs.
