Microsoft Excel - Computer Fundamentals - Lecture Slides, Slides of Computer Science

Download Microsoft Excel - Computer Fundamentals - Lecture Slides and more Slides Computer Science in PDF only on Docsity!

Microsoft Excel

Table of Contents

1_ Introduction to Excel 2_ Overview of the Excel Screen 3_ The Excel Menus: File Menu Edit Menu Insert Menu Format Menu View Menu Help Menu and Office Assistant 4_ Excel Worksheets 5_ Entering Formulas and Data 6_ Formatting Workbooks 7_ Charts 8_ Freezing Panes 9_ Printing 10_ Keyboard Shortcuts

Overview of the Excel Screen

Before working with Excel, it is essential to first become familiar with the Excel screen. The following will help you to recognize the various parts of an Excel screen and their functions.

The Title bar is located at the very top of the screen. The Title bar displays the name of the workbook you are currently using.

The Menu bar is located just below the Title bar. The Menu bar is used to give instructions to the program.

Overview of the Excel Screen

Toolbars select Toolbars, then select which toolbar you wish to add to the screen. provide shortcuts to menu commands. There are many different toolbars and the user can choose which toolbars are shown on the screen. To enable more toolbars go to “View” on the Menu bar, The Standard Toolbar provides shortcuts to the File Menu, as well as mathematical functions, chart creation, and sorting.

The Formatting Toolbar provides shortcuts to font formatting as well as mathematical functions.

The Status Toolbar allows the user to view if the current worksheet is ready to enter data.

Overview of the Excel Screen

• The Name Box indicates what cell you are in. This cell is called the “active cell.” This cell is highlighted by a black box.
• The “=” is used to edit your formula on your selected cell.
• The Formula Bar indicates the contents of the cell selected. If you have created a formula, then the formula will appear in this space.

File Menu

• When first opening Excel a worksheet will automatically appear. However, if you desire to open a file that you previously worked on go to the “File” option located in the top left corner. Select “Open.”
• To create a new worksheet go to the “File” option and select “New.”
• To save the work created go to the “File” option and select “Save.”
• To close an existing worksheet go to the “File” option and select “Close.”
• To exit the program entirely go to the “File” option and select “Exit.”

Insert Menu

• The Insert Menu allows

you to:

• Add new worksheets,

rows, and columns to an existing.

• You can also insert

charts, pictures, and objects onto your worksheet.

Format Menu

• You can change the

colors, borders,

sizes, alignment,

and font of a

certain cell by going

to the “Cell” option

in the Format

Menu.

View Menu

• The View menu allows you

different options of viewing your work.

• You can enable a Full Screen

view that changes the view to include just the worksheet and Menu bar.

• You can zoom in on your

worksheet to focus on a smaller portion.

View Menu

• You can change the view

of your work so that it is page by page.

• You can insert Headers

and Footers to your work.

• You can add comments

about a specific cell for future reference.

Excel Worksheets

With Excel, you will be working with different worksheets within a

workbook. Often times it is necessary to name the different

worksheets so that it is easier to find them. To do so you must:

1_Double click to highlight an existing worksheet

2_Type in what you would like to rename the worksheet

Entering Formulas

• When entering numerical data, you can command Excel to do any mathematical function.
• Start each formula with an equal sign (=). To enter the same formulas for a range of cells, use the colon sign “:”

ADDITION FORMULAS

 To add cells together use the “+”

sign.

To sum up a series of cells,

highlight the cells, then click

the auto sum button. The

answer will appear at the

bottom of the highlighted box.

Tips for Entering Data

• To highlight a series of cells click and drag the mouse over the desired area.
• To move a highlighted area, click on the border of the box and drag the box to the desired location.
• You can sort data (alphabetically, numerically, etc). By highlighting cells then pressing the sort shortcut key.

Tips for Entering Data

• You can cut and paste to move

data around.

• To update your worksheets,

you can use the find and replace action (under the Edit Menu).

• To change the order of

worksheets, click and drag the worksheet tab to the desired order.