Transcript Microsoft Office 2010

Microsoft
Office 2013
Office 2013 and
Windows 8: Essential
Concepts and Skills
Objectives
•
•
•
•
•
Use a touch screen
Perform basic mouse operations
Start Windows and sign in to an account
Identify the objects in the Windows 8 desktop
Identify the apps in and versions of Microsoft
Office 2013
• Run an app
• Identify the components of the Microsoft Office
ribbon
Office 2013 and Windows 8: Essential Concepts and Skills
2
Objectives
•
•
•
•
•
•
Create folders
Save files
Change screen resolution
Perform basic tasks in Microsoft Office apps
Manage files
Use Microsoft Office Help and Windows Help
Office 2013 and Windows 8: Essential Concepts and Skills
3
Roadmap
•
•
•
•
•
Sign in to an account
Use windows
Use Office apps
File and folder management
Switch between apps
Office 2013 and Windows 8: Essential Concepts and Skills
4
Roadmap
•
•
•
•
•
Save and manage files
Change screen resolution
Exit Office apps
Use additional Office apps
Use Office and Windows help
Office 2013 and Windows 8: Essential Concepts and Skills
5
Introduction to the Windows 8 Operating
System
• Windows 8 is the newest version of Microsoft
Windows, which is the most popular and widely
used operating system
• An operating system is a computer program (set
of computer instructions) that coordinates all the
activities of computer hardware such as memory,
storage devices, and printers, and provides the
capability for you to communicate with the
computer
• Windows 8 is used to run apps
Office 2013 and Windows 8: Essential Concepts and Skills
6
Introduction to the Windows 8 Operating
System
• The Windows 8 interface begins with the Start
screen
• A tile is a shortcut to an app or other content
Office 2013 and Windows 8: Essential Concepts and Skills
7
Using a Touch Screen and a Mouse
Office 2013 and Windows 8: Essential Concepts and Skills
8
Using a Touch Screen and a Mouse
Office 2013 and Windows 8: Essential Concepts and Skills
9
Scrolling
• A scroll bar is a
horizontal or vertical bar
that appears when the
contents of an area may
not be visible
completely on the
screen
Office 2013 and Windows 8: Essential Concepts and Skills
10
Signing In to an Account
• Swipe up on the lock screen to display a sign-in
screen
• Tap or click the user icon on the sign-in screen
• If necessary, enter the user account password in
the Password text box.
Office 2013 and Windows 8: Essential Concepts and Skills
11
Logging On to the Computer
Office 2013 and Windows 8: Essential Concepts and Skills
12
The Windows Start Screen
Office 2013 and Windows 8: Essential Concepts and Skills
13
Introduction to Microsoft Office 2013
• Microsoft Office 2013 is the newest version of
Microsoft Office, offering features that provide
users with better functionality and easier ways to
work with the various files they create
– Microsoft Word 2013
– Microsoft PowerPoint 2013
– Microsoft Excel 2013
– Microsoft Access 2013
– Microsoft Outlook 2013
Office 2013 and Windows 8: Essential Concepts and Skills
14
Introduction to Microsoft Office 2013
– Microsoft Publisher 2013
– Microsoft OneNote 2013
– Microsoft InfoPath Designer 2013
– Microsoft SharePoint Workspace 2013
– Microsoft Lync 2013
Office 2013 and Windows 8: Essential Concepts and Skills
15
Microsoft Office 2013 Suites
Office 2013 and Windows 8: Essential Concepts and Skills
16
Running an App from the Start Screen
• If necessary, scroll to display the desired tile
• Tap or click the desired tile to run the app
Office 2013 and Windows 8: Essential Concepts and Skills
17
Running an App from the Start Screen
Office 2013 and Windows 8: Essential Concepts and Skills
18
Switching between an App
and the Start Screen
• Swipe in from the left edge of the screen, and
then back to the left, or point to the lower-left
corner of the desktop to display a thumbnail of
the Start screen
• Tap or click the thumbnail of the Start screen to
display the Start screen
• Tap or click the Desktop tile to redisplay the
desktop
Office 2013 and Windows 8: Essential Concepts and Skills
19
Switching between an App
and the Start Screen
Office 2013 and Windows 8: Essential Concepts and Skills
20
Maximizing a Window
• Tap or click the Maximize button next to the Close
button on the window’s title bar to maximize the
window
Office 2013 and Windows 8: Essential Concepts and Skills
21
The Word Document Window, Ribbon,
and Elements Common to Office Apps
Office 2013 and Windows 8: Essential Concepts and Skills
22
Displaying a Different Tab on the Ribbon
• Tap or click a tab on the ribbon to display it
Office 2013 and Windows 8: Essential Concepts and Skills
23
Collapsing and Expanding the Ribbon
and Using Full Screen Mode
• Tap or click the ‘Collapse the Ribbon’ button on
the ribbon to collapse the ribbon
• Tap or click a tab on the ribbon to expand the tab
• Tap or click the ‘Pin the ribbon’ button on the
expanded tab to restore the ribbon
• Tap or click the ‘Ribbon Display Options’ button to
display the Ribbon Display Options menu
Office 2013 and Windows 8: Essential Concepts and Skills
24
Collapsing and Expanding the Ribbon
and Using Full Screen Mode
• Tap or click Auto-hide Ribbon to hide all the
commands from the screen
• Tap or click the ellipsis to temporarily display the
ribbon
• Tap or click the ‘Ribbon Display Options’ button to
display the Ribbon Display Options menu
• Tap or click ‘Show Tabs and Commands’ to exit
Full Screen mode
Office 2013 and Windows 8: Essential Concepts and Skills
25
Collapsing and Expanding the Ribbon
and Using Full Screen Mode
Office 2013 and Windows 8: Essential Concepts and Skills
26
Using a Shortcut Menu to Relocate
the Quick Access Toolbar
• Press and hold or right-click the Quick Access Toolbar
to display a shortcut menu that presents a list of
commands related to the Quick Access Toolbar
• Tap or click ‘Show Quick Access Toolbar Below the
Ribbon’ on the shortcut menu to display the Quick
Access Toolbar below the ribbon
• Press and hold or right-click the Quick Access Toolbar
to display a shortcut menu
• Tap or click ‘Show Quick Access Toolbar Above the
Ribbon’ on the shortcut menu to return the Quick
Access Toolbar to its original position
Office 2013 and Windows 8: Essential Concepts and Skills
27
Using a Shortcut Menu to Relocate
the Quick Access Toolbar
Office 2013 and Windows 8: Essential Concepts and Skills
28
Customizing the Quick Access Toolbar
• Tap or click the ‘Customize Quick Access Toolbar’
button to display the Customize Quick Access
Toolbar menu
• Tap or click the command you wish to add to the
Quick Access Toolbar
Office 2013 and Windows 8: Essential Concepts and Skills
29
Entering Text in a Document
• With a blank document open in Microsoft Word,
type the text you wish to add
• Press the ENTER key to move the insertion point
to the beginning of the next line
Office 2013 and Windows 8: Essential Concepts and Skills
30
Creating a Folder
• Tap or click the File Explorer app button on the
taskbar to run the File Explorer app
• Tap or click the Documents library in the
navigation pane to display the contents of the
Documents library in the file list
• Tap or click the New folder button on the Quick
Access Toolbar to create a new folder with the
name, New folder, selected in a text box
• Type the desired folder name, and then press the
ENTER key
Office 2013 and Windows 8: Essential Concepts and Skills
31
Creating a Folder
Office 2013 and Windows 8: Essential Concepts and Skills
32
Expanding a Folder, Scrolling through
Folder Contents, and Collapsing a Folder
• Double-tap or double-click the desired folder in
the navigation pane to display its contents and
display a black arrow to the left of the folder icon
• Double-tap or double-click the desired folder in
the navigation pane to collapse the folder
Office 2013 and Windows 8: Essential Concepts and Skills
33
Expanding a Folder, Scrolling through
Folder Contents, and Collapsing a Folder
Office 2013 and Windows 8: Essential Concepts and Skills
34
Switching from One App to Another
• If you are using a mouse, point to the app button
on the taskbar to see a live preview of the
window
• Tap or click the app button or the live preview to
make the app associated with the app button the
active window
Office 2013 and Windows 8: Essential Concepts and Skills
35
Switching from One App to Another
Office 2013 and Windows 8: Essential Concepts and Skills
36
Saving a File in a Folder
• Tap or click the Save button on the Quick Access Toolbar to
display the Save As gallery
• Tap or click the Browse button to display the Save As dialog
box
• Type the file name in the File name box. Do not press the
ENTER key after typing the file name
• Scroll to display the location to which you wish to save the
file
• Expand drives and folders as necessary to locate the
desired save location, and then double-tap or double-click
the folder in which you wish to save the file
• Tap or click the Save button
Office 2013 and Windows 8: Essential Concepts and Skills
37
Saving a File in a Folder
Office 2013 and Windows 8: Essential Concepts and Skills
38
Minimizing and Restoring a Window
• Tap or click the Minimize button on the app’s title
bar to minimize the window
• If necessary, click the app button on the taskbar
to restore the minimized window
Office 2013 and Windows 8: Essential Concepts and Skills
39
Saving a File on SkyDrive
• Tap or click FILE on the ribbon to open the
Backstage view
• Tap or click the Save As tab in the Backstage view
to display the Save As gallery
• Tap or click SkyDrive to display SkyDrive saving
options or a Sign In button, if you are not signed
in already to your Microsoft account
• If your screen displays a Sign In button, tap or
click it to display the Sign in dialog box
Office 2013 and Windows 8: Essential Concepts and Skills
40
Saving a File on SkyDrive
• Type your Microsoft account user name and
password in the text boxes and then tap or click
the Sign in button to sign in to SkyDrive
• Tap or click your SkyDrive to select your SkyDrive
as the storage location
• Tap or click the Browse button to contact the
SkyDrive server and then display the Save As
dialog box
• Tap or click the Save button to save the file on
SkyDrive
Office 2013 and Windows 8: Essential Concepts and Skills
41
Saving a File on SkyDrive
Office 2013 and Windows 8: Essential Concepts and Skills
42
Changing the Screen Resolution
• Tap or click the Show desktop button
• Press and hold or right-click an empty area on the
Windows desktop to display a shortcut menu that
displays a list of commands related to the desktop
• Tap or click Screen resolution on the shortcut
menu to open the Screen Resolution window
• Tap or click the Resolution button in the Screen
Resolution window to display the resolution slider
Office 2013 and Windows 8: Essential Concepts and Skills
43
Changing the Screen Resolution
• If necessary, drag the resolution slider to the
desired screen resolution
• Tap or click an empty area of the Screen
Resolution window to close the resolution slider
• Tap or click the OK button to change the screen
resolution
• Tap or click the Keep changes button to accept the
new resolution
Office 2013 and Windows 8: Essential Concepts and Skills
44
Changing the Screen Resolution
Office 2013 and Windows 8: Essential Concepts and Skills
45
Exiting an Office App
with One Document Open
• Tap or click the Close button on the right side of
the app’s title bar
• If necessary, save changes to the document
Office 2013 and Windows 8: Essential Concepts and Skills
46
Copying a Folder to a USB Flash Drive
• Insert a USB flash drive in an available USB port on the
computer to connect the USB flash drive
• Tap or click the File Explorer app button on the taskbar to
make the folder window the active window
• Navigate to the location of the folder you wish to copy
• Press and hold or right-click the folder to display a shortcut
menu
• Tap or point to Send to
• Tap or click the USB flash drive to copy the folder to the
USB flash drive
Office 2013 and Windows 8: Essential Concepts and Skills
47
Copying a Folder to a USB Flash Drive
Office 2013 and Windows 8: Essential Concepts and Skills
48
PowerPoint
• PowerPoint is a full-featured presentation app
that allows you to produce compelling
presentations to deliver and share with an
audience
Office 2013 and Windows 8: Essential Concepts and Skills
49
Running an App
Using the Search Box
• Swipe in from the right edge of the screen or
point to the upper-right corner of the screen to
display the Charms bar
• Tap or click the Search charm on the Charms bar
to display the Search menu
• Type the app name as the search text in the
Search box
• Tap or click the desired app name in the search
results to run the app
Office 2013 and Windows 8: Essential Concepts and Skills
50
Running an App
Using the Search Box
Office 2013 and Windows 8: Essential Concepts and Skills
51
The PowerPoint Window and Ribbon
Office 2013 and Windows 8: Essential Concepts and Skills
52
Entering Content in a Title Slide
• Tap or click the ‘Click to add title’ label located
inside the title text placeholder to select the
placeholder
• Type the presentation title in the title text
placeholder
• Do not press the ENTER key because you do not
want to create a new line of text
Office 2013 and Windows 8: Essential Concepts and Skills
53
Entering Content in a Title Slide
Office 2013 and Windows 8: Essential Concepts and Skills
54
Creating a New Office Document
from the Backstage View
• Tap or click FILE on the ribbon to open the
Backstage view
• Tap or click the New tab in the Backstage view to
display the New gallery
• Tap or click the desired thumbnail in the New
gallery to create a new presentation
Office 2013 and Windows 8: Essential Concepts and Skills
55
Creating a New Office Document
from the Backstage View
Office 2013 and Windows 8: Essential Concepts and Skills
56
Closing an Office File Using the
Backstage View
• Tap or click FILE on the ribbon to open the
Backstage view
• Tap or click Close in the Backstage view to close
the open file without exiting the active app
Office 2013 and Windows 8: Essential Concepts and Skills
57
Opening a Recent Office File Using the
Backstage View
• Tap or click FILE on the ribbon to open the
Backstage view
• Tap or click the Open tab in the Backstage view to
display the Open gallery
• Tap or click the desired file name in the Recent
Presentations list to open the file
Office 2013 and Windows 8: Essential Concepts and Skills
58
Opening a Recent Office File Using the
Backstage View
Office 2013 and Windows 8: Essential Concepts and Skills
59
Excel
• Excel is a powerful spreadsheet app that allows
users to organize data, complete calculations,
make decisions, graph data, develop professionallooking reports, publish organized data to the
Web, and access real-time data from websites
– Workbooks and worksheets
– Charts
– Tables
– Web Support
Office 2013 and Windows 8: Essential Concepts and Skills
60
Excel
Office 2013 and Windows 8: Essential Concepts and Skills
61
Creating a New Blank Office Document
from File Explorer
• In File Explorer, display the folder in which you want
to create the new Office document
• Press and hold or right-click an open area in the file
list to display a shortcut menu
• Tap or point to New on the shortcut menu to display
the New submenu
• Tap or click the document type you wish to create on
the New submenu
• Type the desired file name in the text box, and then
press the ENTER key
Office 2013 and Windows 8: Essential Concepts and Skills
62
Creating a New Blank Office Document
from File Explorer
Office 2013 and Windows 8: Essential Concepts and Skills
63
Running an App from File Explorer and
Opening a File
• Display the folder window containing the file you wish to
open
• Press and hold or right-click the file icon or file name to
display a shortcut menu
• Tap or click Open on the shortcut menu to open the
selected file in the app used to create the file
Office 2013 and Windows 8: Essential Concepts and Skills
64
Running an App from File Explorer and
Opening a File
Office 2013 and Windows 8: Essential Concepts and Skills
65
Unique Features of Excel
Office 2013 and Windows 8: Essential Concepts and Skills
66
Entering a Worksheet Title
• Tap or click cell A1 to make it the active cell
• Type the worksheet title in the cell
• Tap or click the Enter box to complete the entry
Office 2013 and Windows 8: Essential Concepts and Skills
67
Saving an Existing Office File
with the Same File Name
• Tap or click the Save button on the Quick Access
Toolbar to overwrite the previously saved file
Office 2013 and Windows 8: Essential Concepts and Skills
68
Access
• The term database describes a collection of data
organized in a manner that allows access,
retrieval, and use of that data
• Access is a database management system
– Software that allows you to use a computer to create a
database; add, change, and delete data in the
database; create queries that allow you to ask
questions concerning the data in the database; and
create forms and reports using the data in the
database
Office 2013 and Windows 8: Essential Concepts and Skills
69
Access
Office 2013 and Windows 8: Essential Concepts and Skills
70
Unique Elements in Access
Office 2013 and Windows 8: Essential Concepts and Skills
71
Creating an Access Database
• Tap or click the ‘Blank desktop database’ thumbnail
to select the database type
• Type the desired database name in the File Name box
• Tap or click the ‘Browse for a location to put your
database’ button to display the File New Database
dialog box
• Navigate to the desired save location
• Tap or click the OK button to select the save location
• Tap or click the Create button in the Backstage view
to create the database
Office 2013 and Windows 8: Essential Concepts and Skills
72
Creating an Access Database
Office 2013 and Windows 8: Essential Concepts and Skills
73
Opening an Existing Office File
• Tap or click FILE on the ribbon to open the Backstage
view and then tap or click Open in the Backstage view
to display the Open gallery
• Tap or click Computer to display recent folders
accessed on your computer
• Tap or click the Browse button to display the Open
dialog box
• Navigate to the location of the file to be opened
• Tap or click the file to be opened to select the file
• Tap or click the Open button to open the file
Office 2013 and Windows 8: Essential Concepts and Skills
74
Opening an Existing Office File
Office 2013 and Windows 8: Essential Concepts and Skills
75
Outlook
• Outlook is a powerful communications and
scheduling app that helps you communicate with
others, keep track of contacts, and organize your
calendar
• Email is the transmission of messages and files
over a computer network
Office 2013 and Windows 8: Essential Concepts and Skills
76
Outlook
Office 2013 and Windows 8: Essential Concepts and Skills
77
Publisher
• Publisher is a powerful desktop publishing (DTP)
app that assists you in designing and producing
professional-quality documents that combine
text, graphics, illustrations, and photos
Office 2013 and Windows 8: Essential Concepts and Skills
78
Publisher
Office 2013 and Windows 8: Essential Concepts and Skills
79
OneNote
• OneNote is a note taking app that assists you in
entering, saving, organizing, searching, and using
notes
Office 2013 and Windows 8: Essential Concepts and Skills
80
Renaming a File
• In File Explorer, navigate to the location of the file
to be renamed
• Press and hold or right-click the file to be
renamed to display a shortcut menu that presents
a list of commands related to files
• Tap or click Rename on the shortcut menu to
place the current file name in a text box
• Type the new file name in the text box and then
press the ENTER key
Office 2013 and Windows 8: Essential Concepts and Skills
81
Renaming a File
Office 2013 and Windows 8: Essential Concepts and Skills
82
Moving a File
• In File Explorer, navigate to the location of the file
to be moved
• Display the folder in the navigation pane to which
you want to move the file
• Drag the file from the right pane to the desired
folder in the navigation pane
Office 2013 and Windows 8: Essential Concepts and Skills
83
Moving a File
Office 2013 and Windows 8: Essential Concepts and Skills
84
Deleting a File
• In File Explorer, navigate to the location of the file
to be deleted
• Press and hold or right-click the file to be deleted
to display a shortcut menu
• Tap or click Delete on the shortcut menu
• If a dialog box appears, tap or click the Yes button
to delete the file
Office 2013 and Windows 8: Essential Concepts and Skills
85
Deleting a File
Office 2013 and Windows 8: Essential Concepts and Skills
86
Opening the Help Window
in an Office App
• Tap or click the Office app’s Help button near the
upper-right corner of the app window to open the
app’s Help window
Office 2013 and Windows 8: Essential Concepts and Skills
87
Moving a Window by Dragging
• Drag the window title bar to the desired location
Office 2013 and Windows 8: Essential Concepts and Skills
88
Resizing a Window by Dragging
• If you are using a mouse, point to the lower-right
corner of the window until the mouse pointer
changes to a two-headed arrow
• Drag the bottom border to display more of the
active window
Office 2013 and Windows 8: Essential Concepts and Skills
89
Obtaining Help Using the ‘Search online
help’ Text Box
• Type the search text in the ‘Search online help’
text box at the top of the app’s Help window
• Tap or click the ‘Search online help’ button to
display the Search results
• Tap or click the desired link to view the Help
document
• Tap or click the Home button in the Help window
to clear the search results and redisplay the Help
home page
Office 2013 and Windows 8: Essential Concepts and Skills
90
Obtaining Help Using the ‘Search online
help’ Text Box
Office 2013 and Windows 8: Essential Concepts and Skills
91
Obtaining Help Using the Help links
• Tap or click the desired link on the Help home
page to display the associated page
Office 2013 and Windows 8: Essential Concepts and Skills
92
Using Windows Help and Support
• Windows Help and Support is available when
using Windows or when using any Microsoft app
running in Windows
Office 2013 and Windows 8: Essential Concepts and Skills
93
Using Windows Help and Support
• Swipe in from the right edge of the screen or point to
the upper-right corner of the screen to display the
Charms bar
• Tap or click the Settings charm on the Charms bar to
display the Settings menu
• Tap or click Help to open the Windows Help and
Support window
• After reviewing the Windows Help and Support
window, tap or click the Close button to close
Windows Help and Support
Office 2013 and Windows 8: Essential Concepts and Skills
94
Using Windows Help and Support
Office 2013 and Windows 8: Essential Concepts and Skills
95
Chapter Summary
•
•
•
•
•
Use a touch screen
Perform basic mouse operations
Start Windows and sign in to an account
Identify the objects in the Windows 8 desktop
Identify the apps in and versions of Microsoft
Office 2013
• Run an app
• Identify the components of the Microsoft Office
ribbon
Office 2013 and Windows 8: Essential Concepts and Skills
96
Chapter Summary
•
•
•
•
•
•
Create folders
Save files
Change screen resolution
Perform basic tasks in Microsoft Office apps
Manage files
Use Microsoft Office Help and Windows Help
Office 2013 and Windows 8: Essential Concepts and Skills
97
Microsoft
Office 2013
Chapter Complete