February 2018
Excel VBA
Sub HelloWorld() MsgBox “Hello VBA World!” Range(“A1”).Value = “Message shown” End Sub Expanding selection– //The following code will move the selection A1:C3 to 1 column and 1 row. Range(“A1:C3”).Offset(1, 1).Select //Resize will keep the active cell and expand the selection as defined. Range(“A1”).Resize(2, 2).Select This code will navigate to another cell based on currently active […]
IAM (Identity Access Management) Section 3
IAM-Identity Access Management. IAM It allows to manage users and their level of access to the AWS console. It is important to understand IAM and how it works, both for the exam and for administrating a company’s AWS account in real life. It gives us: Centralized control of AWS account. Shared access to AWS […]
AWS Terms Section 2
SECTION 2 Lec-4 (10k foot overview part-1) AWS GLOBAL INFRASTRUCTURE AWS Global Infrastructure: This is basically the data centers all spread throughout the world. AWS Region: Is a geographical area Each region consists of 2 or more availability zones. Availability Zone: Is simply a Data Center. They are in a region but far enough […]
S3: AWS simple storage service Section 4
Lecture-14 ( Object Storage and CDN-S3, Glacier and CloudFront ) S3-101: S3 provides secure, highly-scalable object storage. Spread through multiple devices and facilities. Designed to sustain the loss of 2 facilities concurrently. Files size limit is upto 5 TB. Object based storage (images, video etc are each considered as a one Object). But for installing OS […]