Mid Function

Description: A built-in, string/text function in excel that can be used as a worksheet function and VBA function.

*worksheet function can be used as a part of formula in excel. VBA functions are used in macro code that are entered through the Microsoft Visual Basic Editor.

Syntax: =MID(text, starting_num, num_of_chars)

Arguments:

• text is the original text string
• start_num is the position of the first character to extract
• num_of_characters –No of characters to extract (mandatory in WS function and optional in VBA coding)

Purpose: To extract text/ substring from inside a string

Return: A substring/text value

Note:

• Use the MID function when need to extract text from inside a text string, based on location and length.
• Use FIND or SEARCH to locate starting_num when don't know the location in advance.

A few points that one should consider while using Mid Function in Excel (click on the Image to understand)

MID Function

How useful are Ted Talks?

In the current scenario, people are busy in keeping pace with the increasing competition. No one has enough time to spend on reading columns in newspapers, sharing thoughts with their companions and listen to others. In this time, a source of information is required that can provide a variety of information in less time to keep you updated with what is going on in the world; TED Talks is one of a kind that source. It offers short video content that is easily accessible over the web.

TED is a conference series and stands for Technology, Entertainment and Design. It was the brainchild of Richard Saul Wurman, who began it in 1984. Later, Chris Anderson acquired TED in 2001. He manages all the conferences and acts as the guardian for the thousands of TED talks that can be accessed anytime at TED.com. Speakers at TED events are provided 18 minutes to share their thoughts, deliver their messages that are highly polished and crisp. The main motto behind conducting these events is to inspire, challenge and be thought-provoking.

TED matters a lot as it is evident. One of the TED speakers, Salman Khan (Founder Of Khan Academy), whose main aim is to bring world-class education, online and that too free on this planet, has shared once that before his TED speech, his site has drawn only 6.9 million students. Now, more than 140 million students take online courses through his portal. And, the site is getting enrollment of 10 million new students each month. Many others share that their lives and causes were impacted dramatically for the better after their TED speeches.

The biggest reason TED matters is the actual impact it has had on the millions of lives; especially for the past eight years as TED talk shows are posted online for free. Also, TED organizers have received thousands of letters, emails, and reviews from people explaining how one or more TED talks have impacted their lives positively for the better. So, keep visiting TED.com and keep yourself motivated for your future endeavors.

What is the difference between a Content Writer & a Copywriter?

The transition lines between copywriter and content writer are blurring. Furthermore, the following are the parameters based on which we can distinguish between the two:

• It’s mandatory for copywriters to write as few words as possible and if feasible no words at all; just logo with tagline. Whereas, content writers sometimes write in volumes such as web content, blog, articles, social media content.
• Copywriters are required to write short and crisp messages and content explains things by creating a story.
• Copywriters work primarily with landing pages such as home page, email, newsletter subscriptions, cover pages, etc. Content writers are hired to writer internal pages.
• The job role of copywriters is tuned with all aspect of a page including design, font, layout color combination, theme etc. Content writers work with text only.

How customer can login on Paytm if he/she has forgotten the password?

Since incorporation, paytm has been gathering customers’ trust and credibility for its support and swift services. To take this trust to the next level, we have developed a multi-layer security system to keep your data secure and provide a seamless user experience. If you are facing any trouble while accessing your Paytm profile; here’s a guide that can help you get rid of it. So, follow these below listed simple steps to swiftly log in to paytm:

• In the top right corner of the page, you can see the profile.
• In profile section on top, you get the option to login.
• Click on Login To Paytm and enter your registered mobile number or email id.
• On selecting Forgot Password option, you will be asked to ring on the mentioned number from your registered mobile number.
• Call on that number and select the desired option; you will receive a link via SMS, follow the instructions to reset your Paytm password.
• Your password will be updated.
• Click on Other Login Issues if you are unable to login to your account/ unable to create a new account/ you have lost your mobile or changed your mobile number.

For any other assistance, write to us; we are always there to solve your queries.

How Paytm has helped post demonetisation?

From November 8, 2016, to till date, wherever we go, whether it’s a small shop or a big store, we spot a scanning code on the wall with Paytm logo stating Paytm Karo.

India’s largest mobile e-payments and e-commerce brand - Paytm- is helping consumers and merchants around the nation to switch to mobile payments. It was incorporated in 2010 and over the span of seven years; Paytm has earned immense popularity across the nation. Moreover, Paytm has RBI’s approval to establish India’s first payment bank. All the existing users of Paytm find facilities like mobile wallet and online recharge to be highly reliable to go with. Paytm is associated with the leading online stores like Amazon, Flipkart, Snapdeal, etc., to help people obtain their favorite products through Paytm wallet without sharing any sensitive details. Above all, Paytm has revolutionized online payment and trading domain and has been influencing it positively without any hindrance for years.

Ever since the GOI has introduced demonetization of 1000 and 500 rupee note and launched the new 2000 and 500 rupee note, the move has been welcomed by the honest population of India. However, small merchants and common people, often found it chaotic to segment the amount of 2000 and 500 note into 100 rupees. In order to bolster such historical move, Paytm came up with a concept of Cashless Economy and helped people resolve issues conveniently. A few points that advocate Paytm’s credibility are real-time processing, no need to share sensitive details, lower or zero transaction fee and security.

