Turkey in Transition: The Path to High Income

We still have to learn a lot from other countries. Spain should start to develop.

The World Bank

The World Bank Group has set two goals for the world to achieve by 2030:

• End extreme poverty by decreasing the percentage of people living on less than $1.25 a day to no more than 3%
• Promote shared prosperity by fostering the income growth of the bottom 40% for every country

The World Bank is a vital source of financial and technical assistance to developing countries around the world. We are not a bank in the ordinary sense but a unique partnership to reduce poverty and support development. The World Bank Group comprises five institutions managed by their member countries.

Reconstruction remains an important part of our work. However, at today's World Bank, poverty reduction through an inclusive and sustainable globalization remains the overarching goal of our work.

Click here to enter

Wanderers a short film by Erik Wernquist

Invest in science, technology and innovation. Someday we will expand beyond our limit.

USB OTG DataTraveler microDuo | Kingston

Kingston's DataTraveler® microDuo USB Flash drives provide additional storage in a small, convenient form factor for tablets and smartphones that support the USB OTG (On-The-Go) functionality. The USB OTG standard allows mobile devices to connect directly to supported USB devices. 

DataTraveler microDuo Flash drives allow microUSB ports, often used for charging devices, to be used as expansion ports for additional memory. Ideal for storing large files while travelling, DT microDuo Flash drives give plug-and-play functionality to tablets and smartphones without microSD ports at a lower price per GB than the extra built-in storage on a mobile device.

What is Bitcoin?

Bitcoin is a new kind of money. It's the first decentralized electronic currency not controlled by a single organization or government. It's an open source project, and it is used by more than 100,000 people. All over the world people are trading hundreds of thousands of dollars worth of bitcoin every day with no middle man and no credit card companies. It's a startup currency which has never happened before.

Bitcoin is the first digital currency that is completely distributed. The network is made up of users like yourself so no bank or payment processor is required between you and whoever you're trading with. This decentralization is the basis for Bitcoin's security and freedom.

Email let us send letters for free, anywhere in the world. Skype lets us make phone and video calls for free, anywhere in the world. Now there's bitcoin. Bitcoin lets you send money to anyone online, anywhere in the world for less than a cent per transaction! Bitcoin is a community run system not controlled by any bank or government. There's no wallstreet banker getting rich by standing between you and the people you want to send and receive money from.

Bitcoin is more efficient than all competing currencies. This will drive its adoption in the same way computers were adopted, in that computers made people more efficient in competing in the marketplace. A currency has value by it being widely used. Bitcoin is a startup currency with a deflationary bootstrapping economy. Its use spreads by providing the speculator incentive.

Bitcoin is going to be the biggest opportunity for innovation that the world has seen since the industrial revolution. An idea whose time has come.

The World Trade Organization

The World Trade Organization (WTO) is the only global international organization dealing with the rules of trade between nations. At its heart are the WTO agreements, negotiated and signed by the bulk of the world’s trading nations and ratified in their parliaments. The goal is to help producers of goods and services, exporters, and importers conduct their business.

CamScanner

CamScanner digitize all documents On The Go. Quickly scan documents of all kinds and
auto-optimize the scans quality using its unique technology. Power Your Apps with Document Scanning. Enable your apps to digitalize paper documents with cutting-edge image processing technologies.

It has Intelligent Document Managemen. Provide solution for individuals, small businesses, organizations, governments and schools. It is the perfect fit for those who want to digitize, sync, share and manage various contents on all devices.

View, edit and manage documents on smartphones, tablets, PCs and in browser. Edits made on one device are instantly synced to others.

Easily send document scans to colleagues via email or the cloud and say goodbye to running between your desk and the printer.

Click here to enter

RMIT University and Sports leadership

RMIT is a global university of technology and design and Australia's largest tertiary institution.

The University enjoys an international reputation for excellence in professional and vocational education and outcome-oriented research.

RMIT is a leader in engineering, accounting and finance, computer science and information systems, communication and media studies, psychology, education, law and economics.

RMIT has three campuses in Melbourne, Australia, two campuses in Vietnam and a centre in Barcelona, Spain. We also offer programs through partners in Singapore, Hong Kong, mainland China, Indonesia, Sri Lanka, Belgium, Spain and Germany, and we enjoy research and industry partnerships on every continent.  Click here RMIT

Sports leadership

