Excel 2013: Working with Charts and Graphs

4/5 ( ratings)

NB: There are Video Tutorials supporting this eBook. Link to video training is inclusive. Get it on Google Book here .

Visualize data and get new insights into your information with Excel's charts and graphs. Learn how to create and modify charts, graphs, tables, and SmartArt to enhance your spreadsheets or other Office documents. This course covers all of the essential features needed to get up and running with these valuable Excel tools.

Topics include:

• Creating a chart

• Picking a chart type

• Displaying data with tables

• Editing data in a chart

• Adding SmartArt graphics

As a small business owner, which has grown into a medium-sized business, it is been important that I am comfortable running my own spreadsheets and analysing data. Through the years, I have worked with professionals like accountants and other people that have given me valuable input, but it is been necessary that I can analyse that data and crunch it. On top of this, I also produce visual communication material for our clients, so I am often asked to take data and reformat it into a way that is visually pleasing. While a lot of times this involves going into applications like Photoshop or After Effects to create animation, often it starts inside of Excel.

The skills acquired from this version are mostly applicable to newer versions of Excel.

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Computer Based Training is a way to master MS Excel. This is where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

The concept of spreadsheeting has been around for hundreds of years. The process can be described as the ability to arrange numbers, characters and other objects into rows and columns. It is most common that spreadsheets only contain numbers and text. The software version of spreadsheeting basically takes the manual processes described above and puts them into an electronic format. Whilst the accounting industry which most commonly uses spreadsheets they can be used in any situation.