Focus video player for keyboard shortcuts
We hope you enjoyed this lesson.
Cool lesson, huh? Share it with your friends
About this lesson
A quick introduction to the course.
There are no related exercise files for this lesson.
In this course, we'll cover:
- Getting Data in Workable Format
- Fixing text and numbers
- Fixing dates
- Getting rid of blank lines in your data
- Working With a Range of Data
- Conditional formatting
- Data validation
- Functions in Excel
- Text functions
- Logic functions
- Calculations based on criteria
- Lookup functions
- Extracting, Combining, and Reporting Data
- Data tables
- Pivot tables
- Power Query
- Create your own Income Tax and Loan Calculators
Login to download
Lesson notes are only available for subscribers.