Object-oriented programming approach is very different from the traditional programming techniques where a chunk of data is sent to function to function. Objects model the real – world things, processes, and ideas that your application is designed to handle. An object-oriented application is a set of collaborating objects that independently handle certain activities. The concepts of classes […]
Pivot Tables in Microsoft Excel – Free Excel Tutorials
Sunil has the following spreadsheet that contains information about the productivity of 25 employees of his company from various branches across India. What is a Pivot Table? A pivot table is a summarized and consolidated table that contains complex data from all over the sheet and workbook. It doesn’t change any of the values in […]
Drawing Tools: Shape Outline in MS Excel
Abhi has inserted a shape in his Excel Sheet. Now that he has done that, the ‘Drawing Tools’ will open on the ribbon to format the picture. In this module we will look at how he can change the shape outline to suit his need. This option can be found in the ‘Shape Styles’ group […]
Picture Tools: Corrections to an Inserted Picture in Excel
Daya has inserted a picture in her Excel Sheet. She wants to bring some corrections to it to make it look more synchronized with the sheet. These are the options available to her: Sharpen/Soften Brightness/Contrast Sharpen/Soften Sharpening an image increases the detailing and specifications of it to more clarity. Softening an image, on the contrary, […]
Inner Joins in SQL – Free SQL tutorials
Inner joins are useful in querying data from two tables and output is produced when based on Join condition mentioned in the where clause of the query. In the output, only the rows that satisfy the join condition will be fetched. As the condition used in Inner join is based on equality of two columns […]
- 1
- 2
- 3
- …
- 1307
- Next Page »