Русский Русская версия English English version

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 in Excel using standard functions.
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-fileShare an Excel file workbook.
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-excelSolving tasks in Excel with examples.
Commands and functions for optimization models, logical, mathematical, financial, econometric. Examples of solutions of problems with illustrations and descriptions.
analysis-data-of-reportsAnalysis of data in excel with examples of reports.
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.