Course Description
Short Course | 6 hours | 0.6 CEUs | $345
Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. Students will benefit most from this course if they want to use Excel to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.
Course Outline
- Chapter 1: Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
- Chapter 2: Advanced Formulas
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
- Chapter 3: Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
- Chapter 4: Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
- Chapter 5: Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
- Chapter 6: Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
- Appendix A: Internationalization and Accessibility
- Preparing workbooks for internationalization and accessibility
Prerequisites
Duration
6 Hours | 1 Day or 2 Nights
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.