Archive for the tag: Important

Top 10 Most Important Excel Formulas – Made Easy!

Ideas No Comments »

Top 10 Most Important Excel Formulas - Made Easy!

This video provides a basic introduction into the top 10 most important formulas used in excel. These include the average function, autosum, Sum If, Count, Counta, Count If function, Concantenate, If logical function, Vlookup, and Drop Down Lists.

My Twitter Page:

YouTube Channel Growth Accelerator Course:

Algebra For Beginners:
https://www.video-tutor.net/algebra-for-beginners-basic-introduction.html

Excel Tutorial For Beginners: https://www.youtube.com/watch?v=nK-uNYuvcag
Top 30 Excel Tips & Shortcuts: https://www.youtube.com/watch?v=UMad9_-4rOU
How To Use VLookUp: https://www.youtube.com/watch?v=zV0ah1DPNJ8
Pivot Tables: https://www.youtube.com/watch?v=WoR2RhT7AF0

Excel Tutorial Playlist:

Disclaimer: Some of the links associated with this video may generate affiliate commissions on my behalf. As an amazon associate, I earn from qualifying purchases that you may make through such affiliate links.

Learn how to use formulas in Excel, including the following functions & formulas:

⌚ Timestamps
0:00 Introduction
0:55 Add
1:55 Subtract
2:18 Multiply
2:50 Divide
3:20 Sum
4:46 Min
5:05 Max
5:30 Count
6:15 Counta
6:48 Average
7:20 Median
7:54 Concatenate
8:29 If
9:10 Countif
9:40 Vlookup
10:58 Sumif
11:46 Current Time

πŸ“ƒ Watch related playlists and videos
– Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Pivot Tables: https://youtu.be/m0wI61ahfLc
– Vlookup & hlookup: https://youtu.be/8okA22yMwTs
– Mail Merge: https://youtu.be/_Efb_oMgxEs
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

Thinking about subscribing to Office 365? You get the Word, Excel, and PowerPoint desktop apps and up to 6 TB cloud storage. Check the latest pricing on Amazon: https://amzn.to/2UgyoJ4 (as a disclaimer, purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same).

Let me know if you have any questions. Also, let me know if there are other topics that you would like to see videos on.

🚩 Connect with me on social
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://discord.gg/kHuujY2pZf
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/

πŸ™ Request How To Tutorial Videos
https://forms.gle/BDrTNUoxheEoMLGt5

πŸ”” Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

πŸ› Support me with your Amazon purchases: https://amzn.to/3kCP2yz

βš– As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.

#stratvert #excel

Sales vs Marketing: Which is More Important?

Ideas No Comments »

What are the differences between Sales and Marketing? Patrick Bet-David provides perfect examples between the two.

How to Find the Leaks in Your Business: https://www.youtube.com/watch?v=eSzJ8…

Visit the official Valuetainment Store for gear: https://www.valuetainmentstore.com/

Download the free PDF: http://www.patrickbetdavid.com/sales-vs-marketing-important/

About Valuetainment:

Founded in 2012 by Patrick Bet-David, our goal is to impact entrepreneurs around the world through value and entertainment. We are the #1 channel for entrepreneurs because of the best interviews, best how to videos, best case studies and because we defend capitalism and educate entrepreneurs.

To reach the Valuetainment team you can email: marketing@patrickbetdavid.com

Follow Patrick on social media:

Website: http://www.patrickbetdavid.com

Snapchat: betdavid19

Facebook: https://www.facebook.com/PatrickBetDavid.Valuetainment/

Instagram: https://www.instagram.com/patrickbetdavid/

Twitter: https://twitter.com/patrickbetdavid

Linkedin: https://www.linkedin.com/in/patrick-bet-david-3731553

Check out these books about Steve Jobs:
* Steve Jobs: https://amzn.to/2PGH3nM
* The Presentation Secrets of Steve Jobs: https://amzn.to/2JB1j55
* Becoming Steve Jobs: https://amzn.to/2QgZKf8
* Steve Jobs: The Man Who Thought Differently: https://amzn.to/2AHIqdQ
* Steve Jobs (Movie): https://amzn.to/2CZgLq3

