Sale!

$999.00 $799.00

Getting comfortable in Office Professional 2013
Exploring the Office environment
Working with Office files
Recovering unsaved files and versions
Customizing the user interface
Customizing the Office environment
Customizing the Quick Access toolbar
Customizing the status bar
Customizing the ribbon
Choosing the right application for the task at hand

Using shared Office features

Identifying new shared features in Office Professional 2013
Applying Office themes
Inserting graphics, videos, charts, and diagrams
Inserting charts
Searching for online templates
Presenting Office documents online
Inserting online video

Sharing and collaborating
Defining the term cloud service
Signing in and managing your Office account
Connecting cloud services to your Office account
Saving files on SharePoint Online and SkyDrive
Sharing files with others from SharePoint Online or SkyDrive
Opening files from the cloud
Syncing files with SkyDrive for offline use
Syncing with SkyDrive Pro
Syncing with SkyDrive for a Microsoft account
Getting started with co-authoring

Using touch in Office

Getting comfortable with Office on a tablet
Looking at unsupported features
Using touch mode
Selecting content with touch
Working with ink in Office.

SKU: OfficeLive1001 Categories: ,

Product Description

Microsoft Office 2013

Course objectives

Getting comfortable in Office Professional 2013
Exploring the Office environment
Working with Office files
Recovering unsaved files and versions
Customizing the user interface
Customizing the Office environment
Customizing the Quick Access toolbar
Customizing the status bar
Customizing the ribbon
Choosing the right application for the task at hand

Using shared Office features

Identifying new shared features in Office Professional 2013
Applying Office themes
Inserting graphics, videos, charts, and diagrams
Inserting charts
Searching for online templates
Presenting Office documents online
Inserting online video

Sharing and collaborating
Defining the term cloud service
Signing in and managing your Office account
Connecting cloud services to your Office account
Saving files on SharePoint Online and SkyDrive
Sharing files with others from SharePoint Online or SkyDrive
Opening files from the cloud
Syncing files with SkyDrive for offline use
Syncing with SkyDrive Pro
Syncing with SkyDrive for a Microsoft account
Getting started with co-authoring

Using touch in Office

Getting comfortable with Office on a tablet
Looking at unsupported features
Using touch mode
Selecting content with touch
Working with ink in Office

Course Outline

Week1

Word 2013
Getting comfortable in Word 2013
Exploring the Word 2013 user interface
Modifying your document view
Changing other view options
Discovering what’s new in Word 2013

Navigating and reading documents
Navigating a document by scrolling and using keyboard shortcuts
Searching and navigating a document by using the Navigation pane
Collapsing and expanding document content
Working with documents in the new Read Mode
Exploring research tools in Read Mode

Editing and composing documents
Moving the cursor by using keyboard shortcuts
Selecting text by using the keyboard and mouse
Selecting text by using the keyboard
Selecting text by using the mouse
Using other selection methods
Using formatting marks during document composition
Inserting symbols, international characters, and other special characters
Inserting special characters
Using AutoCorrect
Composing documents faster by using building blocks

Formatting documents
Formatting documents more efficiently
Setting default document formatting for your documents
Setting section formatting
Using styles for paragraph and character formats
Exploring other paragraph formats
Exploring other character formats
Changing case
Managing pagination through formatting

Presenting information
Formatting simple lists by using bullets and numbering
Creating tabbed lists
Inserting tables
Enhancing tables

Finalizing documents
Correcting proofing errors
Inspecting documents before publishing
Marking documents as final
Creating PDF files in Word
Printing documents

 

Week 2-3

Excel 2013
Getting comfortable in Excel 2013
Starting Excel 2013
Identifying what’s new in Excel 2013

Creating and editing worksheets
Entering and organizing data
Changing column widths
Using formatting to alter the appearance of data
Extending a series with AutoFill
Introducing Flash Fill
Selecting and naming cell ranges
Using column headers to define names
Moving around in the worksheet
Moving and adjusting cells
Moving and copying rows and columns
Copying one or more cells to many

