Hands On Training

Functional Excel Skills by Skillshare

via

Skillshare

Course Features

Duration

2.18 hours

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Mobile, Desktop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

2.18 hours

Course Description

This class is intended for Excel users who use Excel every day. This class is for users who wish to improve their functional skills.

We'll cover:

Keyboard shortcuts
Absolute and relative referencing, when using Tables
There are some useful formulas, including VLookup or the new XLookup.
Delimiters
Data Validation
Conditional Formatting
Raw data processing
Inserting tables
Inserting Slicers
Statements of Nested IF
OR Statement
AND Statements

Bonus Videos:

Logic is used to fill in the gaps
Insert rows underneath alternating rows

Viewer request:

Pivot Tables
Multi-Column Comparison

You will find new videos uploaded every now and again, so keep checking back for the latest content.

If you have any questions about Excel, please let me know.

Course Overview

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Business

Business Analytics

Data Analysis

Data Processing

Excel Functions

Microsoft Excel

Ms-excel

Spreadsheets

Course Content

Expand all sections

Module 1: Intro

Module 2: Lesson Keyboard Shortcuts

Module 3: Lesson Before We Look At Formulas

Module 4: Lesson Formulas

Course Instructors

K3A

Instructor

Welcome to K3A! I hope you find something of value while you are here. Currently my "Functional Excel Skills for Beginners" and "Microsoft 365 Online - Getting Setup" classes are available to watch.