Author: Joern Steinz

Important Excel functions

If function Example use case: Calculate commission in the form of 10% for 10.000€ or more turnover, and 5% for commission for turnover that is below. =if(B3>=10000;B3*0,1;B3*0,05) Countif Frequency VLookup Finds a value in a column to the right of a search criteria, e.g. what is the ranking position for the term “wordpress” in our example. Combine  ...

Read More

Conditional formatting in Excel

work in progress…. Conditional formatting comes handy if there is too much data to put into a graph or if you quickly want to analyze data in large dataset. This is how it works: Data bars As usual, the first thing to do is to apply table formatting to your dataset, since this will allow us later to sort and filter our data based on the conditional formatting we apply. But in order have the conditional formatting work best, select a table layout that only colors the headline (the first table layout is usually without color) Select the column...

Read More

Sort and filter in Excel

When you have applied table formatting to your data set, you can now take full advantage of Excel table´s sneaky built in sort and filter functions. You find these functions by clicking on the small triangles in the headline row of your table. Excel directly offers you only sorting and filter options, that are relevant for the respective cells. So if your cells in a column contain text, Excel shows you the text sort and filter options. Equally, if your cells contain numbers, Excel only offers you sort and filter options for numerical formats.   Sorting options in Excel Excel provides you with...

Read More

Table formatting in Excel

Get a worksheet that is clean, visually appealing, and interactive. You will love to this with every data set in Excel! Table formatting is one of the most powerful Excel tools for anyone who is collecting and interpreting data sets. The big benefit of the table formatting options is that they turn static data in tables in a dynamic database. Let´s see how it works. Table formatting in Excel in 2 minutes For this exercise we will use a data export form the Google Search Console. The Google Search Console is mighty tool that shows website owners at which position...

Read More
  • 1
  • 2

About Effective Charts is a Storytelling and Slide Design training service to help you build effective presentations. Contact me me for
  • Presentation Design
  • Data Visualization
  • Storytelling
  • Custom Slides and Reports
  • Workshops

Excel tips & tricks mail

Build your own website

Divi WordPress ThemePartner offer