Excel courses

Learn Excel from basics to advanced


Télécharger Learn Excel from basics to advanced

★★★★★★★★★★3.5 étoiles sur 5 basé sur 1 votes.
Votez ce document:

Télécharger aussi :


Learn Excel from basics to advanced

..

Scroll

A way to display locations on the worksheet without changing the active cell.

Tabs of the sheet

Tabs that appear at the bottom of the workbook window and display the name of each worksheet.

SkyDrive

A file hosting service that lets you download and synchronize files in a virtual storage environment or in the cloud. The files are then accessible from a web browser or local device.

Scroll buttons

The buttons to the left of the sheet tabs allow you to scroll through the hidden tabs.

Model

A document containing formatting, styles, and a sample text that you can use to create new documents.

Workbook

An Excel file with one or more worksheets.

Worksheet

Work area for entering and calculating data consisting of columns and lines separated by grid lines (light gray lines). Also called spreadsheet.

Try it! Start Excel

q On the Windows Start screen, click the Excel 2013 program tile.

✓ If your keyboard has a Windows key (a key with the Windows logo), you can press this key at any time to display the start screen.

OR

  1. Right-click an empty area on the Windows Start screen.
  2. Click the All Apps button.
  3. Scroll to the Excel 2013 tile.
  4. Click Excel 2013.

OR

  1. Move the mouse pointer to the lower left corner of the screen.
  2. When you see Windows

Start screen icon, click to open the startup screen.

w Click the empty workbook.

e Explore the features of the Excel program window.

r Leave the file open for use during the next test.

Name and save a workbook

■ After entering data into a workbook, you must save it. Otherwise, this data will be lost when you leave Excel.

■ A saved workbook is called a file.

■ A file can be saved to a hard disk, removable disk, shared drive, or SkyDrive. Files stored on SkyDrive are virtually stored on the Microsoft SkyDrive.com website.

■ You must assign a name to the file when it is saved. The file names must be descriptive, with a limit of 255 characters for the name, disk drive, and path.



■ A file name can contain letters, numbers, and spaces, but not \ /: *? "<> Or | .

■ Excel automatically adds a dot and file type extension (usually .xlsx) to the end of the file name when you save it.

■ You must select a location in which to save your file, for example the Documents folder. You can also create new folders in which to store your workbooks.

■ The default Excel file format is .xlsx or Strict Open XML Spreadsheet file format. This XML-based file format makes it easier for your workbooks to integrate with external data sources and gives smaller file sizes than in earlier versions of Excel.

✓ You can install updates from older versions of Excel so that they can read the new .xlsx format.

■ Data can also be saved in other formats, such as HTML, Excel Binary (a file format for very large workbooks), or earlier versions of Excel (.xls).

✓ You may want to save data in a different format to share with someone using a different version of Excel or a web browser to view your data.

■ The Backstage view shows where you can save your file, such as SkyDrive or Computer. Backstage view is displayed the first time a file is saved.

✓ You can exit Backstage mode by clicking the Back button.

■ When you select Computer, the Recent Folders list provides the locations of recently opened folders.

■ You can select another storage location by double-clicking Computer or by clicking Browse.

■ Once you have saved a workbook, simply click the Save button to save the changes made since the last save action. You will not need to re-enter the file name.

■ You can save a previously saved file under a different name by using the Save As tab in the Backstage view.

■ Click Browse to find a location and click Save.

As the dialog box will open.

✓ If the location where you want to store the file is displayed in Backstage view, click it instead of clicking Browse.

■ In the Save As dialog box, you can rename the file, search for a location, and save the file.

Try it! Name and save a workbook

q Click the FILE tab.

OR

 Click the Save button for quick access.

Toolbar.

w Click Save As.

e Click Computer, and then click Browse.

OR

 Double-click on computer.

r In the File Name text box, type E01Try_xx.



✓ Replace xx with your own name or initials, as instructed by your teacher. For example, if your name is Mary Jones, type E01Try_MaryJones or E01Try_MJ.

t Use the navigation pane to navigate to the location where your teacher asks you to store the files in this lesson.

✓ Use the drop-down lists at the top of the Save As dialog box or the locations in the left navigation pane to select the folder in which to save. Click the triangle next to a disk or folder in the navigation pane to show or hide the contents of that location. If you are recording to a USB drive, make sure it is inserted. Scroll down the navigation pane and click on the USB drive under Computer. Refer to Lesson 1 in the General section of this book for more information on navigation.

y Click the Save button.

u Leave the file open for use during the next test.

Explore the Excel window

■ In the worksheet, a green border appears around the active cell.

■ You can edit the active cell with the mouse, touch device, or keyboard.

■ The data is entered in the active cell.

■ The Name box, to the left of the formula bar, displays the cell reference or cell address of the active cell (its column letter and line number). For example, A1 is the cell in the first row of the first column. B5 is the address of the cell in the fifth row of the second column.

■ To help you identify the cell reference for the active cell, Excel wraps the cell around a dark border and highlights its column letter (at the top of the worksheet) and its line number (to the left of the cell). spreadsheet). Column letters and line numbers are also referred to as column and line headers.

■ You can use the wyzx arrow keys (alone or in combination with other keys), special key combinations, the mouse, a touch device, or Go To p to select a cell in the current worksheet.

Try it! Explore the Excel window

q In the E01Try_xx file, press x twice.

w Press y four times.

e Click in the Name box, type b3 and press e.

r Press y.

t Click cell F13.

y Press b + g.

u Save the file E01Try_xx and leave it open.

to use in the next Try It.

Explore the Excel interface

■ In the Basics section of Microsoft Office, you learned that you can access common commands such as Save and Cancel through the buttons on the quick bar.

■ In the FILE tab, you can access file management commands such as New, Open, Save, and Print. Click the FILE tab to display the Backstage view.



■ The ribbon at the top of the Excel window provides buttons for the most common Excel commands.

■ The ribbon has several tabs. On each tab, the corresponding control buttons are organized into groups. Click a tab to view its contents, and then click a button to choose a command or view other choices.

■ Some tabs, called contextual tabs, only appear when you have selected an item to which the tab controls apply.

■ To access Help, click the Help button.

.........

Navigation in the spreadsheet

■ A spreadsheet contains 16,384 columns and 1,048,576 rows, but you do not need to fill out the entire worksheet to use it, just type data into the cells you need.

■ Because the workbook window displays only part of a spreadsheet, scroll down the worksheet to view another location.

■ With the mouse or a touch device, you can scroll using the horizontal or vertical scroll bars.

✓ Using the mouse or touch device to scroll does not change the active cell.

■ With the keypad, you can scroll by pressing specific keys or combinations of keys.

✓ Scrolling with the keyboard changes the active cell.

■ You can switch to a specific cell that is not displayed on the screen by using Go To or the Name box.

✓ You can also use the Name box to go directly to a named cell or range. This is discussed in Lesson 13.

■ The Go To function allows you to access a specific cell and activate it.

■ You can open the Go To dialog box by clicking HOME> Find and Select> Go To.

✓ In this book, the> symbol is used to indicate a series of steps.

■ When you type the cell address in the Reference box and select OK, this cell will become the active cell.



72