Learn Advanced Excel Functions

Advanced Excel Functions Tutorial

This Microsoft Excel tutorial teaches you how to create and use Excel functions. You can use Excel functions to perform various mathematical, statistical, logical calculations. This tutorial takes you step-by-step through the process.

Comments

Post a Comment

Preeti to Unicode Converter

Popular posts from this blog

Nepali Unicode with Keyboard Layout (Traditional and Romanized)

Nepali Unicode with Keyboard Layout (Traditional) is suitable for the persons who are already using true type fonts like preeti, kantipur etc. There is only slight modification upon true type fonts with Unicode flavour. These letters can accessible to everywhere even any client computer doesn't avail Nepali fonts. Similarly, Nepali Unicode with Keyboard Layout (Romanized) is suitable for new Nepali Unicode users which works as typing in English - based on pronunciation. Download Nepali Unicode with Keyboard Layout (Traditional and Romanized) from below: Nepali Unicode with Keyboard Layout (Traditional)
Read more

Download Filmora Video Editor 6.0.3 for Easy Video Edit

Image
Filmora is an all-in-one home video editor that has powerful functionality and a fully stacked feature set. Filmora is a solid app that gives you the features and styles that have been previously only available to professional film makers that have a certain level of experience and the expensive applications to match. Filmora has a simple drag and drop interface, which gives you the freedom to be artistic with the story that you want to create. Key features: Text and titles: support for animated text. Music library: support for adding your music tracks. Overlays and filters: specifically designed filters and overlays to give your a professional finish. Elements: Still and motion graphic support. Unique visual effects: you can incorporate over 100 visual effects. Speed control: Slow motion and time lapse support. Overall, Filmora is a great app that has powerful features coupled with an easy to operate user interface. The design is fresh, modern and is a joy to us
Read more

Learn Customer Information Control System (CICS)

Customer Information Control System (CICS) Tutorial CICS stands for Customer Information Control System. CICS was developed in 1968 by IBM. CICS allows users to develop and execute online application in an MVS environment. CICS has become the most commonly used server for Internet applications. CICS is a transaction processing system which is also called as Online Transaction Processing (OLTP) Software. CICS is a data communication system that can support a network containing hundreds of terminals.
Read more

Types of Firewall

1. Packet filter: Packet filtering inspects each packet passing through the network and accepts or rejects it based on user-defined rules. 2. Circuit-level firewall:  Applies security mechanisms when a TCP or UDP connection is established. Once the connection has been made, packets can flow between the hosts without further checking. 3. Application gateway:  Applies security mechanisms to specific applications, such as FTP and Telnet servers. 4. Proxy server:  Intercepts all messages entering and leaving the network acting as an intermediary between clients and servers. The proxy server hides the true network addresses
Read more

Windows Movie Maker 2016 Free Download

Image
With Windows Movie Maker, you can quickly turn your photos and videos into polished movies. Add special effects, transitions, sound, and captions to help tell your story. Share the movie with friends and family.  Windows Movie Maker 2016 is a easy-to-use & powerful video creating/editing software application, designed for latest Windows7, Windows 8, Windows 10. The old version works for Windows Xp and Vista. Windows Movie Maker contains features such as effects, transitions, titles/credits, audio track, timeline narration, and Auto Movie. New effects and transitions can be made and existing ones can be modified using XML code. Windows Movie Maker is also a basic audio track editing program. Windows Movie Maker can apply basic effects to audio tracks such as fade in or fade out. The audio tracks can then be exported in the form of a sound file instead of a video file. Video: How to download and install Windows Movie Maker 2016 Windows-Movie-Maker.org is a
Read more

Learn Cloud Computing

Image
Cloud Computing refers to  manipulating, configuring,  and  accessing  the hardware and software resources remotely. It offers online data storage, infrastructure, and application. Cloud computing offers  platform independence,  as the software is not required to be installed locally on the PC. Hence, the Cloud Computing is making our business applications  mobile  and  collaborative.
Read more