Sports leadership and volunteer roles are the perfect way to develop your abilities and create the winning edge on your CV. You don't have to play a sport to get involved as a sports leader or volunteer.

Read on to find out more about sports volunteering, recognition for volunteering and the leadership roles of team managers, coaches, trainers, journalists and Redbacks team captains.

Click here to access

 

Social Science Research Network (SSRN)

 

Social Science Research Network (SSRN) is devoted to the rapid worldwide dissemination of social science research and is composed of a number of specialized research networks in each of the social sciences. We have received several excellence awards for our web site.

Each of SSRN's networks encourages the early distribution of research results by distributing Submitted abstracts and by soliciting abstracts of top quality research papers around the world. We now have hundreds of journals, publishers, and institutions in Partners in Publishing that provide working papers for distribution through SSRN's eLibrary and abstracts for publication in SSRN's electronic journals.

Click here SSRN

Welcome to innoresource

Innoresource.org is for you who want to learn more about innovation and innovation studies. It contains information on important research on innovation, leading scholars, research groups, journals, conferences, education programmes and other resources.

Innovation has to do with finding new and better ways of doing things and trying them out in practice. It may take the form of new products, new methods of production or new ways to organise economic activities.

Innovation studies is the scholarly study of how innovations emerge and diffuse, what influences these processes and their social and economic consequences. Research in this area is characterised by a high degree of multi- and interdisciplinarity.

 Click here innoresource

Aprovecha el tiempo en la universidad: Tu profesor, tu primer headhunter

 (*) El artículo original fue publicado en  http://dadeladeylezgz.blogspot.com.es/

Iniciamos sección, que creemos, puede ser muy útil para todos nuestros lectores universitarios, sección que hemos titulado: "Aprovecha el tiempo en la universidad". Es una de nuestras máximas en este pequeño Blog, que se valore y aproveche el tiempo que se pasa en la universidad, que no es un tiempo cualquiera, es un momento importante tanto por el lado de la diversión, el despertar de la conciencia y el ideario personal, como por el lado del trabajo, y de la inversión de tiempo necesario para recoger lo sembrado en la etapa profesional.
Tal vez parezca contradictorio, que diga que es importante divertirse y a la vez trabajar duro, pero es posible, e incluso altamente recomendable. Lo uno sin lo otro no tiene sentido. Desaprovecha tanto su tiempo en la universidad aquel que sólo se divierte y tan apenas pisa la facultad, simplemente preocupándose por un aprobado raspado,  como aquel que sólo busca matriculas de honor y no se divierte, no conoce a gente y no disfruta de una de las etapas más "libres" tanto para la formación de conciencia, como libre de responsabilidades.

Hoy queremos empezar por los profesores, aquellos muchas veces detestados profesores que no se nos ocurre pensar que son personas como nosotros, con buenos y malos días, con preocupaciones y responsabilidades y con necesidades, tanto las que su puesto les obliga, como las personales. Lo primero que diría es que hay que considerarlos humanos, igual que tú y yo, y eso nos ayudará para tener empatía con ellos y poder valorarles, para lo bueno y para lo malo. Hay que exigirles, pero también hay que permitirles ligeros tropiezos, como a todos. He visto situaciones entre profesores y alumnos como iguales muchas veces, fumando o tomando un café juntos, hablando de un titular en un periódico, comiendo en la facultad, o incluso de profesores que se han olvidado sus apuntes y alumnos de otros años se los han dejado. Todos estos hechos no hacen más que acercar posturas, conocimiento mutuo, por el bien de ambas partes. Si no los tratas como iguales, y con respeto, nunca podrás llevarte bien con ellos, y por lo tanto no se llevarán bien contigo.

¿Por qué llevarse bien con los profesores?

• Son expertos en sus respectivas materias, lo que les otorga conocimiento de la misma, y contactos relacionados (periódicos, empresas, otros profesionales, otras universidades, etc.)
• Han realizado tu misma carrera y te pueden aconsejar. Tus padres, tus amigos de la infancia, etc. generalmente no han pasado por esa misma facultad.
• Conocen el entorno, y el mercado mucho mejor que tú. Su experiencia les avala.
• Tienen años de contactos, personales y profesionales. Desde ex-alumnos, hasta ex-compañeros, más todos los contactos que su puesto les da.
• Son personas cultas y muchas veces comprometidas, más que otros grupos profesionales. Si pueden, la gran mayoría estarán encantado de ayudarte a un alumno o ex-alumno.
• Muchos profesores trabajan en grupos de investigación, en proyectos públicos o en fundaciones que pueden necesitar personal.
• Especialmente interesantes los profesores asociados (que trabajan a tiempo parcial en una empresa privada) ya que tienen un contacto diario con el mundo empresarial, y los profesores con empresa propia, que también los hay.

