Library

Excel Essentials

4 courses , 49 lessons , 12 exercises , 4 exams

Learn the core functionality needed to become proficient in Excel, from cell navigation and selection to writing formulas and sorting data.

Course List (4)

Data Manipulation and Formatting

Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.

15 lessons
61 minutes
Created with Sketch. Beginner
Formulas and Functions

This course introduces the most useful of Excel’s built-in arithmetic and logical functions. You also learn how to write, manipulate and audit your own formulas.

14 lessons
61 minutes
Created with Sketch. Intermediate
Finance Functions

Excel is commonly used by finance professionals to evaluate investment returns. This course introduces important finance functions you can use for this purpose, including Internal Rate of Return and Net Present Value.

5 lessons
24 minutes
Created with Sketch. Beginner
Text, Time, and Dates

Excel has a host of functions that help manipulate these 3 data types. In this course, we'll learn how to clean, chop and manipulate text entries and how to perform time-series analysis on a dataset for an online start-up.

15 lessons
58 minutes
Created with Sketch. Intermediate