Manage Large Excel Spreadsheets
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Learn the ins and outs of data manipulation for large spreadsheets in Excel. This course will walk you through how to view your massive quantities of data easily, and to manage your data for quick comparisons. Further your Excel skills and manipulate your data like a professional.
You will learn how to:
Freeze and split panes to compare data across large distances
Sort list data by single and multiple columns
Filter lists by a variety of criteria
Hide and unhide columns
Set up your spreadsheet for printing based on your needs
Frameworks and tools covered: Microsoft Excel 2019
Facilities
Location
Start date
Start date
About this course
Microsoft Excel installed
Basic familiarity with Excel
The course is recorded on Windows and uses shortcuts for that operating system. However, the concepts covered are applicable to Mac.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 3 years
Subjects
- Excel
- Access
- MS Excel
- IT
- Management
Course programme
Introduction 0:54
Introduction 0:54
0:54
Freezing Panes 4:43
Freezing Panes 4:43
4:43
Split Panes 4:32
Split Panes 4:32
4:32
Sorting Data in a List 4:02
Sorting Data in a List 4:02
4:02
Sorting by Multiple Columns 3:43
Sorting by Multiple Columns 3:43
3:43
Filtering a List 10:50
Filtering a List 10:50
10:50
Hide and Unhide Columns 4:34
Hide and Unhide Columns 4:34
4:34
Useful Print Settings in Excel 11:12
Useful Print Settings in Excel 11:12
11:12
Additional information
Manage Large Excel Spreadsheets