Muchas empresas contactan con profesores para ayudarles en la búsqueda de candidatos con un perfil determinado, y es que las primeras selecciones se dan entre conocidos de conocidos, mucho antes de que las ofertas lleguen a ser públicas en webs o periódicos. Así que ánimo, y al toro. Aprovecha el tiempo en la universidad.

10 Essential Startup Lessons That You May Not Have Learned in College

This year you may have attended a graduation party or two or even have recently had one of your own. Earning a degree is something that should be celebrated. But unless you are looking for certain technical skills, college is not always the best place for entrepreneurs.
That’s not to say that you shouldn’t attend college. It may even be a great place to start a business. It's just that educational institutions aren’t known for teaching essential startup techniques.
In an attempt to fill the gap, here are 10 startup lessons that I never learned in college:

Related: What Helps Entrepreneurs Truck Forward After Massive Loss?

1. Deal with failure. 

An inevitable part of the startup experience is tasting failure. Almost all successful entrepreneurs have failed at one point or other. It’s a learning process that can help you make your next venture a success.
But you won’t learn about this in college. After all, colleges want you to succeed. They want you to graduate and become an esteemed alumni who donates money.
Colleges don’t prepare you for failing a class or not landing a job after graduating. They don’t prep you for failure. Truth is, it’s not the end of the world. This is something that you will have to discover and cope with when joining the startup world.

2. Raise money.

Relatively speaking, raising money for college is a cinch compared with funding a new business. While some people rely on parental support, others pursue loans and grants.
But raising money for a startup is infinitely more complex in its paperwork. Investors and banks expect you to present a detailed business plan that describes how a product works and how it will eventually make them a little something extra.
You may have to negotiate with investors and banks if they don’t at first understand your vision (another skill that you may not have acquired in college).

Related: Shoestring Budget? No Problem. Just Be Creative.

3. Budget. 

In college you probably did not handle considerable sums of money. You lived off student loans, a part-time job or credit cards -- not taxes, payroll, business expenses or office rent. If you had  extra cash, you savored it, even if that meant living off Ramen Noodles for the next two weeks. You really did not have to budget your money.
Just try to do that with a startup.
Being able to understand a profit-and-loss statement or balance sheet is vital. You will have to be able to budget expenses for the next six months, a year or longer --  skills you may not have picked up in a college lecture hall.

4. Pivot if necessary.

College students often change majors and transfer to another school. That's not something widely advertised. But, in fact, 61 percent of students switch their major by the close of sophomore year at the University of Florida, according to The New York Times. And pivoting is something that startups are becoming familiar with.

Related: Do Pivots Matter? Yes, in Almost Every Case.

5. Think outside of the box.

Often in school, there’s a right and wrong answer. But in the startup world, ambiguity rules. 
“If you are not prepared to be wrong, you will never come up with anything original," author and educator Ken Robinson declared in a TED talk, “Schools Kill Creativity,” which has been viewed almost 27 million times.

6. Build the right network.

Connecting with people in college is not the same as engaging with people in the real world. A drinking buddy or roommate who may have been so crucial to you in college won't matter so much as you try to get a startup off the ground.
No matter how tempting it may be to hire friends, they may not be right for your startup. If you majored in business, though, how often do you cross paths with an awesome programmer? Probably never.
When running a startup, be ready and willing to reach out and engage with the right people, instead of just relying on those who are there. With the right network of people, the possibilities are endless.

Related: Where the Real Deals Are Ignited at Conferences -- the Bar

7. Become a salesperson.

If you want your startup to succeed, then you must sell. You’re going to have to market the company's product to employees, investors and clients. But did you ever take a "Salesperson 101" course in college?
Being a top-notch salesperson isn’t hardly something that can be taught in a classroom. It’s a skill that must be refined over time through experience and that entails being able to read people well enough to get them hooked on your company's mission.

8. Mind your health.

