Enhanced features of Excel with examples and description

Review of enhanced capabilities of Microsoft Excel via ready real examples with a detailed description.

Examples of tables capabilities

make-crossword-in-excelHow to make a Crossword Puzzle with Excel Functions for Clue.
Creation of an interactive crossword with the verification of the correct answers. Only standard functions without macros are used. Download the finished example of creating a crossword puzzle.
share-excel-fileHow to make an Excel file shared for editing spreadsheet.
Collaborate in Excel in a single file for productive work with a large amount of data. Share the book with the addition and removal of users.
solving-tasks-in-excelExcel Solver Example problems with variables or constraints.
Commands and functions for optimization models, logical, mathematical, financial, econometric. Examples of solutions of problems with illustrations and descriptions.

analysis-data-of-reportsData analysis report template examples for finance in Excel.
Tools with the help of which you can perform a full analysis of the data on the enterprise. Analytical tools: what-if, built-in functions, summary report, data table, graphs and charts. Ready-made examples of financial analysis of the enterprise.
how-to-learn-excelHow to learn Excel on your own.
The instruction for working in Excel is simple and accessible. Introduction to formulas and functions. Editing, moving, deleting, autocomplete values and the basics of formatting cells.

en ru