I’ll teach you how to manipulate and visualize data in Excel by Pietro MacorigI’ll teach you how to manipulate and visualize data in Excel by Pietro Macorig

I’ll teach you how to manipulate and visualize data in ExcelPietro Macorig

Cover image for I’ll teach you how to manipulate and visualize data in Excel

Hi, my name is Pietro, an aspiring management engineer in Italy, and I will teach you how to create a dashboard in Excel and manipulate datasets.

Allow me to help you make your first steps into the data visualization world.

We’ll start from the bottom:

Importing and cleaning data;

Understanding Power Query;

Know how to utilize a Pivot Table;

Create beautiful and interactive graphs.

After a lesson with me, you can expect to be fluent in creating appealing and useful dashboards for you and your business.

Check my profile to see my portfolio and my other projects.

What's included

Import data

Learn how to import data from a CSV file, from a folder, or from a changeable folder declared in a cell.

Power Query

Learn from the basis of how to utilize Power Query, such as cleaning and manipulating data, and merging queries.

Pivot Table

Learn how to create different Pivot Tables for every occasion.

Graph/Charts

Learn how to visualize data, create significant graphs and charts, create likened images, appealing tables, filters, timeline and much more.

Pietro's other services

Cover image for Interactive and Dynamic Excel Dashboard

Interactive and Dynamic Excel Dashboard$40

Starting at$20 /hr

Tags

Microsoft Excel

Data Analyst

Data Visualizer