Every Microsoft document uses a Theme - a combination of coordinated colors, fonts, and effects that visually convey a certain tone. Using Themes is an easy way to specify the colors, fonts, and a variety of graphic effects in the document. You can apply a Theme or any of the Theme elements: Colors, Fonts, Effects.

The appearance of any Microsoft document, such as an Excel workbook, is determined by a Theme (also known as document Theme) — a combination of colors, fonts, and effects. Themes help to create creative and professional-looking documents without a professional designer.

Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet without visiting each cell manually.

When working with formulas in Excel, it is often necessary to find where a mistake was made. Excel provides very useful tools:

• the simple way to evaluate just a part of a formula,
• the Formula Evaluator allows you to see how the various parts of a nested formula are evaluated and the order in which the formula is evaluated:

A hyperlink in Excel is a text that you can click on to quickly navigate to other spreadsheets, files, or pages on the Internet. You can set up hyperlinks to display files stored on your computer, at remote locations, and on the Internet. For example, see how to organize your workbook using hyperlinks:

Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a Text Import Wizard to import data from different text file formats:

When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a Text Import Wizard to help you to import data correctly. Here you can import all or some data from text files of different formats:

When you work with some Excel elements such as tables, charts, you spend a lot of time positioning them and formatting them. Here will find the feature that Excel proposes to help you create a perfect presentation of your data.

Enable the Developer tab in Excel to manage Excel add-ins, create and run recorded macros, or VBA applications with Microsoft Office programs in 3 simple steps.

The Solver tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.