Skip to content
Excel Academy
  • Home
  • Categories
    • Charts
    • Data
    • Excel Basics
    • Formatting
    • Functions
  • Privacy Policy
  • EnglishEnglish
    • PolskiPolski
    • EnglishEnglish

Month: June 2020

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 find duplicates in Excel?

25 June 202021 August 2020 AgnieszkaData, Excel Basics, Formatting

Remove duplicates command, which I presented in the previous article, allows you to quickly remove duplicate lines, but what should be done, if you only want to find duplicates in Excel, but not delete them? There are two Excel tools […]

Read more

How to remove duplicates in Excel?

24 June 202021 August 2020 AgnieszkaData, Excel Basics

Duplicates in Excel are common issue. Removing duplicates in small spreadsheets is easy – it is just checking the data and removing unnecessary values. In case of large spreadsheets, such process will be very time consuming, but fortunately, Excel has […]

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

Cells formats in Excel

14 June 202021 August 2020 AgnieszkaData, Excel Basics, Formatting

By default, all data entered into cells in Excel are in general format, so it means that no particular number format is specified. However, very often we have to work with numbers that should be formatted in a specific way: […]

Read more

How to format cells in Excel?

14 June 202023 August 2020 AgnieszkaData, Excel Basics, Formatting

In Excel spreadsheet, you can format individual cells and ranges of cells in various ways. Formatting is setting up how your cells should look and which format should be set up for cell’s content. Formatting cells in Excel All commands […]

Read more

How to freeze rows and columns in Excel?

10 June 202023 August 2020 AgnieszkaData, Excel Basics

Freezing rows and columns in Excel is very useful option, when you need to work with lot of data. Freezing means, that some rows and/or columns will be always visible on your screen – even if you scroll your spreadsheet […]

Read more

What is Ribbon in Excel and what are its elements?

7 June 202023 August 2020 AgnieszkaExcel Basics

What is Ribbon? Elements of the Ribbon in Excel Elements of each Ribbon’s tab What is Ribbon? Ribbon is a strip containing various tabs and icons and is located at the top of the application: On the Ribbon you can […]

Read more

Relative, absolute and mixed cell reference in Excel

5 June 202023 August 2020 AgnieszkaExcel Basics

Many formulas used in Excel contain references to other cells. This reference allows Excel automatically refresh formula results. To make more accurate and complex calculations you need to understand, what are cell references in Excel. There are three types of […]

Read more

Posts navigation

Older posts

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.