Course Overview
The Azure Administration for AWS SysOps course at Counseltrain Technologies is designed as a specialized training program for AWS SysOps administrators who want to learn how to manage Azure resources. The course is usually delivered through a combination of classroom lectures, hands-on lab exercises, and practical assignments. The duration of the course is 2 days and by completing this training program, AWS SysOps administrators can expand their skills and knowledge, and gain the expertise needed to manage hybrid cloud environments that include both AWS and Azure resources.
Learning Options
Target audiences
- This course is intended for both novice and experienced information worker who have the understanding and knowledge of basic Excel formulas and functions. A minimum one year experience with Excel is recommended before attending.
Schedule Dates
Curriculum
-
Module 2: The LOOKUP Functions Basics
In the course of this module, all lookup functions will be introduced step by step. With the knowledge of the syntax, we will examine examples of use and then test our knowledge in Lab 1
- LOOKUOP function
- VLOOKUP function
- HLOOKUP function
- Lab : LOOKUP function
- • Practice 1: the use of LOOKUP function and both its syntaxes.
- • Practice 2: practice with many tricks of use and providing a deeper understanding LOOKUP function.
- Lab : VLOOKUP function
- • Practice 3: the use of VLOOKUP functions final argument.
- • Practice 4: Tricks of using TRUE as the final argument and IFERROR function to prevent the #N/A error.
- Lab : HLOOKUP function
- • Practice 5: the use of HLOOKUP function and comparison to the VLOOKUP function.
- • Practice 6: The use of IF and LEN functions to avoid a “zero” value when the cell we lookup is empty.
- After completing this module, students will be able to:
- • Recognize a LOOKUP function syntax.
- • Recognize situations when we use the LOOKUP function.
- • List how does LOOKUP differ from other lookup functions.
- • Recognize a VLOOKUP function syntax.
- • Recognize what kinds of examples are solved using VLOOKUP function.
- • List all differences from other lookup functions.
- • Recognize a HLOOKUP function syntax.
- • Tell when to use HLOOKUP.
-
Module 3: Advanced LOOKUP examples with function nesting
This module will be instructor led example by example upgrading of lookup functions with other functions and data validation. Each function will be followed by practices. Also array functions and their use will be mentioned.
- MATCH function
- How can we use MATCH with VLOOKU
- INDEX function
- Combining MATCH and INDEX functions
- INDIRECT function
- CHOOSE function
- CELL function
- OFFSET function
- ROW and COLUMN functions
- After completing this module, students will be able to:
- • Enhance lookup formulas with many new functions and tools.
- • Recognize the need for MATCH function.
- • Face any situation where lookup functions are required at their daily faceoff with Excel.
-
Module 1: Introducing LOOKUP functions
In this module students are shown a variety of lookup function and examples where lookup functions are needed. The basic knowledge given here is then extended throughout the course. The whole spectrum of functions that are explained in detail in future Modules are introduced here.
- Example by using the IF function
- Which LOOKUP functions are at our disposal
- Other functions we will use during this course
- What knowledge should we possess before moving on
- After completing this module, students will be able to:
- • What are we trying to accomplish.
- • Why should we use LOOKUP functions.
- • What LOOKUP functions are at my disposal.
- • Which reference functions should I know.
- • Which Array functions should I know.
- • Recognize the situations where lookup functions are used.