elearning1
microsoft learn for educators

Microsoft Excel 2016

The curriculum extends the learning process to ensure that students have the opportunity to explore all areas of a program pertinent to the corresponding MOS certification objectives, or that have been identified as most important for users to understand, through the completion of individual activities. Through this extended practice, the curriculum provides provide a significant opportunity for the hands-on program experience that is expected and required of a successful certification candidate or power user.

This curriculum assumes that students are studying the program by using the associated Microsoft Imagine Academy course or other available curriculum, including but not limited to resources available on the Microsoft Office website, Microsoft Press books or e-books such as the MOS Study Guides, Microsoft Official Curriculum (MOC) courses, Microsoft Official Academic Curriculum (MOAC) courses, and other resources that are appropriate to and available within the student’s specific environment.

Objetivos

  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Create Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Configure Worksheets and Workbooks for Distribution
  • Insert Data in Cells and Ranges
  • Format Cells and Ranges
  • Create Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Configure Worksheets and Workbooks for Distribution
  • Customize Options and Views for Worksheets and Workbooks
  • Summarize Data by Using Functions
  • Summarize Data by Using Functions
  • Navigate in Worksheets and Workbooks
  • Insert Data in Cells and Ranges
  • Format Cells and Ranges
  • Summarize and Organize Data
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Configure Worksheets and Workbooks for Distribution
  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Insert Data in Cells and Ranges
  • Create Worksheets and Workbooks
  • Summarize and Organize Data
  • Create and Manage Tables
  • Manage Table Styles and Options
  • Filter and Sort a Table
  • Perform Conditional Operations

Duración

25 horas

Curso Online

Del 1 de enero 2023
al 31 de diciembre 2023

Programa

  1. Lesson 1: Overview

  2. Lesson 2: Working with Microsoft Excel 2016

  3. Lesson 3: Using Office Backstage

  4. Lesson 4: Using Basic Formulas

  5. Lesson 5: Using Functions

  6. Lesson 6: Formatting Cells and Ranges

  7. Lesson 7: Formatting Worksheets

  8. Lesson 8: Managing Worksheets

  9. Lesson 9: Working with Data and Macros

  10. Lesson 10: Using Advanced Formulas

  11. Lesson 11: Securing Workbooks

  12. Lesson 12: Creating Charts

  13. Lesson 13: Adding Pictures and Shapes to a Worksheet

La portada ha sido diseñada usando imágenes de Freepik.com

Multiples Imagenes
ods gral
ods educación
Otras actividades relacionadas

Suscríbete

Recibe las últimas tendencias tecnológicas y no te pierdas ninguno de nuestros eventos
The subscriber's email address.

Nuestras redes sociales