Summarizing and Organizing Data in Excel

A practical and pragmatic course exploring the features of Excel that allow you to organize, summarize, analyze, and visualize large amounts of data. Quickly learn how to turn data into insightful and powerful tables and charts.

5|Reviews (191)
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo

Why choose Core Tech?

check
3,900+ Courses
check
Software Development
check
IT Operations
check
Product & UX
check
Business Skills
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →
Price may vary. Check latest price on provider site.

Course Insight

Suitable for beginner learners. This course serves as an entry point into Data Science, building foundational knowledge before moving on to advanced frameworks or specialized paths.

Beginner FriendlySelf-Paced LearningHands-On Learning

SKILLS TO
MASTER

Analytics
Exploratory Data Analysis
ModelingTrending
Predictive Machine Learning
SQL Querying
Relational Data Management
Pandas
Matplotlib
Statistics
Tableau
ETL
Careers:Relevant for professionals pursuing roles within Data Science.

Quick Facts

Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.

What You’ll Learn

  • Course Overview : 1min.
  • Grouping Data and Outlining Your Data : 15mins.
  • Inserting Totals and Subtotals : 17mins.
  • Applying Conditional Formatting : 13mins.
  • Inserting Sparklines : 12mins.
  • Exploring Other Excel Capabilities : 3mins.
See side-by-side differences in what you’ll learn

Description

Microsoft Excel is the world's foremost desktop application for storing, organizing, and manipulating data. This course teaches you how you can use the features of Excel to quickly organize, summarize, analyze, and visualize data so that you can understand your data and gain meaningful insights into it. First, you will learn how to order and group the data so that related items appear together. Then, you will discover how to apply totals and sub-totals to it. Finally, you will explore how to visualize the data using Conditional Formatting and Sparklines. By the end of the course, you will have the skills and knowledge to understand and visualize your own data in Excel.

See how this course compares with alternatives

FAQs

Top Alternatives

Highly-rated courses worth your attention

PostgreSQL Data Manipulation Playbook
5.0· 2 Hrs 34 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Importing Data: Python Data Playbook
4.0· 1 Hrs 35 minutes
Beginner
CORE TECH
₹10,563/yr|₹1,254/mo
Data Wrangling with Python 3
4.0· 1 Hrs 20 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Combining and Shaping Data
4.0· 3 Hrs 28 minutes
Beginner
CORE TECH
₹10,563/yr|₹1,254/mo
Pandas Playbook: Manipulating Data
5.0· 2 Hrs 15 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Querying Data Using T-SQL
5.0· 2 Hrs 7 minutes
Beginner
CORE TECH
₹10,563/yr|₹1,254/mo
Summarizing and Organizing Data in Excel
5(191+ learners)