Although your college's cafeteria may have stocked nutritious food and included gyms and wellness seminars, your health may not have been a focal point back then. Instead, staying out all night and then skipping class was fine occasionally. 
But at a startup, you and your employees will put a lot of hours and hard work. You just can’t call in sick because you have the sniffles.
Since every day at your startup matters, take note that the Centers for Disease Control has found that overall healthy employees are more productive and call in sick less often.

Related: Managing People Is an Art: 32 Ways to Do it Right.

9. Become a boss.

Some people are natural-born leaders. Others become great leaders in college, like that star quarterback. And still others take business classes that cover all sorts of theories for how to make a better businessperson. But being a boss -- that is, actually managing employees -- is something else entirely.
While great bosses may also be great leaders, not all leaders make great bosses. When that quarterback leaves college, could he look the father of five directly in the eyes and fire him?
Being a great boss means that you should be able to guide, inspire and even make tough decisions. There isn’t a class for that. It’s just another skill you’ll have to learn in the real world.

10. Manage your time. 

In college, because of the abundant stretches of free time, you could enjoy leisure time and also make up for any goofing off.
That won’t happen at a startup.
There is no free time. You’re going to be working essentially 24/7, no matter how tired you may be. So while your friends are enjoying happy hour, don’t become upset about finishing up a business plan, doing research or having a late-night meeting with employees. That’s just the nature of the beast.
What startup lessons did you not learn in college?

Related: 9 Lessons You Won't Learn in Business School 

Original: Entrepreneur

Forget Setting Goals. Focus on This Instead.

 Este artículo fue escrito por James Clear, emprendedor experto en comportamiento científico quien escribe para JamesClear.com (*)

We all have things that we want to achieve in our lives -- getting into the better shape, building a successful business, raising a wonderful family, writing a best-selling book, winning a championship, and so on.
And for most of us, the path to those things starts by setting a specific and actionable goal. At least, this is how I approached my life until recently. I would set goals for classes I took, for weights that I wanted to lift in the gym, and for clients I wanted in my business.
What I'm starting to realize, however, is that when it comes to actually getting things done and making progress in the areas that are important to you, there is a much better way to do things.
It all comes down to the difference between goals and systems.
Let me explain.

The Difference Between Goals and Systems

What's the difference between goals and systems?

• If you're a coach, your goal is to win a championship. Your system is what your team does at practice each day.
• If you're a writer, your goal is to write a book. Your system is the writing schedule that you follow each week.
• If you're a runner, your goal is to run a marathon. Your system is your training schedule for the month.
• If you're an entrepreneur, your goal is to build a million dollar business. Your system is your sales and marketing process.

Now for the really interesting question:
If you completely ignored your goals and focused only on your system, would you still get results?

Related: How You Can Form Good Habits and Stick to Them

For example, if you were a basketball coach and you ignored your goal to win a championship and focused only on what your team does at practice each day, would you still get results?
I think you would.
As an example, I just added up the total word count for the articles I've written this year. (You can see them all here.) In the last 12 months, I've written over 115,000 words. The typical book is about 50,000 to 60,000 words, so I have basically written two books this year.
All of this is such a surprise because I never set a goal for my writing. I didn't measure my progress in relation to some benchmark. I never set a word count goal for any particular article. I never said, "I want to write two books this year."
What I did focus on was writing one article every Monday and Thursday. And after sticking to that schedule for 11 months, the result was 115,000 words. I focused on my system and the process of doing the work. In the end, I enjoyed the same (or perhaps better) results.
Let's talk about three more reasons why you should focus on systems instead of goals.

1. Goals reduce your current happiness.

When you're working toward a goal, you are essentially saying, "I'm not good enough yet, but I will be when I reach my goal."
The problem with this mindset is that you're teaching yourself to always put happiness and success off until the next milestone is achieved. "Once I reach my goal, then I'll be happy. Once I achieve my goal, then I'll be successful."

SOLUTION: Commit to a process, not a goal.
Choosing a goal puts a huge burden on your shoulders. Can you imagine if I had made it my goal to write two books this year? Just writing that sentence stresses me out.
But we do this to ourselves all the time. We place unnecessary stress on ourselves to lose weight or to succeed in business or to write a best-selling novel. Instead, you can keep things simple and reduce stress by focusing on the daily process and sticking to your schedule, rather than worrying about the big, life-changing goals.
When you focus on the practice instead of the performance, you can enjoy the present moment and improve at the same time.

2. Goals are strangely at odds with long-term progress.

