Microsoft Office 2010 - Revisore 2018
Scopri come utilizzare Microsoft Office 2010 e migliorare la tua capacità organizzativa e le competenze informatiche di oggi.
Description
Microsoft Office dispone di cinque prodotti software utili sia per gli studenti che per i professionisti. Questo corso online gratuito vi aiuterà a padroneggiare le funzioni, le funzionalità e gli utilizzi di Microsoft Word 2010, Microsoft Excel 2010, Microsoft PowerPoint 2010, Microsoft Access 2010 e Microsoft Outlook 2010. I vantaggi di padroneggia questi strumenti di Microsoft Office sono infiniti, sia che tu voglia asso il tuo lavoro di scuola o migliorare le tue capacità di carriera.
Se hai usato una versione più vecchia di Microsoft Office, in particolare 2003 e 2007 versione, ti stupirà delle novità di Microsoft Office 2010! Per gli studenti che hanno completato il nostro corso di computer introduttivo ABC IT, il corso Microsoft Office 2010 è il passo successivo perfetto per ottenere le tue competenze Microsoft Office aggiornate.
Questo corso online di Microsoft Office è per chiunque voglia migliorare la propria abilità d'ufficio, la capacità organizzativa e la conoscenza informatica. Che tu sia uno studente con carichi di lavoro correlato al computer, o un professionista che ha bisogno di personale con competenze MS Office, questo corso è per te. Quindi iniziate con questo corso gratuito, e migliorate oggi le vostre competenze di MS Office.
Modules
Modulo 1: Fare il passaggio 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
Modulo 2: Whats's New in Word
-
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
Modulo 3: Creazione del tuo primo documento 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
Modulo 4: Esplora Il Tuo Documento utilizzando il Pane di navigazione
-
Learning Outcomes
-
See what your document is made of
-
Locate, add to, and reorganize content
-
Find and replace text and other elements
-
Lesson Summary
Modulo 5: Creare documenti di comporre visivamente
-
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
Modulo 6: Ottieni il controllo di Numeri di pagina, intestazioni e Footers
-
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
Modulo 7: Creare e personalizzare una Tabella di Contenuti
-
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
Modulo 8: Creare documenti accessibili
-
Learning Outcomes
-
Heading styles
-
Paragraph styles
-
Add alt text to images and tables
-
Structure tables for easy navigation
-
Tips and tricks
-
Lesson Summary
Modulo 9: Word 2010 consigli e tecniche
-
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
Modulo 10: Collegamenti di tastiera
-
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
Modulo 11: Microsoft Office 2010 Security
Modulo 12: Fare il passaggio 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
Modulo 13: Novità in 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
Modulo 14: Attività di base in 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
Modulo 15: Creare il tuo primo foglio di calcolo
-
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
Modulo 16: Crea Formulas
-
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
Modulo 17: VLOOKUP - Che cos' è e quando utilizzarlo
-
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
Modulo 18: Understand Data a una occhiata con Condizionale Formattazione
-
Learning Outcomes
-
Format cells to make data stand out
-
Quick formatting
-
Work with rules
-
Make your own rules
-
Lesson Summary
Modulo 19: Sparklines - Utilizzare minuscoli grafici per mostrare le tendenze dei dati
-
Learning Outcomes
-
Introduction to Sparklines
-
Line sparklines
-
Column sparklines
-
Win, Loss sparklines
-
Lesson Summary
Modulo 20: Utilizza tabelle Excel per gestire le informazioni
-
Learning Outcomes
-
Introduction to tables
-
Sort, filter, and remove duplicates
-
Using formulas in tables
-
More about formulas
-
Lesson Summary
Modulo 21: La funzione IF - Che cos' è e come utilizzarlo
-
Learning Outcomes
-
Introduction to the IF function
-
Add or multiply IF results
-
Using more than one IF function
-
Lesson Summary
Modulo 22: Come creare un grafico di base in 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
Modulo 23: Tempo di salvataggio mediante creazione e esecuzione di macro in 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
Modulo 24: Figure out date utilizzando formule in 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
Modulo 25: Pagamenti di piano e risparmio in 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
Modulo 26: scorciatori di tastiera in 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
Avendo completato questo corso sarà possibile:
- Spiegare le funzioni e gli utilizzi delle funzioni Microsoft Word 2010.
- Spiegare Microsoft Excel 2010 funzioni e utilizzi.
- Spiegare le funzioni e gli utilizzi delle funzioni Microsoft PowerPoint 2010.
- Spiegare Microsoft Access 2010 funzioni e utilizzi.
- Spiegare Microsoft Outlook 2010 funzioni e utilizzi.
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