Data Management and Analysis with Excel
Course Description In today’s data-driven world, proficiency in data management and analysis is essential across various industries. This course provides a comprehensive introduction to the fundamental principles of data […]
About Course
Course Description
In today’s data-driven world, proficiency in data management and analysis is essential across various industries. This course provides a comprehensive introduction to the fundamental principles of data management and analysis using Microsoft Excel, a widely accessible and powerful tool for data manipulation and visualization.
The experience will take participants through the fundamentals of data handling, from comprehending data kinds and structures to carrying out complex data analysis tasks. Excel’s features, functions, and formulas for data management and analysis will be taught to learners through a series of practical examples and hands-on exercises.
Course Content
Course Outline
-
Excel_Video Intro
00:00 -
Excel 101 – Welcome
01:03 -
Excel 102 – Course Prerequisite
00:57 -
Excel 103 – Course Overview
01:21 -
Excel 201 – Data Sorting
00:00 -
Excel 202 – Data Filtering
09:58 -
Excel 203 – Sorting & Filtering Exercise
01:23 -
Excel 301 – Data Grouping
05:48 -
Excel 302 – Grouping & Subtotals
04:53 -
Excel 303 – Grouping & Subtotals Exercise
00:00 -
Excel 401 – Removing Duplicate Values
03:43 -
Excel 402 – Data Consolidation
04:36 -
Excel 403 – Pivot Tables
08:00 -
Excel 404 – Data Consolidation Exercise
01:50 -
Excel 501 – Logical Functions (IF, AND, OR)
08:08 -
Excel 502 – Logical Functions (SUMIF & COUNTIF)
04:39 -
Excel 503 – Logical Functions Exercises
00:00 -
Excel 601 – VLOOKUP & HLOOKUP
07:12 -
Excel 602 – Index & Match Functions
04:54 -
Excel 701 – Concatenate Text
00:00 -
Excel 702 – Date Functions
04:11 -
Excel 801_Connect Excel to Databases using SQL
05:14
Student Ratings & Reviews
Related Courses
Contact Us
+44 7466 867906
+234 816 746 9320
info@mymivant.com
Derwent Business Centre, Clarke Street Derby. DE1 2BU, United Kingdom.
© Copyright 2024 Mivant. All rights reserved.