## Best Excel Tutorial

The largest Excel knowledge base ✅ The best place to learn Excel online ❤️

#### How to Insert Smartart in Excel

It is very easy to use SmartArt, which can be extremely useful for a lot of things like describing how to perform a specific task, in a step-by-step format or tons of other things.

#### How to open XML files in Excel?

Using XML file on Excel, and working further on it is quite simple. We are going to use Microsoft Excel to use XML, but first you need an XML file.

#### How to Use Camera Tool in Excel

The Camera tool in Excel allows you to capture a picture of a selected range of cells and paste it into another location as a live image that updates dynamically when the source data changes.

This is about learning how to use the camera in the Excel.

#### How to use Solver in Excel

The solver in Excel is part of an analysis tool known as “What-If analysis”. You can use a solver to ascertain an optimal value in one cell known as the “target cell”.

Basically, a solver is used for a group of cells that are directly or indirectly related. Constraints can also be applied to minimize the value that can be used by Solver. We will provide a step-by-step guide on how to use Solver to find a solution to a business problem.

#### How to Geocode a Map Using 3D Maps (Previously Power Maps)

Geocoding creates coordinates for a physical location on a map. In this Excel tutorial, you will learn what a geocode is and how to use geocode with 3D Maps.

We can use geocoding along with address details to map data within Excel. Once Excel recognises the address details and applies a geocode, Excel maps this allowing users to see a geographic representation of the data.

#### How to Use What If Analysis in Excel

What-if analysis is the process of finding an input that will result in a specific output. In other words, What-if analysis can be considered as the opposite of formulas. Formulas calculate an output by providing inputs, while What-if analysis helps you find out what input will result in a specific output.

You can use What-if analysis to estimate your monthly savings that meet your retirement goals, find the return on investment, plan your budget and so on.

#### How to Insert Subtotals in Excel

In this lesson, you will learn how to use Subtotals in Excel. It will help you dealing with data in Excel and creating reports.