Author: Ovo Odioko

Avatar photo

Ovo is a highly specialized Computer and Networking Expert with experience in Windows, Cisco, Microsoft Office (Excel, Word, etc) and Networking engineering. Ovo is a creative, team player that loves sharing his experience with technology with readers to follow along. He has great attention to detail when discussing various technologies, tutorials and guides.

Excel has a lot of features that make it unique and useful for data organization and analysis. One of the many things that can be done in Excel is converting a column list to a comma-separated list. The TEXTJOIN function, CONCATENATE function, or executing a VBA in excel are all ways that this can be accomplished. In this article, we will be reviewing these three proven and easy methods by which you can convert a column list of data to a list separated by an operator. Before we move on, let’s review some of the advantages of converting column lists…

Read More

The term JSON is common vocabulary for persons who are into Software engineering or Data science. As a newbie, you may get confused with the appellation JSON however, in this article we will explain the concept of JSON, how to create a JSON file, and how to easily open a JSON file using text editors. JSON is an acronym that represents JavaScript Object Notation. As captured in its naming, the word ‘Notation’  indicates that JSON is a way of representing data independent of a platform. A simpler way of explaining this concept is by utilizing the analogy of a PDF…

Read More

What are Macros? Macros can be defined as a tool in Excel used to record routine steps that may be replayed over and over. This replay can be done automatically with a single click of a button. Technically, creating macros means you are recording your mouse clicks and keystrokes of your steps which may be edited or adjusted to your preference. Using Macros help save time and energy which would have been expended on repetitive routines. However, irrespective of its identified advantages, there are instances where we may need to remove Macros from our Excel workbook. This write up explains…

Read More

Over the years, excel has helped many with the task of proper and effortless data representation and organization. Different firms, industries, and individuals have harnessed the various tools on excel and applied them to their dataset to have their data in the best form possible and to do a proper analysis of their data. Just as mentioned earlier, excel is a package that houses many great functions that are useful and largely instrumental in the analysis and organization of data, and one of these very useful functions is the IF function. The IF function is a very useful function and…

Read More

What is a Barcode Barcodes are sets of lines of different widths and sizes representing data that when read help identify encoded pieces of information. It generally consists of a series of parallel black and white bars that can be read by a barcode scanner. They are printed on products to quickly identify them and are used for entering data into a computer system. Barcoding has been in existence since the 1970s and is now found everywhere as part of routine commercial transaction processes. The barcode system can be applied in many industries such as the ones typically used in…

Read More

Excel has so many functions that are useful for data organization and analysis. It is possible to hide rows or even columns containing a specific dataset in excel, and it is also very likely to unhide rows or columns containing a particular dataset in excel. The idea of hiding certain parts of a dataset is instrumental in real-life situations where specific data are kept private and away from a third party. You can conceal and expose hidden rows in excel just the same way you can hide and unhide columns. In addition to freezing rows, you may find it helpful…

Read More

One out of the very many uses of excel is to help us to apply the accounting format to numbers in selected cells. In computations involving monetary values, you might be required to input or change a set of values in your dataset to imply a monetary value; this can be made possible with this wonderful function on excel. This format differs from others in that it aligns items such as decimal points and currency symbols, helping to aid the understanding of numerical data. Excel is replete with quite a lot of functions which when known and properly used can…

Read More

Mean Squared Error (MSE) is one of the most routine parameters that is used for measuring the forecast accuracy of a model. In layman’s terms, it is the mean of the squares of the error margin between observed and expected values. The formula for MSE is: MSE = (1/N) * Σ(O – E)2  Where: Σ stands for summation or sum N = sample size O = observed data value (or actual value) E = expected data value (or forecasted value) Mean squared error gives a measure of the closeness of a regression line to a set of points. It achieves…

Read More

Although we now live in a technology-driven world, many people still restrict the term Information Technology to only getting help with their P.C. or smartphone. This ideology is far from what Information Technology or I.T. is and what the roles of the professionals in this field are. Information technology can be defined in so many ways being a broad and highly innovative field. According to Wikipedia, Information technology uses computers to create, process, store, retrieve, and exchange all kinds of electronic data. Other media outlets define information technology as the development, maintenance, and use of computer software, systems, and networks.…

Read More

Introduction to SRT Files An SRT file is a SubRip subtitle file. They are the type of files that include subtitles in videos of the start and end timecodes of texts. This file does not contain any data. There are several types of raw closed caption file formats, and SRT Files or SubRip (.SRT) is just one of them. This basic caption file can be ordered after a video release and afterward uploaded to a separate file to host the video alongside the video. All media platforms (Facebook, Vimeo, YouTube, and other video players) support video hosting. SRT Files, as…

Read More

VBS is a short form for Visual Basic Script. As implied in its name, it is a script and it is written in a scripting language. VBScript is a subdivision of Microsoft’s Visual Basic for Application family. It is usually included in the individual application within Microsoft Office, Microsoft Project, and a host of third-party applications like AutoCAD. VBS files carry a ‘.VBS’ or ‘.VB’ extension. In this article, we will get to understand the basis of VBScript, its features, drawbacks, and how to run a simple program. History of VBScript VBScript was introduced by Microsoft in the year 1996…

Read More

The TIFF (Tagged Image File Format) or TIF is an extension that is used for a high-quality bitmap image. It is the default file format for several applications on OS X, not excluding the default screen capture utility Grab. It is a file format that is very popular in the image editing and photography industry, and users attest to its ability to be easily edited. The TIFF file format is used with images that have high color depth, and it also has the ability to give details of bilevel, grayscale, palette color, and full-color image data in different color spaces.…

Read More