Intermediate Excel

Focused View

Tyler Tallon

48:39

127 View

S1V1Introducing the Course.mp4

01:04

S1V2Introducing Lookup Functions.mp4

01:37

S1V3Using VLOOKUP to Search in a Column.mp4

06:30

S1V4Using HLOOKUP to Search in a Row.mp4

01:01

S1V5LOOKUP Tips and Common Errors.mp4

01:19

S2V1Introducing Pivot Tables.mp4

02:01

S2V2Building a Pivot Table.mp4

02:42

S2V3Finishing the Pivot Table.mp4

02:43

S2V4_v2Other Pivot Table Tips and Tricks.mp4

02:52

S3V1Introducing Conditional Formatting.mp4

04:30

S3V2Getting Fancy with Conditional Formatting.mp4

04:33

S4V1Why Error Checking is Important.mp4

03:04

S4V2Common Errors.mp4

03:30

S4V3Prevent Errors Using Data Validation.mp4

03:52

S4V4How To Check For Errors.mp4

06:57

S4V5Wrapping Up.mp4

00:24

Description

About this Course

Learn how to perform intermediate level functions in Microsoft Excel. In this course, you will learn how to use LOOKUP functions, build and modify pivot tables, use conditional formatting, find and replace data, and check for errors. Learning these tools will help you bring data to life and allow you to use Excel in a more meaningful way.

What you'll learn

Use the LOOKUP function to look in a single row or column and find a value from the same position in a second row or column.
Build and modify pivot tables
Use conditional formatting
Use find and replace
Perform error checking

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Tyler Tallon

Instructor's Courses

Tyler is the Finance Director at Treehouse who wields his spreadsheet super powers to help Treehouse staff and students excel at teaching and learning. He loves sports, traveling, and hanging out with family and friends.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.