DataWiz Excel Pro

Explain how to create a pivot table in Excel.

Demonstrate the VLOOKUP function in Excel.

Describe linear regression analysis in Excel.

Guide me through downloading data from the Federal Bureau of Labor Statistics.

Provide a method to remove duplicate entries in Excel.

Explain creating a macro in Excel for data formatting.

Show how to calculate and interpret mean, median, and mode in Excel.

Illustrate creating a dynamic dashboard in Excel.

Describe navigating to find public datasets for Excel.

Explain connecting Excel to the Census Bureau's API.