650+ tips on Excel, PowerPoint, Outlook & Windows

I just discovered this immense catalog of tips made by Karen Roem.

This is a collection of more than 650 tips (654 tips at the date of this post) to make you better at all the Windows and Microsoft Office tools.

Here are my favourite 3 tips from Karen:

1) Top 10 Microsoft Outlook shortcuts

  1. CTRL + 1 and CTRL + 2 – Toggle between Mail and Calendar – tip_259.php
  2. CTRL + F – Forward a mail message 
  3. CTRL + G – Go to a specific date – tip_485.php
  4. CTRL + K – Check names in address fields and resolve them against the Address Book – tip_211.html
  5. CTRL + K – Insert Hyperlink – tip_431.php
  6. CTRL + SHIFT + 8 – Show/Hide paragraph marks and other hidden formatting symbols – tip_394.php
  7. F3 – AutoComplete Quick Parts – tip_335.php
  8. F4 – Find text in an email message – tip_108.html
  9. SHIFT + F1 – Reveal Formatting – tip_498.php
  10. SHIFT + F3 – Toggle between UPPER CASE, lower case and Sentence Case 

2) Create a bulleted list in Excel

  1. Select the cell where the list is to appear.
  2. Press ALT + 7 on the numeric keypad.
  3. Type your text.
  4. Press ALT + ENTER if you want to insert another bullet in the same cell.
  5. Repeat steps 2 – 4.

3) Shortcuts in Windows

WIN + D can be used as a toggle to minimize and maximize all windows? But what if you just want to have a quick peek at something on your desktop? Check out the preview shortcut! 

Here’s how: 

  1. Press and hold down the WIN key (the one next to your spacebar) and press the spacebar.
  2. Release the WIN key to return to your last used window.

If you like this post, check the 50 time saving Excel Shortcuts.

Free PowerPoint Template to help you make presentations more professional

You want to make your idea more visual?

You want a quick solution to transform your PowerPoint presentation and make it more professional?

👉 I worked on a free PowerPoint template to help you solved these issues!
Find the presentation here:

You will find inside some great ways to present ideas, list topics, show a project schedule, etc… and on top I added some free icons!

Enjoy!


Check also the free template to learn how to make waterfall chart!

Visual vocabulary: a guide to data visualization

Are you looking for the best way to present some data?

I found a simple and helpful guide from the Financial Times.

In this guide, the visualizations are arranged by type of data relationship and then you have a short explanation to guide you choose the most appropriate chart.

See here the interactive guide.

Or click on the image below for the full PDF.

The FT Visual Vocabulary

On the same topic, check the following article: 10 tips to get better at making Excel Charts.

How to make a Waterfall Chart in Excel? Easy with this free template!

Waterfall Chart Gif

 

Waterfall Charts (also called bridge analysis) are one of the best way to visualize variances between 2 reporting periods or between figures budgeted and actuals.

However, it is tricky to build them in Excel.

This is why have prepared a free and easy ready to use Excel template for you.

This template includes instructions, an illustrative example and a blank table ready to use. Save time and use this template for your next Waterfall!

Download the free template here: Waterfall Chart Template

And if you need more detailed instructions, here is a great video tutorial.

You liked this template? Share it around and don’t forget to subscribe to get more templates from me.


Bonus: I found a free course to learn Power Query. Check the link below:

Click here to get a free course to get the most out of the new Excel function: Power Query

👉Get the free course.

The 5 WHYs

Description

Five whys (or 5 whys) is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem.

The primary goal of the technique is to determine the root cause of a defect or problem by repeating the question “Why?”. Each answer forms the basis of the next question. The “five” in the name derives from an anecdotal observation on the number of iterations needed to resolve the problem.

The method provides no hard and fast rules about what lines of questions to explore, or how long to continue the search for additional root causes. Thus, even when the method is closely followed, the outcome still depends upon the knowledge and persistence of the people involved.

Origin

Sakichi Toyoda, the Japanese industrialist, inventor, and founder of Toyota Industries, developed the 5 Whys technique in the 1930s. It became popular in the 1970s, and Toyota still uses it to solve problems today.

Toyota has a “go and see” philosophy. This means that its decision making is based on an in-depth understanding of what’s actually happening on the shop floor , rather than on what someone in a boardroom thinks might be happening.

The 5 Whys technique is true to this tradition, and it is most effective when the answers come from people who have hands-on experience of the process or problem in question.

The method is remarkably simple: when a problem occurs, you drill down to its root cause by asking “Why?” five times. Then, when a counter-measure becomes apparent, you follow it through to prevent the issue from recurring.

Example

Delays in sales in a production company:

  1. Why is the turnover lower by 20% compared with budget?

Because we have delays on 2 major projects.

  1. Why?

Because it takes more time to build the product as normally.

  1. Why?

