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

Microsoft Excel 2013 - Be the Excel master !!
Udemy
Excel 2013 Tips and Tricks
LinkedIn Learning
Excel: Productivity Tips
LinkedIn Learning
Introduction to Microsoft Excel 2013
Udemy
Cleaning Up Your Excel 2013 Data
LinkedIn Learning