Whatta heck do ya want?

Some people use to say: “Whatta heck do ya want”? In a translation into Excel, this means “Tell me what you want to do”. All of you who have been using Excel for a long time recall a “animated clip”, a personal assistant to whom you could ask a question about working in an application. She has long retire, and since the 2016 version, an integral part of the user interface has become a field in which you can enter the term, after which Excel will offer you a solution for your problem.

Corporate reports

Working in large companies, especially multinational corporations, often involves periodically sending the standardized Excel reports that are intended to provide management with information about the business. These are usually consolidated balance sheets and other reports that display key performance indicators, and the employees who should fill them have a task to enter data into ready-made templates.

Picturesque charts

o far, in several “recipes,” you can find out how to create and beautify the charts. This one will be about how to combine charts and images. First, in the case of a simple column column, you will see how to replace the columns with the image. Then we will add the picture as a background. Although it will not be about new features here, using some tricks will help you to make your reports more beautiful.

Scatter chart

When I was in school, and learning about Cartesian (Descartes’s) coordinate system I must admit I liked it a lot! I was in love with the idea that in the intersection of x and y axes, dots can be drawn, and then they connect to the line and show some trend. It’s been a long time since than, and in the honor of legendary Rene Descartes I’ll be creating a recipe about scatter charts.

Speedometer

When analyzing key performance indicators (KPIs) for their display is often used a gauge that resembles a speedometer in a car. This is not a standard Excel chart. There are commercial add-ins used to create this type of chart that could be found on the Internet, but there is a technique to create it by combining and modifying the existing charts of Doughnut and Pie Chart.