What can you use Excel for in your personal life?

What can you use Excel for in your personal life?

Create a Calendar or Schedule: Whether it is family based planning for a weekly, monthly or yearly calendar or a personal appointment daily planner or a schedule for managing bill payments, homework, favorite sport team’s games, and many more, the excel can make it easy to compile, filter, search, organize and simplify …

How can I make Excel easier for my life?

8 Excel Features That Will Make Your Life Easier

1. Format phone numbers and email addresses.
2. Separate first and last names.
3. Concentrate already separated names.
4. Extract first or last initials from names.

How do you use Excel as a To Do list?

Create simple to do list with drop down list

1. In the Data Validation dialog box, under the Settings tab, please choose List from the Allow drop down, and then click button to select the cell values you want to use in the drop down, see screenshot:
2. Now, the drop down lists have been inserted into the cells.

How do you organize in Excel?

How to Sort in Excel

1. Highlight the rows and/or columns you want sorted.
2. Navigate to “Data” along the top and select “Sort.”
3. If sorting by column, select the column you want to order your sheet by.
4. If sorting by row, click “Options” and select “Sort left to right.”
5. Choose what you’d like sorted.
6. Choose how you’d like to order your sheet.

What are Vlookups used for?

VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.

How many chart types does excel offer?

19 Chart Types

How many types of MS Excel?

three types

How do you resize a chart?

Resize a chart

1. To change the size manually, click the chart, and then drag the sizing handles to the size that you want.
2. To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box.

How do I reduce the area in an Excel chart?

Click the chart, and click Layout tab (or Format tab). See screenshot: 2. Then go to the Current Selection group, and select Chart Area by clicking the drop down arrow.

How do you change the scale of a worksheet in Excel?

You can shrink or enlarge a worksheet for a better fit on printed pages. To do that, in Page Setup, click the window launcher button. Then, click Scaling > Adjust to, and then enter the percentage of the normal size that you want to use.

What is the Resize pointer in Excel?

Click anywhere on the white space of the chart area, plot area, or legend you want to move or resize. Point the mouse to one of the grab handles or resize cursor—the pointer changes to a double-headed arrow—to resize the chart. Use the mouse to drag the sizing handle until the chart is resized to the desired size.

What do sizing handles look like?

The sizing handles will typically appear as small circles or squares. To use sizing handles, hover mouse over a handle until mouse pointer changes to a double-headed arrow, click and drag handle to resize.

How do I resize an embedded chart in Excel?

To move the chart, position the mouse pointer or Touch Pointer in a blank area inside the chart and drag the chart to a new location. To resize the chart (you may want to make it bigger if it seems distorted in any way), position the mouse pointer or Touch Pointer on one of the sizing handles.

What are the basic rectangular building blocks of a spreadsheet?

Cell – cells are the basic rectangular building blocks of a spreadsheet. They are assigned an address, generally referred to as a cell reference, according to their column and row (e.g. the cell in column B at row 3 is referenced as cell B3).

What are the basic building blocks of a spreadsheet?

Cells are the basic building blocks of a worksheet. They can contain a variety of content such as text, formatting attributes, formulas, and functions. To work with cells, you’ll need to know how to select them, insert content, and delete cells and cell content.

What are the blocks in Excel called?

The cell. An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called cells.

What is a Excel file called?

In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.

What are the 4 major parts of Excel?

Terms in this set (24)

• Workbooks, Worksheets, Tables and Charts. Four major parts of Excel.
• Home, Insert, Page Layout, Formulas, Data, Review, and View. When you start Excel, the Ribbon displays these seven top-level tabs.
• Shortcut menu.
• What constitutes a “number” in Excel.
• Merging cells.
• Embedded chart.
• Legend.
• ECS key.

Why is Excel called Excel?

Microsoft was initially developed Multiplan, a spreadsheet program for CP/M system but unfortunately in MS-DOS, Multiplan was losing to Lotus 123. The name of Excel was picked to give impression of ‘It can do everything Lotus 123 does, but exceptionally better.

Who is the father of MS Excel?

Charles Simonyi

Who found MS Excel?

Microsoft Corporation

Why did Microsoft develop Excel?

Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which was very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. This promoted development of a new spreadsheet called Excel which started with the intention to ‘do everything 1-2-3 does and do it better’.