will work on the complex formulas in Excel with use of variety of functions and order of operations • Order of operations • VLOOKUP • SUMIF • SUM • XLOOKUP

• Creating a table • Creating a chart • Line graph • Pie chart • Area chart • Doughnut chart • Histogram

Data cleaning: Will remove or fix errors in data and ensure it's consistent. • Remove duplicate data • Remove irrelevant data • Address outliers • Data validation Data formatting: Will make data more readable and consistent • Clear formatting • Conditional formatting

Pivot tables are a powerful tool for summarizing, analyzing, and presenting data. They can automatically aggregate data and calculate sums, and can configure them to show percentages • Check your data • Select the correct data range • Add a field • Filter

A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. • Get your data • Create PivotTables • Create Pivot Charts • Formatting Chart • Add Slicers and a Timeline

Data mining analysis is the process of using statistical analysis and machine learning to discover patterns, correlations, and anomalies in large dataset. • Anomaly detection • Association rule learning • Clustering • Outlier analysis • Text mining

Automation and macros in Visual Basic for Applications (VBA) can help you streamline your workflow and save time by automating repetitive tasks. • Record a macro • Create a user interface macro • Create a data macro • Automate report generation • Consolidate reports • Clean and transform data • Automate email • Automate document generation