Log In

Excel

This brings your statistics to life: Create charts with pictograms instead of bars
This brings your statistics to life: Create charts with pictograms instead of bars
Transform your Excel charts by replacing standard columns with eye-catching pictograms for clearer, more intuitive data visualization. This step-by-step guide shows you how to select, format, and overlay graphics directly...
5 Min. reading time
Clever: How to reuse documents without accidentally overwriting them
Clever: How to reuse documents without accidentally overwriting them
Duplicating Word documents doesn't have to mean copying files manually or risking the original. Windows Explorer offers a little-known command that creates a clean, independent copy of any existing document...
2 Min. reading time
How Excel automatically compiles age entries into age groups
How Excel automatically compiles age entries into age groups
Keeping track of member age groups in a spreadsheet no longer requires manual counting or guesswork. With the right Excel formulas, you can automatically assign every entry to a defined...
5 Min. reading time
How to turn numbers into stars: for clear visual ratings
How to turn numbers into stars: for clear visual ratings
Turning a simple number into a visual Excel star rating takes just a few steps — no design skills needed. Using the REPEAT function alongside the Wingdings font, Excel automatically...
6 Min. reading time
Add handwritten elements to your documents and set creative accents
Add handwritten elements to your documents and set creative accents
The Excel Draw tab unlocks a surprisingly versatile set of creative tools that go far beyond basic spreadsheets. Using the built-in Highlighter, you can highlight cells in your chosen colour...
2 Min. reading time
Here’s the trick: create a data extract with just a double-click
Here’s the trick: create a data extract with just a double-click
A single double-click on your Excel pivot table is all it takes to generate a complete data extract for any individual salesperson — no manual filtering required. The extracted data...
3 Min. reading time
Discover how to turn your pivot tables into a dynamic analysis tool
Discover how to turn your pivot tables into a dynamic analysis tool
An Excel pivot table with a date field doesn't just organise your data — it unlocks powerful time-based analysis that reveals trends across years, quarters, and months without a single...
4 Min. reading time
Percentage values in pivot tables: How to display percentages correctly
Percentage values in pivot tables: How to display percentages correctly
An Excel pivot table doesn't just sum your data — it can instantly show each value as a share of the total, turning raw figures into meaningful percentage calculation without...
3 Min. reading time
Percentage values in pivot tables: How to display percentages correctly
Percentage values in pivot tables: How to display percentages correctly
An Excel pivot table doesn't just sum your data — it can instantly display each value as a share of the total, turning raw figures into meaningful percentage calculation without...
3 Min. reading time
Excel at its best: From the data list to the pivot table
Excel at its best: From the data list to the pivot table
Mastering the Excel pivot table: how to analyse sales data without writing a single formula — and keep your results current with one right-click. Before creating a pivot table, convert...
6 Min. reading time
Use Excel creatively: How to create a lollipop chart
Use Excel creatively: How to create a lollipop chart
A standard Excel lollipop chart template does not exist — but with one formula and two Unicode symbols, you can build a compelling visual in minutes. The chart creation process...
6 Min. reading time
Remove a background image from your table with just two mouse clicks
Remove a background image from your table with just two mouse clicks
A hidden Excel background image can make an entire spreadsheet practically unreadable — yet removing it takes no more than two clicks. Under the Page Layout tab, the Delete Background...
3 Min. reading time
Learn everything about pivot tables step by step
Learn everything about pivot tables step by step
Excel pivot tables are one of the most powerful tools available for fast, flexible data analysis — with no complicated formulas required. The foundation of any reliable evaluation is a...
3 Min. reading time
Use these options to design your pivot tables clearly and professionally
Use these options to design your pivot tables clearly and professionally
An Excel pivot table becomes far more powerful once you apply precise sorting, targeted filtering, and professional design options — transforming raw data into a clear, structured report in minutes....
5 Min. reading time
Everything at a glance with the „Data slice“ visual filter in your pivot tables
Everything at a glance with the „Data slice“ visual filter in your pivot tables
Excel pivot table slicers replace complex filter menus with a clean, visual interface — large, coloured buttons that let you filter your data instantly and see exactly which criteria are...
4 Min. reading time
15 of 81 articles
Load 15 more articles