Microsoft Excel (Data Analysis and Reporting)

You will automate some common Excel tasks, vLookups, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

After completing this course, students will be able to:

• Use the IF and IFERROR functions to calculate a value based on specified criteria; use conditional functions to summarize data; use PMT function to calculate periodic payments for a loan; use text functions to extract data strings; use date functions to calculate duration in years, months, and days; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits. 
• Use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values. 
• Use the Data Validation feature to validate data entered in cells; and use advanced filter options to display the data you specify. 
• Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects and shapes.