NATIONAL UNIVERSITY OF SAN AGUSTÍN DE AREQUIPA

Institute of Computer Science

UNIDAD DE CAPÀCITACIÓN

SÍLABUS DE MICROSOFT EXCEL BÁSICO

1. - GENERAL DATA

Programa Free Courses

Course Basic Microsoft Excel
Nº Sesiones Frequency (2 hours per session)
Number of Hours :40 hours
Responsible Teacher / Instructor :
Requirement S.O. Windows
Creation or Update Date December 2019

2. PROGRAMMING OF LEARNING UNITS

UNIT I:
Ability 1: Identify the Characteristics of the Excel Environment
Conceptual Contents Procedural Content Hours Session
Data Entry and Activate the Formula Bar
Delete the content of a cell and edit its cell content
Introduction to Excel and management of
Movement in the sheet with the keyboard and mouse
data. 2 1
Select cell blocks
Remove the cell format
Undo and Redo Option

1
 NATIONAL UNIVERSITY OF SAN AGUSTÍN DE AREQUIPA
Institute of Computer Science
TRAINING UNIT
●Create a List or Data Table
●Modify column width and row height.
●Insert Columns, rows and cells
Remove columns, rows, and cells
Hide or show columns and rows
Working with the sheet environment Auto Fill, Auto Complete 2 2
calculation. Search and Replace Data
●Cut, Copy and Paste Data by developing the paste options
●Working with spreadsheets: Insert, Delete, Copy, Hide,
Show, Change label, Change label color and move sheet.

Conceptual Contents Procedural Contents Session Hours

Use of comments.
What is Format?
Will apply formats to elaborate ●Font Format: Font type, size, and colors
filling templates. Alignment Format: Merge cells, Horizontal alignment 2 3
Vertical alignment and orientation.
Apply cell borders.
Copy Format
It will apply formats according to the ●Number
types Format: Thousands, Monetary, Number, Percentage, General,
of data. Dates. 2 4
Apply custom format for numerical data and date

2
 NATIONAL UNIVERSITY OF SAN AGUSTÍN DE AREQUIPA
Institute of Computer Science
TRAINING UNIT
UNIT III
Capacity 3: Apply Formulas to solve problems in Excel
Conceptual Contents Procedural Contents Session Hours
What is a formula?
Elements of a Formula
●Use of Arithmetic operators (+, -, *, /, ( ),^, %)
●Place formulas solving Operator precedence importance of parentheses.
Basic Equations and 2 5
Logical operators: <, >, <=, >=, <>
Combined.
Text operator &
Fill in cell content
Fill numerical sequence in a range of cells
What is a Reference?
●Apply formulas with Relative Reference
●Apply formulas with Absolute Reference
Maximize performance Apply formulas with Mixed References
2 6
using references. ●Apply formulas with references between Sheets in the same Workbook
Apply formulas with references between different workbooks
●Use of the drag point with formulas with reference.
Define Rank Names.

3
 NATIONAL UNIVERSITY OF SAN AGUSTÍN DE AREQUIPA
Institute of Informatics
TRAINING UNIT
UNIT IV
Capability 4: Using Excel functions
Conceptual Contents Procedural Contents Session Hours
What is a function?
●Enter a function from the formula bar by typing the function.
Perform calculations with Functions
Basic Mathematical and Statistical Functions 2 7
Basic Mathematics and Statistics.
Sum, Average, Count, Counta, Count Blank
Max, Min, Round, k-th largest and k-th smallest

Conditional Statistical and Mathematical Functions

Using conditional functions

COUNTIF and COUNTIFS 2 8
to count, add, and average.
SUMIF and SUMIFS
[Link] and AVERAGEIFS
Strengthening learned topics Propose and solve exercises using the developed functions. 2 9
Evaluation First Evaluation 2 10
Comparison operators
Logical Functions:
Using logical functions for IF (without nesting)
2 11 12
conditional processes. Y
O
[Link]
VLOOKUP
Search functions ●SEARCHH 2 13

4
 NATIONAL UNIVERSITY OF SAN AGUSTÍN DE AREQUIPA
Institute of Computer Science
TRAINING UNIT

Date Functions.
TODAY, NOW
▪AÑO, MES, DIA, DIASEM
DIASLAB SIFECHA
●Using Date, Time functions ▪FECHA, TEXTO
and perform operations of 2 14
Operations for adding or subtracting Dates
conversion.
Date Formats: Years, Months, Days.
Operations to add or subtract Hours
Convert time in hours to decimal hours for calculations.
●Hour Formats: Hour, Minute, Second, hour.
Strengthening learned topics Propose and solve exercises using the developed functions. 2 15

5
 NATIONAL UNIVERSITY OF SAN AGUSTÍN OF AREQUIPA
Institute of Computer Science
TRAINING UNIT

UNIT VI
Capacity 6: Develop queries and manage Data Lists
Conceptual Contents Procedural Contents Session Hours
●Apply Text Functions
UPPERCASE, LOWERCASE AND PROPERNAME
Perform calculations with data types LEFT, RIGHT, AND EXTRACT
2 16
texts. CONCATENATE, &(CONCATENATE)
LONG, SPACES
FIND, DISCOVER
Generate a Statistical Column Chart
Graphical Representation of a Painting ●Add important elements for a chart: Chart Title,
data using Graphs Axis Titles, Data Labeling, and Legends. 2 17
Statisticians Generate Trend Chart (linear).
Generate 3D Graph
Freeze Panels of a Data List
Show two distant areas on the same sheet
Show two books at the same time
Show two sheets at the same time
●Set up a print from Print Preview
Working with book windows and Paper size
divided areas. ●Predefined margins and manual margin. 2 18
Print Tables or Lists of Data Paper orientation.
Print scale.
Repeat title on each page
Page numbering
●Text in Page Header.
Printing Areas

6
 NATIONAL UNIVERSITY OF SAN AUGUSTIN OF AREQUIPA
Institute of Computer Science
TRAINING UNIT
Send to Print.

Evaluation Second Evaluation 2 19

Delivery of grades Grading of exams and submission of grades to coordination 2 20