- This event has passed.
Wednesday, January 23, 2019, 6:00 pm - 9: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.
All the personnel of the organization in charge of manipulating a spreadsheet regardless of the graphical environment, as well as Microsoft, Linux and Mac; especially secretaries, assistants, assistants.
OCCUPATIONAL PROFILE (IF APPLICABLE):
- Know the concepts, tools and applications of Financial Excel, using as a basis the knowledge, skills and abilities acquired in Advanced Excel courses.
- Develop skills to handle advanced formula functions.
- Develop skills to manage financial functions.
- Create skills and abilities for managing databases.
All the personnel of the organization in charge of manipulating a spreadsheet regardless of the graphical environment, as well as Microsoft, Linux and Mac; especially secretaries, assistants, assistants
MAXIMUM GROUP OF PEOPLE:
1. 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.
2. 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).
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.
4. Data entry
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.
5. 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 find and replace process in Excel and how to undo and redo actions.
6. 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.
8. Work with functions
Description and use of the existing functions in the Excel spreadsheet: Introduction of functions suggested by Excel (Additions, Subtractions, Multiplications, Divisions), Statistical formulas such as: (Sum, Average, Maximum, Minimum) and the conditional Yes function.
9. 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.
10. 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.
11. Mail Merge
Creation of documents in Word and join them with databases in Excel.
12. Create charts
Creation and modification of graphics 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.
- Save, copy, cut and paste text.
- Knowledge on the internet (mail).
Category A $ 10,000
Category B $ 14,000
Category C $ 103,000
Category D $ 107,000
START: January 23, 2019.
SCHEDULE: 6:00 pm to 9:00 pm Tuesdays, Wednesdays and Fridays.