TrueschoTruescho
All Courses
Create Charts and Dashboards Using Microsoft Excel
Coursera
Guided Project
Unknown

Create Charts and Dashboards Using Microsoft Excel

Coursera

Learn to create charts and PivotTables in Microsoft Excel for sales data analysis and build dashboards to visualize information clearly.

Unknown1 weeksEnglish

About this Course

In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data

What You'll Learn

  • Create PivotTables to analyze data relationships
  • Build line, bar, and pie charts
  • Compose dashboards combining charts and tables

Prerequisites

  • Basic familiarity with Excel or workflow used
  • Ability to follow step-by-step instructions in English

Instructors

P

Paula Del Rey

Subject Matter Expert

Topics

Business Essentials
Business
Spreadsheet Software
Data Visualization
Microsoft Excel
Data Analysis
Trend Analysis
Dashboard
Microsoft 365
Microsoft Office

Course Info

PlatformCoursera
LevelUnknown
PacingUnknown
PriceFree

Skills

أساسيات الأعمال
إدارة الأعمال
برامج الجداول الإلكترونية
تصوير البيانات
مايكروسوفت إكسل
تحليل البيانات
تحليل الاتجاهات
لوحات البيانات
Microsoft 365
Microsoft Office

Start Learning Now