How to consolidate data in Excel
Any business operation produces a lot of data, even in different forms. Manually enter this data from an Excel sheet to...
excel tutorial
Microsoft Excel App Tutorial. Features explained step by step, tips, shortcuts and methods explained in the articles. Choose an article to read and understand where theartificial intelligence.
How to best organize data and formulas in Excel, for a well-done analysis
Microsoft Excel is the reference tool for data analysis, because it offers many features for organizing data sets,...
Excel charts, what they are, how to create a chart and how to choose the optimal chart
An Excel chart is a visual that represents data in an Excel worksheet....
Examples of Excel Macros written with VBA
The following simple Excel macro examples were written using VBA Estimated reading time: 3 minutes Example...
Excel statistical functions: Tutorial with examples for research, part four
Excel provides a wide range of statistical functions that perform calculations from basic mean, median, and mode to functions...
Excel Statistical Functions: Tutorial with Examples, Part Three
Excel provides a wide range of statistical functions that perform calculations from the mean to the most complex statistical distribution and functions of...
IT Security: how to protect yourself from Excel macro virus attacks
Excel macro security protects your computer from viruses that could be transmitted to your computer via...
Excel macros: what they are and how to use them
If you have a simple series of actions that you need to repeat multiple times, you can have Excel record these...
Excel Pivot Table: basic exercise
To better understand the objectives and effects of using a Pivot Table in Excel, let's see a step by step guide...
How to remove duplicate cells in an Excel sheet
We receive a collection of data, and at a certain point we realize that some of it is duplicated. We need to analyze...
How to find duplicate cells in an Excel sheet
One of the classic activities for finding errors or cleaning an Excel file is to find double cells....
Cash Flow Management Excel Template: Cash Flow Statement Template
Cash flow (or cash flow) is one of the main tools for effective financial statement analysis. Fundamental if you want...
Excel template for budget management: Financial Statement Template
The balance sheet represents the financial position of a company over the course of a financial year, every company can draw an overview from this document...
Excel template for managing the income statement: Profit and Loss Template
The income statement is the document that is part of the financial statements, which summarizes all the company operations that have...
Formulas and matrices in Excel: what they are and how to use them
Excel also provides array functions that allow you to perform calculations on one or more sets of values. In this article...
Excel formulas: What are Excel formulas and how to use them
The term "Excel formulas" can refer to any combination of Excel operators and/or Excel functions. An Excel formula is entered...
Excel statistical functions for calculating averages: Tutorial with examples, part two
Excel provides a wide range of statistical functions that perform calculations from the basic mean, median and mode to the distribution...
Excel statistical functions: Tutorial with examples, part one
Excel provides a wide range of statistical functions that perform calculations from the basic mean, median and mode to the distribution...
excel pivot table: what it is, and how to create it. Tutorial with examples
Pivot tables are a spreadsheet analysis technique. They allow a complete beginner with zero experience...
