Skip to content
Play overlay
Preview this course

Intro to Excel Data Tools and Data Management

Learn the fundamentals of Excel’s Data Tools to manage, manipulate, and organize all your spreadsheet data efficiently.

Zenva Academy

Summary

Price
£19 inc VAT
Study method
Online, On Demand What's this?
Duration
1.1 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
3 students purchased this course

Add to basket or enquire

Overview

Learn the fundamentals of Excel’s Data Tools to manage, manipulate, and organize all your spreadsheet data efficiently.

Curriculum

2
sections
13
lectures
1h 5m
total

    • 3: Data Validation Rules to Prevent Bad Data 08:39
    • 4: Drop Down Lists for Data Entry 05:31
    • 5: Custom Validation Messages and Alerts 06:08
    • 6: Splitting Data into Different Columns 03:43
    • 7: Splitting Data of a Fixed Width 03:14
    • 8: Remove Duplicate Rows from a List 03:58
    • 9: The Flash Fill Tool 08:17
    • 10: Goal Seek to Reach your Result 06:17
    • 11: Data Tables to Test Multiple Values 07:24
    • 12: The New Rich Data Types 06:29
    • 13: Additional Resources 01:00

Course media

Description

Master advanced data management and boost your productivity with Excel’s Data Tools. From dynamically organizing your data, to simplifying your methods for data processing and analysis, you will learn techniques that will help you to gain invaluable insights into your projects.

You will learn how to:

  • Set up data validation rules to prevent bad data
  • Separate text in a column
  • Quickly remove duplicate data from a list
  • Utilize flash fill to fill in data with a single click
  • Seek values by testing what-if scenarios for formulas
  • Utilize data tables and data types for more complex analysis

Who is this course for?

  • Entrepreneurs looking to effectively use data for business decisions
  • Job-seekers wanting to upskill into Excel for data-related positions
  • Anyone wishing to improve their business productivity
  • Beginning data analysts enhancing their knowledge of Excel's built-in tools

Requirements

A basic, working knowledge of Excel.

Career path

  • Excel Administrator: £22,379
  • Data Analyst: £36,636
  • Data Scientist: £58,832
  • Data Specialist: £46,152
  • Data Entry: £20,156

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Business management courses, Management courses, Online courses