w3resource logo


gallery w3resource

Excel 2013 - Basics

Secondary Nav

 

Excel is an extremely powerful tool for manipulating a very large amount of data. It is really really works well for any type of day to day simple calculations and tracking almost any kind of information.

Transcript

Create a new workbook

The use of strong passwords lowers the risk of security breaches

Don’t

★ Excel documents are called workbooks.
★ Each workbook contain one or more sheets, called spreadsheets.
★ You can add as many sheets as you want to a workbook.
★ You can create new workbooks to keep your data separate.

Input your data

★ Click an empty cell. For example, cell B2 on the below sheet.
★ Type text or a number in the cell.
★ Press Enter or Tab to move to the next cell.

Create a simple formula

Here is some simple formulas to add, subtract, multiply or divide your numbers.
★ Move the mouse in a cell and type an equal sign (=).
★ Type a combination of numbers and calculation operators.
★ like plus(+) , minus(-), asterisk (*), or forward slash (/).

Create a simple formula

★ For example =(6+6*2)/3
Press Enter key to execute the above formula and press Ctrl+enter to stay in the cell

Apply a number format

Select the cells that have numbers you want to format. Click Home tab --> General.

Pick a number format and see.

Add your data use AutoSum

AutoSum adds up the numbers and shows the result in the cell you selected

Press Enter to get desire result.

Put your data in a table

★ Select your data by clicking the first cell and dragging to the cell in your data.
★ To use the keyboard, hold down Shift while you press the arrow keys to select your data.
★ Click the Quick Analysis button in the bottom-right corner of the selection.

After clicking Quick Analysis tool get the following menu then click on tables button.

To filter data, uncheck the Select All box to clear all check marks, and then check the boxes of the data you want to show in your table.

To sort the data, click Sort A to Z or Sort Z to A.

Show totals for your numbers

★ Select the cells which contain numbers which you want to add or count.
★ Click the Quick Analysis button in the right-bottom corner of the selection area.
★ Then click the Total button or move your cursor accross the Total button to see the calculation results for the data.

Add meaning to your data

★ Use the Quick Analysis tool for a Live Preview of your most important data trends by using conditional formatting.
★ Select the data you want for your analyzing.

★ Click the Quick Analysis button button; appears in the right-bottom corner of your selection.

★ Click on Analysis Tool and get the picture below.

★ Click on Formatting tab and get the options in the pop up box.

★ Now pick a color from Color Scale and click Sparklines and move the mouse pointer on the options and get instant preview.

Show your data in a chart

★ Select your data then click quick analysis tool

★ Click on Quick Analysis tool then click on Chart and move you mouse pointer on the recommended chart and see which one is your choice.

★ Click on your choice and the chart will appear in your data sheet.

Save your workbook

★ To save a file you can use the save button from the Quick Access Toolbar or press Ctrl+S.

★ You can save the file in another way. Click File -- > Save.

Save your workbook

Note :
★ Saving the workbook first time, the Save As window will appear.
★ You can choose the default showing folder for saving your workbook.
★ Or you can brows the folder where you want to save.
★ Then in the file name box type the name of the file and click on Save button.

Print your workbook

★ Click the File --> then click Print or press Ctrl+P from the keyboard



Join our Question Answer community to learn and share your programming knowledge.

Help the community:

Python: Fizzbuzz

C++: Decimal to binary conversion

JavaScript: Need Help in JavaScript

Python: Help me with this program