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

Rails with Active Record and Action Pack
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate II
Macquarie University via Coursera
Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn
Everyday Excel, Part 1
University of Colorado Boulder via Coursera
Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera