Excel Essentials - Level 3

About this Course:

Continue expanding your Excel skills with more advanced settings and skills in this high powered class.

Modules include: Advanced Options and Techniques Worksheet Grouping Dates and Times Linking within Excel Linking to PowerPoint and Word Data Validation - Drop Down Lists - IF Function with Dates IF Function with Nested Functions VLOOKUP Function Protection in Excel Pivot Tables Introduction What If Modelling - Scenarios and Goal Seek Macros Introduction.

This class is packed with skills and techniques that will massively expand your capabilities with the program.

Basic knowledge:

• Students are only required to have a basic understanding of how rows and columns are referenced in Excel .

Course Completion Certificate

What you will learn:

• Advanced Options and Techniques
• Worksheet Grouping
• Dates and Times
• Linking within Excel
• Linking to PowerPoint and Word
• Data Validation (Drop Down Lists)
• IF Function with Dates
• IF Function with Nested Functions
• VLOOKUP Function
• Protection in Excel
• Pivot Tables Introduction
• What If Modelling - Scenarios and Goal Seek
• Macros Introduction

Curriculum:

• Excel Essentials Level 3

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.