Posted on Leave a comment

SEARCH , FIND Function in Excel

The Microsoft Excel SEARCH and FIND functions returns the location of a substring in a string. The only difference between these two functions is that FIND is case-sensitive, but SEARCH is NOT. SEARCH and FIND functions are built-in functions in Excel that are categorized as String/Text Functions.
In this video we describe these functions in details and explain the difference between them with examples. For more videos like this, please subscribe us.

Posted on Leave a comment

Text and numeric Filtering in Excel

In this video talk about the filter option of Excel and how we can use it efficiently for filtering numeric or text data in Excel. We convert the data area into table for convention filtering, but you should note that if you don’t convert range to table all concepts will be same.

 

Posted on Leave a comment

CONCAT and CONCATENATE Function in Excel

The Microsoft Excel CONCAT function allows you to join 2 or more strings together. It was released in Excel 2016 and replaces the CONCATENATE function. The CONCAT function is categorized as a String/Text Function.
In this video we describe how to use this function in different situations.

Posted on Leave a comment

Using filter option and slicer in Excel table

In this video we talk how we can filter data in Excel. Specially, in Excel tables by using slicers options. Slicers are useful tool in excel that enable you filtering data by just clicking at current values in an box. Which can be very helpful when you have lots of data and want to filter them easily

Posted on Leave a comment

Creating New Excel Table Style

In this video, we talk how to using table style and creating one for ourselves. With Table style, we can show data with more properly to other users, specially when you have a lots of data, showing them more efficiently would be one of main concerns of understanding and analyzing data

Posted on Leave a comment

What it means by cleaning data

In this video we talk about how we can clean data. For example, when you gather the data from a database or some other places, then you need to make sure there are structured in good shape (meaning that have a table shape), and if its not, you need to reshape your data into the good structure. Here, we will talk about this good structure and how we can reform data into table format.

Excel data: Data

Posted on Leave a comment

Function definition in Excel

In this video we define the concepts of Excel functions and the way of writing functions in Excel. Functions, which we can call them formulas in Excel are predefined algorithms in Excel software that allow us do some manipulation and operations on data (or cells value or range of cells)

 

Posted on Leave a comment

Excel Presentation of values in cells

Based on the values we provide in Excel cells, we can choose to show them in different formats, for examples, dates are all stored as numbers in Excel, however, we can present dates in different formats (for example, showing the year at the first or at the last position of date, or showing based on month names and not the numbers). In this video we talk about this presentations in Excel cells, and also we talk about how Excel can understands the Date values.

 

This Excel is part of invoice software which is developed by deyako company in Microsoft Excel: https://deyako.co.uk/product/invoicing-invoice-management-software/

Posted on Leave a comment

Different types of values in Excel cells

In this video we talked about what different kind of values we can have in Microsoft Excel cells, and describe meaning of each of these values, these values include: Number , Text ( string ), logical, Error and Array.

This Excel is part of invoice software which is developed by deyako company in Microsoft Excel:

https://deyako.co.uk/product/invoicing-invoice-management-software/