How to get Instant Overview E-Book

Ina Koys

• Herausgeber: Ina Koys
• Kategorie: Fachliteratur
• Sprache: Englisch
• Veröffentlichungsjahr: 2021

Beschreibung

Often, Excel is used to evaluate given data. Which values are critical? Can I see at a glance what the development was like? Can I highlight a whole row if one column has important content? Or ask for the content of two cells, simultaneously? How do I get overview in a thick workbook? How do I get a clear and telling chart? Can I ask Excel in natural language without any formula? All these questions are answered here.

Leseprobe

How to get

Instant Overview

In Excel 365 und 2019

Ina Koys

Short & Spicy, vol. 8

Contents

1      What we’re going to cover

2      Static colours

2.1      Sheet names and tab colours

2.2      The Table feature

3      Setting up your window

4      Keep control of your printout

5      Custom formats

6      Conditional Formatting

6.1      Using the wizard

6.2      Using formulas

7      Sparklines

8      Charts

8.1      Pie Chart

8.2      Column Chart

8.3      Line diagram

9      Talk with Excel!

10      More

0 What we’re going to cover

For many users Excel is a tool to check results of something. Sometimes, simple numbers can explain themselves, sometimes one wants to convert them into graphics. We will look at several ways to get this done.

This booklet is about optics. We will cover some calculation alongside, but not really in-depth. That will be done in a future booklet of this series.

All screen shots are done using Excel 365 in its current form. Like any other feature of Microsoft 365, they may gradually change in the future. In most of the cases, it won’t be a remarkable difference in Excel 2019. With an open eye, both versions will integrate nicely.

If you’d like to download the sample data, you can do so clicking

www.shortandspicy.online

Enjoy your from now on more self-explaining workbooks!

1 Static colours

1.1 Sheet names and tab colours

Sheet names may not be rocket science, still are often ignored. It is not only about clearness of the screen view. They will also make it easier to understand relations and calculations.

One way to get a new sheet is clicking the Plus symbol on the right of the existing sheets. Any sheet can be renamed double-clicking the default name and typing in the new one. Then, to grant it the appropriate colour, right-click the sheet name again and pick a colour from the context menu. As long as the sheet is active, the selected colour will always appear somewhat pale. That’s normal and helps to keep overview.

If one then finds the line-up of sheets inconvenient or inappropriate, their order can always get changed with the left mouse button held down over the sheet name. Excel doesn’t care.

1.2 The Table feature

Not everything that for a human eye looks like a table is also a table from the point of Excel.

---ENDE DER LESEPROBE---