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
Programa
-
Lesson 1: Overview
-
Lesson 2: Working with Microsoft Excel 2016
-
Lesson 3: Using Office Backstage
-
Lesson 4: Using Basic Formulas
-
Lesson 5: Using Functions
-
Lesson 6: Formatting Cells and Ranges
-
Lesson 7: Formatting Worksheets
-
Lesson 8: Managing Worksheets
-
Lesson 9: Working with Data and Macros
-
Lesson 10: Using Advanced Formulas
-
Lesson 11: Securing Workbooks
-
Lesson 12: Creating Charts
-
Lesson 13: Adding Pictures and Shapes to a Worksheet
La portada ha sido diseñada usando imágenes de Freepik.com
