Pivot Tables

In this course, you will learn how fields are extracted and how to create regex and delimited field extractions. You will upload and define lookups, create automatic lookups, and use advanced lookup options. You will learn about datasets, designing data models, and using the Pivot editor. You’ll improve search [...]

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. [...]

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will [...]

Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery. We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data [...]

Este curso está diseñado para proporcionarle los conocimientos básicos de trabajo para utilizar las hojas de cálculo de Excel para el análisis de datos. Cubre algunos de los primeros pasos para trabajar con hojas de cálculo y su uso en el proceso de análisis de datos. Incluye muchos [...]

Further your Excel skills to manage larger datasets and more complex data wrangling, management and modelling. This intermediate Excel course builds on the teachings of the introductory Core Foundations course, teaching you to leverage the power of data calculations and reports to make informed personal or organizational [...]

Hello! This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time. This course will help the learners to improve their skills and be familiar with [...]