custom code gtranslate code

Microsoft Office Excel Level 3 Data List Management

Focus on Data List Management in Level 3. Data is very useful if it is maintained and sorted properly! Save time and work faster by learning how to import data from external sources such as websites.

Course Outlines

  • Working with Multiple Worksheets
  • Working with Multiple Workbooks
  • Formulas and Functions Review
  • Formula Auditing
  • Linking and Consolidating Data
  • Advanced Formulas
  • Defined Names and Range Names
  • Data Validation
  • Worksheet Security
  • Summarizing Data
  • Maintaining Data
  • Pivottables
  • External Data

What you'll learn

  • Create tables, add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods.
  • Filter data in a list using a variety of methods, as well as work with filtered data.
  • Create and work with subtotaled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, Pivot Charts, and Slicers.
  • Import external data from a variety of sources into Excel.

Course Content

  • Create tables, add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods.
  • Filter data in a list using a variety of methods, as well as work with filtered data.
  • Create and work with subtotaled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, Pivot Charts, and Slicers.
  • Import external data from a variety of sources into Excel.

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:

Rachael McPherson, Director of Sales

☎(250)882-9549

📧rachael@qacademy.tech

Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada

☎(514)771-3206

📧caroline.santos@qacademy.tech

Student Ratings & Reviews

Course Info

Prerequisites
This course does not require any prerequisites but to ensure that the participant can maximize the learnings from this course, they are expected to have working knowledge of Level 1 and Level 2.
Duration
6 Hours

Enroll Now

1:1 Price
$475.00
For Group Class Options

Enroll Now

For Corporate and Funding Agencies
popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Tanvir Qureshi
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number
0(0)

Microsoft Office Excel Level 3 Data List Management

  • Course level: Expert

Description

Focus on Data List Management in Level 3. Data is very useful if it is maintained and sorted properly! Save time and work faster by learning how to import data from external sources such as websites.

About the instructor

5.00 (1 ratings)

67 Courses

5 students

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

Phone Number

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup