ITC Certified Office (2013) Specialist

ITC Certified Office (2013) Specialist

Office 2010

Office Specialist certification is one of the leading IT certification in the world. As the name suggests this examination demonstrates the student’s credibility and knowledge for MS office products like Word, PowerPoint & Excel for the most recent version i.e. 2013. Applicable for individual students, professionals employed or unemployed, workforce development in organizations, academic institutions etc.

1 Introduction of Office 2013
Starting an Application
Closing an Application
2 Navigating In Office
The Office Look
Office Application Screen
Quick Access Toolbar
Galleries and Live Preview
The MiniBar or Mini Toolbar
Shortcut menus and contextual command buttons
Enhanced ScreenTips
Dialog Boxes and Launchers
Task Panes or Panes
Status bar
Exploring the File Tab
Displaying and Closing the Tab
Finding Recent Documents and Pinning
Controlling the Ribbon Display
Gestures and Touch Navigation
Setting Application Options
3 Fundamental Operations
Working with Files
Understanding Office 2013 File Formats
Creating a New, Blank File
Creating a File with a Document Template
Saving and Naming a File
Opening a File
Closing a File
Printing a File
Preview and Print
Choosing Print Settings and Printing
Copying, Cutting & Pasting
Spell Checking
Styles and Live Preview
Introduction to Word
1 Document Creation
Creating a New Word Document
Typing Text
Using Word Wrap
Inserting Versus Overtyping
Using Default Tabs
Making a New Paragraph
Creating a File from a Template
Reviewing Available Document Templates
Blank Document and Pinned Templates
Online Templates
Creating the File from the Template
Opening an Existing File
Saving and File Formats
Saving as a Word file
Converting to another format
Choosing the Right Word View for the Task at Hand
Print Layout
Draft View
Read Mode and Object Zoom
Web Layout
Outline (Master Document Tools)
Resume Reading
Showing and Hiding Rulers
Splitting the View
2 Font/Character Formatting
Format Text in Word
Formatting Characters
Applying Character Formatting
Formatting Techniques
Clearing for Matting
Using the Font group on the Home Tab
Formatting via the Font Dialog Box
The Mini Toolbar
Text Effects and Typography
Character Formatting Keyboard Shortcuts
3 Paragraph Formatting
Paragraph Formatting Tools
Paragraph Formatting Attributes
Paragraph Formatting Techniques
Structuring Text with Paragraph Formatting
Adding Indentation
Changing Text Alignment
Changing Spacing
Setting and Using Tabs
Setting Off Text with Paragraph Decoration
Numbering or Bulleting Lists of text
Line and Page Break Controls
Shading Paragraphs
Borders and Boxes
Caveats for Printing and Viewing
4 Using Styles
Using the Styles Group to Apply Styles
Applying Styles from the Style gallery
Applying Styles Using the Styles Pane
Reapplying or Resetting a Style
Modifying and Creating Styles
Modifying an Existing Style
Creating a Style from Scratch
Changing the Whole Document via Style Sets
Applying a Style Set
Creating and Deleting Style Sets
Managing Styles
Choosing which Styles to Display in the Styles Pane
Removing a Style from the Gallery
Recommended Styles
Deleting a Style
Style Inspector
5 Controlling Document Appearance
Changing Basic Page Setup
Page Setup Dialog Box
Section Formatting
Section Breaks Overview
Inserting or Deleting a Section Break
Automatic Section Breaks
Styles, Section Formatting, and Paragraph Formatting
Saving Section Formatting for Reuse
Page Layout within a Section
Headers and Footers Overview
The Header and Footer layer
Coordinating Headers and Footers and Document Sections
Header and Footer Navigation and Design
Inserting a Header or Footer from the Gallery
Editing in the Header and Footer Areas
Using Header and Footer Styles
Link to Previous
Different First Page
Different Odd & Even Pages
Show Document Text
Adding Header and Footer Material
Page Numbers
Adding Document Information
Adding side Margin Material
Adding Header and Footer Graphics
Changing the Number of Columns
Adding a line Between Columns
Changing Columns using Section Breaks
Adding and Removing Page Borders
Working More Effectively with Themes
Understanding and Applying Themes
Style sets and Paragraph Spacing
Setting the Default Theme
6 Adding Tables and Graphics
Getting a Quick Start with Quick Tables
Table Basics
Inserting a Table from Scratch
AutoFit Behavior
Inserting a Table Based on Existing Content
Selecting, Copying, and Moving in Tables
Changing Table Properties
Working with Table Layout and Design
Modifying Table layout
Adding Table Calculations
Modifying Table Design
Adding a Shape
Inserting a Picture from a File
Adding the Picture
Supported Picture File Formats
Adding an Online Picture
Pasting or Snapping a Picture
Pasting a Picture
Taking a screen Shot
Manipulating Inserted Pictures (and Other Graphics)
Controlling Picture Positioning
Setting Wrapping and Wrapping Defaults
Moving a Graphic
Resizing, Rotating, and Cropping a Picture
Formatting a Picture or Shape
Creating WordArt
Formatting WordArt text
Inserting SmartArt
Changing Layout, Style, and Colors
Adding a Shape
Changing Shape Styles and Other Formatting
Arranging Pictures and Other Objects
Using the Selection Pane
7 Data Documents and Mail Merge
Previewing the Mail Merge Process
Reviewing Data File Formats
Typing a New List
Word and Text Files
HTML Files
Choosing the Data Document Type
Restoring a Word document to Normal
Attaching a Data Source
Selecting Recipients
Assembling a Merge Document
Adding Merge Fields
Update Labels
Preview Results
Find Recipient
Highlight Merge Fields
Check for Errors
Finishing the Merge
Mail Merge Pane/Wizard
Step 1: Select Document Type
Step 2: Starting Document
Step 3: Select Recipients
Step 4: Write your Letter
Step 5: Preview your Letters
Step 6: Complete the Merge
Introduction to Excel
1 Excel Worksheets and Workbooks
About Excel
Understanding Workbooks and Worksheets
A Worksheet
Navigating with Your Keyboard
Navigating with your Mouse
Excel's Ribbon Tabs
Ribbon Tabs
Contextual Tabs
Creating Your First Excel Workbook
Getting Started on your Worksheet
Filling in the Month Names
Entering the Sales Data
Formatting the Numbers
Making your Worksheet Look a Bit Fancier
Summing the Values
Creating a Chart
Printing your Worksheet
Saving your Workbook
2 Entering and Editing Worksheet Data
Data Types
Numeric values
Numeric Limitations
Text Entries
Understanding Formulas
Entering Text and Values
Modifying Cell Contents
Deleting the Contents of a Cell
Replacing the Contents of a Cell
Editing the Contents of a Cell
Learning Data-Entry Techniques
Applying Number Formatting
Using automatic Number Formatting
Formatting Numbers by Using the Ribbon
Using Keyboard Shortcuts to Format Numbers
Formatting Numbers Using the Format Cells Dialog Box
When Numbers Appear to Add Incorrectly
3 Worksheet and Cell Range Operations
Learning the Fundamentals of Excel Worksheets
Working with Excel Windows
Activating a Worksheet
Adding a new Worksheet to your Workbook
Deleting a Worksheet you no Longer Need
Changing the Name of a Worksheet
Changing a Sheet Tab Color
Rearranging your Worksheets
Hiding and Unhiding a Worksheet
Preventing Sheet Actions
Controlling the Worksheet View
Zooming in or Out for a Better View
Viewing a Worksheet in Multiple Windows
Comparing Sheets Side by Side
Splitting the Worksheet Window into Panes
Keeping the Titles in View by Freezing Panes
Monitoring cells with a Watch Window
Working with Rows and Columns
Inserting rows and Columns
Deleting rows and Columns
Hiding rows and Columns
Changing column Widths and Row Heights
Understanding Cells and Ranges
Selecting Ranges
Selecting Complete Rows and Columns
Selecting Non Contiguous Ranges
Selecting Multi Sheet Ranges
Selecting Special Types of Cells
Selecting Cells by Searching
Copying or Moving Ranges
Copying by using Ribbon Commands
About the Office Clipboard
Copying by Using Shortcut Menu Commands and Keyboard Shortcuts
Copying or Moving by Using Drag-and-Drop
Copying to Adjacent Cells
Copying a Range to Other Sheets
Using the Office Clipboard to Paste
Pasting in Special Ways
Using the Paste Special Dialog Box
Using Names to Work with Ranges
Creating Range Names in Your Workbooks
Managing Names
Adding Comments to Cells
Formatting Comments
Working Further with Comments
4 Introducing Formulas and Functions
Understanding Formula Basics
Using Operators in Formulas
Understanding Operator Precedence in Formulas
Using Functions in Your Formulas
New Functions in Excel 2013
Entering Formulas into Your Worksheets
Using Formula AutoComplete
Entering Formulas Manually
Entering Formulas by Pointing
Pasting Range Names into Formulas
Inserting Functions into Formulas
Function Entry Tips
Editing Formulas
Using Cell References in Formulas
Using Relative, Absolute, and Mixed References
Changing the Types of Your References
Referencing Cells Outside the Worksheet
Using Formulas in Tables
Summarizing Data in a Table
Using Formulas Within a table
Referencing Data in a Table
Correcting Common Formula Errors
Handling Circular References
Specifying When Formulas are Calculated
Tips for Working with Formulas
Not Hard-Coding Values
Using the Formula bar as a Calculator
Making an Exact Copy of a Formula
Converting Formulas to Values
5 Working with Dates and Times
How Excel Handles Dates and Times
Understanding Date Serial Numbers
Choose Your Date System: 1900 or 1904
Entering Dates
Searching for Dates
Understanding Time Serial Numbers
Entering Times
Formatting Dates and Times
Problems with Dates
Date-Related Worksheet Functions
Displaying the Current Date
Displaying any Date
Generating a Series of Dates
Converting a Non Date String to a Date
Calculating the Number of Days Between Two Dates
Calculating the Number of Workdays Between Two Dates
Offsetting a Date Using Only Workdays
Calculating the Number of Years Between Two Dates
Calculating a Person's Age
Where's the DATEDIF Function?
Determining the Day of the Year
Determining the Day of the Week
Determining the Week of the Year
Determining the Date of the Most Recent Sunday
Determining the First Day of the Week After a Date
Determining the nth Occurrence of a Day of the Week in a Month
Determining the Last Day of a Month
Determining Whether a Year is a Leap Year
Determining a Date's Quarter
Time-Related Functions
Displaying the Current Time
Displaying Any Time
Calculating the Difference Between Two Times
Summing Times That Exceed 24 Hours
Converting from Military Time
Converting Decimal Hours, Minutes, or Seconds to a Time
Rounding Time Values
Working with Non-Time-of-Day Values
6 Creating Formulas
Counting and Summing Worksheet Cells
Getting a Quick Count or Sum
Basic Counting Formulas
About This Chapter's Examples
Counting the Total Number of Cells
Counting Blank Cells
Counting Non Blank Cells
Counting Numeric Cells
Counting Text Cells
Counting Nontext Cells
Counting Logical Values
Counting Error Values in a Aange
Advanced Counting Formulas
Counting Cells by Using the COUNTIF Function
Counting cells Based on Multiple Criteria
Counting the Most Frequently Occurring Entry
Counting the Occurrences of Specific Text
Counting the Number of Unique Values
Creating a Frequency Distribution
Is the Analysis ToolPak Available?
Summing Formulas
Summing all Cells in a Range
Computing a Cumulative Sum
Ignoring Errors when Summing
Summing the “Top n” Values
Conditional Sums Using a Single Criterion
Summing Only Negative Values
Summing Values Based on a Different Range
Summing Values Based on a Text Comparison
Summing Values Based on a Date Comparison
Conditional Sums Using Multiple Criteria
Using And Criteria
Using or Criteria
Using And and Or Criteria
7 Making Charts
What Is a Chart?
Handling Charts
Embedded Charts
Chart Sheets
Parts of a Chart
Creating a Chart
Hands On: Creating and Customizing a Chart
Selecting the Data
Choosing a Chart Type
Experimenting with Different Styles
Experimenting with Different Layouts
Trying Another View of the Data
Trying Other Chart Types
Working with Charts
Resizing a Chart
Moving a Chart
Copying a Chart
Deleting a Chart
Adding Chart Elements
Moving and Deleting Chart Elements
Formatting Chart Elements
Exploring the Format Pane
Printing Charts
Understanding Chart Types
Choosing a Chart Type
8 Communicating Data Visually
Creating a Table
Changing the Look of a Table
Working with Tables
Navigating in a Table
Selecting Parts of a Table
Adding New Rows or Columns
Deleting Rows or Columns
Working with the Total Row
Removing Duplicate Rows from a Table
Sorting and Filtering a Table
Converting a Table Back to a Range
About Conditional Formatting
Specifying Conditional Formatting
Formatting Types you can Apply
Making your Own Rules
Conditional Formats That Use Graphics
Using Data Bars
Using Color Scales
Using icon Sets
Creating Formula-Based Rules
Understanding Relative and Absolute References
Conditional Formatting Formula Examples
Working with Conditional Formats
Copying cells that Contain Conditional Formatting
Deleting Conditional Formatting
Locating cells that Contain Conditional Frmatting
Introducing Sparklines
Sparkline Types
Why Sparklines?
Creating Sparklines
Understanding Sparkline Groups
Handling Hidden or Missing Data
Changing Sparkline Colors and Line Width
Highlighting Certain Data Points
Adjusting Sparkline Axis Scaling.
Specifying a Date Axis
Displaying a Sparkline for a Dynamic Range
Introduction to PowerPoint
1 A First Look at PowerPoint 2013
Starting and Exiting PowerPoint
Changing the View
Normal and Outline Views
Slide Sorter View
Slide Show View and Reading Views
Zooming In and Out
Enabling Optional Display Elements
Color/Grayscale/Pure Black and White Views
Opening a New Display Window for the Same Presentation
Arranging Windows
Switching Among Windows
2 Creating a Presentation, Slides, and Text
Starting a New Presentation
Starting a Blank Presentation
Starting a Presentation from a Template
Using a Personal Template
Basing a New Presentation on Existing Content
Saving Your Work
Understanding save Locations
Saving Subsequent Times
Changing Drives and Folders
Saving in a Different Format
Specifying Save Options
Setting Passwords for File Access
Closing and Reopening Presentations
Closing a Presentation
Opening a Presentation
Opening a File from a Different Program
Working with Multiple Presentations
Finding a Presentation File to Open
Setting File Properties
Creating New Slides
Creating New Slides from Outline View
Creating a Slide from the Thumbnails Pane
Creating a Slide from a Layout
Copying Slides
Inserting Content from External Sources
Copying Slides from other Presentations
Inserting New Slides from an Outline
Opening a Word Document as a New Presentation
Importing Text from Web Pages
Managing Slides
Selecting Slides
Deleting Slides
Undoing Mistakes
Rearranging Slides
Using Content Placeholders
Inserting Content into a Placeholder
Placeholders Versus Manually Inserted Objects
Creating Text Boxes Manually
When Should you use a Manual Text Box?
Creating a Manual Text Box
Working with Text Boxes
Selecting Text Boxes
Sizing a Text Box
Positioning a Text Box
Changing a Text Box's AutoFit Behavior
3 Working with Layouts, Themes, and Masters
Understanding Layouts and Themes
Where Themes are Stored
Themes, Layouts, and Slide Master View
Changing a Slide's Layout
Applying a Theme
Applying a Theme from the Gallery
Applying a Theme from a Theme or Template File
Applying a Theme Variant
Managing Themes
Creating a New Theme
Renaming a Theme
Deleting a Theme
Copying a Theme from Another Presentation
Changing Colors, Fonts, and Effects
Understanding Color Placeholders
Changing the Color Theme
Understanding Font Placeholders
Changing the Font Theme
Changing the Effect Theme
Setting Up a Graphic on Which to Test Effect Themes
Creating a Custom color theme
Creating a Custom Font Theme
Sharing a Custom Color or Font Theme with Others
Deleting a Custom Color or Font Theme
Changing the Background
Applying a Background Style
Applying a Custom Background Fill
Working with Background Graphics
Working with Placeholders
Formatting a Placeholder
Moving, Deleting, or Restoring Placeholders
Displaying the Date, Number, and Footer on Slides
Customizing and Creating Layouts
Understanding Content Placeholders
Adding a Custom Placeholder
Deleting and Restoring a Custom Placeholder
Overriding the Slide Master Formatting for a Layout
Creating a New Layout
Renaming a Layout
Duplicating and Deleting Layouts
Copying Layouts Between Slide Masters
Managing Slide Masters
Creating and Deleting Slide Masters
Renaming a Slide Master
Preserving a Slide Master
Working with Tables and Charts
Creating a New Table
. Creating a Table with the Insert Table Dialog Box
Creating a Table from the Table Button
Drawing a Table
Moving Around in a Table
Selecting Rows, Columns, and Cells
Editing a Table's Structure
Resizing the Overall Table
Inserting or Deleting Rows and Columns
Merging and Splitting Cells
Applying Table Styles
Formatting Table Cells
Changing Row Height and Column Width
Table Margins and Alignment
Applying Borders
Applying Fills
Applying a Shadow to a Table
Applying a 3D Effect to a Table
Changing Text Alignment
Changing Text Direction
Understanding Charts
Starting a New Chart
Working with Chart Data
Plotting by Rows Versus by Columns
Redefining the Data Range
Filtering the Chart Data
Chart Types and Chart Layout Presets
Working with Chart Elements
Working with Chart titles
Working with Axis Titles
Working with Legends
Adding data Labels
Adding a data Table
Controlling the Axes
Displaying or hiding an Axis
Setting Axis Scale Options
Setting a Number Format
Formatting a Chart
Applying Chart Styles
Formatting the Chart Area and Plot Area
Formatting the Legend
Formatting Grid Lines and Walls
Formatting the Data Series
Rotating a 3D Chart
Introduction to Outlook
1 Setting Up Your E-mail Accounts
E-mail Terminology
Automatic E-Mail Account Setup
Manual E-Mail Account Setup (web)
Modifying Account Settings
Using Outlook Profiles
Understanding Profiles
Creating a New Profile
Switching Profiles
Composing and Sending Messages
Quick Compose and Send
Sending a Message
Message Addressing Options
Changing the Reply To Address
Entering recipients Manually
Entering Recipients from your Address Book
Sending Attachments
Reading and Replying to Messages
New Alerts
Reading a Message
Replying to and forwarding Messages
Working with Received Attachments
Understanding Files and Folders
Outlook Data Files
Offline Folders File
Working with Outlook Folders
Outlook’s Default Folders
Creating a New E-Mail Folder
Creating a New Non–E-Mail Folder
Changing the Default E-Mail Account.
Organizing Folders in Groups
Working with Folders, Groups, and Items
Deleting Items and Using the Deleted Items Folder
Setting Options for an Individual E-mail Message
Changing the send Account
Saving Sent Items
Sending Items with a Message
Your Own Business Card
Setting Message Importance and Sensitivity
Assigning a Message to a Category
Delaying Delivery and Setting Message Expiration
Setting Global E-Mail Options
2 Processing and Securing E-mail
Understanding Junk Email Filtering
Setting Junk Email Options
Blocking and Allowing Specific Addresses
Defining safe Senders
Blocking/Allowing Individual Senders
Defining Safe Recipients
Defining Blocked Senders
International Junk E-Mail Options
Creating a New Rule
Selecting a Rule Template
Editing a Rule Description
Finishing the Rule
Creating a Rule from a Blank Template
Some Rule Examples
Rule Example 1
Rule Example 2
Rule Example 3
Managing Rules
Macro Security
Using Certificates and Digital Signatures
Obtaining a Digital ID
Importing/Exporting Digital Ids
Obtaining Other People’s Public Keys
Encrypting and Digitally Signing Messages
Encrypting Messages
Digitally Signing Messages
HTML Message Dangers
3 Working with Contacts
Understanding Outlook Contacts
The Contacts Window
Adding a New Contact Group
Customizing a Contacts View
Finding Contacts
Sending an E-Mail to a Contact or Group
More about Contacts
The Contact window
Other Contact Displays
Editing the Business Card
Sending Contact Information by E-Mail
Contacts, and Lync and Skype
Performing a Mail Merge from Your Contacts
Setting Contact Options
4 Working with Appointments and Tasks
Understanding the Outlook Calendar
Using the Calendar
Working with Calendar Views
Using the To-Do Bar with Appointments
Working with Appointments
Creating a simple appointment
Dealing with Conflicts
Editing and deleting Appointments
Appointment Options
Why Display an Appointment as Free?
Searching the Calendar
Setting Calendar Options
Understanding Tasks
Using the Tasks Feature
Creating a New Task
Entering task Details
Marking a Task as Complete
Assigning a Task
Specifying Task Recurrence
Working with Assigned Tasks
Receiving a Task Assignment
Receiving Accept/Decline Notifications
About Task Ownership
Assigning a Task to Multiple People
Task Status Reports
Sending a Status Report Manually
Other Ways of Viewing Tasks
Viewing Tasks on the To-Do Bar
Viewing Tasks on the Calendar
Setting Task Options

Our Clients