Data Analysis with Excel: Essentials

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

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.

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.

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.

Help a startup catering company that has grown quickly in its first year, but can't pinpoint why. You'll use Excel to analyze their cost trends and determine what spending items actually boost revenue - helping the company mature and grow steadily in the future.