# Working in Excel with formulas and data tables

Examples of effective solutions for the daily office work with spreadsheets. Creating reports, graphs and charts, various computing operations using formulas and functions. Information for self-learning, training and productivity in the work of the office staff.

## How to work in Excel at the office

How to calculate discounts in

An example of using a data table to find the best combinations when choosing a discount for a client under certain conditions. Matrix of numbers with conditional formatting. Template with sample analysis and what if, download free.

An example of using a data table to find the best combinations when choosing a discount for a client under certain conditions. Matrix of numbers with conditional formatting. Template with sample analysis and what if, download free.

Creating a drop-down list in using tools or macros

Create a drop-down list for tables and ranges. We extend its capabilities: creating data substitution and dependent lists, selecting several elements at once. Simple solutions and macro codes.

Create a drop-down list for tables and ranges. We extend its capabilities: creating data substitution and dependent lists, selecting several elements at once. Simple solutions and macro codes.

The calculation of the effective interest rate on loan in

Calculation of the effective interest rate on the loan, leasing and government bonds is performed using the functions EFFECT, IRR, XIRR, FV, etc. Let's look at examples of how real interest is considered.

Calculation of the effective interest rate on the loan, leasing and government bonds is performed using the functions EFFECT, IRR, XIRR, FV, etc. Let's look at examples of how real interest is considered.

How to add cells in an spreadsheet

Inserting and removing cells in the table on the sheet. Adding ranges in the table. Keyboard shortcuts to insert blank cells.

Inserting and removing cells in the table on the sheet. Adding ranges in the table. Keyboard shortcuts to insert blank cells.

Functions for working with text in

To process string data, the functions of working with text are used. Examples of application of TEXT functions, separation and consolidation of text data, SEARCH, LEFT, RIGHT, MID, LEN, etc.

To process string data, the functions of working with text are used. Examples of application of TEXT functions, separation and consolidation of text data, SEARCH, LEFT, RIGHT, MID, LEN, etc.

How to raise a number to a power in using the formula and operator

Examples of work with powers in numerical calculations with the help of an operator in formulas and functions. The format of writing numbers with a degree in cells. Extraction of the root of a degree.

Examples of work with powers in numerical calculations with the help of an operator in formulas and functions. The format of writing numbers with a degree in cells. Extraction of the root of a degree.

Comparison of two tables in for finding matches in columns

Comparison of two lists in a single sheet on the coincidence of data. Color highlighting of missing values in two similar tables by content.

Comparison of two lists in a single sheet on the coincidence of data. Color highlighting of missing values in two similar tables by content.

How to build a chart on a table in : step by step instruction

How to build a dynamic diagram on a table in Excel? How to quickly add data to an existing histogram? Creating Gantt charts. A step-by-step guide for creating dynamic charts and diagrams.

How to build a dynamic diagram on a table in Excel? How to quickly add data to an existing histogram? Creating Gantt charts. A step-by-step guide for creating dynamic charts and diagrams.

Managing Pivot Tables in

Working with pivot tables for filtering, sorting, grouping. Using formulas with the addition of calculated fields. Insert additional columns in the summary report.

Working with pivot tables for filtering, sorting, grouping. Using formulas with the addition of calculated fields. Insert additional columns in the summary report.

Download excel phone list template

Step by step creation of interactive telephone book template using the INDEX function and the MATCH. Free download database template contacts.

Step by step creation of interactive telephone book template using the INDEX function and the MATCH. Free download database template contacts.

How to make a crossword in 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.

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.

Adjusting a print area in page break preview view

The advantages of page mode to configure the print multi-page documents and large tables. print management. Saving settings in the manager views.

The advantages of page mode to configure the print multi-page documents and large tables. print management. Saving settings in the manager views.

Sorting the data in in rows and columns using formulas

How to sort values in several columns or rows, by cell color, in random order, automatically? Sorting is a convenient tool for implementing many tasks.

How to sort values in several columns or rows, by cell color, in random order, automatically? Sorting is a convenient tool for implementing many tasks.

How to quickly move the cursor to the sheet cells

Fast navigation of the cursor on the cells of the sheet with the help of hot keys and other effective tools. Set the direction of cursor movement after pressing ENTER.

Fast navigation of the cursor on the cells of the sheet with the help of hot keys and other effective tools. Set the direction of cursor movement after pressing ENTER.