Tag: How to

Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups

Posted on by Annie D

See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight coupon groups (all combinations of the three store coupons) and then extract the customer names in each group. The data and goals are:
1) Each customer was given coupons to go to Wegmans, Publix, Trader Joe’s.
2) We have a list of Stores names.
3) We have a list of transactions for the coupon redemptions that lists purchases, customer name and store
4) Goal 1: Count Customers who visited a given set of stores.
This Part 02 Video is an alternative method for counting from Tobias de Greeuw from the Netherlands. This alternative version we use the functions COUNTIFS, IF and TRANSPOSE. This alternative eliminates the need for eight separate Logical Formulas and simplifies the process by using an Array Formula.
Download File: http://ift.tt/2t6hC34
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs

Related Videos:
Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1447: DAX Formulas to Count Customers in 8 Sales Coupon Groups & List Store Names

View on YouTube

Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups

Posted on by Annie D

See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight coupon groups (all combinations of the three store coupons) and then extract the customer names in each group. The data and goals are:
1) Each customer was given coupons to go to Wegmans, Publix, Trader Joe’s.
2) We have a list of Stores names.
3) We have a list of transactions for the coupon redemptions that lists purchases, customer name and store
4) Goal 1: Count Customers who visited a given set of stores.
5) Goal 2: List Customers who visited a given set of stores.
Download File: http://ift.tt/2tvSeEE
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Topics in Video:
1. (00:12) Introduction to Problem
2. (03:33) Count number of coupons each customer redeemed for each store. See the COUNTIFS Function.
3. (07:03) Logical formulas for determining which customers fall into each of the eight coupon groups. Learn about AND Logical Tests, OR Logical Tests, and a NONE Logical Test (None are TRUE, or All are FALSE). See the Excel Spreadsheet Logical functions: AND, OR, NOT.
4. (17:23) Count Customers in each of the eight coupon groups using COUNTIFS Function.
5. (18:02) Formula to Extract Customer Names for each of the eight coupon groups. Learn about Array Formulas to looks an item and Return Multiple Items. Learn about the Excel Spreadsheet functions: ROW, AGGREGATE, ROWS, INDEX and IF.
6. (29:25) Conclusion

View on YouTube

The Magic of Excel: Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & more!!

Posted on by Annie D

This video in an introduction to Excel and the Magic it can do to make your life and job easier, more efficient and more fun! It is an introduction to many of the amazing features in Excel that can help us in our job, life and in school. This video is part of Highlines effort to show students that going to college can be fun and amazing for empowering student to do what they want in life!

Download File Here:
Start File: http://ift.tt/2sexb9S
Finished File: http://ift.tt/2sYhnW6 File.xlsx
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs

Topics in this video:
1. (00:36) What is Excel?
2. (03:11) What does Excel do? 1) Calculations, 2) Storing & Formatting Data, 3) Data Analysis
3. (10:28) Formatting to make our Data Look Good. Build a Template that you can use over and over.
4. (12:35) See how to create a List of Days of the Week Quickly using the “Angry Rabbit”.
5. (16:14) Formulas & Cell References to make our Job Easier! Learn about the Excel Functions: SUM, AVERAGE, MAX and MIN.
6. (21:10) Keyboard Shortcuts are Amazing. Learn how to highlight 5000 rows of data quickly.
7. (26:52) Payroll Tax Calculations Hard? Not With Excel : )
8. (29:59) Relative Cell References in Formulas
9. (31:01) Absolute Cell References in Formulas
10. (36:10) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features.
11. (44:31) Chart Your Results Dynamically!! Learn how to create a Column Chart for visualizing the difference across Categories.
12. (48:53) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable.
13. (56:20) Flash Fill to transform your Data in Seconds!
14. (60:05) Summary of all topics.

View on YouTube

10 Acrylic Painting Tips for Beginners

Posted on by Annie D

Hello there! I have been dabbling with paint for a while but this semester I took my first painting class. It is so crazy because I have taken a bunch of drawing classes but never a class that focused on how to paint.

In this video I’m sharing the tips I have learned so far from working with acrylics! These are pretty basic tips but these are things that have been really helping me out and I think they will help you if you are a beginner too.

Here are my Tips:

1. Buy Basic Canvases:
I like using canvas boards because it encourages me to go for and practice. I don’t feel like I have to make everything perfect because I didn’t spend a bunch of money on supplies. Also they are WAYYYYY easier to store in your home.

2. Create more:
It’s better to explore and experiment when you are first learning how to work with paint then trying to make everything look perfect right away. As writers like to say: write for the trash can! You are going to learn more and improve quicker by being less timid and more open. So go paint some train wrecks and you will eventually paint a masterpiece.

3. Try painting without Drawing First:
I feel like you might come after me with torches and pitchforks for saying this but… maybe give it a try? I know how you feel I am SO much more use to drawing then painting but just learning how to work with my brushstrokes at this point has helped me prevent making my work look too stiff.

4. Use a Bigger brush:
I know you little pencil artists out there like me just want to use a fine tip to get in all those little details… But if you start your paintings this way, it is a PAAAIIIN. Also working with a bigger brush to start helps you create more movement and brushstrokes. (also saves you from ripping out hair)

5. Use the Rule of thirds:
Now you don’t always have to do this but it does make the composition more interesting to look at. If my explanation didn’t make sense, here is another example: http://ift.tt/1hTNRXx

6. Buy Small Paint Tubes:
Now I know you are going to think I’ve lost my mind on this one but these little mini tubes have gotten me through SEVERAL assignments on my class. I did not think this was possible AT ALL. Paint adds up quickly, use these little tubes to test out what brand works best for you.

7. Use a gel medium:
I LOVE this stuff. I have had it in my art collection for a WHILE but I never really used it. THIS STUFF IS AMAZING! It makes everything glide much easier and it keeps the paint wet. For only $2 it is a bargain. I wouldn’t recommend using this stuff for the first layer, wait till your 3rd layer. It makes the paint less opaque.

8. Use a Heavy Matte Medium:
Yes girl! If you have always wanted to add some texture to your paint, here you go. You mix this stuff with your paint and it makes it stand out on your canvas.

9. Mix compliments:
I use to HATE. I mean HAAAATTTE complimentary colors… so much. They just looked so repulsive and ugly to me. But when you mix them together, they neutralize eachother put and create these useful neutrals. These neutrals are great for so many things: shadows, skin. Basically anything you are painting from life.

10. Be bold and experiment with mixing colors:
When you are first starting mixing colors is super intimidating. However, you got to give it a shot. Mix colors you would NEVER think of mixing together. You might surprise yourself.

Those are the tips I have for you guys! I hope you enjoyed this video. If you did you can show your support by commenting and liking. I always appreciate hearing from you.

Happy Painting!
xo Heather
via YouTube https://youtu.be/ZRwFbOMDcw4