Enter and edit Excel data. Format numbers, fonts and alignment. Make simple pivot tables and charts Create simple Excel formulas. Use Excel Functions IF and VLOOKUP Filter and sort lists of data. Find the "Top 10" values. Use Excel table functions to de-duplicate data and make totals. Understand how Excel is used in a business context to analyze data. Create a simple sales analysis report.