In this section you’ll find useful resources and ready to use solutions. Enjoy our detailed, step-by-step training and download the training materials and examples.
Use Excel Tables to simplify your work! Learn how to create dynamic ranges, easy-to-read formulas and structured references using a table. In this tutorial, we’ll explain how to add new data to a range or how manage Tables. Keep your formulas ready for auditing! This guide provides useful tricks and examples. Fundamentals of Excel Tables … Read more
Learn how to use traffic lights in Excel! Traffic lights are built for performance tracking and enable you to display project status in an effective way. In the vast majority of cases, it’s not easy to create a native traffic light in Excel. You can use conditional formatting, shapes, named ranges, and linked pictures; if … Read more
Learn how to find, filter, and remove duplicates in Excel using quick and creative methods. If you are working with large data tables, it’s helpful to find unique values or remove duplicate values. Our goal is to show you how to use Excel’s built-in data cleansing tools to find unique values in single or multiple … Read more
Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines) In today’s lesson, we will explain how to use this feature in Excel. Table of contents: How to turn on the Quick Analysis feature Formatting Ranges using Quick Analysis Tool Inserting charts using … Read more
Dynamic charts help us to improve the quality of data visualization. In this post, we will show you the most used solutions in Excel. Use these methods and save your time. Good to know that a great looking dynamic chart is a key element of an excel dashboard. Compare Yearly Sales using dynamic charts Let … Read more
Today’s guide will be all about Excel infographics. Excel is perfect for the task! To build a great data visualization, we can use shapes, widgets, drawings, or texts. What are Infographics? Infographics are a collection of graphs, charts that give an easy-to-understand visual overview of data. No, we are not talking about a simple photo. … Read more
The first part of the tutorial is a step-by-step guide. With its help, you will able to build your very own hierarchical org chart in Excel using employee data. The second part of the guide will be about a VBA solution. The org chart maker tool is quick, easy, and completely free. Speed up the … Read more
In this article, you’ll discover the best free project management templates in Excel that you can edit and download. The bundle will help you track the actual status of the project. Furthermore, you can manage risks and communicate progress for your team members and project owners. What are you waiting for? Browse and download useful … Read more
In this article, you will learn about key performance indicators. Is it easy to create a kpi? From the technological view, yes. Before we take a deep dive, just a few words about how to create a useful KPI. Prepare these four metrics below: Current value: namely where we stand now. Plan value: namely where … Read more