- This event has passed.
Saturday, April 27, 2019, 8:00 am - Saturday, May 25, 2019, 12: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.
The main objective of this course is to know and apply the basic concepts of Excel.
- Learn how to save and open an Excel document.
- Acquire basic knowledge about entering and correcting data.
- Work with ranges, functions, and data.
- Learn the basics of formatting a spreadsheet.
- Use movement and movement techniques.
- Know how to use the formulas.
- Know how to create a chart sheet.
- Know the different types of graphs.
All the personnel of the organization in charge of manipulating a spreadsheet; especially secretaries, assistants, assistants.
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.
Need for advances and knowledge in information technology.
TOPICS TO BE DEVELOPED:
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).
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.
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 find and replace process in Excel and how to undo and redo actions.
How you can organize the windows of the Excel program, 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.
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):
Several options are described regarding the formatting 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.
Creation and modification of graphics in an Excel spreadsheet, based on the existing data in it.
Knowledge of management in a Windows environment.
(1 to 2 SMLMV)
(2 to 4 SMLMV)
(+ 4 SMLMV)
DATES AND TIMES
(Saturdays 8:00 a.m. to 12:00 p.m.)
|25 of May|