Data Analysis With Microsoft Excel (Intermediate level)

text.programmeOutcomes

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

text.trainingCovered

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

text.programmeMode

enum.programMode.virtualELearning

text.duration

1 day

text.hrdcClaimable

text.notSpecified

trainingProgram.programLevel

enum.trainingProgram.intermediate

text.trainingProgramProvidedBy Penang Skills Development Centre (PSDC)

button.viewMore