Excel for Beginners: Sorting, Filtering, Data-Validation

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Excel for Beginners: Sorting, Filtering, Data-Validation

Coursera · Beginner ·📊 Data Analytics & Business Intelligence ·3mo ago

Skills: Excel & Spreadsheets90%

Key Takeaways

Introduces Excel basics including sorting, filtering, and data validation

Original Description

This 1-hour, project-based course is an introduction to spreadsheets. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Sorting tables of data - Filtering data for faster access to key information - Data-validation for minimising human error Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.

Watch on External: Coursera ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

More on: Excel & Spreadsheets

View skill →

Mastering Advanced Pivot Tables in Excel

Mastering Advanced Pivot Tables in Excel

Amazing Excel Trick! Unlock Hidden Features & Boost Productivity

Amazing Excel Trick! Unlock Hidden Features & Boost Productivity

Advanced Excel Financial Modeling Risk Analysis & Auditing

Advanced Excel Financial Modeling Risk Analysis & Auditing

Apply Microsoft Excel Fundamentals for Data Analysis

Apply Microsoft Excel Fundamentals for Data Analysis

Charts, Pictures, Themes, and Styles in Microsoft Excel

Charts, Pictures, Themes, and Styles in Microsoft Excel

Competencias digitales de ofimática: Microsoft Excel

Related Reads

Stop Testing One Indicator at a Time. Loop Your Way to Better Trading

Learn to improve trading by testing multiple indicators using a champion loop, increasing efficiency and accuracy in trading strategies

Medium · Data Science

Fact Tables, Star Schemas, Joins and Dashboards

Learn to design efficient data models using fact tables, star schemas, and joins to create informative dashboards

Dev.to · samwel

The Ultimate Step-by-Step Guide: Connecting Power BI to Cloud-Based & Local PostgreSQL

Learn to connect Power BI to PostgreSQL databases, both cloud-based and local, to unlock powerful data analysis and visualization capabilities

Dev.to · michael imani

Understanding Data Warehousing: The Complete Beginner’s Guide for Data Engineering

Learn the basics of data warehousing and its importance in data engineering

Medium · Data Science

How to Hire Top SEO Talent

Menerva Digital