Excel for Data Analysis and Visualization

Viewing many parts of the spreadsheet (at the same time)

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

When working on spreadsheets, you often need to work on different parts of the spreadsheet at the same time. Perhaps you are building the capital expenditure requirements but you want to see how revenue is changing to match capex with activity. Or you want to see the consolidated income while working on one of the divisions.

In this lesson you will learn about:

  • Freezing the panes
  • Splitting the screen so you can see row 10 while looking at row 1000
  • Watching key cells as you move around your spreadsheet
  • See two (or more) spreadsheet workbooks next to each other
  • See two sheets WITHIN the same spreadsheet at the same time

Split Screens

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop