How to Import CSV to Google Sheets

by

Different applications and systems generate reports in different formats. Considering the huge volume of data it can handle, CSV is a popular format for such reports. In this tutorial, you will learn how to import CSV files to Google Sheets. 

This way, you can work on a wide range of data from different applications. By using the methods given below, you’ll never have to worry about compatibility issues.

2 Methods of importing CSV files to Google Sheets:

  • Use the Open option under the File menu
  • Use a keyboard shortcut

Let us begin by looking at these methods one by one.

Read more

How to Print a Google Calendar

by

Do you need to print your Google calendar to share with others? Or to attach it to other documents as a reference? You can print your calendar and stick it on the fridge for visible access to all your tasks and events for the month.

We share how you can print your Google calendar in simple, step-by-step instructions.

Let us begin.

Read more

How to Insert Subscript in MS Excel

by

When doing calculations or writing chemical formulas, you may need to insert a subscript in your Excel spreadsheet. 

Don’t know how to do it? You don’t have to worry as there are several methods to do that. Here are 8 methods that you can use to insert a subscript in your Excel workbook. 

8 Methods of inserting a subscript in Microsoft Excel:

  • Use the Font tab in Format Cells
  • Use keyboard shortcuts
  • Use the Subscript option
  • Use the Equation option
  • Use the Ink Equation option
  • Use third-party websites
  • Use the Custom option in the Number tab

Let us begin by looking at how each of these methods works.

Read more

How to Add the Developer Tab in MS Excel

by

Excel has many useful features like Macros, VBAs, and Add-ins. You can access these features via the Developer tab. However, the Developer tab is not visible by default. If you use these features often, you can add the Developer tab to your ribbon for quick access.

2 Methods of adding the Developer tab in Microsoft Excel:

  • Add the Developer tab via the menu ribbon
  • Add the Developer tab via general Options

Let us begin by looking at these methods in detail.

Read more

How to Insert an Object in MS Excel

by

While working in an Excel workbook, you may want to add extensive information to it. However, it’s easier to embed or link information. For example, you may want to insert a Word document or a PDF in your MS Excel workbook. For this, you can use the Object feature in Excel. By inserting an Object in MS Excel, you can embed an external object into the worksheet.

2 Methods of inserting an object in Microsoft Excel:

  • Insert an object by creating a new file
  • Insert an object by uploading an existing file

Let us begin.

Read more

How to Add Days to a Date in Google Sheets

by

Adding days to a date helps in determining deadlines efficiently. It can be helpful in stock management and simplify many other administrative tasks.

3 Methods to add days to a date in Google Sheets:

  • Use a formula where the same number of days have to be added
  • Use a formula where a different number of days have to be added
  • Use the End of Month formula

Let us begin.

Read more

How to Add Months to a Date in Google Sheets

by

4 Methods to add months to a date in Google Sheets:

  • Use the DATE function when the number of months to be added is the same.
  • Use the EDATE function when the number of months to be added are different.
  • Use the End of Month function.
  • Use a generic formula (handy only in particular cases).

Let us begin.

Read more

How to Publish an Event on Google Calendar

by

You can publish an entire calendar on a website for the public to see. Similarly, it is possible to publish a single event on Google Calendar as well. Google makes it easy to do so by providing a link for the event.

We will show you how to create an event on Google Calendar with simple step-by-step instructions. We will also show you how to publish this event.

Let us begin.

Read more