EXCEL CHARTS AND GRAPHS NINJA The Best and Fastest Program to Become a Master Using Charts and Graphs in Microsoft Excel (Mejia, Henry E.) (Z-Library)

📄 File Format: PDF

💾 File Size: 2.2 MB

📖 Read Online ⬇️ Download

Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

📄 Page 1

(This page has no text content)

📄 Page 2

EXCEL CHARTS and GRAPHS NINJA (Excel Ninja Series) HENRY E. MEJIA

📄 Page 3

EXCEL CHARTS AND GRAPHS NINJA Copyright © 2020 HENRY E. MEJIA All rights reserved. No part of this publication may be reproduced, stored in any data retrieval system or transmitted in any form or by any electronic, mechanical, photocopying, recording or other means, without the prior written permission of the author, except in the case of brief reviews used in literary reviews and certain non-commercial uses provided by the Copyright Law.

📄 Page 4

ABOUT THE AUTHOR Henry E. Mejia is passionate about progress and goal achieving, he also loves to run and exercise. He works in the insurance industry and likes to invest in the stock market. While doing that, he devotes some time to create Excel written courses like this one, in order to help people to achieve their professional goals. Henry also realized that the vast majority of people use a lot of their work time in front of the computer. That time could be used in more productive or more enjoyable activities, only if people knew how to use Excel a little better. The goal of Henry's books is to open the door for workers and business owners to use Excel more efficiently, so they can have more and better growth opportunities, progress and free time.

📄 Page 5

THANK YOU Thank you for getting this book. This book is all about showing you to use CHARTS as fast as possible. If you want to help the author produce more books like this one please share your honest review about this book on Amazon

📄 Page 6

CONTENTS OTHER BOOKS BY THE AUTHOR INTRODUCTION GET YOUR 26 PRACTICE SPREADSHEETS (.xlsx) CHAPTER 1: BOOK LAYOUT CHAPTER 2: WHAT IS A CHART AND WHICH IS ITS TRUE OBJECTIVE? CHAPTER 3: TYPES OF CHARTS (GENERAL EXPLANATION) CHAPTER 4: CHART TYPE #1 BAR CHART (COLUMN CHART) CHAPTER 5: CHART TYPE #2 PIE CHART CHAPTER 6: CHART TYPE #3 LINE CHART CHAPTER 7: CHART TYPE #4 AREA CHART CHAPTER 8: CHART TYPE # 5 TREE MAP CHART CHAPTER 9 CHART TYPE #6 BRIDGE (WATERFALL) CHART CHAPTER 10: CHART TYPE #7 SCATTERPLOT CHART CHAPTER 11: CHART TYPE #8 HISTOGRAM CHART CHAPTER 12: QUICK FINAL TIPS I WOULD LOVE TO KNOW YOUR COMMENTS

📄 Page 7

OTHER BOOKS BY THE AUTHOR “A STRAIGHTFORWARD, EXERCISE-BASED AND FAST WAY TO LEARN EXCEL FUNCTIONS" - Employee from a State Department of Education CLICK HERE TO KNOW MORE ABOUT “EXCEL FORMULAS NINJA” “I WAS ABLE TO SAVE COUNTLESS HOURS THANKS TO THIS BOOK!"- Department Store Manager CLICK HERE TO KNOW MORE ABOUT “EXCEL SHORTCUTS NINJA”

📄 Page 8

"THE ONLY EXCEL VLOOKUP FUNCTION BOOK YOU WILL EVER NEED" - Sales Manager of an Oil Products Manufacturing Company CLICK HERE TO KNOW MORE ABOUT “EXCEL VLOOKUP CHAMPION” “THIS NEW FORMULA MAKES IT EVEN EASIER THAN EXCEL VLOOKUP FUNCTION" - Manager of a Retail Chain Store CLICK HERE TO KNOW MORE ABOUT “EXCEL XLOOKUP CHAMPION”

📄 Page 9

“THIS BOOK IS SO GREAT! NOW I CAN ANALYZE GIANT DATABASES WITHIN SECONDS!” - Sales Coordinator of a Wholesale Company. CLICK HERE TO KNOW MORE ABOUT “EXCEL PIVOT TABLE CHAMPION” “THIS GREAT AND EASY TO UNDERSTAND BOOK TEACHES A VERY USEFUL WAY TO ANALIZE DATA" - Accounting Manager of a Sportswear Company CLICK HERE TO KNOW MORE ABOUT “EXCEL CONDITIONAL FORMATTING CHAMPION”

📄 Page 10

“The book was engaging and encouraging by providing many examples and exercises. I will eagerly study the other books in the series.” CLICK HERE TO KNOW MORE ABOUT “EXCEL CONDITIONAL FORMATTING CHAMPION”

📄 Page 11

INTRODUCTION Welcome to a new EXCEL NINJA book! The fastest, the most practice- based and definitely the most straightforward Excel Book Series you will ever find! You will learn to use with confidence the most important and useful Excel CHARTS. Excel Ninja Series is all about this: Learning fast Having fun while learning Learning trough practice (from the very beginning) No unnecessary fillers to make the book look longer The most straightforward and lean approach Getting results! Loaded with a gigantic amount of practice spreadsheets, examples, and recommendations. My goal for this Excel Ninja Series was to achieve the perfect balance between a lot of exercises and examples without compromising the straightforward approach, and that’s what you will find here! That being said, I would like to summarize the benefits of becoming an Excel CHARTS and GRAPHS Ninja: Increased chances of getting a promotion and better jobs (Because you are more productive and have better skills) Less workload (Excel does the heavy lifting) More free time Less stress A sense of growth (When you learn something new you feel great, and you know it!) Etc., etc. I could spend more time, word and pages explaining to you the benefits and the importance of becoming an EXCEL CHARTS and GRAPHS NINJA,

