Excel Chapter 1: Getting Started with Excel

Excel Chapter 1: Getting Started with Excel

Skill 1.1: Introduction to Excel

  • Microsoft Excel is a spreadsheet program used to enter, manipulate, calculate, and visualize numerical and text data.

  • An Excel file is called a workbook, consisting of multiple worksheets (or sheets).

  • Each worksheet comprises data arranged in rows and columns, allowing for calculation and data analysis.

Basic Elements of an Excel Workbook

  • Worksheet: An electronic ledger for entering data.

  • Row: A horizontal group of cells, identified by numbers.

  • Column: A vertical group of cells, identified by letters.

  • Cell: The intersection of a row and a column, identified by its cell address (e.g., A1).

  • Cell Range: A contiguous group of cells (e.g., A1:A10).

  • Formula Bar: Area for data entry, below the Ribbon and above the worksheet grid.

  • Name Box: Displays the address of the selected cell, located at the left side of the formula bar.

  • Status Bar: Located at the bottom of the worksheet, displays information about selected cell data.

Skill 1.2: Navigating a Workbook

  • An Excel worksheet can contain over one million rows and over sixteen thousand columns.

  • Scroll Bars: Vertical (right side) and horizontal (bottom) scroll bars allow navigation through the worksheet.

  • Selecting Cells:

    • Click on the cell with the mouse to select.

    • To select a range, click the first cell and drag the mouse to cover the desired range.

    • Click the row or column selector (the gray area) to select entire rows or columns.

Skill 1.3: Working in Protected View

  • Protected View displays files in read-only format to protect against viruses or malware.

  • Files in this mode show a warning Message Bar below the Ribbon.

  • To edit, click Enable Editing in the Message Bar or navigate through the File > Info page to disable it.

  • Files enabled for editing become part of the Trusted Documents list, preventing them from re-opening in Protected View unless the list is cleared.

Skill 1.4: Entering and Editing Text and Numbers in Cells

  • To enter data:

    1. Click the desired cell.

    2. Type the text/number.

    3. Press Enter or Tab to move to the next cell.

    • Enter moves down; Tab moves right.

  • To edit cell content:

    • Ready Mode: Click cell and type to replace content.

    • Edit Mode: Double-click the cell, and then modify the content at the blinking cursor.

Skill 1.5: Applying Number Formats

  • Number formatting changes how data appears without altering the actual value; Excel uses General format by default.

  • Common Number Format buttons can be found in the Home tab in the Number group:

    • Accounting Number Format, Percent Style Format, Comma Style Format, Increase Decimal, and Decrease Decimal.

  • Access the Number Format menu through the Number format arrow for additional formats (Currency, Percentage, etc.).

Skill 1.6: Entering Dates and Applying Date Formats

  • Two formats are available: Short Date Format and Long Date Format.

  • To apply a date format:

    • Click the Number Format arrow, select a format, and click OK.

Skill 1.7: Inserting Data Using AutoFill

  • AutoFill allows filling adjacent cells with the same data or extending data series through the Fill Handle at the cell's bottom right corner.

  • Alternatively, the Fill command can be found on the Home tab.

Skill 1.8: Exploring Charts

  • A chart is a visual representation of data (columns, bars, pie pieces, etc.).

  • Selecting appropriate chart types (e.g., column, pie) based on data relationships is crucial for effective data presentations.

  • Most charts utilize both y-axis (vertical) and x-axis (horizontal) for plotting data.

Skill 1.9: Using the Recommended Charts Feature

  • Access recommended charts via the Quick Analysis Tool by selecting data and choosing the Charts tab.

  • Hover over the charts to view live previews and select the preferred chart type.

Skill 1.10: Entering Simple Formulas

  • Formulas in Excel are equations for calculations, starting with = (e.g., =B17 + B18).

  • Common mathematical symbols:

    • + for addition, - for subtraction, * for multiplication, / for division.

Skill 1.11: Understanding Absolute and Relative References

  • Absolute references do not change when copied (e.g., $A$1), while Relative references do (e.g., A1).

  • Mixed references contain one fixed and one changing part (e.g., A$1).

Skill 1.12: Using Functions in Formulas

  • Functions are built-in calculations that use arguments to perform specific tasks (e.g., =SUM(B9:B14)).

  • Functions simplify complex calculations and streamline spreadsheet usage.

Skill 1.13: Using AutoSum to Insert a SUM Function

  • AutoSum inserts a SUM function based on cells next to the selected cell(s) automatically.

  • Adjust the range if necessary before pressing Enter to complete the function.

Skill 1.14: Calculating Totals with the Quick Analysis Tool

  • The Quick Analysis Tool helps calculate totals like SUM, AVERAGE, COUNT, % Total, and Running Total instantly.

Skill 1.15: Using the Status Bar

  • The status bar shows information about the worksheet. Customize it by right-clicking to manage its display.

Skill 1.16: Changing the Zoom Level

  • Use the zoom slider located at the bottom right of the Excel window to adjust the view of the worksheet.

    • Changes the onscreen size but does not affect printing.

Skill 1.17: Creating a New Workbook Using a Template

  • Templates are preformatted files used as starting points for new workbooks.

  • Templates can be accessed via File > New, and more can be searched online. Use the Create button to generate a new workbook from the selected template.

Skill 1.18: Arranging Workbooks

  • Multiple workbooks can be arranged in various layouts (Tiled, Horizontal, Vertical, or Cascading) through the View tab in the Window group.

Skill 1.19: Checking Spelling

  • Check spelling by using Review > Spelling or pressing F7. Follow the prompts to correct identified errors.

Skill 1.20: Previewing and Printing a Worksheet

  • To print the worksheet, go to File > Print, view the preview on the right, and click Print to finalize.

This comprehensive guide serves as an extensive overview of Excel functionalities covered in chapter 1. Each skill is designed to enhance user proficiency and streamline tasks within the Excel environment.