Excel: You Can Do This
Offered By: LinkedIn Learning
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