TWIL

Things I Have Learned – LPT Episode #1

Greetings, dear friend! Welcome to the very first installment of the “Things I Have Learned” series!  I am so excited to document and share some of the many things I am so fortunate to learn as I journey through this life.

The subject matter will vary – I consider myself a pretty well rounded person – meaning I have a wide range of interests and hobbies.  I am also quite passionate about my work and continuing to grow in that capacity, so naturally some of the LPT (Life Pro Tip) items I share may be technical in nature. Some of what I share may be silly as I’m known for being a bit of a comedian at times. 🙂

I hope that the items I share help you, and I would love to hear feedback from you.  Also, if you have something you would like to share with other readers, please don’t hesitate!

Without further ado, behold this first installment!

Lightning/Storms

If you’re ever caught outside in a thunderstorm and you suddenly feel your hair stand on end, squat as low to the ground on the balls of your feet as possible. Place your hands over your ears and your head between your knees. Make yourself the smallest target possible and minimize your contact with the ground.  Getting struck by lightning has always been a big fear of mine (hopefully irrational)!

SaverLife

SaverLife is an awesome organization that will pay rewards to you if you meet your savings goals (as of 5/29/19).  It appears that they (“EARN”) are a non-profit and there are several useful articles related to personal finance on their website.  I signed up last year and received $60 from them over the course of six months.  Note: This is not an affiliate offer and I have nothing to personally gain if you sign up. Just some free money and great tools/educational material surrounding budgeting and saving for the future. Check it out!

 

10 Acrylic Painting Tips for Beginners

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

VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function

VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function

Download Start File: http://ift.tt/2s2NKpb
Download Finished File: http://ift.tt/2sNrjS5
Entire Page with All Files for All Videos: http://ift.tt/1JhAg9o
Then scroll down to this section: “VLOOKUP “Shark” Week Downloadable Workbooks”
Look for the file named: VLOOKUP-SHARK-WEEK-DownloadableWorkbook01-Start.xlsx

Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
In this video learn everything you need to know about VLOOKUP in 1 video.
Here are the topics (minute marks jump you to that part of the video):
1. VLOOKUP = V = Vertical ( min)
2. Why so common? Because everyone needs to look stuff up ( 00:43 min)
3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)
4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)
5. VLOOKUP and Data Validation ( 8:10 min)
6. VLOOKUP with Named Range ( 10:34 min)
7. VLOOKUP as Formula Element ( 17:24 min)
8. HLOOKUP = H = Horizontal ( 18:25 min)
9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)
10. VLOOKUP with table on different sheet ( 24:00 min)
11. VLOOKUP with table in different workbook ( 25:56 min)
12. Show Full Record: Numbers above column header ( 27:15 min)
13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)
14. Show Full Record vertically: ROWS Function ( 32:28 min)
15. Show Full Record: MATCH Functions ( 33:40 min)
16. Two Lookup Values: Add join column as first column in table ( 35:40 min)
17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)
18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)
19. Partial Text Lookup: MID Function ( 45:37 min)
20. Partial Text Lookup: RIGHT Function ( 48:08 min)
21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)
22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)
23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)
26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)

VLOOKUP Shark WEEK
How To Use Excel VLOOKUP Function
Learn Excel VLOOKUP Function
VLOOKUP made easy
Excel VLOOKUP
Excel VLOOKUP Function
via YouTube https://youtu.be/-hJxIMBbmZY

Using the Excel Average and AverageA functions

Using the Excel Average and AverageA functions

Learn how the Average and AverageA functions work in Excel.

Go to http://ift.tt/2s34X24 for more tutorials or to download the class document to follow along
via YouTube https://youtu.be/EFg7vh2WGk0

Excel 2013 Course (Free)

Excel 2013 Course

In this tutorial for Excel 2013 you will begin to learn the basics of Microsoft Excel 2013

To download the course materials, sample Excel files used in the videos and the handouts for the course, please visit – http://ift.tt/2sNnz2W
via YouTube https://youtu.be/D391EU_Yi9I

Microsoft Excel 2016 Tutorial for Beginners Part 1 Full Intro Learn How to Use Excel 2016

Microsoft Excel 2016 Tutorial for Beginners Part 1 Full Intro Learn How to Use Excel 2016
Excel 2016 Tutorial for beginners
This is a Microsoft Excel 2016 Full Tutorial for beginners & intermediate users.In this crash course Excel video tutorial you will learn how to use Excel 2016 formulas and functions, Excel 2016 new features, Excel 2016 Charts along with many other necessary features that you must know how to use when using Excel 2016.

1:38 The Excel Ribbon
2:10 Ribbon Groups and Commands in Excel 2016
2:30 Data Entry in Microsoft Excel
3:08 How to enter data in to a cell in Excel
3:22 How to enter data into the formula bar in Excel
3:50 How to Navigate through Microsoft Excel
4:24 How to navigate and select cells in Excel with keyboard
8:01 Autofill in Excel 2016
9:15 Autocomplete in Excel 2016
10:32 How to zoom in and zoom out Excel 2016
10:50 Formulas & Functions Tutorial in Microsoft Excel 2016
11:25 Addition in Excel
13:04 Autosum Function in Excel
14:03 The Sum Function in Excel 2016
15:45 Subtraction in Microsoft Excel
16:12 Multiplication in Excel 2016
17:15 The Product Funtion/Formula in Microsoft Excel
17:44 How to Find/Search for a function in Excel using the insert function command in the Function Lirbrary
19:29 Division in Microsoft Excel
19:46 the Quotient Function in Excel
21:25 Exponential formulas in Excel
22:20 Concatenation in Excel
23:06 Logical Comparison in Excel
23:08 Equal to logical comparison in Excel
24:17 Logical Comparison Greater Than in Excel
24:36 Less Than Logical Comparison
24:58 Greater than or equal to
25:42 Not Equal to Excel 2016
26:14 Combining Formulas and Functions in Microsoft Excel 2016
29:18 Cell Reference Tutorial in Microsoft Excel
29:57 Types of cell reference in Excel
30:07 Relative Cell Reference in Excel 2016
32:04 Using Autofill for formulas and cell reference
32:25 Show formula in Excel 2016
33:15 Absolute cell reference in Excel 2016
33:10 How to lock cell reference
34:40 Mixed Cell Reference locking only the row or column
39:27 How to refer to cells in another worksheet in Excel
40:06 How to refer to another workbook in Excel
40:35 How to clear/remove/delet content in a cell
40:52 Autofill dates in Excel
41:15 How to delete a row or column in Excel
46:36 How to style and Excel worksheet
46:50 How to format numbers in Excel
47:50 increase of decrease decimals in Excel
48:54 How to format dates in Excel (short date, long date)
40:32 How to resize cells columns and rows in Excel
50:35 the Today function in Excel Today()
51:54 Formattin and styling cells in Excel
52:05 How to add color fill in Excel
52:55 How to add borders in Excel
53:44 How to copy and paste a range of cells in Excel
54:23 Cell Styles in Excel 2016
55:27 Text direction and how to angle diagnal text content and numbers in Excel
57:00 How to Merge cells in Excel
57:53 Merge across in Excel
58:18 Change height or width of cell in Excel
58:49 Font Style in Excel
1:01:37 content alignment in Excel
1:02:20 Conditional Formatting in Excel 2016

http://ift.tt/2f0EiJ7
hjttp://roofstampa.com
http:/www.subjectmoney.com
http://ift.tt/1jhTIZH
via YouTube https://youtu.be/p1pZmbuygZY