Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Functional Excel Skills

via Skillshare

Overview

This class is for people who use Excel everyday. It is aimed towards users who want to learn a few more functional skills

We will cover:

- Keyboard shortcuts

- Absolute and Relative referencing, including when using Tables

- Some useful formulas including VLookup and the new XLookup

- Delimiters

- Data Validation

- Conditional Formatting

- Dealing with raw data

- Inserting Tables

- Inserting Slicers

- Nested IF Statements

- OR Statements

- AND Statements

Bonus Videos:

- Using Logic to fill in missing values

- Inserting rows beneath alternating rows

Viewer request:

- Pivot Tables

- Multi Column Comparison

New videos are uploaded occasionally, so please keep an eye out for updated content.

Please let me know if you have any requests about a particular feature of Excel you would like to know more about.

Download Resources Here.

Syllabus

  • Intro
  • Lesson 1 Keyboard Shortcuts
  • Lesson 2 Before We Look At Formulas
  • Lesson 3 Formulas
  • Lesson 4 VLookup
  • Lesson 5 Delimiters
  • Lesson 6 Data Validation
  • Lesson 7 Filling Down & Conditional Formatting
  • Lesson 8 Source Sheet
  • Lesson 9 Data Setup
  • Lesson 10 VLookup Continued
  • Lesson 11 Absolute Referencing In Tables
  • Lesson 12 XLookup
  • Lesson 13 Data Extraction with the Find Function
  • Lesson 14 Nested IF Statements
  • Lesson 15 The OR Function
  • Lesson 16 The AND Function
  • Lesson 17 Putting Our Logic Together
  • Viewer Request 1 - Pivot Tables
  • Viewer Request 2 - Multi Column Comparison
  • Bonus Video - Filling in Missing Table Data
  • Bonus Video - Inserting Rows Into a Data Set

Taught by

K3A

Reviews

Start your review of Functional Excel Skills

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.