📊

Introduction to Excel 2013 - Lecture Notes

Jun 4, 2024

View transcript

Introduction to Excel 2013

Instructor Introduction

  • Instructor: Sumit Bansal
  • Course based on Excel 2013, applicable to 2007 and 2010 versions
  • New features in 2013 will be highlighted

Excel Structure Overview

Workbook & Title Bar

  • Default workbook title: Book1 (changes upon saving)
  • Right options:
    • Close (X)
    • Restore Down/Maximize
    • Minimize
    • Tab/Ribbon Display Options
    • Help (F1)
  • Quick Access Toolbar (Left): Save, Undo, Redo

Tabs & Ribbons

  • Tabs Examples: File, Home, Insert, etc.
  • File Tab: Backstage View – Info, New, Open, Save, Print
  • Groups in Home Tab: Clipboard, Font, Alignment, etc.
  • Insert Tab Examples: Tables, Illustrations
  • Name Box: Displays address of selected cell
  • Formula Bar: Enter/edit data/formulas directly
  • Work Area: Contains rows (up to 1 million+) and columns (up to XFD)
    • Cell addresses (e.g., B7, F9)

Sheets & Navigation

  • Bottom strip: Displays worksheets (Sheet1, Sheet2, etc.)
  • Navigation Arrows: For accessing multiple sheets
  • Horizontal & Vertical Scrollbars
  • Ready/Enter/Edit Modes
  • Macros Recording Button
  • Worksheet Display Options: Normal, Page Layout, Page Break
  • Zoom Slider: 10% to 400%

Navigating the Work Area

Using Mouse & Keyboard

  • Click cells, Scrollbars
  • Arrow keys
  • Keyboard Shortcuts:
    • Page Up/Page Down
    • Alt + Page Down/Page Up for horizontal navigation
    • Ctrl + Page Up/Page Down for sheets
    • Ctrl + mouse wheel for zoom
  • Using Name Box: Type cell address (e.g., D100, AM120)

Ribbon & Tabs Features

  • Introduced in Excel 2007
  • Tab examples: Home, Insert, Formulas
  • Groups within tabs (e.g., Function Library in Formulas)
  • Button Types:
    • Action Buttons: Perform an action when clicked
    • Toggle Buttons: Switch state when clicked again
    • Drop-downs: For selecting options

Quick Access Toolbar (QAT)

  • Default Options: Save, Undo, Redo
  • Customization:
    • Add More Commands
    • Position above/below Ribbon

Dialog Boxes & Task Panes

  • Dialog Box Launcher: Detailed control options
  • Task Panes (Excel 2013): Stay open while editing

Customizing Ribbon & Quick Access Toolbar

  • Right-click -> Customize Ribbon/QAT
  • Create new tabs/groups
  • Add commands to tabs/QAT

Active Cell Concept

  • Only one active cell at a time
  • Displays in Name Box
  • Select multiple cells but only one is active

Using Keyboard Shortcuts for Ribbon

  • Alt Key: Access tabs/menu options
  • Combination Keys: Perform specific actions (e.g., Alt + H for Home)

Summary

  • Efficient use of keyboard shortcuts
  • Detailed coverage of Excel structure and navigation

Conclusion: This video provided an introductory overview of Excel’s structure, navigation, and basic features, emphasizing the customization of ribbons and toolbars for efficiency.

Full transcript