addnewskills, Author at

How to Ignore na Values with Formulas in Google Sheets(Quick & Easy Guide)

In this tutorial, you will learn How to Ignore na Values with Formulas in Google Sheets. (#N/A error) To Ignore na ( #N/A) Values with Formulas in Google Sheets you can use the below formula. =AVERAGE(IFNA(A2:A10, “”)) =SUM(IFNA(A2:A10, “”)) =IFNA(VLOOKUP(E2, A2:E12, 2, FALSE), “”) The above formulas will substitute blank values for #N/A values to …

How to Ignore na Values with Formulas in Google Sheets(Quick & Easy Guide) Read More »

How to Check Word Count on Google docs(Quick & Easy Guide)

Google Docs / By addnewskills

In this tutorial, you will learn How to Check Word Count on Google docs To Check Word Count on google docs, click on the Tools menu and Select the option Word Count from the drop-down options. How to Check Word Count on Google docs: Step-by-Step Guide Here are the steps to check Word Count on …

How to Check Word Count on Google docs(Quick & Easy Guide) Read More »

How to Format Pivot Tables in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

In this tutorial you will learn How to Format Pivot Tables in Google Sheets. Format Pivot Tables in Google Sheets(Quick Overview of Steps) Open Google Sheets Prepare your dataset Create A Pivot table for the dataset Customize the default Pivot table theme To Customize the theme ,click on the Format menu on the Main toolbar …

How to Format Pivot Tables in Google Sheets(Quick & Easy Guide) Read More »

How to Interpolate Missing Values in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

In this tutorial you will learn How to Interpolate Missing Values in Google Sheets How to Interpolate Missing Values in Google Sheets : Step by Step Guide Here are the steps to Interpolate Missing values in Google Sheets . Step 1 : Open Google Sheet and prepare yout data set As a first step we …

How to Interpolate Missing Values in Google Sheets(Quick & Easy Guide) Read More »

How to Create a Candlestick Chart in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

This article will explain How to Create a Candlestick Chart in Google Sheets. A Candlestick Chart belongs to a financial chart category that shows the price changes of securities over time is known as a candlestick chart. By condensing all four information into one visual, the candlestick chart can display the Open, High, Low and Close …

How to Create a Candlestick Chart in Google Sheets(Quick & Easy Guide) Read More »

How to View your Google Search History(Quick & Easy Guide)

Software & Apps / By addnewskills

In this tutorial, you will learn How to View your Google Search History. To view you google search History open google.com on your browser and click on your logged in gmail account profile on the top right corner of your browser.Now Click on “Manage your account” then click on Click on the “Data & Privacy” …

How to View your Google Search History(Quick & Easy Guide) Read More »

How to backup your Gmail inbox to another Gmail account (Easy Essential Guide )

Software & Apps / By addnewskills

In this tutorial, you will learn How to backup your Gmail inbox to another Gmail account. If you running out of space on your current gmail account you can use gmail “import mails and contacts” feature to import your mails and contacts to another gmail account . Once your mails are imported to another gmail …

How to backup your Gmail inbox to another Gmail account (Easy Essential Guide ) Read More »

How to Calculate Z scores in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

In this tutorial you learn How to Calculate Z scores in Google Sheets Calculate Z scores in Google Sheets To calculate the Z scores in Google Sheets you can use the formula which will compound a Z score “=(DataValue-Mean)/StDev“. How to Calculate Z scores in Google Sheets : Step by Step Guide Here are the …

How to Calculate Z scores in Google Sheets(Quick & Easy Guide) Read More »

How to Create an Area Chart in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

This article will explain How to Create an Area Chart in Google Sheets. How to Create an Area Chart in Google Sheets: Step By Step Guide To identify trends in data over time, you use an area chart. Like line charts, area charts use shading to highlight the size of trends. Enclosed are the steps to …

How to Create an Area Chart in Google Sheets(Quick & Easy Guide) Read More »

How to Add Average Line to Chart in Google Sheets(Quick & Easy Guide)

Google Sheets / By addnewskills

In this tutorial, you will learn How to add average line to chart in Google Sheets . How to Add Average Line to Chart in Google Sheets : Step by Step Guide Here are the steps to How to Add Average Line to Chart in Google Sheets Step 1 : Prepare your dataset Open Google …

How to Add Average Line to Chart in Google Sheets(Quick & Easy Guide) Read More »

How to Insert a Signature in Google Docs(Quick & Easy Guide)

Google Docs / By addnewskills

In this tutorial, you will learn How to Insert a Signature in Google Docs To insert a Signature in Google docs you can use Adobe Acrobat Sign which will create a unique digitally signed signature for you. How to Insert a Signature in Google Docs: Step-by-Step Guide Here are the steps to insert a signature …

How to Insert a Signature in Google Docs(Quick & Easy Guide) Read More »

How to make a Venn Diagram on Google docs(Quick & Easy Guide)

Google Docs / By addnewskills

In this tutorial you will learn How to make a Venn Diagram on Google docs How to make a Venn Diagram on Google docs(Quick Overview) Open Google docs document Now Click on the Insert tab,Choose Drawing->New Select a Circle from Shapes Eliminate the fill color and Make it transparent. Add text using text boxes in …

How to make a Venn Diagram on Google docs(Quick & Easy Guide) Read More »

How to Delete a Google Doc(Quick & Easy Guide)

Google Docs / By addnewskills

In this tutorial, you will learn How to delete a Google doc. How to Delete Google Docs Document How to Delete a Google Doc: Step by Step Guide Here are the steps to delete a Google doc. Method 1: Without opening the Google docs document Step 1: Sign in to your Google Drive Step 2: …

How to Delete a Google Doc(Quick & Easy Guide) Read More »

How to Change font in Google forms(Quick & Easy Guide)

Google forms, Software & Apps / By addnewskills

In this tutorial you will learn How to Change font in Google forms How to Change font in Google forms(Quick Overview) How to Change font in Google forms : Step by Step Guide Step 1: Logon to Google forms and open a form Step 2 : Click on the Customize theme icon . Click on …

How to Change font in Google forms(Quick & Easy Guide) Read More »

How to Create a Purchase Order in Google Sheets(Fast & Easy Guide )

Google Sheets / By addnewskills

How to create purchase order template in google sheets

In this tutorial you will learn How to Create a Purchase Order in Google Sheets How to Create a Purchase Order in Google Sheets : Step by Step Guide Here are the steps to create a Purchase Order in Google Sheets : Step 1 : Open the Google Sheets Purchase Order Template Step 2 : …

How to Create a Purchase Order in Google Sheets(Fast & Easy Guide ) Read More »