Customize Line Charts To Boost Your Data Credibility - Create and Learn

This post will help you to enhance your data credibility and learn more about advanced chart configuration.

Charts + Pictures = Eye-Catching Information! Create and Learn

Studies have found that 90% of the information that we remember is based on visual impact. Try this step by step and learn how to use charts and pictures to create great eye-catching information.

Create beautiful Infographics in Excel - Create and Learn

Infographics are great communication tools and have been used through every media available. You can create beautiful Infographics by using Ms Excel. Try this step by step. Share and let me know if you liked :)

VLOOKUP in 3 Images

Those 3 images from the book Dynamic Infographics, can help you to understand the "VLOOKUP steps". Try the second image in your excel and follow the colors.

Blue - What are you looking for?

Red - Where do you want to search?

Purple: If you found, which column Excel will retrieve your data?

Yellow: Exact match? Ok, type "0" (zero).

Have fun :)

  

Book - Dynamic Infographic - Create and Learn

 

This book will help you to learn the Intermediate Level concepts of MS Excel 2016. You will create a Dynamic Infographic, formatting, building graphics, working with data validation, shapes, images, formulas (including the famous VLOOKUP and HLOOKUP), and more.