Skip to content
Excel Academy
  • Home
  • Categories
    • Charts
    • Data
    • Excel Basics
    • Formatting
    • Functions
  • Privacy Policy
  • English
    • Polski
    • English

Functions

How to convert text to numbers in Excel?

23 July 202021 August 2020 AgnieszkaData, Formatting, Functions

When working in Excel, you can quite often have a situation, that values in your spreadsheet look like numbers, but they don’t sum up, multiply or cause errors in formulas. The main reason for this is formatting values as text […]

Read more

Top 10 text functions in Excel

14 July 202021 August 2020 AgnieszkaFunctions

Cleaning, editing and transforming text is very important part of work in Excel. In this article, you can find out 10 most useful and most popular text function, which will improve your work with text data in Excel. LEFT RIGHT […]

Read more

How to use COUNTIF function in Excel?

2 July 202021 August 2020 AgnieszkaFunctions

COUNTIF is very useful function in Excel. It allows to calculate, how many cells in given cell range include specified criteria. Syntax of COUNTIF function How to define COUNIT criteria? Example 1 – basic usage of COUNTIF function Example 2 […]

Read more

How to use SUMIF function?

29 June 20202 July 2020 AgnieszkaFunctions

Quite often we need to calculate sum of values which meet specific conditions, for example are less or greater than 0. For such cases, Excel has special function – SUMIF, which is used to sum values from a given range, […]

Read more

How to combine text in Excel?

20 June 202021 August 2020 AgnieszkaData, Excel Basics, Functions

Quite often, data in an Excel spreadsheet is not ordered in the required way. Sometimes you need to combine texts kept in different cells to one cell. In today’s article, I will show you some methods for combining texts in […]

Read more

How to calculate weighted average in Excel?

17 June 202023 August 2020 AgnieszkaFunctions

Weighted average is a calculation, which includes various degree of importance of values. From this article, you will learn how to calculate a weighted average in Excel by using the SUMPRODUCT and SUM formulas. SUMPRODUCT formula In one of my […]

Read more

How to calculate average in Excel?

1 June 202023 August 2020 AgnieszkaFunctions

When working with numeric data, sooner or later you will need to calculate average values. In this article, I will show you basic methods of calculating average in Excel. Command Average on the Ribbon The first, most basic method of […]

Read more

5 Excel functions for beginners

31 May 20209 July 2020 AgnieszkaFunctions

Excel functions simplify calculations and working on large amounts of data. Thanks to several key functions, you can perform various actions in Excel that will increase performance and significantly reduce the possibility of making calculation errors. There are lot of […]

Read more

Recent Posts

  • Line chart in Excel
  • Pie chart in Excel
  • Column chart in Excel
  • How to fill empty cells in Excel?
  • How to convert text to numbers in Excel?

Facebook

Akademia Excela - Akademia-Excela.pl

Categories

  • Charts
  • Data
  • Excel Basics
  • Formatting
  • Functions

Archives

  • August 2020
  • July 2020
  • June 2020
  • May 2020

analitics

Kontakt

  • Privacy Policy
Powered by WordPress | Theme: Astrid by aThemes.
This site uses cookies to provide services at the highest level. By using this site, you agree to use cookies according to Privacy Policy.AgreePrivacy Policy