Excel: Data Analysis with Formulas/Functions and PivotTables

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Excel: Data Analysis with Formulas/Functions and PivotTables

Coursera · Intermediate ·📊 Data Analytics & Business Intelligence ·3mo ago

Skills: Data Literacy80%

Key Takeaways

Analyzes data using Excel formulas, functions, and PivotTables

Original Description

In this course, you'll continue developing your data-analysis skills in Excel by analyzing data using formulas and functions. You'll also analyze data using PivotTables. This is the second 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.

Watch on External: Coursera ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

More on: Data Literacy

View skill →

Analyzing Billing Data with BigQuery

Live Coding Stream: ESports Earnings Data Analysis with Python

Live Coding Stream: ESports Earnings Data Analysis with Python

PySpark in Action: Hands-On Data Processing

PySpark in Action: Hands-On Data Processing

Analyze and Visualize Data Using Splunk Statistics

Analyze and Visualize Data Using Splunk Statistics

Apply SCD2 to Build Dynamic Data Models

Automate Financial Insights with AI Tools & Dashboards

Automate Financial Insights with AI Tools & Dashboards

Related Reads

Por qué el "precio de lista" de una tienda no vale nada (y cómo construimos un tracker honesto)

Learn why list prices in stores are often misleading and how to build a tracker to monitor honest prices, applying data analysis and programming skills to make informed purchasing decisions.

Dev.to · Edu Tor

FDA Recall API: A Working Guide to openFDA Enforcement

Learn to navigate the openFDA Enforcement API to retrieve drug, device, and food recall data, overcoming common issues like the 26,000-record skip wall and silent OR bug

Dev.to · Mayd-It

Common Mistakes New Data Engineers Make (And How to Avoid Them)

Learn to avoid common mistakes new data engineers make to improve data pipeline efficiency and reliability

Dev.to · Abhishek Konagalla

DuckDB vs PostgreSQL: I Ran the Same Query on Both. One Finished in 12ms. The Other Timed Out.

Compare DuckDB and PostgreSQL performance by running the same query on both to determine when to use each database system

Medium · Programming

How to Prompt Your LLM Directly from SQL