You might think your goal will keep you motivated over the long-term, but that's not always true.
Consider someone training for a half-marathon. Many people will work hard for months, but as soon as they finish the race, they stop training. Their goal was to finish the half-marathon and now that they have completed it, that goal is no longer there to motivate them. When all of your hard work is focused on a particular goal, what is left to push you forward after you achieve it?
This can create a type of "yo-yo effect" where people go back and forth from working on a goal to not working on one. This type of cycle makes it difficult to build upon your progress for the long-term.

SOLUTION: Release the need for immediate results.
I was training at the gym last week and I was doing my second-to-last set of clean and jerks. When I hit that rep, I felt a small twinge in my leg. It wasn't painful or an injury, just a sign of fatigue near the end of my workout. For a minute or two, I thought about doing my final set. Then, I reminded myself that I plan to do this for the rest of my life and decided to call it a day.

Related: 8 Steps to Having Wildly Productive Mornings

In a situation like the one above, a goal-based mentality will tell you to finish the workout and reach your goal. After all, if you set a goal and you don't reach it, then you feel like a failure.
But with a systems-based mentality, I had no trouble moving on. Systems-based thinking is never about hitting a particular number, it's about sticking to the process and not missing workouts.
Of course, I know that if I never miss a workout, then I will lift bigger weights in the long-run. And that's why systems are more valuable than goals. Goals are about the short-term result. Systems are about the long-term process. In the end, process always wins.

3. Goals suggest that you can control things that you have no control over.

You can't predict the future. (I know, shocking.)
But every time we set a goal, we try to do it. We try to plan out where we will be and when we will make it there. We try to predict how quickly we can make progress, even though we have no idea what circumstances or situations will arise along the way.
SOLUTION: Build feedback loops.
Each Friday, I spend 15 minutes filling out a small spreadsheet with the most critical metrics for my business. For example, in one column I calculate the conversion rate (the percentage of website visitors that join my free email newsletter each week). I rarely think about this number, but checking that column each week provides a feedback loop that tells me if I'm doing things right. When that number drops, I know that I need to send high quality traffic to my site.
Feedback loops are important for building good systems because they allow you to keep track of many different pieces without feeling the pressure to predict what is going to happen with everything. Forget about predicting the future and build a system that can signal when you need to make adjustments.

Fall In Love With Systems

None of this is to say that goals are useless. However, I've found that goals are good for planning your progress and systems are good for actually making progress.
In fact, I think I'm going to officially declare 2014 the "Year of the Sloth" so that everyone will be forced to slow down and make consistent, methodical progress rather than chasing sexy goals for a few weeks and then flaming out.
Goals can provide direction and even push you forward in the short-term, but eventually a well-designed system will always win. Having a system is what matters. Committing to the process is what makes the difference.

A version of this article was first published on JamesClear.com. For useful ideas on improving your mental and physical performance, join his free weekly newsletter.

Sign in or Post as Guest

(*) El artículo original fue publicado en Entrepreneur.

20 Tricks That Can Make Anyone An Excel Expert

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2010.

1. One Click to Select All

You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds.

 

2. Open Excel Files in Bulk

Rather than open files one by one when you have multiple files you need to handle, there is a handy way to open them all with one click. Select the files you would like to open then press the Enter key on the keyboard, all files will open simultaneously.

 

3. Shift Between Different Excel Files

When you have different spreadsheets open, it’s really annoying shifting between different files because sometimes working on the wrong sheet can ruin the whole project. Using Ctrl + Tab you can shift between different files freely. This function is also applicable to other files like different Windows tabs in Firefox when opened using Windows 7.

 

4. Create a New Shortcut Menu

Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. However, if you want to use more shortcuts, like Copy and Cut, you can set them up as follows:
File->Options->Quick Access Toolbar, add Cut and Copy from the left column to the right, save it.
You will see two more shortcuts added in the top menu.

 

5. Add a Diagonal Line to a Cell

When creating a classmate address list, for example, you may need a diagonal link in the first cell to separate different attributes of rows and columns. How to make it? Everyone knows that Home->Font-> Borders can change different borders for a cell, and even add different colors. However, if you click More Borders, you will get more surprises, like a diagonal line. Click it and save—you can now make it immediately.

 

6. Add More Than One New Row or Column

