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
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