Kirim Whatsapp dari excel

Kirim pesan whatsapp dari excel dengan menggunakan scripts VBA sangat berguna ketika kita ingin mengirimkan laporan atau apapun yang diminta oleh rekan kerja atau atasan kita. nah karena kita saat ini harus dan mau tidak mau menggunakan dan memanfatkan teknologi apalagi saat ini karyawan ataupun perusahaan dipaksa berubah dari yang manual menuju dan harus otomasi memanfaatkna teknologi 4.0. ok cukup orasinya. saatnya kita mulai tutorialnya. tutoral ini sangat sederhana dengan beberapa baris kode saja untuk itu jika kalian perlu mengembangkannya menjadi lebih edvance silakan. :) first of all kita buat sebuah tabel yang terdapat kolom header dan isi buat saja seperti gambar dan satu buah tombol button command yang di ambil dari menu developer lalu command button. untuk lebih jelasnya lihat gambar

sekarang klik pilih menu design mode lihat gambar

Kemudian klik dua kali button command dan tuliskan code berikut. Private Sub CmdKirim_Click() Dim NoWA As String Dim Pesan As String NoWA = Range("D4").Value Pesan = vbNewLine & "*WARUNG ARLEEO*" & Range("E4").Value ActiveWorkbook.FollowHyperlink Address:="https://api.whatsapp.com/send?phone=" + NoWA + "&text=" & Pesan End Sub untuk lebih jelas lihat gambar

sekarang disable mode design dengan cara klik design mode jika sudah sekarang coba untuk kirim pesan dengan mengklik tombol kirim selesai dan jika kurang jelas silakan kunjungi youtube saya di link youtube atau www.youtube.com/c/leomjb semoga bermanfaat

Berkenalan dengan Mikrotik

 

Mikrotik adalah perusahaan yang bergerak dalam bidang jaringan komputer yang dibentuk oleh John Trully dan Arnis Riekstins yang berkantor pusat di latvia. pada tahun 1996 John dan Arnis memulai pengembangan dengan menggunakan system Linux dan microsoft DOS yang dikombinasikan dengan teknologi wireless LAN (W-LAN).

Berkenalan dengan CISCO ASA Firewall

 CISCO ASA Firewall adalah salah satu perangkat jaringan yang berfungsi untuk melindungi jaringan dari serangan - serangan hacker yang mencoba untuk mengakses sumberdaya jaringan internal baik dari luar maupun dari dalam biasanya firewall dipasang diantara perangkat jaringan yang terhubung ke penyedia layananan internet atau yang disebut dengan Internet services provider (ISPs). kenapa di pasang disana karena public internet atau yang disebut dengan internet sering digunakan oleh para penjahat maya untuk menyerang jaringan internal suatu organisasi atau perusahaan. dengan adanya firewall ini kemungkinan serang akan sangat sulit dilakukan namun demikian tidak ada yang dapat menjaga serangan dengan seratus persen aman :).

ASA firewall keluaran big vendor cisco ini sangat sering di jumpai di perusahaan - perusahaan besar yang menggunakanya. ASA firewall menggunakan  statefull yang mana dia akan melihat session state dari sumber yang sama dengan kata lain melihat source address, destination address, protocol, source port dan destination port yang telah terbentuk sebelumnya atau yang telah di allow sehingga tidak memerlukan access list return connection.

Initial konfigurasi router cisco lab dengan Packet Tracer

 Lab ini adalah latihan praktek initial setup dan konfigurasi router cisco dengan menggunakan simulasi  packet tracer yang saya ambil dari free lab friday milik david bombal. saya mencoba untuk menyelesaikanya sendiri meskipun juga telah tersedia jawaban dari latihan lab ini yang di sertakan oleh david bombal. baiklah mari kita selesaikan lab ini.

Scenario dan topology