Manipulating numbers and text
Creating, editing, and copying formulas
Using functions
Using the AutoSum button and built-in function
Inserting functions
Using relative, fixed, and mixed cell references
Using names in formulas and validating cell entries
Looking at useful functions
Working with text in Excel
Combining text from multiple cells into one string
Removing extra spaces
Copying cells containing formulas and pasting only their resulting values
Changing the case of text
Restricting cell entries

Analyzing data
Exploring a built-in template
Performing what-if analyses
Managing multiple what-if models
Using the Quick Analysis tools
Formatting conditionally
Analyzing data from another source
Filtering data with tables
Filter menu commands
Adding data to tables
Sorting data
Creating a custom sort list
Creating a PivotTable

Formatting worksheets
Applying number formatting
Formatting with styles
Creating custom themes
Formatting in cells
Working with custom number formats
Working with percentage formats
Working with fraction formats
Working with date formats
Protecting worksheets
Setting view options
Storing formats in templates

Manipulating workbooks and worksheets
Inserting rows and columns
Inserting and deleting cells
Working with panes and page layout options
Printing row and column labels on every page
Adjusting page breaks
Creating a multisheet workbook
Manipulating sheets
Summarizing a multisheet workbook
Working with sheet references
Managing multiple workbooks
Creating charts and graphics
Creating and modifying a chart
Adding a slicer to a PivotChart
Manipulating chart elements
Adding a timeline to a chart
Manipulating objects
Creating and sharing graphics
Using graphics elsewhere

Week 4

PowerPoint 2013
Getting comfortable in PowerPoint 2013
Getting started working with PowerPoint 2013
Exploring the PowerPoint 2013 tools
Discovering the new features in PowerPoint 2013

Designing and creating presentations
Creating a new presentation based on a theme or template
Applying a theme to an existing presentation
Customizing your file with colors, fonts, and effects
Theme fonts
Theme colors
Applying theme effects to your presentation
Applying background styles to your presentation
Formatting placeholders on the slide master
Adding graphics to the slide master and layouts
Creating a custom slide layout
Changing your presentation from a 16:9 to a 4:3 format

Creating on-slide content
Choosing a slide layout and adding text in placeholders
Adding manual text boxes
Adding and formatting a table
Inserting and formatting charts
Creating and formatting SmartArt diagrams
Reusing slides and keeping their source formatting

Creating Office graphics
Adding and formatting shapes
Applying enhanced fills and effects
Creating your own shapes
Inserting, cropping, and formatting pictures

Adding animation and multimedia
Adding animation to text and shapes
Editing video and applying transitions
Inserting and playing online video
Saving your presentation as a video

Finalizing and presenting
Adding and renaming sections
Inserting comments
Printing slides and notes
Finalizing your presentation
Delivering a presentation
Practicing with Presenter view
Access 2013
Getting comfortable in Access 2013
Starting Access 2013
Looking at the desktop database window
Exploring the Web App window
Displaying results in a browser
Discovering what’s new in Access 2013

Understanding Access 2013 databases
Creating a desktop database
Importing and exporting data
Navigating the user interface
Working with data in a datasheet
Copying and pasting from a datasheet
Configuring Access options
Linking Access to external data
Compacting, repairing, and encrypting a database

Creating basic tables and queries
Creating tables for your data
Creating a table in Datasheet view
Choosing a field data type
Adding validation and calculated fields to your tables
Adding a table validation rule
Adding a calculated field
Indexing a table
Linking tables together with relationships
Creating a manual relationship
Creating a select query
Creating a query by selecting specific fields
Joining multiple tables in a query
Working with query criteria
Filtering and sorting a field
Adding multiple criteria to a query
Adding parameters to queries
Working with totals and crosstab queries
Crosstabulating data

