Loading Events
  • This event has passed.

Basic Excel

Monday, November 25, 2019, 8:00 am - Tuesday, December 3, 2019, 5:00 pm

BUENAVENTURA, CAUCA VALLEY

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.

 GENERAL OBJECTIVE:
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

ADDRESSED TO:
All the personnel of the organization in charge of manipulating a spreadsheet; especially secretaries, assistants, assistants.

CONTENT ORGANIZATION:

  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).
  3. 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.
  4. 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.
  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 search and replace process in Excel and how to undo and redo actions, sort and filter information.
  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.
  7. Formula
    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 (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. Create charts
    Creation and modification of charts (columns, bars, circular, linear, etc.) in an Excel spreadsheet, based on the existing data in it.

 DURATION:
20 hours.

METHODOLOGY:
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

CERTIFICATION:
Comfenalco Valle will deliver a certificate of participation to people who meet at least the 80% of the scheduled sessions.

INVESTMENT VALUE:
Category A:
$19.000
Category A:
$24.500
Category A:
$66.000
Category A:
$68.400

Details

Start:
Monday, November 25, 2019, 8:00 am
End:
Tuesday, December 3, 2019, 5:00 pm
Event Category:

Organizer

Comfenalco Valley
Phone:
8862727 option 2

Venue

Buenaventura
Cra. 4 # 4-28
BUENAVENTURA, CAUCA'S VALLEY Colombia
+ Google Map
Phone:
(57 + 2) 240 3000 Ext 122, 125 and 137

«List of events

Font Resize
Contrast