Data Analysis with Pivot Tables: Build & Automate
Master Data Analysis with Pivot Tables: Build, Analyze & Automate teaches you how to transform raw Excel data into meaningful insights using pivot tables, pivot charts, advanced calculations, and automation. Through a structured, step-by-step learning experience, you'll progress from understanding the fundamentals of pivot tables to applying advanced analytical features that improve reporting and decision-making. You will learn how to build and format pivot tables, sort and filter data, group numeric and date fields, and use advanced features such as Show Details, grand total settings, and Sh
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Excel Skills for Business: Intermediate I
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specializat
All levels
Precalculus: Relations and Functions
This course helps to build the foundational material to use mathematics as a tool to model, understand, and interpret the world around us. This is done through studying functions, their properties, and applications to data analysis. Concepts of precalculus provide the set of tools for the beginning student to begin their scientific career, preparing them for future science and calculus courses. This course is designed for all students, not just those interested in further mathematics courses. Students interested in the natural sciences, computer sciences, psychology, sociology, or similar w
All levels
Observational Methods and Qualitative Data Analysis
This is primarily aimed at first- and second-year undergraduates interested in psychology, data analysis, and qualtitative research methods along with high school students and professionals with similar interests. This course delves into the qualitative research traditions of ethnographic inquiry and case study in psychology, emphasizing the use of participant observation. Students will explore the unique practices, data gathering and analysis methods, and researcher involvement in these traditions. This course explores the interviewing methods used in qualitative research in psychology. The
All levels
Data Visualization
This course will teach you how to make more effective visualizations of data. Not only will you gain deeper insight into the data, but you will also learn how to better communicate that insight to others. You will learn new ways to display data, applying some fundamental principles of design and human cognition to choose the most effective way to display different kinds of data. This course not only teaches you how to use popular applications like Tableau to connect to data warehouses to extract and visualize relevant data, but also teaches you how Tableau works so you can use the same techniq
All levels