Microsoft Publisher 2013 Course overview

Microsoft Publisher 2013 courses, you will create flyers, newsletters, and office stationery working with publication designs. Microsoft Publisher 2013 courses is an entry-level desktop publishing application.

Microsoft Publisher 2013 training will provide you with knowledge on how to insert and format text, adding, resizing, and cropping graphics, inserting tables and using Publisher’s drawing tools.

Instructor Led Learning

Duration: 1 Days
Registration Open Now!

Video Learning

Duration: 1 Days
Registration Open Now!

Earning as much as : R158 000 p.a

What you will learn

    • Lesson 1 :Getting Started with Publisher 2010
    • Lesson 2 :Modifying the Layout and Structure of a Publication
    • Lesson 3 :Formatting Text in a Publication
    • Lesson 4 :Editing Content in a Publication
    • Lesson 5 : Formatting Graphics in a Publication
    • Lesson 6 :Preparing a Publication for Distribution

Basic computer skills

Computers made easy course

Introduction to Microsoft Office course

FULL COURSE OUTLINE

Publisher 2013 – Level 1 Course

Lesson 1: Getting Started with Publisher 2010

  • Identify the Components of the Publisher Interface
  • Customize the Publisher Interface
  • Create a Basic Publication
  • Add Content to a Publication

Lesson 2: Modifying the Layout and Structure of a Publication

  • Import Text into a Publication
  • Organize Text Boxes and Picture Placeholders in a Layout
  • Control the Display of Content in Text Boxes
  • Insert Common Layout Elements
  • Use Building Blocks

Lesson 3: Formatting Text in a Publication

  • Format Text
  • Format Paragraphs
  • Apply Paragraph Styles
  • Apply Schemes

Lesson 4: Editing Content in a Publication

  • Edit Text in a Publication
  • Present Content in Tables
  • Review Text in a Publication
  • Insert Symbols and Special Characters

Lesson 5: Formatting Graphics in a Publication

  • Customize the Appearance of Pictures
  • Add Graphical Objects to a Publication

Lesson 6: Preparing a Publication for Distribution

  • Check the Design of a Publication
  • Save a Publication for Distribution
  • Preview and Print a Publication
  • Send a Publication by Email
Lesson 1: Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function

Lesson 2: Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Lesson 3: Working with Illustrations

  • Using Shapes
  • Working with SmartArt

Lesson 4: Visualizing Your Data

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template
  • Create a Trend Line

Lesson 5: Working with Tables

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

Lesson 6: Advanced Formatting

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Lesson 7: Microsoft Excel Features that Were New in 2013

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

Lesson 8: Features New in 2016

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

Lesson 1: Using Pivot Tables

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • More Pivot Table Functionality

Lesson 2: Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Lesson 3: Data Tools

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Lesson 4: Working with Others

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Lesson 5: Recording and Using Macros

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Lesson 6: Random Useful Items

  • Sparkline
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files
  • Merge Workbooks
  • Using the PMT Function
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

Lesson 7: Microsoft Excel Features that Were New in 2013

  • Using Slicers to Filter Data
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Lesson 8: Features New in 2016

  • PivotTable Updates
  • Ink Equations
  • Multi-Select Option in Slicers
  • Quick Shape Formatting
  • Sharing with SharePoint or OneDrive

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.