Excel 2010

Помогнете ми да споделя тази колекция
Conditional formating - Nested IFs
2019-05-02 14:05830
IF(condition1, result1, IF(condition2, result2, IF(condition3, result3, result4)))
Conditional formating - If cell contains text then copy/paste text from a different cell
2019-05-02 13:57880
If there is any text in J5 then I want the text from J3 to appear in I5. And if there is numbers? Is it not just to check if the cell is empty? Why not =IF(J5="",J3,J5)
How to find the first weekday of the month in Excel
2018-12-24 12:321940
Source: https://www.intheblack.com/articles/2015/01/29/find-the-first-weekday-of-the-month In the previous post I covered how you can return the last weekday of the month. This post will focus on the formula that returns the first weekday of the mon ...
Add or remove items from a drop-down list
2016-03-25 22:574550
Working with Pivot Tables in Microsoft Excel
2015-08-14 01:425470
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to crea ...
Excel 2010: Dependent Drop-down Lists
2015-07-05 18:335970
This example describes how to create dependent drop-down lists in Excel.
Using VLOOKUP in Excel 2010 /функцията VLOOKUP в ексел 2010
2015-05-08 15:446740
VLOOKUP is one of Excel’s most useful functions, and it’s also one of the least understood. In this article, we demystify VLOOKUP by way of a real-life example. We’ll create a usable Invoice Template for a fictitious company. So what is VLOOK ...
Розовата Долина е областта, в която са разположени най-големите ...
В момента в баластра-та се подвизават:
  • 353 кибика