Excel Level 3: Analyzing Data

November 2 & 3 – 2PM to 5PM

Instructor: Mike Rhodes, MediaTek

Format: Virtual

CPE Credits: 6

Field of Study: Computer Software & Applications

Note this course is a one day course split into two half days.

Spot patterns and trends in your data and gain an insight into Excel's powerful business intelligence features. Also covers Excel's security features. Advanced level course.

Prerequisites: Excel 2 or intermediate level skills.

Topics Covered:

• Restrict cell entries to specific numbers, dates or times
• Restrict cell entries to specific entries in a list
• Create a custom number format
• Define a range name
• Use a range name in a formula
• Lookups with INDEX and MATCH functions
• Use the DSUM and DAVERAGE functions
• Trace precedents in a worksheet
• Trace dependents in a worksheet
• Trace errors in a worksheet
• Watch and evaluate formulas in a worksheet
• Consolidate data from multiple workbooks
• Create a workspace
• Add subtotals to worksheet data
• Group and outline data
• Create a PivotTable report
• Reset the summary function in a PivotTable report
• Create a PivotChart report and Dashboard
• Perform data analysis using scenarios
• Import data into Excel
• Export Excel data to other applications
• Use the Data Consolidation feature
• Protecting Excel files, workbooks and worksheets

REGISTER HERE