Data Analysis With Microsoft Excel (Intermediate level)

1. Use the IF and VLOOKUP/HLOOKUP functions 2. Manipulate information 3. Apply sorting 4. Filter data 5. Use Sparklines to show data trend 6. Apply charting elements

1. Module 1 – Working with Conditional Logic 2. Module 2 – Working with Lookup Tables 3. Module 3 – Manipulating Information 4. Module 4 – Managing List 5. Module 5 – Working with Database 6. Module 6 – Using Sparklines to Show Data Trends 7. Module 7– Working with Charts