Excel Data Tools and Data Management

To claim QLS Endorsed Certificate for this course, please go to the curriculum section & submit your assignment. To claim …

0 0 Rating ( 0 Reviews )

154 Students

Bestseller

Great Service

Highly Rated

Trending

i Last Updated: 19th April 2023

◎ English

Flexible Schedule

Unlock 3,000+ Courses & Unlimited Free Digital Certificates for £99 Only! Grab Now

To claim QLS Endorsed Certificate for this course, please go to the curriculum section & submit your assignment.
To claim CPD Accredited Certificate for this course, please go to the certificate section & collect your certificate.

Course Curriculum

Excel Data Tools and Data Management
	Module 01: Introduction	00:03:00
	Module 02: Project Files	00:00:00
	Module 03: Data Validation Rules to Prevent Bad Data Entry	00:09:00
	Module 04: Drop Down Lists for Easy Data Entry	00:06:00
	Module 05: Custom Validation Messages and Alerts	00:06:00
	Module 06: Splitting Data into Different Columns by Delimiter	00:04:00
	Module 07: Splitting Data of a Fixed Width	00:03:00
	Module 08: Easily Remove Duplicate Rows from a List	00:04:00
	Module 09: The Incredible Flash Fill Tool	00:08:00
	Module 10: Goal Seek – How to Reach the Result You Want	00:06:00
	Module 11: Data Table – Test Multiple Values Impact on a Formula Result	00:07:00
	Module 12: The New Rich Data Types in Excel	00:06:00
Assignment
	Assignment – Excel Data Tools and Data Management	00:00:00