Category: Functions

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...

Read More

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