Sebagai bagian dari proyek Cybernetics LAN yang anda kerjakan, sekarang anda di undang untuk ke site untuk meneruskan pekerjaan pengimplementasian Sirius LAN Router setup. Rachel, sang Senior Network engineer kagum dengan pengaturan awal dan detail langkah - langkah verifikasi switch yang telah anda lakukan. dia meminta anda untuk meneruskan pekerjaan untuk Sirius Cybernetics. Rachel memberitahukan bahwa Branch Router memilik configurasi sebelumnya dan telah di hapus dari router. pada saat yang bersamaan siap bagi anda untuk melakukan setup pada router baru sirius's dan melakukan pengujian konektifitas dengan perangkat internal mereka. koneksi ke HQ Router akan di lakukan nanti.

Network Automation dengan python 3 pada GNS3

 Network Automation dengan python 3 pada GNS3 ini adalah tutorial bagaimana menkonfigurasi router cisco menggunakan script python 3. mengapa menggunakan python sederhana saja bahasa pemrograman berbasis scripting ini adalah yang paling mudah digunakan menurut saya :) disamping itu banyak sekali tutorial membahas network automation dengan menggunakan bahasa pemrograman ini jadi tidak begitu kesulitan ketika kita mencari referensi tentang network automation dengan python.

Well, let your hand dirty.

Topology sederhana ini, dimana terdapat satu buah pc network automation, satu buah switch, satu buah nat cloud, dan satu buah router cisco seperti tampak pada gambar. pc network automation telah diinstall dengan Python3 dengan sistem operasi linux ubuntu yang digunakan untuk menuliskan scriptingya. nat cloud digunakan dan difungsikan sebagai dhcp server. router adalah adalah perangkat jaringan yang akan di automasikan. look at the topology.

VPN IPSec dengan Cisco Packet Tracer

 Lab ini adalah mengkonfigurasi VPN IPsec site to site dengan menggunakan simulator Cisco Packet tracer. VPN IPsec adalah jaringan private virtual dengan menggunakan encryption untuk membentuk keamanan packet.  Seperti  pada gambar topology yang memilik dua buah router yaitu router cabang BOR1 dan router Head quarter HQR1.

Untuk confignya silakan ikut dengan benar.

Apakah AWS Amazon QWIKLAbs

 Kemaren tanggal 30 Mei 2019 saya mengikuti AWSome day online conference Asia Pacific by Amazon yang diselenggarakan gratis dapat diikuti oleh siapapun para profesional IT yang ingin mendalami cloud computing terutama amazone web service sang raksasa penyedia layanan technology cloud yang merupakan pimpinan utama di dunia percloudan memberikan materi yang sangat baik dan memuaskan bagi saya pribadi. itu adalah pendapat pribadi saya :) .

Materi yang dibawakan sangat menarik dan yang paling menarik bagi saya adalah tentang QWIKLABS seperti title dari article ini apakah QWIKLABS ? mungkan anda telah mencobanya tetapi bagi saya ini adalah hal baru karena baru tahu kemarin.

QWIKLABS adalah tidak lain dan tidak bukan adalah online training dengan menggunakan mode sandbox artinya anda tidak perlu membuat mengakses real aws jika ingin berlatih dan menjadi expert atau ahlinya ahli dalam bidang cloud terutama aws. QWIKLABS online training menyediakan materi - materi yang dapat anda ikuti baik secara teoris maupun dengan latihan praktik langsung. sepanjang saya mencoba mengikuti course ini (kebetulan saya mendapat freee access :) ) banyak saya temukan prkatik langsung dengan mengikuti perintah atau tutorial yang telah disediakan.

inilah yang menurut saya yang sangat menarik dan memberikan pengalaman bagi kita untuk berlatih dan menguasai layanan cloud. jikada anda tertarik belajar aws silakan langsung kesini

 

Tampilan halaman QWIKLABS

4 Things You Should Know About Cisco CCNA Security 210-260 Certification

 Cisco Certified Network Associate(Cisco CCNA) Security 210-260 certification is an associate-level credential that validates knowledge and abilities required to safeguard networks. A network proficient, after achieving CCNA certification exhibits the abilities required to build up a security infrastructure and identify & alleviate vulnerabilities to networks & systems. The CCNA Security curriculum emphasizes core security innovations, the installation, troubleshooting, and monitoring of network devices to manage integrity, privacy, and accessibility of information, data, and devices that Cisco utilizes in its security structure.

