Anggi Firdian SaputraGet to Know About Pivot Table Pt. 5Drilling Down, GETPIVOTDATA, Timeline, and PivotTable and PivotChart WizardJan 27, 2023Jan 27, 2023
Anggi Firdian SaputraGet to Know About Pivot Table Pt.4Grouping, Calculated Field/Items, and Value Field SettingJan 26, 2023Jan 26, 2023
Anggi Firdian SaputraGet to Know About Pivot Table Pt.3Slicer, Layout, and Update PivotTableJan 26, 2023Jan 26, 2023
Anggi Firdian SaputraGet to Know About Pivot Table Pt.2Sorting, Filtering, and creating PivotChartsJan 25, 2023Jan 25, 2023
Anggi Firdian SaputraGet to Know About Pivot Table Pt.1Introduce PivotTable, Layout, Format, Collapse, and Expand FieldJan 25, 2023Jan 25, 2023
Anggi Firdian SaputraSUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS FunctionsThe SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS formulas are used the same as the COUNTIF and COUNTIFS formulas.Jan 21, 2023Jan 21, 2023
Anggi Firdian SaputraCOUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK FunctionsSometimes 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, 2023Jan 21, 2023
Anggi Firdian SaputraIF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functionsWhile 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, 2023Jan 21, 2023
Anggi Firdian SaputraLookup FunctionsWhile 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, 2023Jan 18, 2023