YoVDO

Excel: You Can Do This

Offered By: LinkedIn Learning

Tags

VLOOKUP Courses Data Validation Courses Power Query Courses PivotTables Courses Flash Fill Courses COUNTIFS Courses

Course Description

Overview

Quickly gain confidence with the most intimidating features in Excel. Unlock the power of VLOOKUP, PivotTables, Flash Fill, Conditional Formatting, and more.

Syllabus

1. Excel: You Can Do This
  • Flash Fill: Merge data in different cells
  • Linking sheets
  • Copying, coloring, and naming tabs
  • SUM: Calculating a basic sum
  • Freeze panes: See your data while scrolling
  • Conditional formatting
  • Data validation: Ensure users don't input crazy data
  • Create a drop-down list
  • Create basic charts from scratch
  • Split text in Power Query: Split real-world data fields
  • IF statement
  • COUNTIFS: Count entries based on conditions
  • The #N/A error: What does it mean and what causes it?
  • VLOOKUP

Taught by

Oz du Soleil

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Microsoft Excel - Excel from Beginner to Advanced
Udemy
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy
Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel Mastery: From Beginner to Pro
Udemy