Flash Fill in Excel

Flash Fill This is an Excel feature that was first introduced in Excel 2013 as an alternative to simplify data cleaning process considered very difficult, time consuming, or not possible with existing methods. The way it works is similar to that of Text-to-Column but can handle the task of cleaning huge data in more faster[…]

Shares 0

Formatting for Print and Email in Excel

The following steps must be follow in order to format for printing and Email in excel. Select the Page Layout Menu Highlight the cells range or table you intend to print and set PRINT AREA to tell excel which cells range or part of the sheet to be printed Click on the arrow underneath Print[…]

Shares 0

Formatting Data as Table in Excel

Formatting data as a table make it easier to work with and visual appealing. Below is a data set we want to format as a table. Highlight the entire cells Select the INSERT MENU Click on Table or Using the shortcut CTRL+T convert the range to table The selected range will show on the dialog[…]

Shares 0

Basic Data Types and Data Consistency in Excel

  The classification of data to various types base on it predefined characteristics and how it value should be stored is refers to as data type. In this case Microsoft excel recognizes four (4) different data types which include Number, Text, Boolean, and Formula. Therefore each cell can contains any of the above mention data[…]

Shares 0