| May.13, 2019 | Extract text between words [UDF] |
| May.01, 2019 | How to use the XNPV function |
| Apr.15, 2019 | How to use the RRI function |
| Apr.04, 2019 | How to use the SET statement |
| Mar.29, 2019 | How to do tiered calculations in one formula |
| Mar.14, 2019 | How to use the ROUNDDOWN function |
| Mar.13, 2019 | How to use the ROUNDUP function |
| Feb.19, 2019 | How to add lines between stacked columns/bars [Excel charts] |
| Feb.08, 2019 | How to sum a cell range |
| Jan.30, 2019 | How to ignore error values using the SMALL function |
| Jan.22, 2019 | How to use the VDB function |
| Jan.21, 2019 | How to use the DDB function |
| Jan.10, 2019 | Highlight unique distinct records |
| Jan.08, 2019 | How to use the AMORLINC function |
| Dec.17, 2018 | How to use the AMORDEGRC function |
| Dec.13, 2018 | How to use the YIELD function |
| Dec.12, 2018 | How to use the SYD function |
| Dec.11, 2018 | How to use the TBILLEQ function |
| Dec.10, 2018 | How to use the TBILLPRICE function |
| Dec.07, 2018 | How to use the TBILLYIELD function |
| Dec.04, 2018 | How to use the UNICODE function |
| Dec.03, 2018 | How to use the UNICHAR function |
| Nov.28, 2018 | How to use the PERCENTRANK.EXC function |
| Nov.26, 2018 | How to use the PERCENTRANK.INC function |
| Nov.16, 2018 | Sum unique distinct numbers |
| Nov.16, 2018 | How to use the PERCENTRANK function |
| Nov.15, 2018 | Highlight current date |
| Nov.15, 2018 | How to use the EVALUATE method |
| Nov.14, 2018 | INDEX MATCH โ Last value |
| Nov.14, 2018 | How to highlight dates based on day of week |
| Nov.14, 2018 | How to create a combined stacked area and a clustered column chart |
| Nov.13, 2018 | How to use the QUARTILE.EXC function |
| Nov.13, 2018 | How to use the QUARTILE function |
| Nov.13, 2018 | Highlight unique/duplicates [Conditional formatting] |
| Nov.12, 2018 | How to find the smallest number excluding zeros |
| Nov.09, 2018 | How to build an arrow chart |
| Nov.07, 2018 | How to highlight weekends [Conditional Formatting] |
| Nov.07, 2018 | How to use the LOGNORM.DIST function |
| Nov.06, 2018 | How to use the GOTO statement [VBA] |
| Nov.06, 2018 | How to count blank cells |
| Nov.05, 2018 | How to use the LOGNORMDIST function |
| Nov.05, 2018 | Highlight cells equal to |
| Nov.05, 2018 | Use slicers to quickly filter chart data |
| Nov.02, 2018 | How to use the LOG10 function |
|
English
Spanish