Because it is a new product and there are new technical requirements which needed to be modified once we moved into production. 

  1. Why?

Because the feasibility of the new technical requirements were not validated beforehand with the production

  1. Why?

Because to reduce the price and satisfy the client’s demand, we changed the design at the last minute without following the normal process of validating these design changes with the production.


Check also this article “The 12 FP&A Principles”.

The Rule of 72

Have you heard about the Rule of 72 ?

💡Imagine you could calculate how long it take to double your money just with a simple formula.

The rule of 72 is really simple and works as explained below
Doubling Time (# years) = 72/Interest Rate

Example:
What is the doubling time for an investment with a compound interest rate of 8%?
A person using the rule of 72 equation would find the doubling time equal to 9 years.
Calculate this by taking 72 and dividing it by 8.
By performing this the investor can tell that it will take approximately 9 years to double the principal.
It is fairly accurate as the exponential function yields an actual doubling time of 9.006 years.

10 tips for Excel charts to make your life easier! 📈

👉 Get the tutorial Excel file by clicking here: 10 tips for Excel charts
and start training yourself to improve making charts in Excel!

Today I found a simple but excellent tutorial from Microsoft.
You get 10 tips to make charts in a faster and simpler way.

I particularly like the tips number 4 and 9.

This tutorial trains you with the following tips:

1. Quickly make a chart with ALT+F1 shortcut

2. Select specific columns, before creating a chart to show only what you need

3. Expand graph automatically as you add additional columns/row

4. Quickly filter data from a chart.

5. Use PivotCharts when your data isn’t summarized.

6. Create multi-level labels

7. Use a secondary axis to create a combo chart.

8. Hook up a chart title to a cell.

9. Split off slices into a second pie

10. Hover over Chart Elements to get a preview.

Share your other tips in the comment section!

👉 Get the tutorial Excel file by clicking here: 10 tips for Excel charts

 

Power Query Academy

How to optimize your LinkedIn summary? 5 tips and examples.

Nowadays, everybody has a LinkedIn profile which replicates accurately their resume. But how can you differentiate yourself from the others?

You will notice that few people have a summary on their page. Therefore, one of the best way to stand out from the crowd is to write and customize your summary.

Here at High Performers, we give you 5 tips to guide you to optimize and improve your LinkedIn profile summary.

1) What should you write in your LinkedIn profile summary?

There is many way to get the best out of your LinkedIn profile summary. You could do so by doing the following:
– List key words about your expertise, experience, skills and education to maximise your LinkedIn ranking for search by recruiters
-Write about yourself, explain your journey in the professional world and what makes you a valuable asset
-Show your creativity! Attach a creative presentation of you, tell a story, show yourself from a different angle and leave a special impression

2) How to stand out?

You already made the first step by deciding to write your summary! Now what to write to make your LinkedIn Profile summary special?
We recommend to explain here what drives you, what do you stand for, what is your mind-set, your objectives but most of all be genuine.
You can inspire yourself from the great examples that we have listed below, but also from your LinkedIn network. There are great LinkedIn profile summaries out there!
Finally, you can stand out by a call to action at the end of your summary. This call to action can be an invitation to connect, to help or to share a story.

3) Describe your mind set and your main skills

The summary is an opportunity to use the key words which will help you to improve your LinkedIn Profile ranking. But be
You can also list special skills and knowledge that are not traditional in your industry and demonstrate why this is an asset to you.
Being able to show your mind set is one of the great advantage of the LinkedIn Profile summary and that could make the difference in the eyes of a potential recruiter!

4) Attach a photo, a presentation or a video

Did you know that you could attach documents in your summary? That’s maybe the best tip to stand out make your profile come alive with some examples of your work or maybe a presentation of you! You can attach many different types of documents:

  • Video
  • Images
  • Audio
  • Presentations
  • Slide Shows
  • And More!

5) Last but not least, talk about your personality and your personal interests

One of the best way to connect with a potential recruiter can be through personal interests. Actually, doing so will increase your likeability factor. The summary is an excellent opportunity to let you share what you love doing, what you are doing outside of work, what you are currently reading and maybe explain what is special about you and what your friend and family love in you.

If you want to read more about the topic, we recommend you the post “7 LinkedIn Profile Summaries That We Love (And How to Boost Your Own)” from the official LinkedIn blog.

Edit May 2020: Add a banner with a call to action or a description of your profile. Check mine here: https://www.linkedin.com/in/bouchernicolas/

Finally, as a bonus, we have attached here some examples of the best LinkedIn profile summaries.

LinkedIn Profile summary “short version”

Capture

LinkedIn Profile summary with call to action

Bildergebnis für linkedin profile summary best

LinkedIn Profile summary “out of the box”

2014-6-12-linkedin-burda

If you liked this post it will mean a lot to me if you share it around. You can also leave a comment below to contribute with your ideas.