CAT 7 (Category 7) Networking cable

Category 7 (Cat-7) network cabling is used as a cabling infrastructure for 1000BASE-T (Gigabit Ethernet, or GbE) and 10GBASE-T (10-Gigabit Ethernet, or 10 GbE) networks.  The Cat 7 standard provides performance of up to 600 MHz  (1000 MHz for the Cat-7a, or Augmented Category 7 standard) and can be used up to a maximum length of 100 meters. Category 7 cable is able to achieve higher performance than preceding Ethernet standards such as Cat 5, Cat 5e and Cat 6 by requiring each of its twisted wire pairs to be fully shielded.  This is known as Screen Shielded Twisted Pair (SSTP) or Screened Foiled Twisted Pair (SFTP) wiring, and it almost completely eliminates alien cross-talk while significantly improving noise resistance. It is published in 2002 by the International Organization for Standardization (ISO) and is also known as Class F cabling.  While more expensive than Cat 5e and Cat 6 cabling, Cat-7 cabling does have a 15-year life-cycle (compared to estimated 10-year life-c
Read more

How to set up ADSL for NTC?

Image
Here, we provide NTC ADSL Setting for Digicom routers. The settings for other routers are also quite similar. In the router, make sure that the ADSL/Link Light is continuous. If it is blinking, then connect main line to the digicom splitter, then connect modem to router, and finally connect phone to phone line. It must be constant. Now, follow these steps: Open a browser and type 192.168.1.1 in the address bar. Put admin in both username and password. Setup page will open. Click on Network, and then click on WAN. Default Route Selection: Auto Click on Select Current ATM VC Table. VPI: 8 VCI: 81 Encapsulation: LLC Channel Mode: PPPoE Enable NAPT (on) Enable IGMP (on) Type in the username and password provided by NTC. (adslxxxxxxx for both, where xxxxxxx is your phone number) Type: Continuous Click on Modify Click on Save Button on the bottom of the page. If it is not visible, press F11 to go to fullscreen mode. Done. That’s it. Happy Surfing! 
Read more

Havij 1.15 Advanced SQL Injection Tool

Image
Havij is an automated SQL Injection tool that helps penetration testers to find and exploit SQL Injection vulnerabilities on a web page. It can take advantage of a vulnerable web application. By using this software user can perform back-end database fingerprint, retrieve DBMS users and password hashes, dump tables and columns, fetching data from the database, running SQL statements and even accessing the underlying file system and executing commands on the operating system. The power of Havij that makes it different from similar tools is its injection methods. The success rate is more than 95% at injecting vulnerable targets using Havij. The user friendly GUI (Graphical User Interface) of Havij and automated settings and detections makes it easy to use for everyone even amateur users. Download Free Havij 1.15 Advanced SQL Injection Tool New Features      HTTPS support     Add MSSQL Blind     MSAccess more Blind (commercial version only)     PostgreSQL ad
Read more

The use of EEG in recording the brain waves

Image
Electroencephalograph (EEG) is a tool used for gauging and recording brain waves. In 1929, Hans Berger, the German psychiatrist, published the results of his experiments using the electroecenphalograph in recording human brain waves. Four major brain waves exist: alpha has a frequency that ranges from 8 to 14 cycles per second (cps) and is found in the occipital part of the brain. Beta covers 14 to 30 cps. Delta wave includes frequencies that are below 5 cps. Theta wave covers the range between 5 and 8 cps. Alpha waves are more active during relaxation and light sleep. Nonetheless, their function is altered by deep mental activities. Beta waves, on the other hand, appear during mental concentration periods. In 1935, the findings of collaborators Frederic Gibbs, William Lennox, and Hallowelle Davis from Harvard on the use of EEG in epilepsy was published. Since EEG poses no pain or side effects, it is broadly included as a medium for identifying brain irregularities. The EEG is
Read more