Complete Beginner's Guide to Excel

In this lesson, learn the VLOOKUP function in Microsoft Excel. Find out how to pull a value from a range, then return a matching value to a spreadsheet cell.

In this lesson, learn how to pair an “if” function with a “concatenate” function to link text and produce an answer of true or false in Microsoft Excel!

In this lesson, learn about conditional formatting, to format cells based on set specifications, and IfError, to dynamically return results of an Excel table.

Want to create compelling visual data representations in MS Excel? In this lesson, learn how to transform data tables into pie, line, and column charts.

In this lesson, explore chart editing features in Excel. Learn to format data labels, delete chart elements, create stacked charts, add 3-D effects, and more!