'How to' feed from TechFunda.com (C) TechFunda.com2026. All rights reserved. http://techfunda.com webmaster@techfunda.com en-us http://techfunda.com/howto/1263/how-to-deploy-microsoft-office-web-apps-2013 Sharepoint In this section we are going to learn about deployment of Microsoft Office Web Apps 2013 and steps to integrate with SharePoint 2013. Prerequisites: All servers must be domain joined .Net 4.0 or higher is installed IIS 7.0 (role needs to be turned on through Webserver(IIS) role PowerShell 3 Thu, 11 May 2017 12:00:00 PM GMT http://techfunda.com/howto/1262/new-project ASP.NET Core Open Visual Studio, a start page appears like below. Select New Project .... . Alternatively we can also go to File > New > Project... That opens up 'New Project' dialog box as shown below. Choose the options in the dialog box as shown in the picture below (Left panel - .NET Core, Cent Thu, 02 Mar 2017 12:00:00 AM GMT http://techfunda.com/howto/1261/environment-setup ASP.NET Core In order to develop ASP.NET Core application, we need to setup the development environment. This requires Downloading .NET Core (to run ASP.NET Core apps) from Microsoft website.Please note that in order to develop ASP.NET Core application, you will need to download .NET Core SDK not the Runtime. Thu, 02 Mar 2017 12:00:00 AM GMT http://techfunda.com/howto/1260/why-asp-net-core ASP.NET Core The first version of ASP.NET came around 2001 as part of .NET Framework overcoming the challenges faced by classic ASP for Windows environment web development. Since it's inception, millions of applications have been developed and new features have been added in each releases of ASP.NET (from ASP.N Thu, 02 Mar 2017 12:00:00 AM GMT http://techfunda.com/howto/1259/what-is-asp-net-core ASP.NET Core ASP.NET Core is a new open-source and cross-platform framework for building modern, cutting edge cloud based internet and intranet applications such as web apps, IoT apps, mobile apps, desktop apps etc. ASP.NET Core is the next version of ASP.NET 4.5 (earlier known as ASP.NET vNext or ASP.NET 5). Thu, 02 Mar 2017 12:00:00 AM GMT http://techfunda.com/howto/1258/references CSharp References for further reading The following video Learn C# (C sharp) will get you kick started with things like from where to download visual studio and getting your first program running. Following is 6 minutes video which goes in-depth of explaining Build vs Rebuild vs clean sol Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1257/if-conditions-and-for-loops CSharp One of the things in programming we always need is conditional checks. Mean if this condition is satisfied then execute some part of code or else execute something else. So to write “IF” condition we put condition inside the round brackets ( “(“ ) and the code to be executed Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1256/variables-in-c CSharp When applications run they need to store temporary data in memory. This is done in things termed as variables. Below is a simple code which declares a variable of type integer. So this variable can only hold numeric values. // DataType variableName int num=10; // declares a variable with name &ldq Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1255/run-first-c-program CSharp When Visual studio created the project it generated some basic C# code in ‘program.cs’ file , let’s try to understand this basic code. ‘program.cs’ first starts with a bunch of “using” statements. ‘using’ statements indicate which components fro Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1254/why-to-compile-in-an-il-code CSharp But now the next question which itches is, why do we need to compile to half code (IL Code). If you think logically compiling on runtime will definitely hamper the performance of the application. Because now the application needs to be compiled and as well as executed this can increase the startup t Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1253/understanding-jit CSharp While going through the previous step i.e. Step 4 you must be wondering so when does the final compilation happen?. Because at the end of the day machine only understands machine language and not half compiled code like IL code. Note: - In Java language also we have half compiled code, its termed a Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1252/the-half-compiled-il-code CSharp After reading Step 3 you must have concluded that whatever finally goes in to the “bin” directory is the FINAL MACHINE CODE. But that’s just half truth. The real truth is: - “The Compiled code in the ‘bin’ directory is a half compiled code. This half compiled co Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1251/compiling-the-project-solution CSharp Any code to run on a machine needs to go through a process called as “Compiling”. Humans write code in higher level languages like C# and Java but in order that these codes run on hardware machines they need to be converted to “Machine Language”. The process of converting a Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1250/create-a-simple-vs-project CSharp When we create software application it can have lot of things, it has source code, configuration files , images , text files and so on. In Visual studio to manage these all artifacts we need to create something called as “PROJECT”. So let’s open visual studio and create a simple C Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1249/difference-between-ide-language-and-framework CSharp As a C# developer you would always hear these three words again and again, IDE (Integrated Development Environment), Programming language and framework. Even senior developers use these three words interchangeably without even not knowing that they are very much different. So in one line let me def Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1248/install-visual-studio-community-edition CSharp Figure 1.1: - Visual Studio installed In order to learn C# we need to first install visual studio. Go to https://www.visualstudio.com/ and get this beauty. Once installed you should see “Visual studio” in your program files as shown in figure 1.1. Visual studio communit Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1247/acronyms-used CSharp VS: - Visual studio. IDE: - Integrated development environment. DLL: - Dynamic link library IL: - Intermediate Language ILDASM: - Intermediate language disassembler. JIT: - Just in time compiler. Fri, 17 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1246/introduction CSharp If your goal is to learn C# then you have reached the right spot. In this step by step article series we will run through step by step labs and theories which will make your C# foundation strong. This article does not expect you to have any knowledge of any programming language. This complete step Thu, 16 Feb 2017 12:00:00 AM GMT http://techfunda.com/howto/1245/center-align-text-in-5-columns-layouts Bootstrap In the previous post, we learnt about responsive layout in Bootstrap. In this post, we shall learn how to center align text and images inside Bootstrap columns layout. By default when we write text inside Bootstrap columns layout, it goes to left align so here we shall make them center aligned. In Sat, 21 Jan 2017 12:00:00 AM GMT http://techfunda.com/howto/1244/meta-tags-noindex HTML5 There are many scnenarios where you do not want your web page to be indexed or followed by Google or any other search engines robots. In those scenario, you can place meta tags under <head></head> as below. <meta name="robots" content="noindex,nofollow" /> The noindex value inst Wed, 14 Dec 2016 12:00:00 AM GMT http://techfunda.com/howto/1243/pivot-table-items-grouping Excel In last post, we learnt how to create Pivot Table and Pivot Chart. In this post, we shall learn how to group Pivot Table items. It is used to combine similar types of items in a group and see the result. Grouping Pivot Table Items Below is the Pivot Table created using last post. In this table, yo Mon, 17 Oct 2016 12:00:00 AM GMT http://techfunda.com/howto/1242/pivot-table-pivot-chart Excel In previous posts, we learnt about different types of Charts in Excel. In this post, we shall learn how to create Pivot Table in MS Excel. Pivot Table Pivot table is the most important and powerful feature of MS excel, it is used to extract useful information from tabular data set (in general larg Fri, 14 Oct 2016 12:00:00 AM GMT http://techfunda.com/howto/1241/error-bar-to-chart Excel In previous post we learnt about Easy Pareto chart in Excel. In this post, we shall learn about adding Error bars to the Chart in MS Excel. Let's take example of the previous post Pareto chart as shown below. To add Error bar, select the Chart by clicking on it and then right click that will sho Thu, 13 Oct 2016 12:00:00 AM GMT http://techfunda.com/howto/1240/easy-pareto-chart Excel In last post, we learn how to create Gantt chart in Excel. In this post, we shall learn how to create Pareto chart in MS Excel. Pareto Chart Pareto chart is named after 'Vilfredo Pareto', it is a type of chart that contains bar chart in descending order for individual values and line chart for cum Wed, 28 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1239/gantt-chart Excel In last post, we learnt how to create Thermometer chart in MS Excel. In this post, we shall learn how to create Gantt chart in MS Excel. Gantt Chart There is no Gantt chart inbuilt in MS Excel. We basically create Stacked Bar chart and custmoize it to give Gantt chart look & feel.  For t Tue, 27 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1238/thermometer-chart Excel In last post, we learnt how to create Sparkline chart in MS Excel. In this post, we shall learn how to create Thermometer chart in MS Excel. Thermometer Chart Thermometer chart is used to show how much of a goal has been achieved or what is the current status of work. Let's make a sample data fir Thu, 22 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1237/vertically-center-align-text CSS3 Aligning the text at the center horizontally is easy, just put 'text-align:center;' as style within the element and you are good to go. However, if we need to vertical center align the text within a box, its tough trying different display properties and thier values. So we have time tested solut Tue, 20 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1236/sparkline-chart Excel In last post, we learnt about 2D & 3D Bubble Chart in Excel. In this post, we shall learn how to create Sparkline chart in Excel. Sparkline Chart Sparkline chart is a mini chart placed in a single cell, each representing a row of data in the selection. To insert a Sparkline chart, go to 'INSER Tue, 20 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1235/2d-3d-bubble-chart Excel In last post, we learnt how to create Scatter chart in Excel. In this post, we shall learn how to create 2D and 3D Bubble chart in Excel. 2D Bubble chart To create a Bubble chart in Excel, go to INSERT menu and click on 'Insert Scatter ...' command button on the ribbon. From the dropdown, select Sun, 18 Sep 2016 12:00:00 PM GMT http://techfunda.com/howto/1234/scatter-chart Excel In last post, we learnt about 2D & 3D Area Chart in Excel. In this post, we shall learn Scatter chart in Excel. Scatter chart To insert Scatter chart, click on INSERT menu and click on Scatter chart command button from the ribbon as displayed below. Do remember to select data to create ch Sun, 18 Sep 2016 12:00:00 PM GMT http://techfunda.com/howto/1233/2d-3d-area-chart Excel In last post, we learnt how to create 2D & 3D Bar Chart in Excel. In this post, we shall learn how to create an Area chart in Excel. 2D Area Chart Select the data for which we want to draw a chart, now go to 'INSERT' menu and click on 'Area' chart command button from the 'Charting' group Fri, 16 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1232/2d-3d-bar-chart Excel In last post, we learnt how to insert Pie chart in Excel. In this post, we shall learn how to create 2D & 3D Bar chart in MS Excel. 2D Bar Chart To insert 2D Bar Chart (or just Bar Chart), select the data for which the Bar chart has to be generated, now go to INSERT menu and click on 'Insert B Fri, 16 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1231/2d-3d-pie-chart Excel In last post, we learnt about creating Line chart in Excel. In this post, we shall learn how to create Pie chart, add filter and style to it. 2-D Pie Chart To create 2-D Pie chart in Excel, first select the Chart data and go to INSERT menu and click on 'Insert Pie or Doughnut Chart' command dropdo Wed, 14 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1230/chart-style-filters-and-elements Excel In the previous post, we learnt about Secondary axis chart in Excel. In this post, we shall learn styling and changing color scheme of chart and filtering data points and names on chart. Chart Styles The easiest way to style and change color scheme of the chart is to use the shortcut command butto Mon, 12 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1229/line-chart Excel In last post, we learnt how to create Column chart in Excel. In this post, we shall learn how to create a line chart in MS Excel. 2-D Line Chart To insert Line Chart in MS Excel, Select the data to generate Line chart and then go to 'INSERT' menu and click on 'Line Chart' dropdown from 'Charts' gr Mon, 12 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1228/column-chart Excel In the last post, we learn how to create secondary chart in Excel. In this post we shall learn how to create column chart in Excel. 2-D Column chart To create a 2-D column chart in Excel, select the data for which chart has to be created. Go to 'INSERT > Insert Column Chart'. A chart appears as Fri, 09 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1227/secondary-axis-chart Excel In last post, we learnt about creating combination chart in Excel. In this post, we shall learn how to create secondary axis on Excel chart so that chart with different magnitude make sense. To do this, select the chart by clicking on it and select 'Change Chart Type' from the 'DESIGN' me Tue, 06 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1226/combination-chart Excel In last post, we learnt about changing chart type and switch row/columns in Excel. In this post, we shall learn how to create combination chart. Combination chart in Excel Combination chart is the combination of two different types of chart so that the data comparision is easy. If we look at below Tue, 06 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1225/change-chart-type-switch-row-column Excel In last post, we learnt about Chart axes, legend, data labels and trendline in Excel. In this post, we shall learn how to change chart type, switch rows to column and vice-versa. Change Chart Type To change the chart type for chart already built, simply select the chart by clicking and then select Tue, 06 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1224/chart-axes-legend-data-labels-trendline Excel In last post, we learnt about how to create a chart and format it in excel. In this post, we shall learn how to work with chart legends, data labels axes etc. Hide/show Axes in Excel chart Many a times, we may need to hide/show horizontal or vertial axes labels in the chart. To do this, go to 'DES Tue, 06 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1223/create-a-chart Excel In the last post, we learnt ranking in MS Excel. In this post, we shall learn how to create a chart in MS Excel. Before we proceed further let's have a sample data to draw a chart. Below are our chart data. Create a chart Now select all the data from A1 to C9, go to INSERT menu adn select 'Clus Fri, 02 Sep 2016 12:00:00 AM GMT http://techfunda.com/howto/1222/ranking-in-excel Excel In last post, we learnt how to generate random number between two numbers in Excel. In this post, we shall learn how to rank a number in the list of numbers in Excel. RANK.EQ function RANK.EQ function is equivalent to RANK function of older version of Excel. RANK.EQ function in Excel is used to re Wed, 31 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1221/random-numbers Excel In last post, we learnt about statistical functions of MS Excel. In this post, we shall learn how to generate random numbers in MS Excel. RAND function RAND (Random) function is used to generate random numbers in MS Excel whose range will be between 0 to 1.  B2 cell has '=RAND()' formula tha Wed, 31 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1220/statistical-functions Excel In previous post, we learnt how to calculate different types of depreciation in MS Excel. In this post, we shall learn how to work with statistical functions in MS Excel. AVERAGE function AVERAGE function is used to calculate average of the range of given cells. In below example, B9 cell contains Tue, 30 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1219/depreciation-calculations Excel In last post, we learnt about how to calculate compounded interest in MS Excel. In this post, we shall learn how to calculate different types of depreciation on assets costs in Excel. Excel has got 5 different methods to calculate depreciation. Let's learn them one by one. SLN function SLN (Strai Mon, 29 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1218/compound-interest-calculations Excel In the previous post, we learnt 'What if I had invested calculations in Excel'. In this post, we shall learn how to calculate compound interest in MS Excel. Excel doesn't have an inbuilt function to calculate compound interest. So we will do some manipulations to calculate compound interest. In be Fri, 26 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1217/what-if-i-had-invested-calculation Excel In previous post, we learnt about Calculate monthly installment of a loan in Excel. In this post, we shall learn 'What if I had invested scenario' in Excel. We will learn what If I would have invested a certain amount for certain period assuming to get certain interest rate then how much amount we w Thu, 25 Aug 2016 12:00:00 PM GMT http://techfunda.com/howto/1216/calculate-monthly-installment-of-a-loan Excel In the last post, we learnt about getting maximum and minimum value from set of values in Excel. In this post, we shall learn how to calculate payment for a loan based on monthly payment and to a specific interest rate. This can be done using PMT function of Excel. To understand how it works, we sh Wed, 24 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1215/max-min-value Excel In previous post, we learnt about VLOOKUP and HLOOKUP function in Excel. In this post, we shall learn about MAX, MIN, MATCH and ADDRESS function of Excel. MAX function MAX function in Excel is used to return the larget value in the set of values. It ignores the textual or logical values. In C2 ce Tue, 23 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1214/caste-of-pv-sindhu Misc. Okay, many people in India particularly from Telangana (where she belongs to) and Andhra Pradesh (earlier Telangana was part of Andhra Pradesh) are searching for Caste of Badminton player PV Sindhu. The search of PV Sindhu caste was so high that it started trending in Google Search. Many news paper Mon, 22 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1212/vlookup-hlookup-functions Excel In previous post, we learnt the difference between Find and Search in Excel. In this post, we shall learn about VLOOKUP and HLOOKUP functions in Excel. VLOOKUP function VLOOKUP (Vertical lookup) function is used to look for a value in the main table and return corresponding value from the lookup t Fri, 19 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1211/find-vs-search-function Excel In previous post, we learnt about Text to Columns in Excel for CSV data. In this post, we shall learn the difference between FIND and SEARCH function in Excel and where to use what? FIND function Look at below example. In B2, we have '=FIND("JOHN", A2)' formula that returns '#VALUE' as FIND couldn Tue, 16 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1210/text-to-columns Excel In previous post, we learnt about seprating string from sepecific characters in Excel. In this post, we shall learn about converting CSV (comma separated values) data into columns in Excel.  This post is equally helpful in case data is not comma separated but simicolumn, space, tab or any othe Tue, 16 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1209/separate-string Excel In the previous post, we learnt about how to compare two strings (Case sensitive and Case insensitive) in Excel. In this post, we shall learn how to separate string from a specific character in Excel. Let's take example of below data. In B column we have Full Name of people separated by Comma (,). Sat, 13 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1208/compare-strings Excel In the previous post, we learnt about how to change string to upper, lower and proper case in Excel. In this post, we shall learn how to compare two strings (case sensitive and case insensitive) in Excel. Case Sensitive comparison (EXACT function) To compare two string (case sensitive compari Sat, 13 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1207/upper-lower-proper-case Excel In the previous post we learnt about how to count number of words in Excel. In this post, we shall learn how to change the case of a string (upper, lower or proper case) in Excel. UPPER function To change string to upper case, we can use UPPER function. In B3 cell, we have '=UPPER(A3)' formula tha Sat, 13 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1206/count-words Excel In the previous post, we learnt about LEFT, MID, RIGHT, FIND and SUBSTITUTE function of Excel. In this post we shall learn how to count the number of words in a cell of Excel worksheet. Let's solve this problem three simple step. Step 1: Count the total length of string To count the total length Sat, 13 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1205/join-left-mid-right-find-substitute-functions Excel In the previous post, we learnt about Date & Time functions in Excel. In this post, we shall learn about Text manipulation in Excel. Join strings in Excel To join two strings in Excel, we an use '&' operator.  In below example, D3 has formula '=B3 & " " & C3' that concatenate Fri, 12 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1204/date-and-time-functions Excel In previous post, we learnt about If, And, Or functions in Excel. In this post, we shall learn about Date and Time functions in MS Excel. How to write date and time in MS Excel? Date in Excel can be written seprated by either '/' (forward slash) or '-' (dash). Time in Excel can be written seprate Tue, 09 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1203/cell-references-relative-absolute-mixed Excel In previous post, we learnt about Functions and Formulas in Excel. In this post, we shall learn about different types of Cell references to be used in formulas. What is cell reference in Excel? Cell reference is the name of a cell made by combining column and row names. It is used to refer a parti Mon, 08 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1202/if-and-or-functions Excel In the previous post, we learnt about Sumproduct, SumsQ function in Excel. In this post, we shall learn about Logical functions such as If, And and Or in Excel. If Function IF is a conditional function that returns one value based on whether the condition is valid or not. In below example, F colum Mon, 08 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1201/sumproduct-sumsq-functions Excel In previous post, we learnt about Sum, SumIf and SumIfs function in Excel. In this post, we shall learn about SUMPRODUCT, SUMSQ function in MS Excel. SumProudct function SUMPRODUCT function in Excel is used to sum the products (multiplication) of corresponding ranges. In below example, we want to Sat, 06 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1200/sum-sumif-sumifs-functions Excel In the previous post, we learnt about counting logical and bit values in Excel. In this post, we shall learn about sum range of cells value in Excel. Sum function To sum/add a range of cells in MS Excel, we can use SUM function. SUM function can either by used by directly writing in the cell or by Sat, 06 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1198/dom-document JavaScript HTML DOM Document HTML DOM Document is defined as an object in the webpage. HTML DOM Document is used to represent webpage. HTML DOM Document is used to access any HTML element. Some of HTML DOM Document which are used to access HTML. Finding HTML Elements document.getElementById(id) - F Fri, 05 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1197/dom-methods JavaScript DOM Methods DOM Methods are defined as actions when we perform on html elements, DOM properties are values of html element that we can change or set the values. All HTML elements as defined as objects, programming interface is an property and method of an object. Property Property is a value tha Fri, 05 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1196/count-logical-and-bit-values Excel In the previous post, we learnt about counting blank and non blank cells in Excel. In this post, we shall learn how to count logical and mixed logical values in MS Excel. How to count logical values in Excel? To count logical values (TRUE/FALSE) in MS Excel, we can use COUNTIF function as explaine Thu, 04 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1195/count-blank-and-non-blank-cells Excel In the previous article, we learnt about Count, CountIf, and CountIfs function in MS Excel. In this article, we shall learn COUNTBLANK and COUNTA function that is used to count blank and non blank cells within given range. How to count blank cells in MS Excel? We have already learnt other way of c Thu, 04 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1194/count-countif-countifs Excel In the previous post, we learnt about Keyboard shortcuts in MS Excel. In this post, we shall learn how to count cells using Count, CountIf and CountIfs function. Count() function Count() function is used to count the number cells between two ranges that contains numberical data; it doesn't count t Thu, 04 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1193/split-spreadsheet-window Excel Learn about Ribon in Excel here. In this post, we shall learn how to split/divide the spreadsheet window. This helps us in viewing multiple distant contents of the spreadsheet. To split the spreadsheet, first select a cell from where you want to split. In this case, we have selected D10. Now go Wed, 03 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1192/named-range-named-constant Excel In the previous post, we learnt about how to protect a MS Excel file. In this post, we shall learn how to created Named range, Named constant in MS Excel and how to edit, delete and use them. What is Named range or Named constant in MS Excel? Named range is a range of cells that has been given a s Mon, 01 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1191/keyboard-shortcuts Excel In the previous post, we learnt about Named range and Named constant. In this post we shall learn about Keyboard shortcuts in Excel. Keyboard shortcuts are a way to perform frequently used activities quicker with the combination of keys rather than following few steps through mouse. This helps in i Mon, 01 Aug 2016 12:00:00 AM GMT http://techfunda.com/howto/1190/protect-file Excel In the previous post, we learnt about how to take print out from MS Excel and setup page properties. In this post, we shall learn about how to protect a excel workbook (file) so that it requires a password to open. To create a password protected file, first open that file int he MS Word and go to F Fri, 29 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1189/print-options Excel In the previous post, we learnt about data validations in MS Excel. In this post, we shall learn how to take print out of Excel worksheet and how to set different printing settings. To open the Print dialog box, go to File > Print and you would see a screen similar to this. If all th Thu, 28 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1188/data-validation Excel In previous post, we learnt about Find, Replace, Go To etc. in MS Excel. In this post, we shall learn how to validate data in MS Excel. To understand how validation is implemented, we have created a sample form. Let's say, we have a requirement for age data that it should except data between 1 t Wed, 27 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1187/find-and-replace Excel In previous post we learnt about Templates in MS Excel. In this post, we shall learn how to find, replace, select cells based on data, conditions, formulas etc. To learn those, we will take an example of below data. How to find data in MS Excel? To find data in MS Excel, we can use followi Tue, 26 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1186/templates Excel What is templates in MS Excel? Template in MS Excel is a ready made pattern / design / guide available to make a certain type of MS Excel file. There are plenty of online/offline free templates available in MS Excel. How to create a file based on template in MS Excel? To create a new MS Excel fil Tue, 26 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1185/cell-formatting Excel In the last post, we talked about Excel Worksheet and Workbook. In this post, we shall learn about formatting and doing other formatting activities related with cells of Excel worksheet. The default data type of any cell in excel is 'General', to prove this write any numeric data in a cell lik Mon, 25 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1184/worksheet-and-workbook Excel Worksheet is a collection of rows and columns whose intersection makes cells in which we keep and manipulate data.  Workbook is a collection of Worksheets. A workbook can contain many worksheets. How to create a new Workbook & Worksheet in Excel? To create a new workbook in MS Excel, cli Mon, 25 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1183/ribbon-toolbars Excel What is Ribbon in MS Excel? Ribbon is MS Excel is nothing but a placeholder on which Tabs exists. Look at below picture, we have HOME, INSERT, PAGE LAYOUT .... etc. tabs on a panel and that panel is called Ribbon . Each tab has it's relevant commands in the form of Toolbar icon that does a certain Fri, 22 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1182/functions-and-formulas Excel What is Formula & Function in Excel? A formula is a mathematical relationship or rule expressed in symbols that calculates the value of a cell. A function is a pre-defined formula available in Excel that is ready to use. A formula in excel starts with '=' inside a cell. For example, to show Fri, 22 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1181/cell-range Excel What is Cell in MS Excel? Cell in MS Excel is the intersection between a row and a column on spreadsheet. Cell is denoted by its Column and Row number on the spread sheet.  Look at the picture below, the bordered (selected) cell is denoted by A1 (A is the column and 1 is the row). Same applie Wed, 20 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1180/excel-opening-screen Excel How to quickly open MS Excel on windows machine? There few ways to find and quickly open MS Excel on the windows desktop or laptop. Go to Run dialog box in the Windows machine by pressing Ctrl+R and type excel and hit OK button. This will instantly open the MS Excel on your machine.  The o Wed, 20 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1178/net-tutotials-websites Misc. Below are the list of .NET community tutorials/guide website (supported by .net community developers) that are popular and reliable source of learning .NET Technologies. asp.net - The official asp.net website developed and maintained by Microsoft(R). This website has tutorials, forums and other o Thu, 07 Jul 2016 12:00:00 AM GMT http://techfunda.com/howto/1177/thumbnail Bootstrap Bootstrap thumbnail Bootstrap's thumbnails are used to show linked images in grids with very minimum required markup, a thumbnail is created using class .thumbnail within the element <a>, The column grids are created using class .col-sm-* and .col-md-*, Tue, 07 Jun 2016 12:00:00 AM GMT http://techfunda.com/howto/1174/icc-odi-world-cup-winners-list Misc. ICC ODI Cricket World Cup Winners List The International Cricket Council (ICC) started contesting the world cup for the One Day International (ODI) format game in 1975. This contest held for every 5 years and it is organized by ICC. List of Winners Year Venue Winner Runn Mon, 04 Apr 2016 12:00:00 AM GMT http://techfunda.com/howto/1173/icc-world-t20-winners-list Misc. ICC T20 World Cup Winners International Cricket Council (ICC) started contesting world cup for the short format game (20-20/T20) in 2007. This contest held for every 2 years and it is organized by ICC. Here is the list of the T20 worldcup winners Year Venue Winner Runner Mon, 04 Apr 2016 12:00:00 AM GMT http://techfunda.com/howto/1172/list-of-2015-2016-national-film-award-winners-of-india Misc. 63rd Indian National Award Winners  Category Winner Best Feature Film Baahubali Indira Gandhi Award For Best Debut Film Of A Director Neeraj Ghaywan for Masaan Best Popular Film Providing Wholesome Entertainment Bajrangi Bhaijaan Nargis Dutt Award For Best Sat, 02 Apr 2016 12:00:00 AM GMT http://techfunda.com/howto/1170/responsive-images-sizes CSS3 Images in Responsive Web Design Images in responsive web design are nothing but when the user starts scaling the browser, the images in the web page adjusts automatically without croping. Width Property If we set the width property 100%, the image will responsive on the webpage and we can scale u Mon, 28 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1169/media-queries CSS3 Media Queries Media queries are newly added to CSS3 and it is a technique to include block of CSS properties only if a certain conditions is true.  <style> p { color: Red; } @media only screen and (max-width:600px) { p { color: green; Tue, 22 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1168/viewport CSS3 Viewport User's visible area of a webpage is called as 'Viewport' and it is a value to the name attribute inside the <meta> tag. It varies with the device (Computer screen, Tablet, Mobile phone), we can test this by scaling the browser width on the computer screen. As the size of the browser Tue, 22 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1167/independence-day-speech Misc. Independence day speech Respected Chief guest, Principal/ Head Master/ Head Mistress, Teachers, Parents and my dear Friends. A very good morning to one and all who are presented over here. Today we are all gathered here to celebrate this auspicious occasion of <nth> Independence day. Indep Fri, 18 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1166/animation-properties CSS3 Animation An animation lets an element gradually change from one style to another, to create animation using css we need to use keyframes for the animation  There are different types of animations used in animation, they are  Animation delay Animation direction Animation duration A Fri, 11 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1163/language-codes HTML5 Language code The HTML lang attribute can be used to declare the language of a Web page or a portion of a Web page. This is meant to assist search engines and browsers. <html lang="en"> ... </html> Abkhazian- ab Afar- aa Afrikaans- af Albanian- sq Amharic- am Arabic- ar Ar Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1162/spellcheck HTML5 Spellcheck It is used to check the spelling of the text whethere it is correct or wrong. <h2>Spellcheck is used to check the spelling of the text </h2> <p contenteditable="true" spellcheck="true">This is a g0lbe. </p> In the above code snippet we defined the sp Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1161/tabindex HTML5 Tab index  Tabindex is used to re-arrange the navigation of the page on press of tab key on the keyboard.  <h2>Tab index is used to arrange navigation links of tab button </h2> <a href="http://www.techfunda.com/" tabindex="2">TechFunda</a><br> &lt Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1159/fieldset HTML5 Fieldset Fieldset is used to group the elements together in the form, which uses <fieldset> to group elemnts  <h2>Field set is used to group elements</h2> <form> <fieldset> <legend>Sign up</legend> Email Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1158/legend HTML5 In previous posts, we learnt how to group elements using fieldset. Legend By using <legend> we can create a caption on the field set   <form> <fieldset> <legend>Please Login</legend> Email: <input type="text"><br> Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1157/jam-topics-on-importance-of-women-in-our-society Misc. Importance of Women in our Society Womens are an important element of our society, in every one's life women play a major role.  Womens are participating actively in all walks of life, so the present society has started recognizing the individual identity of women. In some countries Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1155/source-tag HTML5 Source  Source is used in the audio and video functions which is used to select the songs in audio and video functions  <p>Source is used in audio and video </p> <audio controls> <source src="horse.ogg" type="audio/ogg"> <source src="hor Thu, 10 Mar 2016 12:00:00 AM GMT http://techfunda.com/howto/1153/variable HTML5 Variable  Variable in html is used define the variable, we use <var> tag to define a variable   <body> <p>Var is used to define a variable</p> <var>Techfunda</var> </body> In the above code snippet we have defined the variable using Thu, 10 Mar 2016 12:00:00 AM GMT