Summary
Highlights
This section covers tasks such as clearing cell contents of a named range, applying number format with two decimal places, deleting a table row, constructing email addresses using the CONCAT function, swapping chart axis data, and adding a new column with random numbers between 1 and 12 using RANDBETWEEN.
This project begins with importing a text file, using the first row as headers, and adjusting column widths to 12. It then moves to inserting sparklines to show salary and sales values, summing named ranges using the SUM function, converting a table to a range while preserving formatting, moving a chart to a new sheet named 'ventas del banco', and adding a primary vertical axis title 'ventas' to the chart.
Tasks include copying formatting from one cell to another, renaming a table to 'ejercicios', using the COUNTBLANK function to find uncounted days, modifying a chart to remove the legend and display data labels above each column, sorting text data in alphabetical order using the SORT function, and configuring print settings to show specific rows on each printed page.
This section focuses on freezing rows 1, 2, and 3 to keep headers visible, aligning text to the left in a specific cell, applying a three-semaphore conditional formatting icon set to a column, applying a 'Medium 1' table style, entering a formula to multiply two named ranges (valor actual by incremento), and changing the chart's color palette to 'Palette 2'.
This project sets the print area from A4 to G16, filters table data to show only 'DPV' policy types, uses an IF function to display 'sí' (yes) if 'años como miembros' (years as members) is greater than 3 and 'no' otherwise, and employs the LEFT function to extract the first three characters of the month. It also adds 'sueldos de empleados' as alternative text to a chart and uses the DELETE ROWS command to align the table.
The final project extends a formula in cell I5 to the end of the column, removes all conditional formatting rules from the sheet, performs a multi-level sort by 'país' (country) A-Z and 'ciudad' (city) A-Z, uses the MAX function to find the highest number in the 'total' column, creates a clustered column chart showing 'total' by 'ciudades' (cities) as horizontal axis labels, and uses the UNIQUE function to extract unique values from the 'país' column.