📄 Page 12

but I promised that I won’t fill this book with unnecessary words so let’s start the first chapter right now!

📄 Page 13

GET YOUR 26 PRACTICE SPREADSHEETS Before starting Chapter 1 I recommend you to get your 26 practice spreadsheets. Those exercise files are included for everyone who purchases this book. They will serve you at the end of each chapter to reinforce what you have learned and make sure you have learned it well. All you have to do is to send me an email to: ems.online.empire@gmail.com With the Subject “CHARTS AND GRAPHS NINJA PRACTICE SPREADSHEETS” and saying: "Hello, I bought your book EXCEL CHARTS AND GRAPHS NINJA and I need the 26 practice spreadsheets" I will gladly reply your email and send you the files. Now you are ready to start Chapter 1. Let’s go!

📄 Page 14

CHAPTER 1 BOOK LAYOUT In this brief chapter I want to explain to you the book layout. I really believe that it is a lot easier to navigate through this book if you know the exact order from the very beginning. Also, if you feel comfortable, you can skip certain parts and revisit them later, according to what you need at this moment. First, in Chapter 2, I’m going to explain what a Chart is and exactly what it is for. Some people think that charts are used to embellish the work you have done but that is not exactly true. So, in Chapter 2 we are going to go deeply into this concept. Next, in Chapter 3, I want to show to you the most important types of Charts and to provide a fast but clear explanation of each one of them. You’ll understand that each type of Chart serves to its own purposes. You will also learn that to believe that any Chart could do the work is a costly and common mistake among Excel user. In the following Chapters (from Chapter 4 and beyond) we will go deep into each type of Chart individually. You will learn in which scenarios you need to use that specific type of Chart and in which scenarios you need to avoid it. You’ll also learn the strengths and weaknesses of each Chart and the most important features you need to take care off when creating one. Also, as the most important part of each chapter, you will learn through practice by developing your own charts following the exercises provided in this book. The last Chapter of this book gives you some extra advice on how you can become an Excel Ninja by developing your skills in other key Excel features. That said, let’s move on to the next chapter! QUICK CHAPTER SUMMARY

📄 Page 15

There are plenty types of Charts Each of them has its own and strengths and weaknesses The purpose of this book is to train you to use the chart type that you need in each situation you face.

📄 Page 16

CHAPTER 2 WHAT IS A CHART AND WHICH IS ITS TRUE OBJECTIVE? In just a few words, a Chart is a visual representation of data. The data I’m talking about may be just a few values or a lot of them. The main fact here is that a Chart transforms raw data into visual images that include proportions, time, variables, and some other features. Charts transform data into images What is even more important is the objective of those charts. Always remember that the reason you are creating a chart is to TELL A STORY! That’s it. The only reason to create and show a chart is to communicate the story the data is hiding. You see, when you have lots of disorganized (or even organized) numbers, it is so hard to tell if things are going the way you want or not. Even if you are a numbers maniac (like me) sometimes you may find it hard to recognize the patterns inside those numbers. But, when you organize those numbers and create a visual representation of them, you can easily communicate that story to everyone you need. If you need to show the story of previous years’ profits, you need a chart that allows you to show quantity and time relationship. If you need to tell a story about the sales made by each division of the company, you need a chart that allows you to show proportion (not time). If you need to show the strengths of your employees, based on specific features, you need a chart that allows you to show all the features at the same time. I think I have made my point so far. You will need to use the specific chart type that allows you to tell the story you want to tell in the best way

📄 Page 17

possible! So, remember: The only reason to create a chart is to tell a story QUICK CHAPTER SUMMARY: Charts transform data in to visual representations Charts tell stories Specific chart types tell specific stories

📄 Page 18

CHAPTER 3 TYPES OF CHARTS (GENERAL EXPLANATION) Here is one of the most important chapters of the book, because we are going to discover the chart types and you will get a general understanding on how they are commonly used. The main purpose of this chapter is to serve as a brief introduction to the specialized chapters, where we will focus on each of the charts individually. Please notice that when talking about charts, there are some important thing that we want to convey to our audience. Those things fall in one or more of these categories: Development over time Proportion of a whole Relationship between variables Distribution of data BAR CHART The Bar Chart is probably the most used kind of chart and it is super useful. It consists on multiple vertical bars with different height, according to the variable that you are measuring. However, it has its limitations and it should not be used when facing certain situations.

📄 Page 19

The bar chart is excellent to show the development of one variable over time and it also could be used to show the relationship between more variables at a specific point in time. You can’t add too much information to this chart because it would be a mess. With Bar charts, the less information, the better. PIE CHART Pie charts are absolutely the best way to show all the parts of a whole. It is like a Pie with colored slices inside it and it is the one to use when you need to convey proportions. The only important requirement here is that you must include all the parts of the whole (100%). If you miss one slice, you would be giving incorrect information to you audience. LINE CHART Line charts are formed with lines moving from the left to the right. The benefits of them using continuous lines is that they make it easy to follow a trend, thus, line charts are best used to follow the development of multiple variables over time (something that the bar chart can not do).

📄 Page 20

Unlike bar charts, with line charts you can’t show the relationship of 1 variable at a specific point in time, but you do can track the development of multiple variables over time. AREA CHART Area chart is similar to the line charts (they are kind of brothers) but they are best used for different purposes. While line charts are used to track the development of multiple variables over time, area charts are best used to convey the proportion in which every variable contributed to the complete output over time. There are two different area charts that you will learn to use. Stacked Area Chart and 100% Stacked Area Chart. TREEMAP CHART Treemap charts or “Rectangular Charts” are the way to go if you have to show subdivisions of the parts of a whole. What??? Let me explain it better.