The four things that you should know about the Cisco CCNA Security 210-260 certification are mentioned below:

1. Highly demanded IT security skills: With regards to the job postings for network administrators, security is the main ability a business searches for. This implies organizations are looking for network experts who have skills in network security.
2. Provides opportunities for career growth: A Cisco CCNA Security credential will provide new opportunities for network practitioners and support engineers, and help them gain a dependable balance in this exceedingly competitive industry.
3. Provides great remuneration: Being a standout among other non-certified experts implies to a better remuneration and improved marketability of skills. Cisco CCNA Security 210-260 certification validates that you possess a certain level of expertise in securing enterprise networks, and hence employers offer high paychecks to the skilled professionals. 
4. Expands your insight & abilities: Good comprehension of a subject ingrains certainty and lifts the spirit. The abilities offered by the Cisco CCNA Security credential expands your present learning & knowledge and help you remain updated and grow further in this profession.

uCertify offers the CCNA Security 210-260 cert guide for the preparation of the Cisco CCNA Security 210-260 certification exam. All these benefits of CCNA Security certification training will open up a plethora of options for learning and development. Enroll now in CCNA Security 210-260 certification exam training and gain the knowledge required to secure Cisco networks; develop a security infrastructure; recognize threats and vulnerabilities to networks, and mitigate security threats.

4 Things You Should Know About Cisco CCNA Security 210-260 Certification

 Cisco Certified Network Associate(Cisco CCNA) Security 210-260 certification is an associate-level credential that validates knowledge and abilities required to safeguard networks. A network proficient, after achieving CCNA certification exhibits the abilities required to build up a security infrastructure and identify & alleviate vulnerabilities to networks & systems. The CCNA Security curriculum emphasizes core security innovations, the installation, troubleshooting, and monitoring of network devices to manage integrity, privacy, and accessibility of information, data, and devices that Cisco utilizes in its security structure.

The four things that you should know about the Cisco CCNA Security 210-260 certification are mentioned below:

1. Highly demanded IT security skills: With regards to the job postings for network administrators, security is the main ability a business searches for. This implies organizations are looking for network experts who have skills in network security.
2. Provides opportunities for career growth: A Cisco CCNA Security credential will provide new opportunities for network practitioners and support engineers, and help them gain a dependable balance in this exceedingly competitive industry.
3. Provides great remuneration: Being a standout among other non-certified experts implies to a better remuneration and improved marketability of skills. Cisco CCNA Security 210-260 certification validates that you possess a certain level of expertise in securing enterprise networks, and hence employers offer high paychecks to the skilled professionals. 
4. Expands your insight & abilities: Good comprehension of a subject ingrains certainty and lifts the spirit. The abilities offered by the Cisco CCNA Security credential expands your present learning & knowledge and help you remain updated and grow further in this profession.

uCertify offers the CCNA Security 210-260 cert guide for the preparation of the Cisco CCNA Security 210-260 certification exam. All these benefits of CCNA Security certification training will open up a plethora of options for learning and development. Enroll now in CCNA Security 210-260 certification exam training and gain the knowledge required to secure Cisco networks; develop a security infrastructure; recognize threats and vulnerabilities to networks, and mitigate security threats.

Learn Python with ucertify.com

 

Learn programming language like python is very interested and i have tried it at ucertify.com self face online training. i have found all the topics is from scratch its very good for beginner as me. everything you need explained with clear like data type, basic syntax, python operations and expressions, looping, list tuples, sets, dictionaries, sequences, looping techniques, function, modules, standard Modules, dir() function, packages, input from user, output formatting, reading and writing files, directories in Python, error handling and exceptions, and also explained about object oriented programming in python.

Python is popular programming language now this is because of the syntax that is easy to understand and it freeware you can download it and install on your linux machine, macos and windows machine then code it in your favorites machine.

if you interested and want to learn python too i really do recommended this course. follow this Link this course a lot of basics and fundamentals of python scripts to hardening your basic understanding.

Happy Learning..

