Publisher 2016 - Link Excel Workbook - How to Merge an MS Database Workbook as Object in MS Tutorial

This Microsoft Publisher tutorial shows you how to merge an Excel 2016 database to your publication. I show how to merge using the mailings tab and how to print the database using data from the MS Office 365 database.

Here is a full list of tutorial videos available on my channel:

Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App

Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions
Modify a Style

Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment
Describe the Excel Worksheet
Enter Formulas Using Point Mode

Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms
Create and Use a Form to Add and Delete Records
Learn the Guidelines for Designing Databases and Setting Field Properties
Find, Modify, and Delete Records in a Table
Create a Form Using the Form Wizard

PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office
Edit an Existing Presentation
Insert Online Pictures
Create a Title Slide and Slides With Lists
Select and Change a Document Theme and Variant
Insert and Format Pictures
Insert Shapes
Insert a Video

Outlook 2016
Basic Tutorial

Office 2016:
Identify the Components of the Microsoft Office Ribbon

Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems

Microsoft Publisher 2016 Full Playlist

[gjm]

Spot on - Labels printed super quick thanks

[aussiechappy]

HI Professor, hope you are well. I found your video very helpful. Could you possible tell me how to select a specific cell in excel to then show in publisher. For example we have a brochure that has a price and when the price changes we'd like to be able to have publisher update to the current price? So we'll change the base price of a component, which then changes the overall price via a calculation in excel, and we'd like to have that calculation solution to then update the price in the publisher brochure. Any advice would be greatly appreciated.

[HashAliNZ]

Great video! I think the Level part from your database is a bit off. In your ticket, it's going to say "Level Level 2" once it gets past all the Pit seats

[danrothbart]

how would i do this if my excel sheet did not have the same number of rows in each column? i am running into an issue in which i have a multipage publisher doc, and an excel sheet with columns that have different numbers of rows. i have a different set of columns for each page in the publisher document. page 1 has 10 corresponding columns and 4 corresponding rows in excel, page 2 has 10 and 3, and page 3 has 10 and 1. but my document is printing page 1, page 2, page 3, and repeats so on and so forth, with blank info on the pages where the excel sheet has run out of columns. does that make sense? is there a way to change the print order of my document to exhaust all of the page 1's, THEN print page 2's, and then page 3's, moving to the next page when the excel sheet has run out of columns?

[timlagendyk]

You did this for text, can it also work for images saved in a similar database?

[debbiethomas]

I have watched this video and it was, as usual, very helpful. However, I am looking for instruction on how to merge Excel information to a Word document for annual reporting. I don't have Publisher availability. Do you have something that could help me? Thank you!

[karencole]

Can you save into Publisher in order to manipulate some of the text/fonts after it has been merged?!

[aniles]

I have a question 🙋🏾‍♂️ if I wanted to put something like a map on the back of that ticket how do I go about doing that

[pasindusadamjaya]

How to print multiple copy’s in one sheet from sequence.

[Mosheusa]

can i hide text box if there is no data in specific row? if so how, thanks

[guyw]

Hello Sir, i want to create a 8 page leaflet, should I use word or publisher, and how can I get a leaflet template and change leaflet size?
Thank you for your time.

[Gemainsp]

Hi, I am working in a catalogue but I am having a hard time figuring out how to source pictures from an excel database. Does someone know how to do it? :)