Al Chen

Excel for the Real World: Gain the Basic Skills of Microsoft Excel

Great looking Excel file Sarah! There are so many things I love about your file:-Conditionally formatting the "Name" column. It looks like this is the store where you sold a product so it's easy to see which stores brought the most sales for you. -The SUM and AVERAGE formulas are great to use to calculate how your affiliate sales are doing as well as clicks. -LEFT and CONCATENATE are definitely a little more advance formulas. As you get more comfortable with these formulas, you'll start to see the power of Excel!

A sheet that uses click references from affiliate partners. I added SUM and AVERAGE functions and used LEFT and CONCATENATE to create new references.&nbsp;

Affiliate Click References

Company

Community

Teaching

Mobile

English

English