- This event has passed.
Tuesday, October 16, 2018, 6:00 pm - 9:00 pm
Description of the most common advanced functions of the Microsoft Excel spreadsheet, explaining functions that the application has to create, edit and work with complex spreadsheets.
Personnel of the organization in charge of manipulating information in spreadsheets; especially secretaries, assistants, assistants and other positions of an organization that require it.
The course has been structured through the theoretical - practical scheme, that is, the necessary information will be presented to know the theory and apply at the same time the activities that refer to them.
TOPICS TO BE DEVELOPED:
1. Advanced cell formatting
Several advanced options are described regarding the format of cells in the Excel spreadsheet: number formatting, custom and conditional formats, and cell auto-formatting. It also explains how to apply a style to a cell.
Use of functions with conditionals (yes, yes and, yes or), Findv, differentiation of contents in a cell to create functions that allow to perform calculations or organize information quickly. Work with links between different Excel sheets is also analyzed. Finally, the process of calculating the values of the cells is studied:
manual and automatic calculation and various options on this aspect. Functions by categories (mathematics and trigonometric, statistics, text, financial, date and time, etc.), elaboration of formulas with nested functions.
Creation and use of lists in an Excel spreadsheet, use of them in a form and validation of the information entered in cells, creation of forms to filter information.
What filters are and what are they used for in an Excel spreadsheet: filter data to extract only the right data, auto-filter, and work with filtered data.
Description of the creation of subtotals obtained from the data of an Excel spreadsheet, in order to carry out partial and general calculations. How to create and print reports with subtotals.
Create tables on different sheets and join them on a single sheet
7. Handling hyperlinks
Creation of several sheets and join them in a menu from the same or different book, creation of catalogs.
8. Manipulation of dynamic tables and creation of graphs.
Creation and updating of pivot tables and pivot charts in Excel to create complex reports quickly and easily, as well as the creation of charts based on the existing data in it: type and format of the chart and its elements and how it can be edited and print the chart, correct for a custom chart display.
9. Managing Forms
Handling of forms to feed the database and the tools of the programmer file (2007).
10. Handling automatic macros
Make this tool known by applying what was seen in class by creating automatic macros and showing the visual basic program in simple exercises.
11. Data analysis and other topics
Description of various utilities available to the Excel spreadsheet that can help when interpreting and modifying the data in a workbook: search for the goal of a formula, Extract data, remove duplicates, track precedents, dependents, data validation , use of data tables to calculate different results in an operation.
- Knowledge of handling in a Windows environment, Keyboard and Mouse.
- Save, copy, cut and paste text.
- Knowledge on the internet (Mail).
- Knowledge of Basic Excel.
- Handling basic formulas (addition, subtraction, multiplication and division)
- Tables handling.