• BUS 115 - Business Applications: Excel in Practice
  • Acknowledgements
  • Excel Overview
  • Time Saver
  • Auto Fill and Fill Series
  • Cell Referencing
  • Absolute and Relative Referencing
  • Navigation Shortcuts
  • Managing Cells
  • Sorting and Filtering
  • Hiding and Grouping
  • Paste Special
  • Named Ranges
  • Ranking
  • Rounding
  • Sum and Count
  • Managing Worksheets
  • Lookup Functions
  • Data Validation
  • IF Statements
  • Formula Errors
  • Text Functions
  • Text to Columns
  • Logic Functions 2
  • Date and Time
  • Conditional Formatting 1
  • Standards of Professionalism
  • Spreadsheet Formatting and Design
  • Basic Charts
  • Dashboards
  • Conditional Formatting 2
  • Spreadsheet Protection
  • Basic Pivot Tables
  • Advanced Pivot Tables and Slicers
  • Logic Functions 3
  • Advanced Lookup Functions
  • Loan Amortization Schedule
  • Advanced Charts
  • Macros 1
  • Macros 2
  • Macros 3
  • How to Use Search Engines
  • Sandbox
  • Author Biographies
  • Why the Standards of Professionalism?
  • Learning New Functions
  • Download
  • Translations
  • Sandbox

    Practice Spreadsheet

    Download this workbook for the chapter.

    Cell Referencing and Anchoring

    1.1
    Figure 1

    Figure 1Time Saver

    This semester, we are going to be watching a lot of videos. Before we get started in Excel, let’s take a few minutes to learn how to use the video player to the best of its capabilities, as well as how to use it in conjunction with Excel.

    What color is the sky?

    1. Red
    2. Blue
    3. Yellow

    Many of you already know how to use these embedded video players, but the following handful of tips will be very useful to you as you work with Excel. If you follow these tips, you may save hours of time over the course of this semester. 

    Typically, when we see a video, we would hit the play button or make it full screen. Instead of doing that, complete the following.

    1. Right click on the Play button in the center.
    2. Choose Open Link in New Tab or Open Link in New Window.
      1. The video will open on its own page.

    Control Bar

    When you push play, you can then hit the same button and push pause. The volume control is the button to the right, and can be adjusted up or down. Directly beside it is the minute counter. This tells you how many minutes there are and how many minutes have passed in the video. On the right hand side, the arrows represent the full screen mode. If you select full screen, it will take up the whole screen. Push Escape on your keyboard to exit full screen. (See Figure 01 for reference.)

    Figure 01

    There is a closed captioning (CC) button on the left side of the control bar. If you would like, you can turn closed captioning on to English. When you do that, the text of the video will be shown at the bottom as the video is progressing. You can turn closed captioning off by selecting the CC button and then selecting Off

    https://books.byui.edu/-cZwX

    1. Hey
      1. yes

    Supplemental Resource

     

    This content is provided to you freely by EdTech Books.

    Access it online or download it at https://edtechbooks.org/bus_115_business_app/sandbox.