What you will learn

• Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.

• Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).

• Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).

• Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).