planilhas

Leon

In this class, we will learn how to use Solver in Excel to solve optimization problems, which involv...

Leon

In the last module we saw several Excel or Google Spreadsheet functions. Let's see in this module w...

Leon

The pivot table in Excel automates everything we have learned to date with just a few clicks

Leon

In this class we will see how to reduce your database in Excel or spreadsheets so that we can only u...

Leon

Let's continue looking at Excel formulas, now let's try to understand COUNTIFUNIQUEIF and AVERAGEIF

Leon

Let's continue looking at Excel formulas, now let's try to understand SUMIF or SUMIF, COUNTIF or COU...

Leon

Within each Excel cell we can perform different calculations. Let's start by looking at what we can...

Leon

Let's switch applications now and see how Microsoft Excel or Google Sheets works

Leon

To develop our functions in Google Spreadsheet we will need to learn Javascript! Let's start with i...