Ultimate Excel Course #2 - Essential Skills for Working with Large Spreadsheets

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (55m)
    • 1. Introduction

    • 2. Keeping Headers Visible on Screen as you Scroll

    • 3. Splitting a Spreadsheet for Referencing Two Differnet Areas

    • 4. Hiding and Unhiding Columns

    • 5. Sorting a Large List - Including a Super Shortcut

    • 6. Filtering a List - One of Excel's Most Useful Tools

    • 7. Scaling a Print to Fit onto Fewer Pages

    • 8. Repeat your Headers across Multiple Pages

    • 9. Printing a Selected Range and Setting a Print Area

    • 10. Aligning a Print on a Page

    • 11. Using Page Breaks to Logically Break Up a Print

    • 12. Thank you


About This Class


This is class #2 of a series called the Ultimate Excel Course.

In this class you will learn essential skills for working with large spreadsheets in Excel.

These skills will supercharge your ability to work with large sets of data.

These essential skills include;

  1. Keeping parts of a spreadsheet visible on screen as you scroll.
  2. Splitting a spreadsheet so that you can view two completely different parts of the sheet at the same time.
  3. Hiding and unhiding columns to temporarily remove less important data.
  4. Sorting a list including a super shortcut and how to sort a list on multiple levels.
  5. How to filter a list - one of Excel's most used features. Powerful, versatile, easy and quick.
  6. Scaling a print to fit on fewer pages.
  7. Printing the headers on every page.
  8. Printed a selected range only and setting a print area.
  9. Aligning a printed range to the centre of the page.
  10. Using page breaks to logically break a print over multiple pages.

The spreadsheets used during the lessons are available for download from the Project area. You can use these to follow along with me.

The class project provides an exercise to recap on what we covered during the class. Any questions, please post them in the discussion area.

Grab a coffee, enrol and let's do this.

Please note that this is class #2 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions - The Decision Making Formulas of Excel

Class #4 - Conditional Formatting - Make your Data Come to Life

Class #5 - Lookup Functions - The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot