• Keyboard Shortcuts

    Shortcut keys help provide an easier and quicker method of navigating and executing commands in the computer software.

  • Hardware Tips

    Learn about the latest computer hardware and find out how to diagnose

  • Knowledge Practise questions and answers

    Here you can practise more questions and answers to improve your knowledge on computer

Showing posts with label Easily sort data in Microsoft Excel by using the auto filter. Show all posts
Showing posts with label Easily sort data in Microsoft Excel by using the auto filter. Show all posts

Tuesday 9 January 2018

How to create a spreadsheet

How to create a spreadsheet

To create a spreadsheet, you must either have a spreadsheet program installed on your computer capable of creating a spreadsheet or use an online service capable of creating a spreadsheet.

Note: Although some computers may come with a trial version of Microsoft Excel that can be used for a limited time to create a spreadsheet, almost all Windows computers do not include a spreadsheet program. The only exception was the Microsoft Surface with Windows RT, which is no longer available. There are also many versions of Linux that include LibreOffice.

Tip: If you are already in a worksheet (workbook) and want to create a new sheet tab within the workbook see our how to create, delete, rename, and move a worksheet in Excel page.

The most common and widely used spreadsheet program is Microsoft Excel. However, because of all of the different needs of users today, we've included additional options that are available for creating a spreadsheet.

  • Create a spreadsheet with Google Sheets
  • Create a spreadsheet with Microsoft Excel
  • Create a spreadsheet with LibreOffice and OpenOffice

Create a spreadsheet with Google Sheets

Google Sheets is one of our favorite solutions for most users, especially new computer users, because it is free, easy to access, supports collaborative editing, can open other spreadsheet files, and can be accessed from any device. To use Google Sheets, follow the steps below.

Visit https://docs.google.com/spreadsheets/


If prompted, log into your Google account.
 

Click the green plus to start a new blank spreadsheet or select from one of the pre-made templates.
 

After creating and opening a new spreadsheet, any information can be added. As you continue to work, Google automatically saves all changes. To name the spreadsheet, click on "Untitled spreadsheet" in the top-left corner and enter a new name. You can also click the share button in the top-right corner to share the spreadsheet to work collaboratively.

Create a spreadsheet with Microsoft Excel

To use Microsoft Excel to create a spreadsheet, follow the steps below.

Open Excel in Windows


Open Microsoft Excel. If you're not sure how to open or find Excel, skip to the finding Microsoft Excel section.
 

Once Excel is open, any new information and formulas can be entered.
Once complete or while working on the spreadsheet, you can Save your work through the File tab to the destination of your choice.
 

How to find Microsoft Excel in Windows
In Windows, click the Start button.


In the search box, type excel. If Excel is installed on the computer, it will be shown in the search results. For example, you may see Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 365.


Tip: In Windows 10, the search box is on the Taskbar next to the Start button. In Windows 8, start typing excel on the Start page and the search results will show on the right side of the screen.

How to install Microsoft Excel

If Excel is not installed, it would need to be installed on the computer. Today, the latest version of Excel is included in Office 365 and requires a subscription. You can download Office 365, which includes Excel, Word, and other Office applications, from https://www.office.com/.

Tip: If you've purchased Office or Excel in the past, older versions of Office can also be installed on newer computers, even those running Windows 8 or Windows 10. You must have the installation discs to install Office or Excel again.

Create a spreadsheet with LibreOffice and OpenOffice
LibreOffice and OpenOffice Calc are other great free products that allow anyone to create spreadsheets on their computer and can even support most of the features in Excel. Below are the steps on how to run LibreOffice and OpenOffice in Windows.

Open LibreOffice and OpenOffice in Windows

In Windows, click the Start button
In the search box, type calc. If LibreOffice or OpenOffice is installed, either LibreOffice Calc or OpenOffice Calc is shown in the search results.
Tip: In Windows 10, the search box is on the taskbar next to the Start button. In Windows 8, start typing calc on the Start screen and the search results are shown on the right side of the screen.

How to install LibreOffice or OpenOffice

LibreOffice can be downloaded from https://www.libreoffice.org/ and OpenOffice can be downloaded from https://www.openoffice.org/.

Once either of these programs has been installed on the computer, you can follow the steps above to create a spreadsheet.

Related Articles:)


How do I create a computer file?
How to create, delete, rename, and move a worksheet in Excel.
See our spreadsheet definition for further information and related links on these terms.

Easily sort data in Microsoft Excel by using the auto filter

Easily sort data in Microsoft Excel by using the auto filter

Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be sorted by using the Auto filter option. To use this option follow the steps below.

Select the top rows of the columns you want to be used.


Click Data
Click Filter and select Auto Filter.
Once successfully completed you can use drop down arrows to filter the data automatically. In the example below table following the above steps you'd highlight the top row from "Name" to "Position". After created you'll have down arrows next to each of the table headings. If for example you were to click the down arrow next to Position you could sort the table to only show programmer positions.

Name                 Sex    Age    Position
John                     M       34    Programmer
Jane
                     F    23    Customer Service
Bob
                     M    56    Programmer

Additional information
How do I sort a list in Microsoft Excel?
How to create a custom sort in Microsoft Excel.
See our sort definitions for further information and related links on these terms.


Good Morning Beautiful

Do you know????

Do you know????
/