In this course, you'll continue to develop your data-analysis skills in Excel by presenting visual insights with dashboards. You'll also create geospatial visualizations in Excel.
This is the third course in a multi-course Specialization.
All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
PivotTables provide the raw power and ease of use that allow you to perform iterative data analysis to determine important insights and trends in data, but you still have to communicate those findings in a way that is compelling and easy to understand.
涵盖的内容
1篇阅读材料5个插件
显示有关单元内容的信息
1篇阅读材料•总计5分钟
⚠️READ THIS FIRST⚠️•5分钟
5个插件•总计115分钟
Lesson Introduction•5分钟
Visualize Data with PivotCharts•35分钟
Filter Data Using Slicers and Timelines•35分钟
Create a Dashboard in Excel•35分钟
Lesson Summary•5分钟
Creating Geospatial Visualizations with Excel
第 2 单元•小时 后完成
单元详情
Often, images can tell a story or provide insight in an instantaneous fashion that isn't always possible with words and numbers. When presenting complex relationships among various bits of data to large groups of people, you may find it easier to display a chart or a map instead of asking the audience to pore over massive amounts of data to see your point.
涵盖的内容
4个插件
显示有关单元内容的信息
4个插件•总计40分钟
Lesson Introduction•5分钟
Create Map Charts in Excel•15分钟
Customize Map Charts in Excel•15分钟
Lesson Summary•5分钟
Completing the Course
第 3 单元•15分钟 后完成
单元详情
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
Logical Operations is the world's largest general publisher of instructor-led technology curriculum, and a leader in the technical training community for over 40 years. We employ a rigorous, expert-driven authoring process that, for decades, has produced successful results for learners the world over. Our courseware aligns with real-world business needs and objectives, ensuring learners are able to apply their newly developed skills while on the job.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.