Anggi Firdian Saputra – Medium

Anggi Firdian Saputra

Anggi Firdian Saputra

Get to Know About Pivot Table Pt. 5

Drilling Down, GETPIVOTDATA, Timeline, and PivotTable and PivotChart Wizard

Jan 27, 2023

Get to Know About Pivot Table Pt. 5

Jan 27, 2023

Anggi Firdian Saputra

Get to Know About Pivot Table Pt.4

Grouping, Calculated Field/Items, and Value Field Setting

Jan 26, 2023

Get to Know About Pivot Table Pt.4

Jan 26, 2023

Anggi Firdian Saputra

Get to Know About Pivot Table Pt.3

Slicer, Layout, and Update PivotTable

Jan 26, 2023

Get to Know About Pivot Table Pt.3

Jan 26, 2023

Anggi Firdian Saputra

Get to Know About Pivot Table Pt.2

Sorting, Filtering, and creating PivotCharts

Jan 25, 2023

Get to Know About Pivot Table Pt.2

Jan 25, 2023

Anggi Firdian Saputra

Get to Know About Pivot Table Pt.1

Introduce PivotTable, Layout, Format, Collapse, and Expand Field

Jan 25, 2023

Get to Know About Pivot Table Pt.1

Jan 25, 2023

Anggi Firdian Saputra

SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions

The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS formulas are used the same as the COUNTIF and COUNTIFS formulas.

Jan 21, 2023

SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions

Jan 21, 2023

Anggi Firdian Saputra

COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions

Sometimes during work, we are asked to count the amount of data specifically, for example, we are asked to count the number of names…

Jan 21, 2023

COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions

Jan 21, 2023

Anggi Firdian Saputra

IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions

While working with data and analyzing it, we need a function that can return the results that only we want. Therefore, we can use the IF…

Jan 21, 2023

IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions

Jan 21, 2023

Anggi Firdian Saputra

Lookup Functions

While working as a data analysts, we are sometimes required to find out the specifics of a product, whether it is the price of the product…

Jan 18, 2023

Lookup Functions

Jan 18, 2023

Anggi Firdian Saputra

Get to Know About SQL Pt.11

Using View and Cursor

Jan 13, 2023

Get to Know About SQL Pt.11

Jan 13, 2023

Anggi Firdian Saputra

Anggi Firdian Saputra

Data Analyst | Geothermal Energy Enthusiast | Data Scientist | Business Analyst | Geophysical Engineering

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams