| EXCEL BASICS |
| Basic concepts: |
| 📌 Definition of Microsoft Excel. |
| 📌 Different ways to enter Microsoft Excel. |
| 📌 Description of the Microsoft Excel application window. |
| 📌 Toolbars. |
| 📌 Formula bars. |
| 📌 Name boxes: names with sheet scope and book scope. |
| 📌 Leaf labels. |
| 📌 The Microsoft Excel Workbook 2021. |
| 📌 Optimal management of the Mouse pointer and the selection of ranges and data. |
| 📌 Spreadsheets, sheet protection. |
| 📌 Rows and columns, protection of cells and hiding of data formulas. |
| 📌 Cell and range (range names). |
| 📌 Data types, custom lists. |
| 📌 Multiple entry of data. |
| 📌 Mouse pointer shapes (copy, move, delete, mark). |
| 📌 Filler box. |
| 📌 Continuous and discontinuous selection. |
| 📌 Way to record the Book. |
| 📌 Record with password. |
| 📌 Way to open the Book. |
| 📌 Protection of cell ranges with different access codes |
| 📌 How to hide a sheet with a password |
| 📌 Header, footer, page number and insertion of a logo in a file to print |
| 📌 Page settings and book views. |
| 📌 Data printing settings, convert from Excel to PDF |
| 📌 Practical examples of file printing and data printing area |
| CORE OPERATIONS |
| 📌 Format the sheet. |
| 📌 Using the ribbon buttons – creating our own tab. |
| 📌 Use of tabs: Page Layout and Formulas. |
| 📌 Number, Alignment, Borders, etc. Tabs. |
| 📌 Edit the spreadsheet. |
| 📌 Move and copy ranges. |
| 📌 Show or hide rows and columns. |
| 📌 Insert and/or delete rows and columns. |
| 📌 Modify the width of the columns and the height of the rows. |
| 📌 Fundamental Calculations. |
| 📌 Autosuma button. |
| 📌 Mathematical and text operators. |
| 📌 Formulas with relative, absolute and mixed reference. |
| 📌 Write formulas in natural language using cell labels. |
| 📌 Formula analysis - relative and absolute position of formulas |
| 📌 Data validation: lists, numbers, texts, text length, dates and times. |
| BASIC-ADVANCED FUNCTIONS |
| 📌 Relationship operators. |
| 📌 Use of functions: Sum(), Max(), Min(), Average(), Count(), Count(). |
| 📌 Basic functions (arithmetic, text or string and date). Applications. |
| 📌 Text functions: convert to uppercase, lowercase, proper name. |
| 📌 Use of the spaces function, to remove excess spaces in the records. |
| 📌 How to extract data from a text – the Concatenate() and & function |
| 📌 If(), Integer(), Round(), AND(), OR(). |
| 📌Seekv(), Seekh(), Seek(), Index(), Count.if(), Sum.if(). Application of vLookup() as a Dynamic Matrix function. |
| 📌 Applications of the .if.set() functions |
| 📌 Name a range – local and global names. Using the Name Manager. |
| 📌 Format changes from value type to date type and vice versa – example with Text() and Value() |
| DATABASE MANAGEMENT |
| 📌 Create custom lists. |
| 📌 Database. |
| 📌 Sort a database, eliminate blank spaces and records. |
| 📌 Using more than three criteria. |
| 📌 Using a custom list. |
| 📌 Using the Menu – Data – Filter – Autofilter. |
| 📌 Automatic filters. |
| 📌 Custom filters (advanced). |
| 📌 Using the Menu – Data – Filter – Advanced Filter. |
| 📌 Advanced filter on current sheet and remote sheet. |
| 📌 Range of criteria. |
| 📌 Output range. |
| 📌 Use of the Dynamic Matrix functions: Filter(), Unique() and Sort() |
| 📌 Use of the Menu – Data – Subtotals. |
| 📌 Obtaining summaries by groups or breaks. |
| 📌 Use of the Menu – Data – Report tables and dynamic graphs. |
| 📌 Use of the assistant, Data Segmentation and Time Scales. |
| 📌 Modify a dynamic table. |
| 📌 Use of the dynamic table bar. |
| 📌 Format for dynamic tables. |
| 📌 Design of Dynamic Tables, application of Filters, Percentages (row – column – general total) and Calculated Fields. |
| 📌 Ejemplo de aplicación de Tablas Dinámicas; Diseño, Presentación Porcentual y Elemento y Campo Calculado. |
| CREATION OF GRAPHICS AND PERSONALIZATION |
| 📌 Charts in Microsoft Excel. |
| 📌 Using the graphics wizard. |
| 📌 Types and subtypes of graphics. |
| 📌 Edit a graph. |
| 📌 Format a graph. |
| 📌 Trend lines, line smoothing and equation. |
| 📌 Pie Charts and Chart customization. |
| 📌 Charts and Images in Microsoft Excel. |
| 📌 Image Filter |
| 📌 Using the drawing toolbar. |
| 📌 Group and/or ungroup graphics and drawings. |
| PROCESS AUTOMATION |
| 📌 Creation of custom formats. |
| 📌 Definition of conditional formats. |
| 📌 Operations with date type data. |
| 📌 Dashboard creation applying: data export, segmentation, timeline, filters and dynamic graphs |
| 📌 How to bring data from dynamic tables to Dashboards and form elements. |
EN 
ES