Do you ever receive a dataset with a bunch of blank cells so you can't do any analysis on it? Here's a tutorial on how to fill in those blank cells with the values above it so you can create pivot tables, formulas, and whatever other analysis you want to conduct on that dataset! Data Cleaning is often the longest part of creating dashboards and presentations #corporatelife #dataanalytics #spreadsheet #exceltips #officelife #financetips #businessgrowth #worksmarternotharder

Calculate Age Automatically in excel #excel

COUNTIF in Excel #excel #exceltips #exceltips #excelformula