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

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX
Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Data Processing and Analysis with Excel
Rochester Institute of Technology via edX
Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera
Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera