Modules
1.1 Data Analysis Categories
1.2 4-Steps of Data Analysis and Management
1.3 Data Management Tools
1.4 Step 1: Importing Data into Excel
1.5 Practice Exercise #1 – Import an Access Database table into Excel
1.6 Practice Exercise #2 – Import a Comma Separated Value (CSV) text file into Excel
1.7 About External Data Connections
Module 2
2.1 Excel Standards for Organizing and Cleaning Your Data
2.2 Organize and Clean Data Using Data Tools Section on the Ribbon; Practice Exercise 3 Organize and Clean Data in the EMPLOYEES Table
2.3 Practice Exercise 4 – Organize and Clean Data in the CUSTOMERS Table
Module 3
3.1 Sorting
Module 4
4.1 Functions and the Formulas Tab in Excel 2016
4.2 Insert Function Tool
4.3 The AND Function; Practice Exercise 5 Concerning the AND function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.
4.4 The OR Function; Practice Exercise 6: Concerning the OR function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.
4.5 The IF Function; Practice Exercise 7: Concerning the IF function, we will use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument; Practice Exercise 8: Create an IF formula using the IF function in a table
4.6 Nested IF Function; Practice Exercise 9: Create an IF formula using nested IF functions to create additional conditions
4.7 VLOOKUP and HLOOKUP Functions; Practice Exercise 10: Use a VLOOKUP table for applying approximate matching data
4.8 Using VLOOKUP Function for Finding an Exact Match; Practice Exercise 11: Use a VLOOKUP table for applying exact matching data