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

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

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 ...
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 estim...
Read more

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

List of Ministry's websites of Government of Nepal

Office of the Prime Minister and Council of Ministers Ministry of Defence Ministry of Foreign Affairs Ministry of Culture, Tourism & Civil Aviation Ministry of Home Affairs Ministry of Information and Communications Ministry of Finance Ministry of Law, Justice, Constituent Assembly and Parliamentary Affairs Ministry of Irrigation Ministry of Energy Ministry of Peace & Reconstruction Ministry of Federal Affairs and Local Development Ministry of Health & Population Ministry of Labour & Employment Ministry of General Administration Ministry of Land Reform & Management Ministry of Education Ministry of Forest & Soil Conservation Ministry of Industry Ministry of Agriculture Development Ministry of Physical Planning, Works and Transport Management Ministry of Urban Development Ministry of Co-operatives and Poverty Alleviation Ministry of Youth & Sports Ministry of Envir...
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

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

How to change the SQL Server Authentication Mode in SQL Server 2008?

Image
In Server Properties, click Security under Select a Page on the left side panel. Then you will be able to see the currently used SQL Server Authentication Mode. Now you can change Server authentication mode . If you would like to change the SQL Server authentication mode, then select the authentication mode under Server authentication and click OK to change the authentication mode and restart SQL Server Database Engine services to reflect the changes.  You can also generate the TSQL script to change the authentication mode by selecting any of the options under Script drop down as highlighted in the snippet below in Server Properties window. 
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