This post will help you to enhance your data credibility and learn more about advanced chart configuration.
Sunday, May 22, 2016
Wednesday, May 4, 2016
Treemap and Concatenate function. Create and Learn.
Use the CONCATENATE function to improve your TREEMAP data labels.
TREEMAP is a hierarchical chart; it shows how the parts of hierarchy compare in size to each other.
CONCATENATE, one of the text functions, to join two or more text strings into one string.
Try this step-by-step to Create and Learn Excel.
Monday, May 2, 2016
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.
Sunday, May 1, 2016
VLOOKUP + Data Validation. 10 Steps. Create and Learn
Use them together to create great dynamic information in your spreadsheet:
VLOOKUP: use one of the lookup and reference functions, when you need to find things in a table or a range by row.
Data Validation: Use to control the type of data or the values that users enter into a cell.
Thursday, April 28, 2016
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 :)
Wednesday, April 27, 2016
Using Shapes to improve your presentation. Create and Learn
This post will show you how to use shapes, images and custom colors to improve your information and make it more attractive.
Tuesday, April 26, 2016
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 - Budget Control - Create and Learn
This book will help you learn the key concepts of MS Excel in less than 24 hours. You will create a budget control sheet with Upside and Downside, formatting, building graphics and preparing printing.
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.
Book - Dashboard using PivotTable
This book will help you learn the Intermediate Level concepts of MS Excel 2016 in less than 24 hours. You will create a professional Dashboard using PivotTable, formatting, building graphics, working with shapes, images, formulas, PivotCharts, and more.
Subscribe to:
Posts (Atom)