Tools in Excel 365
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.
Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink such as URL or e-mail. You can quickly turn off and turn on the automatic creation of hyperlinks for more comfortable work in Excel ☺.
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.
If you would like to understand better how some of these complex array formulas work, consider using a handy tool - Formula Evaluator:
You can use Excel's AutoCorrect feature to create shortcuts for commonly used words or phrases.
If you simply need to perform a calculation, you can use the Formula bar as a calculator.
Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet without having to enter each cell manually.