Steve Jobs shares his amazingly different approach to marketing and how he used it to build Apple into one of the largest companies in the world.

* Join my BELIEVE newsletter: http://www.evancarmichael.com/newsletter/

Transcript:

To me….marketing is about values. This is a very complicated world. It’s a very noisy world. And we’re not going to get a chance to get people to remember much about us. No company is! And so, we have to be really clear on what we want them to know about us.

Now Apple, fortunately, is one of half-a-dozen best brands in the whole world. Right up there with Nike, Disney, Coke, Sony β€” it is one of the greats of the greats. Not just in this country, but all around the globe.

But even a great brand needs investment and caring if it’s going to retain its relevance and vitality. And the Apple brand has clearly suffered from neglect in this area in the last few years. And we need to bring it back!

The way to do that is NOT to talk about speeds and fees. It’s NOT to talk about bits and mega-hertz. It’s NOT to talk about why we are better than Windows.

The dairy industry tried for 20 years to convince you that milk was good for you. It’s a lie, but they tried anyway. And the sales were falling. And then they tried β€œGot milk” and the sales went up. β€œGot milk” wasn’t even talking about the product. In fact, it focuses on the absence of the product.

But the best example of all, and one of the greatest jobs of marketing that the universe has ever seen, is Nike. Remember, Nike sells a commodity. They sell shoes!!!

And yet, when you think of Nike you feel something different than a shoe company. In their ads, as you know, they don’t ever talk about the product. They don’t ever tell you about their air soles and why they are better than Reebok’s air soles.

What does Nike do in their advertising? They honor great athletes. And they honor great athletics. That’s who they are, that’s what they are about!

Apple spends a fortune on advertising β€” you’d never know it….you’d never know it!
So…when I got here, Apple just fired their agency and there was a competition with 23 agencies that…you know…four years from now we would pick one. And we blew that up and we hired Chiat\Day, the ad agency that I was fortunate enough to work with years ago and created some award winning work including the commercial voted the best ad ever made, 1984 (by Advertising Professionals).

And…we started working about eight weeks ago, and the question we asked was, β€œOur customers want to know who is Apple and what is it that we stand for…where do we fit in this world?”

And what we’re about isn’t making boxes for people to get their jobs done β€” although we do that well. We do that better than almost anybody, in some cases.

But Apple is about something more than that! Apple at the core…its core value β€” is that, we believe that people with passion can change the world for the better. That’s what we believe!

And we have had the opportunity to work with people like that. We’ve had the opportunity to work with people like you; with software developers, with customers, who have done it. In some big, and some small ways.

And we believe that, in this world, people can change it for the better. And that those people who are crazy enough to think that they can change the world are the ones that actually do!

And so, what we’re going to do in our first brand marketing campaign in several years, is to get back to that core value!

A lot of things have changed. The market is in a total different place than where it was a decade ago. And Apple is totally different β€” and Apple’s place in it is totally different. And believe me, the products, and the distribution strategy, and the manufacturing are totally different…and we understand that.

But values and core values β€” those things shouldn’t change. The things that Apple believed in at its core, are the same things Apple really stands for today.

ENGAGE
* Subscribe to my channel: http://www.youtube.com/subscription_center?add_user=Modelingthemasters
* Leave a comment, thumbs up the video (please!)
* Suppport me: http://www.evancarmichael.com/support/

CONNECT
* Twitter: https://twitter.com/evancarmichael
* Facebook: https://www.facebook.com/EvanCarmichaelcom
* Google+: https://plus.google.com/108469771690394737405/posts
* Website: http://www.evancarmichael.com

EVAN
* About: http://www.evancarmichael.com/about/
* Products: http://www.evancarmichael.com/zhuge/
* Coaching: http://www.evancarmichael.com/movement/
* Speaking: http://www.evancarmichael.com/speaking/