How to create a common report from several Excel tables

Learn how to create a common Excel report from several tables on separate sheets for multiple users:

1. Create a query from table / range
2. Append queries in a single database
3. Create a common report Watch the video for cost planning use case.

Learn more about how to automate Excel ...

BI capabilities in Excel

Microsoft Excel is the most popular spreadsheet tool globally.

Although it is not the only program offering functions and Pivot Tables regarding Business Intelligence, Excel is still one of the most commonly used BI tools. With advanced excel skills you can build a simple data w...

How to create Excel Interactive Sales Map

Show on Excel dashboard sales by country and customer.

The Excel solution is quick and easy:

1. Create a PivotTable From the sales database which shows sales by country.
2. Set the TOP 10 filter on the data table. Derive the data from the PivotTable into a new table. Create a map from...

What is an Excel drop-down list and how to use it?

What is an Excel drop-down list?

An Excel drop-down list is a data validation function that allows users to select an option from a list of choices defined in the code list (list of options). Drop-down lists enable controlled data entry in certain cells in the table, which are re...