Designing forms and reports
Creating a continuous form
Working with a form in Layout view
Creating a datasheet with conditional formatting
Creating a single record form
Creating a single record form by using the Split Form template
Creating a parent/child form
Creating a parent/child pop-up form by using the Form Wizard
Tying your forms together with a navigation form
Creating a single record report
Creating a tabular report with grouping
Creating a continuous report with conditional formatting
Creating a parent/child report

Week 5

Outlook 2013
Getting comfortable in Outlook 2013
Setting up an email account in Outlook
Navigating the Outlook interface
Discovering what’s new in Outlook 2013

Using mail
Creating and sending messages
Addressing messages
Saving and sending messages
Attaching files to messages
Viewing messages and message attachments
Configuring Reading pane behavior
Viewing Reading pane content
Marking messages as read
Single-key reading
The People pane
Responding to messages
Inline replies

Staying on schedule
Scheduling and changing appointments
Using Quick Entry mode to create date-specific events
Creating recurring appointments and using appointment features
Creating appointments from messages
Configuring a Quick Step to create an appointment from an email message
Scheduling and changing meetings
Updating and canceling meetings
Responding to meeting requests
Displaying different views of a calendar
Views
Arrangements
Using the Date Navigator
Calendar item peeks

Working with tasks
Creating tasks from scratch
Setting task options
Creating tasks from Outlook items
Updating tasks
Removing tasks and items from task lists
Managing task assignments
Reclaiming an assigned task
Dealing with tasks other people assign to you

Managing contacts and people
Viewing contacts
Using the People Hub
Viewing Contact Cards
Using contact views
Using the People peek
Creating contacts
Using inline editing
Managing linked contacts
Configuring a social network account
Viewing social network updates

Saving time with Outlook
Flagging and reviewing important messages
Applying a message flag
Categorizing a message
Creating a high-priority Quick Step
Reviewing high-priority messages
Using the Calendar peek to plan your schedule
Planning ahead with the Weather bar
Organizing your mail with Folder Favorites
Rearranging key folders
Searching for related messages
Finding messages from a specific sender
Conducting quick searches
Using Search Folders to view today’s mail
Creating items quickly
Creating contextual appointments, contacts, and tasks from email messages
OneNote 2013
Getting comfortable in OneNote 2013
Getting started with OneNote 2013
Exploring the OneNote interface
Identifying new and improved features in OneNote 2013

Working with notebooks, sections, and pages
Creating a notebook
Creating and organizing sections
Section groups
Creating and organizing pages
Creating subpages
Adding and organizing notes
Inserting images
Working with ink and shapes
Custom pens
Shapes
Erasing ink or shapes
Inserting space
Arranging shapes
Recovering deleted sections or pages

Using organizational tools
Using tags
Creating and customizing tags
Using styles to format your notes
Connecting OneNote to Outlook
Sending email messages to OneNote
Connecting appointments to OneNote
Annotating contacts
Connecting OneNote tasks to Outlook
Using hyperlinks to tie your notes together
Creating custom hyperlinks to other pages
Creating and organizing tables
Using the Insert Table feature
Searching your notes to find information quickly
Changing your search scope

Sharing notes with others
Creating a new notebook on SkyDrive
Moving a notebook to SkyDrive
Stopping sharing in SkyDrive
Using a file server to share notes
Stopping sharing on a file server
Sharing notes via SharePoint
Sharing notes with others during a meeting
Sending notes via email
Exporting to other formats

Using OneNote everywhere
Syncing your notes by using SkyDrive
Accessing your notes in a web browser
Using OneNote on your phone or tablet
Using OneNote on an iPhone or iPad
Using OneNote Mobile for Android
Using OneNote Mobile on a Windows Phone
Using OneNote with a Windows 8 tablet

Saving time with OneNote
Finding tags
Recording audio
Using Quick Notes
Using screen clipping
Using linked notes
Searching your images
Inserting a spreadsheet
Using the Napkin Math feature
Formatting with templates

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.