Be sure that you have an application to open this file type before downloading and/or purchasing. How to unzip files.
This lesson uses vLookup and hLookup Tables to find the right answers.
UPDATED: If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need:
This course includes:
• Step-by-step video demonstrations (MP4)
• Companion eBook with detailed instructions (PDF)
• Sample spreadsheets and files
• Practice, Quizzes and Skill Test
With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market.
Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert will find Microsoft Excel spreadsheets that demonstrate the MOS topics taught in the Intermediate Guide to Excel 2013.