Working with large tables in Excel can be quite a challenge in several concerns: It is not always easy to display large tables properly, to compare them to figures from other tables or to print them out in a reasonable manner. However, Excel contains a number of functions that will help you perform the above tasks in a convenient way - even in large tables. In this Special Topic we will introduce all relevant tools and functions for working with larger tables and explain them to you step by step.

Published on: 24.07.2012

To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Working with Large Tables:  
In this video you will learn how to work with large tables and how Excel can help you by providing special functions. It is, for instance, possible to compare values or data sets within a single worksheet or between several worksheets. (6 Min.)

Printing Large Tables:  
In this video you will learn how to modify large tables for printing. We show you how to display the headings of the rows and columns on every page and how to optimize the layout. (5 Min.)



Excel 2013

Working with Large Tables:  
In this video you will learn how to work with large tables and how Excel can help you by providing special functions. It is, for instance, possible to compare values or data sets within a single worksheet or between several worksheets. (6 Min.)

Printing Large Tables:  
In this video you will learn how to modify large tables for printing. We show you how to display the headings of the rows and columns on every page and how to optimize the layout. (5 Min.)



Excel 2010

Working with Large Tables:  
In this video you will learn how to work with large tables and how Excel can help you by providing special functions. It is, for instance, possible to compare values or data sets within a single worksheet or between several worksheets. (6 Min.)

Printing Large Tables:  
In this video you will learn how to modify large tables for printing. We show you how to display the headings of the rows and columns on every page and how to optimize the layout. (5 Min.)



Excel 2007

Working with Large Tables:  
In this video you will learn how to work with large tables and how Excel can help you by providing special functions. It is, for instance, possible to compare values or data sets within a single worksheet or between several worksheets. (6 Min.)

Printing Large Tables:  
In this video you will learn how to modify large tables for printing. We show you how to display the headings of the rows and columns on every page and how to optimize the layout. (4 Min.)