1 Get & Transform Data The Get & Transform Data tool in Excel allows you to quickly retrieve data. There are several ways to modify the data while doing so, one of which is to eliminate blank rows. Fortunately, it’s simple to use, although it does necessitate the usage of a Table object; if your… Continue reading ways to delete blank rows in Excel
Tag: excel
ADVANCED FILTER IN EXCEL
Extracting a Unique list using Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). Select the entire data set (including the headers). Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). This will open the… Continue reading ADVANCED FILTER IN EXCEL
Create and edit pivot tables
Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, group data, and more.Examples– Summarize thousands… Continue reading Create and edit pivot tables
Excel Functions Used In CSV Import
We have to use various excel functions for importing such as Text functions ,Lookup functions ,Date and Time functions, If and related functions etc Note: In Excel we can use FORMULATEXT() function to know the functions that we have used in each cells. a) Right function is used to extracts a given number of characters… Continue reading Excel Functions Used In CSV Import
Download Excel from the custom suitelet page
/** * @NApiVersion 2.1 * @NScriptType Suitelet */ /************************************************************************************************************************* * CLIENTNAME: * AMVOP-117 * Vat Report * ********************************************************************************************************************** * Date 23/07/2021 * * Author: Jobin & Jismi IT Services LLP * Script Description : This Script is to create suitelet page for vat report * Date created : 23/07/2021 * * REVISION HISTORY * *… Continue reading Download Excel from the custom suitelet page
Excel macro for inserting images from a Netsuite link
An excel macro that can be used to insert images stored in NetSuite cloud to an excel workbook. Requirement for the macro: Adding images to an excel workbook is a straightforward task in usual cases but files behave differently when NetSuite links are used. Files are usually accessed from file cabinet using the NetSuite file… Continue reading Excel macro for inserting images from a Netsuite link
Re-occurring Reports
Send mail to every customer about their back ordered items.