You may know the way to add one new row or column, but it really wastes a lot of time if you need to insert more than one of these by repeating this action X number of times. The best way is to drag and select X rows or columns (X is two or more) if you want to add X rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop down menu. New rows will be inserted above the row or to the left of the column you first selected.

 

7. Speedily Move and Copy Data in Cells

If you want to move one column of data in a spreadsheet, the fast way is to choose it and move the pointer to the border, after it turns to a crossed arrow icon, drag to move the column freely. What if you want to copy the data? You can press the Ctrl button before you drag to move; the new column will copy all the selected data.

 

8. Speedily Delete Blank Cells

Some default data will be blank, for various reasons. If you need to delete these to maintain accuracy, especially when calculating the average value, the speedy way is to filter out all blank cells and delete them with one click. Choose the column you want to filter, go to Data->Filter, after the downward button shows, undo Select All and then pick up the last option, Blanks. All blank cells will show immediately. Go back to Home and click Delete directly, all of them will be removed.

 

9. Vague Search with Wild Card

You may know how to activate the speedy search by using the shortcut Ctrl + F, but there are two main wild cards—Question Mark and Asterisk—used in Excel spreadsheets to activate a vague search. This is used when you are not sure about the target result. Question Mark stands for one character and Asterisk represents one or more characters. What if you need to search Question Mark and Asterisk as a target result? Don’t forget add a Wave Line in front.

 

10. Generate a Unique Value in a Column

You are aware of the key function of Filter, but few people use the Advanced Filter, which will be repeatedly applied when you need to filter a unique value from data in a column. Click to choose the column and go to Data->Advanced. A pop-up window will show up. As the screenshot shows, click Copy to another location, which should be in accord with the second red rectangular area. Then specify the target location by typing the value or clicking the area-choosing button. In this example, the unique age can be generated from Column C and show in Column E. Don’t forget to choose Unique records only, then click OK. The unique value showing in column E can be the contrast of the original data in C, that’s the reason why it is recommended to copy to another location.

 

11. Input Restriction with Data Validation Function

In order to retain the validity of data, sometimes you need to restrict the input value and offer some tips for further steps. For example, age in this sheet should be whole numbers and all people participating in this survey should be between 18 and 60 years old. To ensure that data outside of this age range isn’t entered, go to Data->Data Validation->Setting, input the conditions and shift to Input Message to give prompts like, “Please input your age with whole number, which should range from 18 to 60.” Users will get this prompt when hanging the pointer in this area and get a warning message if the inputted information is unqualified.

 

12. Fast Navigation with Ctrl + Arrow Button

When you click Ctrl + any arrow button on the keyboard, you can jump to the edge of the sheet in different directions. If you want to jump to the bottom line of the data, just try to click Ctrl + downward button.

 

13. Transpose Data from a Row to a Column

You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste. Here’s how: copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste->Transpose, please note that this function won’t activate until you copy the data first.

 

14. Hide Data Thoroughly

Almost all users know how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data. The best and easiest way to hide data thoroughly is to use the Format Cells function. Choose the area and go to Home->Font->Open Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all the values in the area will be invisible, and can only be found in the preview area next to the Function button.

 

15. Compose Text with &

Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below. Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.

 

16. Transforming the Case of Text

With all the tricks shared here, I’ve tried my best to avoid complicated formulation. But there are still some simple and easy to use formulations to show you, like UPPER, LOWER and PROPER, which can transform texts for different purposes. UPPER will capitalize all characters, LOWER can change text to all lower case and PROPER will only capitalize the first character of a word.

 

17. Input Values Starting with 0

When an input value starts with zero, Excel will delete the zero by default. Rather than reset the Format Cells, this problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.

 

18. Speed up Inputting Complicated Terms with AutoCorrect

If you need to repeat the same value and it is complicated to input, the best way is to use the AutoCorrect function, which will replace your text with the correct text. Take my name, Liza Brown, for example, which can be replaced by LZ. Therefore, every time I input LZ, it can autocorrect to Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and input Replace text with correct text in the red rectangular area, as below.

 

19. One Click to Get More Status

Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value. However, do you know you can move the pointer to the bottom tab and right click to get more status, as shown below?

 

20. Rename a Sheet Using Double Click

There are multiple ways to rename sheets, and most users will right click to choose Rename, which actually wastes a lot of time. The best way is to just click twice, then you can rename it directly.



(*) Este artículo fue escrito por Liza Brown en Lifehack.