The efforts of Paytm are evident from the facts that state “The company has registered a five times surge at Parking lots, four times increase in restaurants and local travel spends, three times surge at grocery outlets including Mother Dairy stores and two times surge at pharmacies and metro recharge.” Paytm has provided solutions to everyone- be it taxi, autos, grocery shops, restaurants, multiplexes, pharmacies, petrol pumps, coffee shops, kirana, hospitals, newspaper vendors, parking shops and many more.

The after effects of Demonetization were vivid across the country. But after this bold & effective step by the Government, Online Payment industry has witnessed a significant growth, courtesy to Paytm.

FRU2go: A Healthy Snack For Kids

Are you worried about your kid’s snacking habits? Do you want him/her to adopt healthy snacking habits? Are you seeking to coax your child into eating certain fruits and vegetables that he/she wouldn’t normally touch? Is it tedious for you to measure your kid’s daily nutritional intake? Are you in search of some snacking options that offer the perfect combination of fiber, fat, and protein? Above all, how do you plan on getting your kiddo to adopt healthy snacking habits in life? Well, all you need to do is a little market search for finding the right option that is tasty, healthy and can keep your kid’s hunger at bay-in a good way.

FrU2go has made quite a buzz in the market owing to its availability in different flavors, packaging standards, and cost-effectiveness. A fruit snack- 100% natural and available in the pouch- is obtainable in five different variants that are Mix Fruit, Mango, Mango Banana, Apple Banana and Strawberry Banana. A few points that advocate FRU2go to be a healthy
snack are listed below:

•  Natural Fruit: Made of the hand-picked fruits and natural processing techniques, FRu2go is a perfect blend of nutrition and taste. 

•  Easy To Carry: Whether you are a working professional or a school-goer or travelling to some place, carry FRU2go to never miss out on the energy and nutrition. FRU2go can be carried to wherever you go due to its handy and leak-proof packaging. 

• Storage: FRU2go is suitable for every occasion and season. It doesn’t require special storage facility. In rain, hail, snow and sunshine, it will taste the same without disappointing you.

Snacks can often be a big part of your kid’s diet. So it is imperative that most of the snacks you give him/her are ones you feel good about. Being a parent, it’s our duty to ensure that whatever our children consume must be tasty and healthy. Enriched with the goodness of fresh fruits, FRU2go is free from preservatives, artificial flavours & added colors and available in handy packaging- perfect for busybees. Try It To Believe It.

Reasons Why Your Business Needs A Digital Marketing Consultant

Do you own a business? Are you finding it difficult to drive rapid and sustainable business growth? Are you one of the companies that don’t have a digital marketing strategy yet? Do you have plenty of reasons to not get help for digital marketing strategy planning? Well, here are a few reasons that entail hiring a digital marketing consultant is critical to succeed in today’s marketplace. Scroll down to read more!

#1. The Digital Revolution

With digital marketing, businesses are no longer limited by geography, time-zone or any of the constraints of traditional marketing methods. Digital technology allows businesses to communicate their marketing message with absolute laser-like precision by targeting, segmenting and positioning specific niche market segments. All that is required is a professional that can plan and implement different marketing techniques to get better outcomes.

#2. You Lack Strategic Direction

If a business wishes to lead the digital world, it is imperative to have clear aims & objectives and a well-developed brand vision. A consultant can be useful for planning clear action plans to make everything happen.

#3. You Want To Dominate The Digital Landscape

If a business wants to become a preeminent name in the industry and dominate the digital landscape, then there is a need of coherent digital marketing strategy. When it comes to digital marketing, the prime focus should be on building marketing gravity that amplifies the market reach with an aim of attracting people to the unique brand value. And, this all can be easily done with the help of a professional digital marketing consultant.

#4.You’re Behind Your Competitors

If your business hasn’t got a clear vision for the future and it’s using an ad-hoc approach with no coherent strategy, then there are chances to fall behind. To avoid such a chaotic situation, it is good to appoint a professional digital marketer.

#5. You Don’t Know Your Unique Brand Value

Understanding your unique brand value will facilitate you to differentiate your offerings and clearly communicate it to your prospective customers so that they do not miss out on the fantastic value that you have to offer them. So, it is advised to get associated with a digital marketing consultant before you start digital marketing.

#6. Your Marketing In Not Integrated

Do not consider digital marketing as a separate function from the rest of the business. It is an integrated approach that can help you achieve your organizational goals and improve ROI in both online and offline channels. All this can be achieved conveniently with the help of a digital marketer.

#7. You Are Not Organized

Taking an ad-hoc approach to digital marketing means you are probably not equipped to respond to the changes that are taking place in the industry right now. In order to take full advantage of the opportunities available in the digital world, investment in resource planning and implementation is vital and it can be made with the help of digital marketing consultant.

If there is no strategy, digital marketing will not benefit you no matter how much time, money or resources you invest. Before approaching a digital marketing consultant, it is advised to measure your digital marketing requirements. If you own a small business, you can go for freelance digital marketing professionals; for the middle-scale firm, you can outsource your digital marketing requirements and for a blue-chip company, you can have an in-house digital marketing team.