- This event has passed.
Monday, November 25, 2019, 8:00 am - Tuesday, December 3, 2019, 5:00 pm
In this course a description of the Microsoft Excel spreadsheet will be made, seeing the functions available in this program when creating and modifying spreadsheets, seeing the use of formats, formulas, functions and graphics in Excel workbooks.
Train participants to use and work with advanced Excel applications, where they can design and build automated spreadsheets, in order to optimize their work and achieve more efficient performance.
OCCUPATIONAL PROFILE (IF APPLICABLE):
Does not apply
All the personnel of the organization in charge of manipulating a spreadsheet; especially secretaries, assistants, assistants.
- Basic Excel
Description of the Microsoft Excel spreadsheet, seeing the functions available in this program when creating and modifying spreadsheets, seeing the use of formats, formulas, functions and graphics in Excel workbooks.
- Introduction to Excel
Introduction to the Excel spreadsheet creation and editing program, describing how to start and close it, as well as its basic environment (windows and menus).
- Work books
Description and use of the documents handled in the Excel spreadsheet, called books. Use of existing sheets in these books: insertion, modification, elimination, copying. It also indicates how to save Excel documents.
- Data input
Describes how to enter numbers, text, dates, in an Excel spreadsheet document, introducing the concept of formula. It also explains several aids that can be useful when filling in the cells of a spreadsheet: Creating series and filling in cells adjacent to a given one.
- Editing a sheet
It explains how to modify the data entered in the cells of an Excel spreadsheet: Editing the data, copying, cutting and pasting, inserting and deleting cells. It also describes the search and replace process in Excel and how to undo and redo actions, sort and filter information.
- Organize sheets
How the windows of the Excel program can be organized, to show several documents, or several parts of a document sheet, as well as the division of a spreadsheet into panels. It also describes the existing spell check function in Excel and how to print spreadsheets in Excel, seeing all the options it allows and the settings that must be applied.
Use of formulas in the Excel spreadsheet: How they are written, operators, how to refer to other cells in the same or other sheets, use of relative and absolute references, how to copy and paste formulas that contain references
- Work with functions
Description and use of the existing functions in the Excel spreadsheet: Introduction of functions suggested by Excel (Sum, Average, Maximum, Minimum) and the conditional Yes function.
- Cell format
Several options are described regarding the format of the cells in the Excel spreadsheet: introduction to the format of the cells, height, width, borders and filling of the same, alignment of the existing data in the cells and text sources used.
- Cell format (II)
Various options are described regarding the format of cells in the Excel spreadsheet: Number format, custom and conditional formats, and cell auto-format. It also explains how to apply a style to a cell.
- Create charts
Creation and modification of charts (columns, bars, circular, linear, etc.) in an Excel spreadsheet, based on the existing data in 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.
PREREQUISITES (IF APPLICABLE):
- Knowledge of handling in a Windows environment, Keyboard and Mouse.
- Handling of basic commands to select, Save, Copy, Cut and Paste text.
- Knowledge of the internet (email management).
EVALUATION (IF APPLY):
At the end of the program, the teacher will carry out an evaluation to know the knowledge acquired
Comfenalco Valle will deliver a certificate of participation to people who meet at least the 80% of the scheduled sessions.
Category A: $19.000
Category A: $24.500
Category A: $66.000
Category A: $68.400