SS1: SECOND TOPIC

Create, Formatting, and Adjusting Data in Excel

Create New Records with Excel

Creating new records using Excel can be an efficient way to migrate from a previous system, or manage workflows in an offline capacity. Since this process recommends importing the data first, it’s imperative to maintain the media filenames in the Filename field of the Excel spreadsheet. Once the data is added, uploading the media files follows. This allows the system to sync and match the media files with their corresponding data records.
To create a new record in Microsoft excel, perform the following step:
Click start or press window button
Go to All programs
Select Microsoft office
Click Microsoft Excel
After the application is ready for use, you will observe that the environment looks like the interconnection between rows and columns which then form a cell.
There is fixed alphabet letter from A-Z an more than that.
There exist a fixed number vertically from 1-2000+
Click on the first cell under A and type your data.
See below for example:

Adjust settings
1.To wrap text in a cell, select the cells that you want to format, and then on the Home tab, in the Alignment group, click Wrap Text.

To adjust column width and row height to automatically fit the contents of a cell, select the columns or rows that you want to change, and then on the Home tab, in the Cells group, click Format.

Under Cell Size, click AutoFit Column Width or AutoFit Row Height.
Tip    To quickly autofit all columns or rows in the worksheet, click the Select All button, and then double-click any boundary between two column or row headings.

Format the dataTo apply number formatting, click the cell that contains the numbers that you want to format, and then on the Home tab, in the Number group, click the arrow next to General, and then click the format that you want.

To change the font, select the cells that contain the data that you want to format, and then on the Home tab, in the Font group, click the format that you want.