6 Skills You Can Learn With The PMI PMP Certification

 PMI Project Management Professional (PMP) certification is a globally acknowledged industry-recognized certification targeted at professionals looking to start a career in the field of Project Management. Being a globally acknowledged and highly demanded credential, PMP is considered essential for the project managers. It becomes even more important for those who wish to take the next step in their career. A recent survey states that certified PMP project managers handle more than three fourth of the high performing projects. Also, companies having more than one-third of PMP certified managers have a much better success rate than companies that do not. You can advance your career prospects adding this certification to your resume as PMP is the fifth highest-paying certification in the year 2016. On average, a PMP certified professional earns 20% more than the non-certified peer.

The information given above is enough to make you think about getting this certification. The next question must be about the PMP exam and the secret theory of successfully passing the exam. Before we explore this question in this article, let us first introduce you to the domains of the PMP exam. Basically, the PMP exam focuses on the five project constraints that are:

1. Initiating the project
2. Planning the project
3. Executing the project
4. Monitoring and controlling the project
5. Closing the project

Oracle Java Certifications For You

 The Java programming language is among the most widely used software development platforms in the IT industry nowadays. It is extensively being used and appreciated by individuals as well as organizations to transform their innovative ideas into working software solutions.

The Java programming language is among the most widely used software development platforms in the IT industry nowadays. It is extensively being used and appreciated by individuals as well as organizations to transform their innovative ideas into working software solutions.

Oracle Corporation is constantly working in the area of Java platform development. They provide Java certifications as well. Each of these java certifications verifies a certain level of expertise and knowledge of the Java platform belonging to specific domains.

Five common programming errors to avoid in JavaScript

Five common programming errors to avoid in JavaScript  After the World Wide Web (WWW) advanced, innovations & technologies in computing have always been in the spotlight which work with, or on, the World Wide Web. This includes W3C technologies as HTML, CSS, and XML (that work on the web) but also programming languages as Java, Python, Ruby, and so on. Java is a technology from Oracle that is used in different fields of computing. It can be used for web development, on both the client and server-side. JavaScript, first included in Netscape 2, in 1995! is a language that is largely used in the World Wide Web to add client-side interactivity to web pages. JavaScript is ordinarily utilized as a client-side scripting language. This implies JavaScript code is composed of an HTML page. At the point when a client demands an HTML page with JavaScript in it, the content is sent to the browser and it's upon the browser to accomplish something with it. Before we proceed further in this article let's go through with JavaScript features:

• It helps you create anonymous functions.
• It can automatically change the date format.
• It helps you to change any object at any time.
• It causes a linked-to page to appear in the popup window.
• It is dynamic, interpreted, and client-side scripting language.
• It is a class-free, object-oriented language with prototypal inheritance.

JavaScript programs are composed by the fusion of new functions that the developer composes with "prepackaged" functions and objects accessible in JavaScript. JavaScript is not a programming language in a strict sense. Rather, it is a scripting language since it utilizes the browser to do the messy work. In case you command a picture to be substituted by another, JavaScript prompts the browser to follow it. Since the browser really takes the necessary steps, you just need to pull a few strings by thinking of some moderately simple lines of code. That is the thing that makes JavaScript a simple language, to begin with. Yet, don't be tricked by some beginner's karma: JavaScript can be pretty annoying, as well. Above all else, regardless of its basic appearance, it is a full-fledged programming language: it is conceivable to compose very complicated programs in JavaScript. This implies there are some complicated programming structures that you'll comprehend after protracted learning. Secondly, and all the more important, there is browser diversity. In spite of the fact that all cutting-edge internet browsers help JavaScript, there is no such law that says they should support precisely the same JavaScript. So fundamentally JavaScript is anything but not that difficult to learn & adapt, however when you begin composing propelled contents browser differences, you will crawl up. JavaScript provides a few objects that have a rich accumulation of techniques for performing normal scientific & mathematical computations, string controls, date and time controls, and manipulation of accumulation of data called arrays. Whenever possible, use existing JavaScript objects, methods, and functions instead of writing new ones. This reduces the script-development time and helps avoid introducing errors.