Manage Large Excel Spreadsheets

Course

Online

£ 50 + VAT

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

Online

Start date

Different dates availableEnrolment now open

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

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

On-demand, 24/7 access 0.7 hours of video Certificate of completion Source code and PDF notes Closed captions

Manage Large Excel Spreadsheets

£ 50 + VAT