Microsoft Office 2016 Complete Course by Online Ahmed Ali

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Publisher 2016

Click File , New, and do one of the following:

Choose one of the Featured templates, and click Create.

To use one of the templates installed in Publisher, choose Built-in, scroll to click the category you want, choose a template, and click Create.

To find a template on Office.com, use the Search for online templates box to find what you need. Enter “newsletter,” for example, scroll to a template you like, and click Create.

Save your publication

Save your publication the first time by following these steps.

Click File  Save As.

In Save As, choose where you want to save your publication.

Screenshot of the Save As option in Publisher.

OneDrive is a free Microsoft service that provides password-protected online file storage.

Other Web Locations includes websites you’ve used recently, and a Browse button to save your publication to any website you have access to.

Computer includes any folder on your computer.

Add a Place lets you add an online location to save your publication.

Enter the name for your publication, and click Save.

After you’ve saved your publication once, you can simply click File , Save each time you want to save.

If you want to change the file name or location of your publication, click File , Save As, and save the publication as if you were saving for the first time.

Add pictures to your publication

Click Home , Pictures.

Use the options in the Insert Pictures dialog box to find the picture you want to use.

Add text to your publication

Add text to your publication by inserting a text box first. Most templates contain text boxes you can fill in, but you can also add your own text boxes.

First: Add a text box

Click Home , Draw Text Box, and drag the cross shaped cursor to draw a box where you want text.

Screenshot of the Draw text box in Publisher.

Type text in the text box.

If the text you type is too long for the text box, you can make the text box bigger, or link it to another text box.

Second: Link your text boxes

You can link text boxes so that text flows from one box to another.

When a text box has too much text, a little box with ellipses appears in the lower right of the text box.

Screenshot of the text box overflow in Publisher.

Create a new text box.

Click the overflow indicator and your cursor becomes a pitcher.  text box linking pitcher, used to link text boxes.

Move to the new text box and click.

The overflow text will show up in the new text box.

Now as you add text, words flow from one text box to another. If you run out of room in the second box you can link to another text box, and the text will flow through all three boxes.

Add Building Blocks to your publication

Building blocks are reusable pieces of content such as headings, calendars, borders, and advertisements. Publisher has built-in building blocks, or you can create your own.

In the Page Navigation pane, select a page in your publication.

On Insert , Building Blocks, pick a building block gallery.

Screenshot of the Building Blocks group on the Insert tab in Publsiher.

Scroll to find a building block, or click More ,gallery name, to open the Building Block Library.

Click a building block.

Print your publication

Click File , Print.

Screenshot of the Print options in Publisher.

Under Print, enter the number of copies to print in Copies of print job box.

Make sure the correct printer is selected.

Note:  The properties for your default printer are automatically entered for you.

Under Settings, do the following:

Make sure the correct range of pages or sections is selected.

Select the layout format for printing.

Set the paper size.

Set whether to print on one side of the paper or on both sides.

If your printer is capable of color printing, choose whether you want to print color or grayscale.

Click the Print button when you are ready to print

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