SKILLSHARE ULTIMATE EXCEL COURSE 2 ESSENTIAL SKILLS FOR WORKING WITH LARGE SPREADSHEETS-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:16
Category:
Genre:
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:
- Keeping parts of a spreadsheet visible on screen as you scroll.
- Splitting a spreadsheet so that you can view two completely different parts of the sheet at the same time.
- Hiding and unhiding columns to temporarily remove less important data.
- Sorting a list including a super shortcut and how to sort a list on multiple levels.
- How to filter a list - one of Excel's most used features. Powerful, versatile, easy and quick.
- Scaling a print to fit on fewer pages.
- Printing the headers on every page.
- Printed a selected range only and setting a print area.
- Aligning a printed range to the centre of the page.
- Using page breaks to logically break a print over multiple pages.
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:
- Keeping parts of a spreadsheet visible on screen as you scroll.
- Splitting a spreadsheet so that you can view two completely different parts of the sheet at the same time.
- Hiding and unhiding columns to temporarily remove less important data.
- Sorting a list including a super shortcut and how to sort a list on multiple levels.
- How to filter a list - one of Excel's most used features. Powerful, versatile, easy and quick.
- Scaling a print to fit on fewer pages.
- Printing the headers on every page.
- Printed a selected range only and setting a print area.
- Aligning a printed range to the centre of the page.
- Using page breaks to logically break a print over multiple pages.