Working with Formulas and Data Tables in Excel

Examples of effective solutions for daily office tasks with spreadsheets. Creating reports, building charts and diagrams, performing various computational operations using formulas and functions. Information for self-learning, skill improvement, and increasing productivity for office workers.

How to Utilize MS Excel in the Office

Excel Visual DataDownload Dashboards in Excel to present reports with data visualization.

Interactive Excel dashboards for visual data analysis download for free. These visual reports are especially effective in developing quick strategies for influencing results and meeting goals on statistical metrics. The best examples of Excel visualization.

Download templates and dashboards with charts for Excel reports. How to create a template, dashboard, chart, or graph to make a visually appealing report for analysis in Excel? Choose examples of charts with graphs for interactive data visualization in Excel's smart tables and use them for quick decision-making. Download ready-made templates of dynamic charts for use in dashboards, reports, or presentations for free.

presentation-julian-date-formula-for-visualizationPresentation Julian Date Formula for Excel Visualization
Formula for creating formulas for converting the Julian date to the Gregorian date and vice versa. Download a presentation for astrology about the geocentric and heleocentric model of the universe on the zodiacal circle.
calculation-discountsHow to calculate discounts in Excel
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.
drop-down-list-macrosHow to create a drop down menu in excel for database
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.
how-to-make-vacation-scheduleHow to make a vacation schedule in Excel Download Example
How to automatically create a vacation schedule with certain conditions to control the number of employees at work? A convenient and visual schedule for planning vacations for company employees.
copying-data-standard-toolsCopying of sheet data with standard Excel tools
The ways for copying ranges with shortcut keys & the context menu. The replication cell formats without values.
how-sumproduct-works-with-conditionHow SUMPRODUCT function works with a condition in Excel
Presentation of the capabilities of the SUMPRODUCT function with multiple criteria conditions. For example, summing subtotals by a criterion condition.
index-match-multiple-search-criteriaFormula INDEX and MATCH with Multiple Search Criteria in Excel
An example of searching and selecting values from a source table using the formula of the INDEX and SEARCH functions. How to create a formula to search using multiple criteria?
how-to-fill-cells-with-text-and-numeric-valuesHow to Fill Cells with Text and Numeric Values in Excel
Working with formats when filling cells of different types of data. Entering numeric and text values when filling out tables. Learn how to seamlessly enter text and numeric data, format cells for currency and percentages.
how-to-create-jitter-scatter-chartHow to Create Jitter Scatter Chart for Statistics in Excel
An example of creating a scatter chart of jitter distributions in the statistical data view for visual analysis of the most popular values. Free Download MS Excel Chart Template.
managing-pivot-tablesWhat is the use of Pivot Table and Pivot Chart in Excel
Working with pivot tables for filtering, sorting, grouping. Using formulas with the addition of calculated fields. Insert additional columns in the summary report.
download-phone-list-templateDownload 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.
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.
printing-table-headerPrinting of a table header on each page of the Excel sheet
The page setup options to print a table header on each sheet of paper for later convenient viewing of the data. There are pass-through strings and through sheets in the page parameters.
sorting-data-using-formulasSorting the data in Excel 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.
changing-color-scheme-themeChanging the color scheme of the Excel interface Office Theme
The interface of the color scheme is configured in the same way for all programs that are included in the MS Office package.

en ru