I'm improving my skills with Excel 2016: data processing, IF statements, macros, VBA (I'm learning how to use it). How do I use Excel to manage data? How do I create an Excel database, manage fields and records, and create a form? How do I extract data from an Excel database? How do I filter and sort it? How and when do I use Excel's basic database functions? The functions SUM, STDEV, AVERAGE, COUNT, and MIX?
I'm improving my skills with Excel 2016: Data processing, IF statements, macros, VBA (I'm learning how to use it).
How do I use Excel to manage data? How do I create an Excel database, manage fields and records, and create a form?
How do I extract data from an Excel database? How do I filter and sort it?
How and when to use Excel's database functions?
The functions sum, standard deviation, average, count, mix?…
How to use Excel with an external database?
How do I extract data in Excel? How do I use Microsoft Query?
How do I create a pivot table? A pivot chart, an OLAP cube?…
How to use Power Pivot and Power View in Excel?… How to create measures and performance indicators?…
How do I create a hypothesis table? One-variable, two-variable, or database-linked?
How do I use Excel functions? Logical, date and time, mathematical, statistical, lookup, text, and information functions?
How do you audit Excel formulas? To be sure of the result obtained or to look for an error?
How do I use macros in Excel? How do I secure workbooks, display the "Developer" tab, record a macro, run it, and modify it?
How to use VBA in Excel? Objects, properties, methods, events, conditions, loops, conditional loops?…
