Microsoft Office 2010-Revisado 2018
Aprenda a utilizar Microsoft Office 2010 y a mejorar su capacidad organizativa y habilidades informáticas hoy en día.
Description
Microsoft Office tiene cinco productos de software que son útiles tanto para estudiantes como para profesionales. Este curso gratuito en línea le ayudará a dominar las funciones, capacidades y usos de Microsoft Word 2010, Microsoft Excel 2010, Microsoft PowerPoint 2010, Microsoft Access 2010 y Microsoft Outlook 2010. Las ventajas de dominar estas herramientas de Microsoft Office son infinitas, ya sea que desee hacer un buen trabajo escolar o mejorar sus habilidades profesionales.
Si ha utilizado una versión más antigua de Microsoft Office, especialmente la versión de 2003 y 2007, le sorprenderá las novedades de Microsoft Office 2010. Para los estudiantes que han completado nuestro curso de iniciación a la informática ABC IT, el curso de Microsoft Office 2010 es el siguiente paso perfecto para actualizar sus conocimientos de Microsoft Office.
Este curso en línea de Microsoft Office es para cualquier persona que desee mejorar su habilidad de oficina, capacidad de organización y conocimiento de la computadora. Si usted es un estudiante con cargas de trabajo relacionado con la computadora, o un profesional que necesita personal con habilidades de MS Office, este curso es para usted. Así que empiece con este curso gratuito y mejore sus habilidades de MS Office hoy en día.
Modules
Módulo 1: Hacer el cambio a Word 2010
-
Learning Outcomes
-
What's new with keyboard shortcuts
-
Reacquaint yourself with everyday tasks
-
Acquaint yourself with the ribbon
-
Some tools appear on demand
-
Behind the scenes: File tab and Backstage view
-
Work between new and earlier versions of Word
-
Lesson Summary
Módulo 2: Nuevo en la Palabra de Whats
-
Learning Outcomes
-
Work in Word anywhere
-
Bring your best ideas to life
-
Document Navigation Pane
-
Work more easily
-
Customize the Ribbon
-
Work better together
-
Coauthoring
-
Lesson Summary
Módulo 3: Creación del primer documento de Word
-
Learning Outcomes
-
Create and save a new document
-
Fix spelling and grammar as you type
-
Add formatting to your text
-
Change page margins
-
Save, print and close a new document
-
Moving around in a document
-
Use formatting marks
-
Move text around in the document
-
Change line spacing and alignment
-
Lesson Summary
Módulo 4: Explorar el documento utilizando el panel de navegación
-
Learning Outcomes
-
See what your document is made of
-
Locate, add to, and reorganize content
-
Find and replace text and other elements
-
Lesson Summary
Módulo 5: Crear documentos visualmente convincentes
-
Learning Outcomes
-
Make your text stand out with special effects
-
Polish your pictures like a pro
-
Add a screenshot without using another program
-
SmartArt graphics: Turn ideas into illustrations
-
Lesson Summary
Módulo 6: obtener el control de números de página, cabeceras y pies de página
-
Learning Outcomes
-
Open the header and footer space; find tools
-
Get more help from Word with style galleries
-
Get less help from Word by using Quick Parts
-
Insert page numbers; use "Page X of Y" format
-
Add the current date and time
-
Add the document filename and path
-
Insert an art logo into a header
-
Adjust header and footer position on the page
-
Use varying headers and footers
-
Remove page numbers, headers, and footers
-
Lesson Summary
Módulo 7: Crear y personalizar una tabla de contenido
-
Learning Outcomes
-
Generate and update a TOC
-
Create and customize a table of contents
-
Mark other styles for use in a TOC
-
Use outline levels to mark text for a TOC
-
Control TOC content and formatting
-
Customize a TOC by changing styles
-
Remove a TOC
-
Lesson Summary
Módulo 8: Crear documentos accesibles
-
Learning Outcomes
-
Heading styles
-
Paragraph styles
-
Add alt text to images and tables
-
Structure tables for easy navigation
-
Tips and tricks
-
Lesson Summary
Módulo 9: Consejos y técnicas de Word 2010
-
Learning Outcomes
-
Open Word quickly
-
Use a template from Office.com
-
Convert a list into a table
-
Make a bulleted list more interesting
-
Crop a picture to shape
-
Zoom with your mouse
-
Put documents on SkyDrive
-
Find and replace text
-
Techniques for selecting things
-
Show or hide the Ribbon
-
Use the Quick Access Toolbar
-
Add a list with checkboxes
-
Lesson Summary
Módulo 10: atajos de teclado
-
Learning Outcomes
-
Introduction
-
How to use access keys
-
Access keys in dialog boxes
-
F6: Another kind of access key
-
How to use key combinations
-
Key combos for working with files
-
Moving around a document
-
Key combos for working with text
-
Other handy shortcuts
-
Lesson Summary
Módulo 11: Seguridad de Microsoft Office 2010
Módulo 12: Hacer el cambio a Excel 2010
-
Learning Outcomes
-
Making the switch to Excel 2010
-
Work with files in the Backstage view
-
Do the basics on the home tab
-
Math, Anywhere
-
Commands when you need them
-
Keyboard shortcuts
-
Keep your favorite buttons visible
-
Work between new and old Excel versions
-
Lesson Summary
Módulo 13: Novedades de Excel 2010
-
Learning Outcomes
-
Access the right tools, at the right time
-
Backstage view in Excel 2010
-
Access workbooks in new ways
-
Make fast, effective comparisons from lists of data
-
Introduction to Sparklines
-
Obtain powerful analysis from your desktop
-
Changes made to functions
-
Create an Excel table
-
Create workbooks with more visual impact
-
Paste with live preview
-
Collaborate on workbooks in new ways
-
Collaborate on a worksheet in the browser
-
Find and fix accessibility issues
-
Extend workbooks in new ways
-
Lesson Summary
Módulo 14: Tareas básicas en Excel 2010
-
Learning Outcomes
-
What is Excel?
-
Ceate, save, print, and apply templates to a workbook
-
Format numbers in a worksheet
-
Create an Excel table, formula and chart your data
-
Filter and sort your data
-
Lesson Summary
Módulo 15: Crear la primera hoja de cálculo
-
Learning Outcomes
-
Meet the Excel spreadsheet
-
Do basic math in Excel
-
Create column titles
-
Let Excel type for you
-
Get more(or less) columns, rows, spreadsheets
-
Keep column titles in sight as you scroll
-
Prepare to print
-
Lesson Summary
Módulo 16: Crear fórmulas
-
Learning Outcomes
-
Formulas in Excel
-
Cell references in formulas
-
The SUM and AVERAGE functions
-
More about cell references and formulas
-
More about functions
-
Lesson Summary
Módulo 17: VLOOKUP-Qué es y cuándo utilizarlo
-
Learning Outcomes
-
What is VLOOKUP
-
How, and when to use VLOOKUP
-
Using more than one spreadsheet with VLOOKUP
-
Using absolute cell references with VLOOKUP
-
Avoiding VLOOKUP errors
-
Lesson Summary
Módulo 18: Comprender los datos de un vistazo con formato condicional
-
Learning Outcomes
-
Format cells to make data stand out
-
Quick formatting
-
Work with rules
-
Make your own rules
-
Lesson Summary
Módulo 19: Sparklines-Utilice pequeños gráficos para mostrar las tendencias de los datos
-
Learning Outcomes
-
Introduction to Sparklines
-
Line sparklines
-
Column sparklines
-
Win, Loss sparklines
-
Lesson Summary
Módulo 20: Utilizar tablas de Excel para gestionar la información
-
Learning Outcomes
-
Introduction to tables
-
Sort, filter, and remove duplicates
-
Using formulas in tables
-
More about formulas
-
Lesson Summary
Módulo 21: La función IF-Qué es y cómo utilizarlo
-
Learning Outcomes
-
Introduction to the IF function
-
Add or multiply IF results
-
Using more than one IF function
-
Lesson Summary
Módulo 22: Cómo crear un gráfico básico en Excel 2010
-
Learning Outcomes
-
Introduction to charts
-
How spreadsheet data appears in a chart
-
Change the chart view
-
Add chart titles
-
Change the look of your chart
-
Make a pie chart
-
More chart types
-
Lesson Summary
Módulo 23: Guardar tiempo creando y ejecutando macros en Excel 2010
-
Learning Outcomes
-
Create and run macros
-
Edit an existing macro to change what it does
-
Save my macro in the Personal Workbook
-
Assign a button to my macro
-
Lesson Summary
Módulo 24: Figura de fechas utilizando fórmulas en Excel 2010
-
Learning Outcomes
-
Dates and formulas
-
Find the number of days between two dates
-
Find the number of workdays between two dates
-
Find the date that falls after a number of workdays
-
Find the date that falls after a number of months
-
Find the date that falls after a year, months, and days
-
Lesson Summary
Módulo 25: Pagos del plan y ahorros en Excel 2010
-
Learning Outcomes
-
Calculate credit cart debt
-
Figure out mortgage payments
-
Calculate vacation savings
-
How a first deposit affects savings
-
Figure out a down payment
-
Paying off a personal loan
-
How much your saving add up to over time
-
Lesson Summary
Módulo 26: atajos de teclado en Excel 2010
-
Learning Outcomes
-
Introduction to keyboard shortcuts
-
Basic keyboard shortcuts
-
Keyboard shortcuts for formulas
-
Keyboard shortcuts for moving around workbooks
-
Keyboard shortcuts for selecting
-
Keyboard shortcuts for adding and inserting
-
Keyboard shortcuts for formatting
-
Introduction to access keys
-
Access keys from previous versions
-
Access keys in dialog boxes
-
Other kinds of access key
-
Lesson Summary
Module 27: First Assessment (Word & Excel)
Module 28: Making the switch to PowerPoint 2010
-
Making the switch to PowerPoint 2010 Learning Outcomes
-
Get acquainted with the ribbon
-
Create slides and format text
-
Insert slide elements
-
Design, animate, review
-
Backstage view
-
Save or undo with the Quick Access Toolbar
-
Keyboard Shortcuts
-
Switch between new and old versions
-
Lesson Summary
Module 29: What's new in PowerPoint 2010
-
Learning Outcomes
-
Create, manage, and collaborate with other people
-
Separate PowerPoint presentation files in different windows
-
Enrich your presentations with video, picture, and animations
-
Embed, edit, and play a video in your presentation
-
Trim an audio or video clip
-
Use bookmarks in your audio and video clips
-
Use transitions with 3-D motion graphic effects
-
Copy and paste animated effects from one object to another
-
Deliver and share your presentations more effectively
-
Broadcast your slide show
-
Identify and resolve accessibility issues
-
Lesson Summary
Module 30: Create your first PowerPoint 2010 presentation
-
Learning Outcomes
-
Create slides and add text
-
Choose a layout, insert a picture, apply a theme
-
Change the size and position of slide elements
-
Add more slide content and use formatting
-
Create speaker notes to use when you present
-
Finalize your slides and notes
-
Save, share and print
-
Lesson Summary
Module 31: Add photos to PowerPoint
-
Learning Outcomes
-
Insert a single photo
-
Use the Clip Art task pane
-
Create a photo album
-
Crop a photo
-
Position photos
-
Styles and effects
-
File sizes
-
Lesson Summary
Module 32: Insert video into a presentation
-
Learning Outcomes
-
Introduction
-
Embed a video
-
Link to a video
-
Size a video
-
Playback options
-
Insert a video from a website
-
Lesson Summary
Module 33: Broadcast a presentation
-
Learning Outcomes
-
Introduction
-
Before you broadcast publicly
-
Start a public broadcast
-
Start an internal broadcast
-
Four thing to keep in mind
-
Features that change during a broadcast
-
Lesson Summary
Module 34: Charts and SmartArt in PowerPoint
-
Learning Outcomes
-
Visualize text with SmartArt
-
Insert new SmartArt
-
Add text and shapes to SmartArt
-
SmartArt examples
-
Visualize data
-
Insert a column chart
-
Other chart examples
-
Customize a chart
-
Lesson Summary
Module 35: Animations and Transitions
-
Learning Outcomes
-
Getting started with animations
-
Animate text, charts and shapes
-
Apply an animation to all slides
-
Add transitions
-
Animation timing
-
Change order and effects
-
Animations with motion paths
-
Lesson Summary
Module 36: Keyboard Shortcuts
-
Learning Outcomes
-
Use access keys
-
Use access keys in dialog boxes
-
Other kinds of access keys
-
Use key combinations
-
Keys for creating new files and slides
-
Keys for working with text
-
Keys for shapes and objects
-
Keys that start and stop a presentation
-
Lesson Summary
Module 37: PowerPoint Tips and Techniques
-
Learning Outcomes
-
Make a slide from a bullet
-
Crop, zoom and reuse
-
Sorter View, screenshot and clipping
-
Show or hide the Ribbon and Quick Access bar
-
Lesson Summary
Module 38: Making the Switch to Microsoft Access 2010
-
Learning Outcomes
-
Get started with Access 2010
-
Start something with the navigation pane
-
Get to know the ribbon
-
Use files from previous versions
-
Get started fast with templates and web databases
-
Design on the fly with layout view
-
Lesson Summary
Module 39: Design and Create New Tables for a Database
-
Learning Outcomes
-
Plan for good design
-
Planning a new database
-
Keys and data types
-
Create tables for a new database
-
Saving, adding and navigating your data
-
Lesson Summary
Module 40: Create Relationships and Queries for a New Database
-
Learning Outcomes
-
Create relationships for a new database
-
Create relationships
-
Set referential integrity
-
Create lookup fields
-
Create queries for a new database
-
Lesson Summary
Module 41: Create Forms and Reports for a New Database
-
Learning Outcomes
-
Create forms for a new database
-
Types of forms
-
Ways to create forms
-
Change forms in layout view
-
Create reports for a new database
-
Lesson Summary
Module 42: Build and Publish Web Databases
-
Learning Outcomes
-
Create and publish a web database
-
Save a changed database to the web
-
Create a web database from scratch
-
Add the web to your database
-
Lesson Summary
Module 43: Access 2010 Keyboard Shortcuts
-
Learning Outcomes
-
Introduction to keyboard shortcuts
-
Basic keyboard shortcuts
-
Moving around in Access
-
keyboard shortcuts for selecting
-
Keyboard shortcuts for editing
-
Introduction to access keys
-
Basic access keys
-
Getting around dialog boxes
-
The property sheet and field list
-
Other kinds of access keys
-
Lesson Summary
Module 44: Making the Switch to Outlook 2010
-
Learning Outcomes
-
Find everyday commands in Outlook 2010
-
Create and send messages
-
Read and respond to messages
-
Print and set Outlook options
-
Get around in your calendar
-
Search and find in Outlook 2010
-
Lesson Summary
Module 45: What's new in Microsoft Outlook 2010
-
Learning Outcomes
-
The ribbon, file tab, conversation view, and start topic
-
Messages and meetings features
-
Instant search improvements
-
Organizing your inbox conversations
-
Calendar improvements
-
E-mail attachment features
-
Improved features
-
Lesson Summary
Module 46: Get Familiar with the Outlook Calendar
-
Learning Outcomes
-
Calendar basics
-
Create meetings
-
Create recurring meeetings
-
Use colour categories and follow-up flags
-
Set tasks and reminders
-
Set all-day events and free/busy data
-
Lesson Summary
Module 47: Manage Your Information and Create RSS Web Feeds
-
Learning Outcomes
-
Stay organized with conditional formatting
-
Conditional formats with calendars and tasks
-
Use your RSS feeds in Outlook
-
Change settings for your RSS feeds
-
Manage your RSS feeds with search folders
-
Unsubscribe from an RSS feed
-
Lesson Summary
Module 48: Organise Messages and Automatic Replies
-
Learning Outcomes
-
Better than just date arrangement
-
Introducing date (conversations)
-
Reading the conversation map
-
Acting conversationally
-
Switching views and using search
-
Use automatic replies
-
Send replies without Exchange
-
Rules to manage mails by
-
Lesson Summary
Module 49: Electronic Business Cards, E-mail Signatures and Instant Search
-
Learning Outcomes
-
Create electronic business cards
-
Change the look and feels of a business card
-
Create e-mail signatures
-
Jazz up your signature
-
Find it with instant search
-
Pile and file with search folders
-
Lesson Summary
Module 50: Organise with Templates and Views
-
Learning Outcomes
-
Create and use templates
-
Use templates with calendars, tasks, and contacts
-
Organise your mailbox with views
-
See just what you need with custom views
-
Reduce clutter with conversations view
-
Lesson Summary
Module 51: Second Assessment (PowerPoint, Access and Outlook)
Course assessment
Learning Outcomes
Después de haber completado este curso, podrá:
- Explicar funciones y funciones de funciones de Microsoft Word 2010.
- Explicar las funciones y las funciones de las funciones de Microsoft Excel 2010.
- Explicar funciones y funciones de funciones de Microsoft PowerPoint 2010.
- Explicar funciones y funciones de funciones de Microsoft Access 2010.
- Explicar las funciones y los usos de las funciones de Microsoft Outlook 2010.
Certification
All Alison courses are free to study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.
Having an official Alison document is a great way to celebrate and share your success. It is:
- Ideal to include with CVs, job applications and portfolios
- A way to show your ability to learn and achieve high results