Home

Welcome to my New Technology Blog.

Software Bytes helps you to use Microsoft Office programmes effectively and easily to complete any personal or professional tasks.

Follow My Blog

Get new content delivered directly to your inbox.

Word

Beginner

Word Introduction

Create a document

Save your document to OneDrive

Design and Editing

Collaborate

Set up your mobile apps

Learn more about Word

Introduction to using a Screen Reader in Word

Learning Tools in Word

Learning how to do things with Tell Me

Making your document more accessible

Keyboard shortcuts

Intermediate

Add and format text

Create a bulleted or numbered list

Change the line spacing

Apply styles

Apply themes

Change margins

Create newsletter columns

Change page orientation to layout

Add a border to a page

Inseert a header or footer

Insert page numbers

Insert a page break

Insert a table of contents

Insert a table

Insert pictures

Insert icons

Insert WordArt

Insert a watermark

Show the ruler

Rotate a picture or shape

Wrap text around a picture

Convert or save to PDF

Edit a PDF

Print your document

Print an envelope

Print return address labels

Print labels for your mailing list

Expert

Share a document

Collaborate on Word documents

Insert or delete a comment

Track changes

Accept tracked changes

Write an equation or formula

Indent the first line of a paragraph

Double-space the lines in a document

Crete a bibliography, citations, and footnotes

Insert footnotes and endnotes

Use Word on a mobile device

Excel

Beginner

Quick Start

Produce a new workbook

Insert or delete a worksheet

Move or copy worksheets or worksheet data

Print a worksheet or a workbook

Use Excel as your calculator

Fill data automatically in worksheet cells

Rows and Columns

Inserting or deleting rows, and columns

Select cell contents in Excel

Freeze panes to lock rows and columns

Hide or show rows or columns

Filter for unique values or remove duplicate values

Split text into different columns with the Convert Text to Columns Wizard

Create a list of sequential dates

Intermediate

Cells

Move or duplicate cells and cell contents

Change the column width or row height in Excel

Find or replace text and numbers on a worksheet

Merge and unmerge cells

Apply data validation to cells

Import or export text (.txt or .csv) files

Formatting

Available number formats in Excel

Conditional formatting

Align or rotate text in a cell

Change the format of a cell

Copy cell formatting

Add a watermark in Excel

Display or hide zero values

Produce a custom number format

Formulas and functions

Summary of formulas in Excel

VLOOKUP

SUM Function

COUNTIF Function

IF Function

IFS

SUMIF

SUMIFS

Automatically number rows

Calculate the difference between two dates

Define and use names in formulas

Combine text from two or more cells into one cell

Tables

Create and format tables

Sort data in a table

Filter data in a range or table

Total the data in an Excel table

Use slicers to filter data

Charts

Create a chart from start to finish

Add or delete titles in a chart

Show or hide a chart legend or data table

Add a trend or moving average line to a chart

Analyse your data instantly

Update the data in an existing chart

Use sparklines to display data trends

Expert

PivotTables

Create a PivotTable to analyse worksheet data

Use the Field List to arrange fields in a PivotTable

Group or ungroup data in a PivotTable

Filter data in a PivotTable

Create a PivotChart

Share and co-author

Share your Excel workbook with others

Comments and notes

Collaborate on Excel workbooks at the same time with co-authoring

See files others have shared with you

Lock or unlock specific areas of a protected worksheet

Protect an Excel file

Save or convert to PDF

Outlook

Beginner

Quick Start

Add an e-mail account to Outlook

Create and send e-mail

Manage calendar and contacts

Collaborate

Set up your mobile apps

Learn more

Video – What is Outlook?

Add an Outlook.com or Microsoft 365 Account

Set up Gmail accounts

Customise view

Create, change, or customise a view

Change how you view your Outlook calendar

Keep upcoming appointments and meetings always in view

Focused Inbox for Outlook

Show, hide, and view the Bcc box

View message list by conversations

View only unread messages

Mark a message as read or unread

View e-mail message headers

Change the sound played when an email message arrives

Turn new message alert pop-up on or off

Categorise items

Create and assign colour categories

Add contacts to colour categories

Assign a colour category to a calendar appointment, meeting, or event

Rename a colour category

Change fonts

Change text colour as you compose an email message

Change the default font or text colour for email messages

Change the background colour of your calendar

Automatically change incoming message colors and fonts based on sender, subject, or recipients

Change the font or font size in the message list

Create stationery for email messages

Apply stationery or backgrounds to email messages

Compose or reply e-mails

Create an email message

Create an email message template

Send an email message based on a template

Attach a message, contact, file, or task to an email message

Add graphics to messages

Reduce the size of pictures and attachments

Add a table to a message

Add and request read receipts and delivery notifications

Add tracking to email messages

Create polls in email messages and review the results

Flag messages for follow-up

Use @mentions to get someone’s attention

Reply to or forward an email message

Intermediate

Signature

Create and add a signature to messages

Change an email signature

Include an Electronic Business Card in your email signature

Send, save, print e-mails

Delay or schedule sending email messages

Change send/receive group settings

Recall or replace an email message that you sent

Change the display name that e-mail recipients see

Save a message

Change where sent email messages are saved

Print email messages

Digital signatures

Secure messages by using a digital signature

Verify the digital signature on a signed email message

Encrypt email messages

Get a digital ID

Share mailbox

Open and use a shared mailbox in Outlook 2016 and Outlook 2013

Access another person’s mailbox

Manage another person’s mail and calendar items

Manage appointments

Set or remove reminders

Change an appointment, meeting, or event

Create an all-day event

Schedule appointments

Schedule a meeting with other people

Cancel a meeting

Forward a meeting

Customise calendars

Add holidays to your calendar

Export an Outlook calendar to Google Calendar

View multiple calendars at the same time

Share calendar

Share an Outlook calendar with other people

Allow someone else to manage your mail and calendar

Open another person’s Exchange Calendar

Known issues with shared calendars in Outlook

Create and manage contacts

Add people to a contact group

Edit a contact

Share a contacts folder with others

Create a contact group from a list of names in an email message

Send an email message to a contact group

Create and edit a contact group or distribution list

Create a contact group from a list of contacts in Excel

Synchronise Outlook and Apple iPhone or iPod Touch contacts

Create and assign tasks

Create tasks and to-do items

View your tasks in Outlook

Create a task from a message

Assign and track tasks

Search

Create a Search Folder

Find people and contacts

Search and filter messages

Find a message or item with Instant Search

Learn to narrow your search criteria for better searches

Open and find items in an archive Outlook Data File (.pst)

Clean up Inbox

Overview of the Junk Email Filter

Add names to the Junk Email Filter lists

Change the level of protection in the Junk Email Filter

Use junk email filters to control which messages you see

Review email messages identified as junk

Block a mail sender

Recover deleted items

Use Conversation Clean Up

Use Clutter to sort low-priority messages in Outlook

Turn off Clutter in Outlook

Archive

Archive in Outlook 2016 for Windows

Archive older items manually in Outlook for Windows

Archive older items automatically

Back up your email

Export or backup email, contacts, and calendar to an Outlook .pst file

Import and Export

Import contacts to Outlook

Export contacts from Outlook

Import email, contacts, and calendar from an Outlook .pst file

Open or import items from an offline Outlook Data File (.ost)

Import your messages or account from Outlook Express to Outlook

Import vCards to Outlook contacts

Create or edit .csv files to import into Outlook

Import Gmail to Outlook

Import Google Gmail contacts into Outlook

Import Google Calendar to Outlook

See your Google Calendar in Outlook

Rules

Forward and redirect email automatically

Send automatic out of office replies

Manage email messages by using rules

Troubleshooting

See a list of Outlook known issues

Fix Outlook and Office 365 problems with the Support and Recovery Assistant for Office 365

How to sign in to or out of Outlook.com

Unblock my Outlook.com account

Something went wrong adding Gmail to Outlook

I can’t start Outlook or it gives me an error that says “Cannot start Microsoft Office Outlook. Cannot open the Outlook Window”

The Outlook programme freezes, stops working, or hangs

My sent messages are stuck in the Outbox

Other people aren’t receiving my messages

Fix Outlook.com email sync issues

Expert

Data Files

Locating the Outlook Data Files

Open and close Outlook Data Files (.pst)

Repair Outlook Data Files (.pst and .ost)

Reduce the size of Outlook Data Files (.pst and .ost)

Create an Outlook Data File (.pst) to save your information

PowerPoint

Quick Start

Beginner

Create a presentation

Save

Design

Share and collaborate

Give a presentation

Set up your mobile apps

Learn more

Save and share

Save PowerPoint presentations as PDF files

Share your PowerPoint presentation with others

Remove hidden data and personal information by inspecting presentations

YouTube: Learn how to share and co-author with Microsoft Creators (English only)

Work together

Work together on PowerPoint presentations on your PC

YouTube: Learn how to share and co-author with Microsoft Creators (English only)

Track changes

Track changes in your presentation

Use digital signatures

Add or remove a digital signature in Office files

Digital signatures and certificates

Templates

Apply a template to your presentation

Create and save a PowerPoint template

What is a slide master?

Where are my custom templates?

Create or customise a slide master

Copy and paste a slide master from one presentation to another

Backgrounds and themes

Format the background colour of slides

Create your own theme in PowerPoint

Add colour and design to my slides with themes

Combining colours in PowerPoint – Mistakes to avoid

Save a slide design (theme) as a template

Use multiple themes in one presentation

Slide design with PowerPoint Designer

YouTube: Learn slide design with Microsoft Creators (English only)

Watermarks

Add a text ‘DRAFT’ watermark to the background of slides

Add a background picture (or watermark) to slides

Add a watermark to a photo with PowerPoint

Headers and Footers

Edit page numbering, footers, and headers for Handouts

Edit page numbering, footers, and headers for Notes

Insert or change the slide numbers, date, or footer on Slides

Change the fonts in a footer on a slide

Why can’t I select and change the text in the footer?

(PowerPoint for Mac) Add a logo, company name, or header or footer text to handouts

Intermediate

Animate slides

Animate text or objects

Apply multiple animation effects to one object

Change, remove, or turn off animation effects

Make words appear one line at a time

Add a motion path animation effect

Change the playing order of your animation effects

Animate a picture on your slide

Animate a set of objects as a group

Add an animated GIF to a slide

YouTube: Learn animation with Microsoft Creators (English only)

Transitions

Add, change, or remove transitions between slides

Set the speed and timing of transitions

Using the Morph transition in PowerPoint

Use Zoom for PowerPoint to bring your presentation to life

YouTube: Learn animation with Microsoft Creators (English only)

Audio and video

Add audio to your PowerPoint presentation

Add and play a video in a presentation

Video and audio file formats supported in PowerPoint

Play music for the duration of your slideshow

Add an animated GIF to a slide

Why can’t I embed a video in PowerPoint?

Record a slideshow with narration and slide timings

Play music or other sounds automatically when a slide appears

Insert or link to a video on YouTube

YouTube: Learn about video and audio with Microsoft Creators (English only)

Charts and pictures

Add clip art to your file

Insert a picture from your computer

Crop a picture

Rotate a picture or other object

Draw a picture by combining and merging shapes

Insert a screenshot

Where is Picture Manager?

Create an organisation chart

Create an organisation chart in PowerPoint using a template

Use charts and graphs in your presentation

Insert a linked Excel chart in PowerPoint

Create a timeline

YouTube: Learn about pictures, graphics, and charts with Microsoft Creators (English only)

YouTube: Learn how to make infographics with Microsoft Creators (English only)

Tables

Add a table to a slide

I want to animate individual cells, rows, or columns in my table

Change the look of a table

Add or delete table rows and columns

Add a border to a table

Move or resize a table

YouTube: Learn text and tables with Microsoft Creators (English only)

Expert

Print handouts and notes

Print slides with or without speaker notes

Print your PowerPoint slides or handouts

Workaround for printing slides without white edges

Prepare and present

Open the presentation and press F5 to start from the beginning, or press Shift+F5 to start from the current slide.

Create a self-running presentation

View your speaker notes privately, while delivering a presentation on multiple monitors

Start the presentation and see your notes in Presenter view

Turn your mouse into a laser pointer

Add speaker notes to your slides

Print speaker notes

Rehearse and time the delivery of a presentation

YouTube: Learn how to present slideshows with Microsoft Creators (English only)

YouTube: Learn how to plan your presentation with Microsoft Creators (English only)

Work with slides

Add, rearrange, and delete slides

Change the size of your slides

Change the page orientation of your PowerPoint presentation

Can I use portrait and landscape slide orientation in the same presentation?

Reuse (import) slides from another presentation

Organise your slides into sections

Select individual objects on a slide

YouTube: Learn slide design with Microsoft Creators (English only)

Work with text

Wrap text around a circle or other shape

Add a hyperlink to a slide

Format text as superscript or subscript

Clear all text formatting

Change the colour of hyperlink text

Highlight your text

Change the colour of text on a slide

YouTube: Learn text and tables with Microsoft Creators (English only)

YouTube: Learn slide design with Microsoft Creators (English only)

Access

Beginner

Quick Start

Produce an Access database

Add a primary key

Backup your database

Create a query, form or report

Learn more

Intermediate

Tables

Introduction to tables

Create a table and add fields

Guidelines for naming fields, controls, and objects

Set the field size

Add a calculated field to a table

Add data macros in a desktop database

Control data entry formats with input masks

Restrict data input by using a validation rule

Add or change a table’s primary key

Create and use an index to improve performance

Data types

Data types for Access desktop databases

Introduction to data types and field properties

I get a message about data type mismatch

Document and print your database design

Relationships

Guide to table relationships

Create, edit or delete a relationship

Normalise your data using the Table Analyser

Import and Export

Import and link

Import or link to data in another Access database

Import database objects into the current Access database

Import or link to data in an Excel workbook

Import or link to data in an SQL Server database

Link to or import data from an Azure SQL Server Database – Access 2016 and later versions

Import or link to data in a text file

Import or link to data in a SharePoint list

Link to or import from dBASE

Link to or import data from Salesforce – Only for the subscription versions of Access in these SKUs: Microsoft 365 Apps for enterprise, Office 365 Enterprise E3, and Office 365 Enterprise E5 only

Link to or import data from Dynamics 365 – Only for the subscription versions of Access in these SKUs: Microsoft 365 Apps for enterprise, Office 365 Enterprise E3, and Office 365 Enterprise E5 only

Import or link to contacts from an Outlook address book

Link to a Data Service

Import data from an Access database into an Access web app – Access 2013 and later versions

Import Access 2.0 and Access 95 databases into current versions

Export

Export data to Excel

Export a database object to another Access database

Export data to a text file

Use mail merge to send Access data to Word

Export Access data to a Word document

Export data to dBASE

Export contacts to an Outlook address book

Export a table or query to a SharePoint site

Export Access web app tables to SharePoint – Access 2013 and later versions

Export Access web app tables to an Access desktop database – Access 2013 and later versions

Queries

Simple Queries

Introduction to queries

Create a simple select query

Join tables and queries

Examples of query criteria

Apply criteria to text values

Use Like criterion to locate data

Use the OR criteria to query on alternate or multiple conditions

Examples of wildcard characters

Compare two tables and find only matching data

Find duplicate records with a query

Use a parameter to make a query ask for input

Dates in queries

Examples of using dates as criteria in Access queries

Date criteria doesn’t work in my query

Add to or subtract from date and time values

Expert

Advanced queries

Create and run an update query

Create and run a delete query

Delete duplicate records with a query

What do I do if I get an error message about not being able to delete from the specified tables?

Sum data by using a query

Count data by using a query

Create a make table query

Add records to a table by using an append query

Common errors when you run an append query

Use a union query to combine multiple queries into a single result

SQL syntax

Edit SQL statements to sharpen query results

Access SQL: basic concepts, vocabulary, and syntax

Access SQL: WHERE clause

Access SQL: SELECT clause

GROUP BY Clause

ORDER BY Clause

ALL, DISTINCT, DISTINCTROW, TOP Predicates

Forms and reports

Forms

Introduction to forms

Introduction to controls

Create a form in Access

Create a form by using the Form tool

Create a form that contains a subform (a one-to-many form)

Create a navigation form

Create a split form

Create a tabbed form

Set the tab order for controls

Create a list of choices by using a list box or combo box

Set default values for fields or controls

Use a command button to start an action or a series of actions

Add a check box control to show Yes/No values

Reports

Introduction to reports in Access

Create a grouped or summary report

Set the record source for a report

Filter data in a report

Insert a page break control in an Access report

Set print options

Preview and print a report

Distribute a report

Automate with macros

Introduction to macros

Create a user interface (UI) macro

Turn sandbox mode on or off to disable macros

Expressions

Creating expressions

Use the Expression Builder

Introduction to expressions

Build an expression

Guide to expression syntax

Examples of expressions

String functions and how to use them

Popular functions

Access Functions (by category)

Type Conversion Functions

IIf Function

MsgBox Function

NZ Function

IsNull Function

Count Function

Round Function

InputBox Function

Array Function

Val Function

Text

Format Function

InStr Function

Mid Function

LTrim, RTrim, and Trim Functions

Replace Functions

StrConv Function

Date/time

Date Function

DateAdd Function

DateDiff Function

DatePart Function

DateSerial Function

DateValue Function

Month Function

Now Function

Weekday Function

Domain

DLookup Function

DSum Function

DMin, DMax Functions

DFirst, DLast Functions

DCount Function

SQL Server migration

Migrate an Access database to SQL Server

Import or link to data in an SQL Server database

Link to or import data from an Azure SQL Server Database

Connect Access to SQL Server

Create a pass-through query

Take an Access excursion through SQL Server

Comparing Access and SQL Server data types

Comparing Access SQL with SQL Server TSQL

Using the Large Number data type

Administer ODBC data sources

ODBC Scalar Functions

Rediscovered Jet and ODBC white papers

OneNote

Quick Start

Create a notebook in Windows 10

Take notes in OneNote

Share and stay organised

Set up your mobile apps

Learn more

Beginner

Get started with OneNote

What’s new in OneNote for Windows 10

Get started with the new OneNote

Introducing OneNote

Basic tasks

OneNote video training

Accessibility support for OneNote

Do things quickly with Tell Me

Create a new notebook

Save notes and notebooks

Open a notebook

Print notes

Switch between notebooks

Touch gestures

Use different versions of OneNote on the same computer

Use multiple Microsoft accounts

Where is the radial menu in OneNote?

Take notes

OneNote for Windows 10

Video: Take notes in OneNote

Convert and solve math equations

Send documents and files to OneNote for Windows 10

Embed content

Insert a file

Create links to notebooks, sections, pages, and paragraphs

Add a link

Research your paper easily

Intermediate

Format notes

OneNote for Windows 10

Format text

Check spelling

Insert a table

Video: Format pages

Change the background color of a page

Add a picture to a page

Edit and crop pictures

Insert online video

Send photos and images from other apps

Learning Tools

Draw & sketch

OneNote for Windows 10

Write notes and draw

Change the colour and thickness of ink strokes

Draw straight lines or measure with the ruler

Replay ink strokes

Group selected ink strokes in a drawing

Select all nearby ink strokes in a drawing

Expert

Share & sync

OneNote for Windows 10

Sync notebooks

Share a page of notes or an entire notebook

Protect notes with a password

Notebook storage options

Stay organised

OneNote for Windows 10

Video: Organise your notebooks

Video: Create more room in your notebook

Search for notes

Tips for searching notes

Troubleshoot

OneNote for Windows 10

Troubleshoot errors

Find my lost notes

Resolve the 0xE0000007 error (“We ran into a problem syncing your notebook”)

Why doesn’t the screen clipping tool work anymore?

Where’s OneNote 2016 in the Microsoft Store?

OneDrive

Quick Start – OneDrive (Personal)

Upload files and folders

Manage files and folders

Collaborate

Set up your mobile apps

Stay connected

Learn more

Quick Start – Intro to OneDrive (work or school)

Upload and save files and folders to OneDrive

Manage files and folders

Collaborate

Set up your mobile apps

Work on-the-go

Learn more

Beginner

Files in OneDrive

Add and Upload

Upload photos and files to OneDrive

Upload files and folders in OneDrive for work or school 

Create files and folders in OneDrive

Create a document from OneDrive for work or school

Add and sync shared folders to OneDrive

Save screenshots to OneDrive automatically

Save photos and videos to OneDrive automatically

File types supported for previewing files in OneDrive, SharePoint, and Teams

Files save to OneDrive by default in Windows 10

Store videos in Microsoft Stream

Manage

Find your SharePoint and Teams files in OneDrive for work or school

Move files and folders between OneDrive and SharePoint

Copy files and folders between OneDrive fand SharePoint sites

Sort, rename, or move photos and files in OneDrive

Organize and find photos in OneDrive

Download files and folders from OneDrive or SharePoint

Use OneDrive to fetch files on a PC

Delete files or folders in OneDrive

Embed files directly into your website or blog

Video formats you can play on the OneDrive website

Secure, protect, and restore

Back up your Documents, Pictures, and Desktop folders with OneDrive

Restore deleted files or folders in OneDrive

Restore a previous version of a file in OneDrive

Restore your OneDrive

Ransomware detection and recovering your files

What to do when a malicious file is found in SharePoint, OneDrive, or Microsoft Teams

Report abuse in OneDrive

How OneDrive safeguards your data in the cloud

Intermediate

Share and collaborate with OneDrive

Share OneDrive files and folders

See files you shared in OneDrive

See files shared with you in OneDrive

Edit a shared OneDrive file from another organization

Notify your team after uploading a file to SharePoint

Use @mention in comments to tag someone for feedback

Stop sharing OneDrive or SharePoint files or folders, or change permissions

Are my documents safe in the Discover view in OneDrive for work or school?

Unable to share OneDrive files

Sync with OneDrive

Set up sync

Sync files with OneDrive in Windows

Sync files with OneDrive on Mac OS X

Sync SharePoint and Teams files with the OneDrive sync app

Install OneDrive on an external drive

Back up your Documents, Pictures, and Desktop folders with OneDrive

Move files off a Windows 7 PC with OneDrive

How to cancel an upload or stop a download in OneDrive

Manage sync settings

Which OneDrive app?

Save disk space with OneDrive Files On-Demand for Windows 10

Save disk space with OneDrive Files On-Demand for Mac

Use OneDrive and Storage Sense in Windows 10 to manage disk space

Change the OneDrive sync app upload or download rate

Choose which OneDrive folders to sync to your computer

Use Office applications to sync Office files that I open

Mobile and Mac for OneDrive

Android

Video: Set up OneDrive on your phone or tablet

Video: Use the OneDrive mobile app

Sign in to OneDrive for Business in Android

Manually upload files or photos with OneDrive for Android

Automatically save photos and videos with OneDrive for Android

Scan a whiteboard, document, business card, or photo in OneDrive for Android

Find files in OneDrive for Android

Mark up a PDF in OneDrive for Android

Delete or restore files from your OneDrive recycle bin in Android

Share files in OneDrive for Android

Read files or folders offline in OneDrive for Android

Clean up space on your Android device with OneDrive

Add a passcode to OneDrive for Android

Troubleshoot OneDrive for Android app problems

iOS

Video: Set up OneDrive on your phone or tablet

Video: Use the OneDrive mobile app

Sign in to OneDrive for Business in iOS

Manually upload files or photos with OneDrive for iOS

Automatically save photos and videos with OneDrive for iOS

Scan a whiteboard, document, or business card in OneDrive for iOS

Find files in OneDrive for iOS

Mark up a PDF in OneDrive for iOS

Delete or restore files from your OneDrive recycle bin in iOS

Share files in OneDrive for iOS

Read files or folders offline in OneDrive for iOS

Troubleshoot OneDrive for iOS app problems

Windows

Video: Set up OneDrive on your phone or tablet

Video: Use the OneDrive mobile app

Sign in to OneDrive for Business for Windows mobile devices

Using OneDrive in Windows Phone 10

Upload files or photos to OneDrive for Windows mobile devices

Automatically save photos and videos from OneDrive on Windows mobile devices

Find files in OneDrive for Windows mobile

Delete or restore files from your OneDrive recycle bin in Windows mobile

Share files in OneDrive for Windows mobile devices

Read files or folders offline in OneDrive for Windows mobile devices

Troubleshoot OneDrive for Windows Phone app problems

Voice commands in OneDrive for Windows 10

Mac

Sync files with OneDrive on Mac OS X

Choose which OneDrive folders to sync to your computer

Save disk space with OneDrive Files On-Demand for Mac

Fix OneDrive sync problems on a Mac

Microsoft virtual support agent iconContact support
If you still need help, shake your mobile device while you’re in the OneDrive app or contact support through your browser.

Expert

Accounts and storage for OneDrive

Plan information

What to do if you can’t sign in

What does it mean when your OneDrive account is frozen?

How to add or remove an account in OneDrive

How do I merge my personal and work Microsoft accounts?

OneDrive storage plan and billing questions

OneDrive storage plans by country/region

How to reactivate a blocked account

Why did I get an email saying your account will be deleted?

“You’re syncing a different account” error

Which OneDrive account to use?

Account & Billing Support

OneDrive support advocates cannot help with Office 365 or Microsoft 365 subscriptions. For help with your Microsoft account and subscriptions, visit Microsoft Account & Billing Help or contact support through your browser.

Important: If you cannot sign in, Microsoft customer support advocates will not be able to help you beyond what you can do for yourself in the account recovery form. To protect your account and its content, advocates are not allowed to change account details or send password reset links.

Business admin

OneDrive for Business – Admin Help

Account & Billing Support

OneDrive support advocates cannot help with Office 365 or Microsoft 365 subscriptions. For help with your Microsoft account and subscriptions, visit Microsoft Account & Billing Help or contact support through your browser.

Important: If you cannot sign in, Microsoft customer support advocates will not be able to help you beyond what you can do for yourself in the account recovery form. To protect your account and its content, advocates are not allowed to change account details or send password reset links.

Troubleshoot issues with OneDrive

Sync issues   

Fix sync problems on a PC

Fix sync problems on a Mac

Stuck on “Processing changes”

Stuck on “Sync pending”

Cancel or stop a download

Find lost or missing files

When OneDrive renames items

Invalid file names and file types

How to remove a .pst file

Unable to sync to an SD card or external USB drive

Why has my filename changed from comma to ^J
 

Installation issues   

Reinstalling OneDrive

Reset OneDrive

Fix “A newer version of OneDrive is installed”

Other issues   

Fixes or workarounds for recent issues

Fix problems uploading at OneDrive.com

What do the OneDrive error codes mean?

What do the OneDrive icons mean?

How do I turn on AutoSave?

Unable to share OneDrive files
 

Mobile issues   

Android app problems

iOS app problems

Windows Phone app problems

Samsung Gallery issues

My Samsung bonus has expired
 

Account issues   

Accounts and storage for OneDrive

Microsoft virtual support agent iconContact support
If you still need help, shake your mobile device while you’re in the OneDrive app or contact support through your browser.

Microsoft Teams

Quick Start

Video – What is Microsoft Teams?

Sign in and get started

Chat and share files

Collaborate

Set up your mobile apps

Learn more

Beginner

Teams and channels

Basics

Learn about teams and channels

Team owner, member, and guest capabilities

Video: Go to guide for team owners

Video: Get your team up and running

Work in teams

Learn about teams and channels

Team owner, member, and guest capabilities

Add members to a team

Manage team settings and permissions

View analytics for your teams

Show or hide a team or channel

Find more information about a teammate

Use @mentions to get someone’s attention

Using tags in Teams

Add content and notes to a team

Reorder the teams list

Leave a team

Ways to join a team

Find and join a team

Use a link or code to join a team

Create a link or a code for joining a team

Ways to create a team

Create a team from scratch

Create a team from an existing team

Create a team from an existing group

Work in channels

Learn about teams and channels

Teams can have standard or private channels

Show or hide a team or channel

Team member and guest capabilities

Customize channel notifications

Check a channel for notifications

Delete a channel

Create or manage channels

Create a channel

Change moderator roles and settings in a channel

Share info in a channel

Send a message to a channel

Send an announcement to a channel

Send an email to a channel

Cross-post a channel conversation 

Share between Teams and Outlook

Share to Outlook from Teams

Reply to missed activity emails from Outlook

For team owners

Team owner capabilities

Create a team from scratch

Create a team from an existing group

Create a team from an existing team

Add members to a team

Accept or deny requests to join a team

Make someone a team owner

Change team settings

Renew a team

Make a public team private

Delete a team

Remove someone from a team

Archive or restore a team

Manage channels

Set guest permissions for channels

Change moderator roles and settings in a channel

Add guests

Add guests to a team

Guest capabilities in Teams

Intermediate

Notifications and settings

Notifications

Manage notifications

Six things to know about notifications

Troubleshoot notifications for Teams mobile apps

Fix notification issues in the Android app

Explore the Activity feed

Personalise

Reorder your teams list

Change your picture

Change app settings

Change the app theme

Customize the Activity feed

Favorite a team

Manage team settings

Status

Change your status

Set your status message

See who’s online

Accessibility

Accessibility support for Microsoft Teams

Switch to high contrast mode

Use a screen reader

Keyboard shortcuts

Answer a call with the keyboard

Navigate conversations with the keyboard

Zoom in and out

Change message font size

Chat in Microsoft Teams

Basics

Six things to know about chat

Start a chat

Send a message to a channel

Video: Create and format a post

Hide, mute, or pin a chat

Pop out a chat

Share your screen in a chat

Create, edit, or delete a contact group

Video: Start chats and make calls

Do your one-on-ones in Teams

Use Teams with Skype

Send and read

Send and read messages

Format a message

Copy and paste in messages

Edit or delete a sent message

Use read receipts for messages in Teams

Send a file, picture, or link

Send an emoji, GIF, or sticker in Teams

Like or react to messages

Mark a message as saved or unread

Mark a message as important or urgent

Send Praise to people

Translate a message

Send code snippets in a message

Use Markdown formatting

Use Immersive Reader

Share to Outlook from Teams

Send messages to Skype for Business users from Teams

Group chats

Four things to know about group chats

Start a group chat

Hide, mute, or pin a chat

Share your screen in a chat

Leave or remove someone from a group chat

Find and filter

Search for a message

Resume an old conversation 

Video: Save a post or message

Filter the activity feed

Video: Filter your activity feed

Meetings and calls

Basics

Meetings

Overview of meetings in Teams

Join a meeting

Using video in Microsoft Teams

Calls

Start a call from a chat

Call a phone number

Answer a call

Live events

Get started with live events

Schedule a live event

Attend a live event

Meetings

Join a meeting

Join a meeting

Video: Join a Teams meeting

Join a meeting without a Teams account

Participate in a meeting from the mobile app

Participate in a meeting on Surface Hub

Join a Skype for Business meeting on Surface Hub

Call in to a meeting

During a meeting

Using video in Microsoft Teams

Change your video background

Adjust your view

Share content

Video: Show your screen during a meeting

Take meeting notes

Raise your hand

Multitasking in a meeting

Video: Move around during a Teams meeting

Manage audio settings

Change participant settings

Download an attendance report

Whiteboard

Share system audio

Keyboard shortcuts for Teams meetings

End a meeting for everyone in attendance

Set up a meeting

Schedule a meeting

Schedule a Teams meeting from Outlook

Start an instant meeting

Video: Create instant meetings with Meet now

Start a new Teams meeting on Surface Hub

Invite people to a meeting

Video: Tip: Meet in a channel

See all your meetings

Video: Manage meetings

Add a dial-in number for a meeting

Record a meeting

Record a meeting

Play and share a meeting recording

Delete a meeting recording

Edit a recording transcript

Calls

Make calls

Start a call from a chat

Call a phone number

Answer a call

Add someone to a call

Make multiple calls at the same time

Put a call on hold

Transfer a call

Manage calls

Manage your call settings

Call forwarding, call groups, and simultaneous ring

Share a phone line with a delegate

Park a call

Check your voicemail

View or add contacts

View your call history

Turn off automatic video in a call

Control calls using a headset

Live events

Get started with live events

Live event organiser checklist

Schedule a live event

Invite attendees

Produce using Teams

Produce using an external app or device

Best practices for producing

Present in a live event

Share system audio

Attend a live event

Participate in a Q&A

Use live captions

Manage event recording and reports

Use Teams for tier 1 events

Files

Use and share files

Explore the Files list

Edit a file

Download a file

Share a file

Share a file with someone outside your team

Get a link to a file

Move or copy files

Sync file libraries to a team

Recover deleted files

File storage

Cloud storage

Add a cloud storage service

Share a file from cloud storage

Share a folder from cloud storage

Add third-party apps to the Files app on iOS

Sign-in issues

Expert

Basics

General

Five things to know about apps

Video: Use apps in Teams

Add or remove an app

Use an app in a tab or channel

Insert app content into a message

Get app notifications in a channel (Connectors)

Chat with a bot

Use an app with a personal view

Report a problem with an app

Team owners 

Turn off adding apps

Developers 

Build a custom app

Organise apps

Access your apps

Pin an app for easy access

Personal use

Use an app with a personal view

Shifts

Video: What is Shifts?

Get started in Shifts

Video: Create a Shifts schedule

Fill out a schedule

Keyboard shortcuts for Shifts

View the team schedule

Copy or export a schedule

Manage settings

Video: Manage a Shifts schedule

Manage your shifts

Time off and availability

Set up Time Clock

Clock in and out using Time Clock

Export time reporting

Bookings

Overview of Bookings in Teams

For schedulers

Set up a booking calendar for a business or department

Add staff members to a booking calendar

Create appointment types with corresponding emails

Schedule a booking

Filter a booking calendar to view select staff schedules

For attendees

Join a Bookings appointment – External attendees

Join, conduct, and end a Bookings appointment – Staff attendees

Additional resources

How Microsoft Teams helps industries (healthcare, finance, etc.) meet compliance

More apps

OneNote

Add a OneNote notebook

Access notes outside the app

Wiki

Add and use a Wiki tab

Edit and format a Wiki tab

Patients 

Get started in Patients

Kaizala

Create a Checklist

Create a Poll

Create a Survey

More apps

Add and use a Planner tab

Add a Kanban board

Add a Power BI tab

Add and use a Stream tab

Use the Organisation tab

Troubleshoot the Website tab

Create, edit, and collaborate on a form

SharePoint

Quick start

Sign in to SharePoint

Discover in SharePoint

Collaborate in SharePoint

Create a site in SharePoint

Set up your mobile apps

Beginner

Sharing and permissions

Share SharePoint files or folders

Stop sharing OneDrive or SharePoint files or folders, or change permissions

Share a site

Store videos in Stream

More ways to learn

YouTube: Learn about security and permissions from Microsoft Creators

YouTube: Learn about SharePoint administration from Microsoft Creators

YouTube: Learn about automation with SharePoint from Microsoft Creators

Documents and libraries in SharePoint

Check out & sync

Check out, check in, or discard changes to files in a library

Enable and configure versioning for a list or library

How does versioning work in a list or library?

Top questions about check out, check in, and versions

Restore a previous version of an item or file in SharePoint

Set up a library to require check out of files

Delete a previous version of an item or file in SharePoint

More ways to learn

YouTube: Learn about documents and libraries from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Alerts

Create an alert to get notified when a file or folder changes in SharePoint

Manage, view, or delete SharePoint alerts

Add RSS feeds from external sites to your site

Workflow

Power Automate

Set a reminder flow

SharePoint 2010 and 2013 workflow

Overview of workflows included with SharePoint

Introduction to SharePoint workflow

Send email in a workflow

All about Approval workflows

All about Collect Feedback workflows

More ways to learn

YouTube: Learn about documents and libraries from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Content types

Create or customise a site content type

Add a content type to a list or library

Create content organiser rules to route documents

More ways to learn

YouTube: Learn about documents and libraries from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Manage

What is a document library?

See file insights before you open a file

Upload files and folders to a document library

Create a folder in a document library

Create a document library in SharePoint

Move or copy items from a SharePoint document library

Delete a file, folder, or link from a SharePoint document library

Add a link in a document library

Delete a document library in SharePoint

Restore a document library

Require approval of items in a site list or library

Set a custom template for a SharePoint library

More ways to learn

YouTube: Learn about documents and libraries from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Intermediate

Data and lists in SharePoint

Create & edit

Add, edit, or delete list items

Bulk edit list item properties

Create a list in SharePoint

Create a list based on a spreadsheet

Differences between classic and new experiences for lists and document libraries

Columns

Add an enterprise keywords column to a list or library

Add an index to a SharePoint column

Change a column in a list or library

Column formatting

Create a column in a SharePoint list or library

Create a folder in a SharePoint list

Create a managed metadata column

Create list relationships by using unique and lookup columns

Delete a column in a SharePoint list or library

Export to Excel from SharePoint

List and library column types and options

More ways to learn

YouTube: Learn about data and lists from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Views

Create, change, or delete a view of a list or library

Formatting list views

Prioritise content management tasks with attention views

Use filtering to modify a SharePoint view

What is the list and library filters pane?

More ways to learn

YouTube: Learn about data and lists from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

List types

Add branching logic to a survey

BI capabilities in Excel and Microsoft 365

Create a survey

Differences between using a workbook in the browser and in Excel

Plan a survey

Using Excel workbooks in a browser

Video: Adding events to a SharePoint calendar

Video: Create a shared calendar in Microsoft 365

Video: Create your own SharePoint calendar

More ways to learn

YouTube: Learn about data and lists from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Manage

Create a PowerApp for a list in SharePoint Online

Delete a list in SharePoint

Examples of common formulas in SharePoint Lists

Export an external list to Excel

Manage large lists and libraries in SharePoint

Manage list templates

SharePoint basics – Large lists and libraries

Switch the default experience for lists or document libraries from new or classic

Target content to specific audiences

More ways to learn

YouTube: Learn about data and lists from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Pages in SharePoint

Create & edit

Modern pages

Add a page to a site

Add or remove columns on a page

Add a page to a Communication site

Using web parts on SharePoint pages

Configure page approval using Microsoft Flow

Classic pages

Create and edit classic SharePoint pages

More ways to learn

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Web parts & apps

Modern web parts

Complete guide to all modern web parts:

Using web parts on SharePoint pages

Featured web parts:

Add text and tables to your page with the Text web part

Use the Image web part

Use the Document Library web part

Use the List web part

Maintenance:

Open and use the web part maintenance page

Classic web parts

Add an app to a site

Buy an app from the SharePoint Store

Remove an app from a site

Add an App Part to a page

Use the List and other web parts on classic pages

Add, edit, minimize, or delete a web part on a classic page

Connect a Filter web part to a List View web part on a classic page

Open and use the web part maintenance page

More ways to learn

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about building a modern intranet from Microsoft Creators

Sites in SharePoint

Team sites

What is a SharePoint team site?

Plan your SharePoint site

Create a team site in SharePoint

Manage your SharePoint team site settings

Keep your team updated with News on your team site

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Communication sites

What is a SharePoint communication site?

Plan your SharePoint site

Create a communication site in SharePoint

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

What is a SharePoint communication site?

Plan your SharePoint site

Create a communication site in SharePoint

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Hub sites

What is a SharePoint hub site?

Create SharePoint hub sites using PowerShell

Set up your SharePoint hub site

Associate a SharePoint site with a hub site

Disassociate a SharePoint site from a hub site

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Navigation

Customize the navigation on your team site

Set up metadata navigation for a list or library

Enable managed navigation for a site in SharePoint

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Manage

Customise your SharePoint website

View usage data for your SharePoint site

Choose the languages you want to make available for a site’s user interface

Change regional settings for a site

Create a multi-language website

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Mobile

Get SharePoint mobile app

Android

SharePoint mobile app for Android

Team News in the SharePoint mobile app for Android

iOS

SharePoint mobile app for iOS

Team News in the SharePoint mobile app for iOS

Windows

SharePoint mobile app for Windows 10 Mobile

More ways to learn

YouTube: Learn about building a modern intranet from Microsoft Creators

YouTube: Learn about news and pages from Microsoft Creators

YouTube: Learn about working in SharePoint from Microsoft Creators

Expert

Troubleshoot issues with SharePoint

File size limits for workbooks in SharePoint

Why SharePoint ribbon buttons are unavailable

Fix problems opening documents in SharePoint libraries

Documents open read-only in desktop Office programmes

Reduce the file size of a workbook

Refreshing data in a workbook in a browser window

SharePoint Correlation ID in error messages: what it is and how to use it

Viewing SharePoint Home with the Office Graph turned off

Restore items in the Recycle Bin of a SharePoint site

Restore deleted items from the Site collection recycle bin 

Forms

Quick Start

Sign in

Create a form

Share a form

View results

Learn more

Beginner

Share and collaborate

Want to collaborate with colleagues on your quizzes and forms? Want to share your quiz or form as a template for others to use independently? You can do both of these sharing tasks easily.

First, sign in and create

Sign in to Microsoft Forms

Create a new form or Create a new quiz

Next, share your form or quiz

Share your quiz or form and collaborate with others

Share a quiz or form as a template

Send your form or quiz to others and collect responses

Send an email receipt of responses

Then, check results and share them

Check and share your form results

Check and share your quiz results

Where can I go to submit feedback such as product bugs or feature requests?

We’d love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.

See Also

Frequently asked questions

Intermediate

Format

Add a logo to your form or display pictures or videos next to quiz questions.

Add a picture or logo to a form header

Add a picture to a question

Add a video to a question

Add sections to your survey or questionnaire

Adjust settings for your form or quiz

Change a form theme

Change your picture size

Copy a form

Delete a form

Delete a picture

How to ensure your form and workbook are in sync

How to get missing data in Forms

Print a form

Send a form in multiple languages

Use branching in Microsoft Forms

VIDEO: Explore new question types

Where can I go to submit feedback such as product bugs or feature requests?

We’d love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.

See Also

Frequently asked questions

Integration

You can also insert quizzes, surveys, polls, and other types of forms into other Microsoft 365 products with which you’re familiar.

Excel Online

Create a form in Excel Online

OneDrive for Business

Create a form in OneDrive for Business

OneNote

Insert a form or quiz into OneNote for the web

Outlook

Create a poll in Outlook

Power Automate

Create an automated workflow with Microsoft Forms

PowerPoint

Insert a form or quiz into PowerPoint

SharePoint

Use the Microsoft Forms web part in SharePoint

Stream

Add a survey, poll, or quiz to a Microsoft Stream video

Sway

Embed a form in a Sway

Teams

Create a poll in Microsoft Teams

Delete a group form created in Teams

Survey your team to check in and stay connected

Work with colleagues to create, edit, and review forms in Microsoft Teams

Where can I go to submit feedback such as product bugs or feature requests?

We’d love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.

See Also

Frequently asked questions

Expert

Admin tasks

Administrator settings for Microsoft Forms

Data storage for Microsoft Forms

FAQ for administrators

Form, question, response, and character limits in Microsoft Forms

Microsoft Forms and proactive phishing prevention

Microsoft Forms and user accounts

Review and unblock forms or users detected and blocked for potential phishing

Security and privacy

Set up Microsoft Forms

Transfer ownership of your form

Turn off or turn on Microsoft Forms

Where can I go to submit feedback such as product bugs or feature requests?

We’d love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.

See Also

Frequently asked questions

Kaizala

Beginner

Get started with Microsoft Kaizala

Office for business, Office 365 Small Business, Microsoft Kaizala.

Get to know Kaizala

Quick start guide for Kaizala

Kaizala videos



< Kaizala help centre

Set up and customise Microsoft Kaizala

Office for business, Office 365 Small Business ,Microsoft Kaizala.

Profile settings

Update your profile

Update your status



< Kaizala help centre

Privacy settings

Set your last seen status

Download your data

Block or unblock a contact

View the privacy statement

Delete your account

< Kaizala help centre

Security settings

Two-step verification

< Kaizala help centre

Other settings

Set your language settings

Change your auto-download settings

Change your message sound settings

< Kaizala help centre

Chats, calls, and groups in Microsoft Kaizala

Office for business, Office 365 Small Business, Microsoft Kaizala.

Chats & calls

Start a chat

Use Me Chat

Invite contacts who are not on Kaizala

Start a call

< Kaizala help centre

Intermediate

Invite & join groups

Group structures

Create a group

Invite people to a group

Using a group invite link

Using a QR code

Using a group code

Revoke an invite link or code for a group

Make a group discoverable to people nearby

Join and discover groups

< Kaizala help centre

Manage groups

View participants list and count

Remove people from a group

Assign or remove the admin role

Link a group to an organization

Leave a group

Mute or unmute a group

Delete a group

Change the profile picture of a group

Change a group name

Pin or unpin a group

Set group policies

Report abusive content

< Kaizala help centre

Org chats & groups

Organization chats and groups

Email notifications for missed messages

< Kaizala help centre

Send, share, and respond in Microsoft Kaizala

Office for business, Office 365 Small Business, Microsoft Kaizala.

Create & manage Actions

Add or remove Actions from a group

Send and respond to Actions

Send reminders for Actions

Check pending Actions

Give consent to custom Actions

< Kaizala help centre

Manage group content

Star messages

Clear group content

Delete messages

Search

Check read receipts

Reply to messages

Share and forward messages

Like and comment

View likes and comments

< Kaizala help centre

Expert

Send attachments

Add attachments to a group

Send photos and photo stories

Send a video

Send a contact

Send a document

Send an audio message

< Kaizala help centre

Help and support for Microsoft Kaizala

Office for business, Office 365 Small Business, Microsoft Kaizala.

Get help information

Send feedback

Kaizala training

< Kaizala help centre

Planner

Quick Start

Sign in

Create a plan

Manage tasks

View plan and get updates

Set up your mobile apps

Learn more

Beginner

Build your plan

Start building your plans and adding tasks to Microsoft Planner.

Plans

Sign in to Microsoft Planner

Create a plan in Microsoft Planner

Create buckets to sort your tasks

Add people to your plan

Copy a plan

Mark plans as favourites

Delete a task or plan

Tasks

Add tasks to a plan

Add task start and due dates

Assign task priority

Assign people to tasks

Attach files, photos, or links to a task

Set a preview picture for a task

Flag your tasks with labels

Copy Planner tasks

Add a checklist to a task

Stay on track

View and track progress for your tasks in Microsoft Planner.

View progress

Set and update task progress

View charts of your plan’s progress

View your tasks on a calendar

Collaborate

Comment on tasks in Microsoft Planner

Stay on top of tasks and plans with email and notifications

Plan members: Manage group emails for your Planner plans

Group owners: Turn group emails about task activity on or off for a plan

Guest access in Microsoft Planner

Intermediate

Apps & integrations

Learn how you can use Planner with Teams, Outlook, on your mobile phone, and more.

When to use Microsoft Project, Planner, or To-Do

Use Planner in Microsoft Teams

Planner notifications in Teams

See your Planner calendar in Outlook

See Planner tasks in Microsoft To-Do

Use Microsoft Planner on your SharePoint site

Use the Planner web part

Use the Planner for Android app

Use the Planner for iOS app

Planner for Microsoft 365 US Government

Export a plan to Excel

Onboarding your team

Help your team start using Microsoft Planner.

Plan an event

Support customers

Publish content

Track a process

Expert

Admin tasks

Publisher

Create a publication in Publisher

Save

Design

Learn more

Beginner

Create

Use Publisher to create professional publications.

Get started

Basic tasks

Keyboard shortcuts

Get a word count

Make cards and brochures

Make and print business cards on Avery stock

Make greeting cards

Make one or two-sided postcards

Find brochure templates

Make a brochure

Build newsletters

Create a newsletter

Remove pages from a newsletter

Create and send email newsletters

Work with calendars and templates

Change the dates on a calendar

Change the month on a calendar

Add months to a calendar

Create a publication from a template

Find an Avery template

Create labels with different addresses

See Also

Format Publisher publications

Change the layout of Publisher publications

Print and mail Publisher publications

Troubleshoot Publisher publications

Format

Basic formatting

Resize the page or paper

Highlight text

Fit text in a text box

Change line spacing

Add or delete pages

Insert a table of contents (TOC)

Use building blocks to quickly create a publication

Save As or convert a publication to .pdf

Add a PDF file or image to a publication

Create a hyperlink

Change the colour of hyperlinks

Intermediate

Work with pictures

Tips for working with images

Crop a picture

Insert a picture into an AutoShape

Make a picture a background

Group and ungroup text boxes, pictures, and other objects

Work with watermarks

Add a watermark to a photo or picture

Add a text watermark

Create a watermark from a photo or picture

Print watermarks

Remove a watermark

See Also

Create Publisher publications

Change the layout of Publisher publications

Print and mail Publisher publications

Troubleshoot Publisher publications

Layout

Work with borders, backgrounds, and columns

Add or remove a page border in Publisher

Add a border around a text box, picture, or other object

Remove a border around a page, text box, picture or other object

Create columns within a text box in Publisher

Working with page margins

Make a two-column publication

Change the background color

Make a background transparent

See Also

Create Publisher publications

Format Publisher publications

Print and mail Publisher publications

Troubleshoot Publisher publications

Print and mail

Create and print labels with different addresses

Print different labels on one sheet

Add and print crop marks

Set page margins for printing

Print watermarks

Print a newsletter on 11×17 paper

Print a sheet of business cards

Print a brochure

Print two-sided postcards

Print multiple postcards on a single sheet

Make and print business cards on Avery stock

See Also

Create Publisher publications

Format Publisher publications

Change the layout of Publisher publications

Troubleshoot Publisher publications

Expert

Troubleshoot

Common printing issues

Fix text hyphenation

“Publisher cannot save the file” error when saving as PDF

Common mail merge issues

Understanding the Custom Page Size dialog box in Publisher

Where is the Publisher viewer?

Understanding the Page Setup dialog in Publisher

See Also

Create Publisher publications

Format Publisher publications

Change the layout of Publisher publications

Print and mail Publisher publications

Project

Project for the Web Quick Start

Create a project

Build a project

Manage a project

Learn more

Project desktop Quick Start

Create a project

Edit a project

Manage a project

Learn more

Project Online Quick Start

Project Online Quick Start

Collaborate

Share your project

Share a project in Project for the web

Share a roadmap with a group

Share a timeline in Project desktop

Create and share a resource pool in Project desktop

Publish a project to Project Web App

Get started with a Project site

Time reporting

Enter hours on your timesheet in Project Online

Add a task to your timesheet in Project Online

Capture vacation, sick leave, and other non-project hours in Project Online

Take back a timesheet that you sent for approval in Project Online

Task progress

Track your time and task progress in Project Online

Report your task progress in Project Online

Report the percent of work you’ve completed in Project Online

Update how much work you have left to do in Project Online

Hand off work to someone else in Project Online

Assign someone else to enter your time and task progress in Project Online

View other projects across your organization in Project Online

Projects & tasks

Projects

Get started with Project for the web

Organize your project in Board view in Project for the web

Copy a project in Project for the web

Open a Project Online project in Project desktop

Open a project for editing in Project Online

Change a project’s template in Project Online

Edit project details in Project Online

Publish a project in Project Online

Export your Project Online project to Microsoft Excel

Add an issue to a project in Project Online

View a project document in Project Online

Scheduling

Project management goal: Create a new project schedule in Project desktop

Set the start date or finish date for your project in Project desktop

Link projects to create a master project in Project desktop

Show the critical path of your project in Project desktop

Set and save a baseline in Project desktop

Create WBS codes in Project desktop

Show slack in your project in Project desktop

Create tasks

Build a project in Grid and Timeline views in Project for the web

Create a new task in Project Online

Indent or outdent tasks in your project in Project Online

Link tasks in your project in Project Online

Create or update a baseline or an interim plan

Add tasks to a project timeline in Project Online

Change the appearance of a timeline in Project Web App

Get email reminders about your work in Project Web App

Add a risk to a project in Project Online

SharePoint task lists

Overview: View a SharePoint task list in Project Web App

Add an existing SharePoint task list to Project Web App

Work with a SharePoint task list in Project Web App

Customize timesheets and task progress for your organization

Change a SharePoint task list into an enterprise project in Project Online

Remove a SharePoint task list from Project Web App

Add projects and tasks to the Project Center timeline in Project Online

Set up policies for capturing time and task progress

Set up how time and task progress are captured

View an imported SharePoint task list in Project Web App

Configure time and task progress

Intermediate

Resources

Manage resources

View resource workloads and availability in Project desktop

Add a resource to Project Web App

Add or update enterprise resources using an external data file

Use data to forecast resource demand in Project Online

Replace a resource in Project Online

Evaluate resource capacity in Project Online

Use team resources in Project Online

Resource engagements

Overview: Resource engagements

Activate resource engagements in Project Online

FAQ: Resource engagements are replacing the old resource plans

Accept or reject an engagement request in Project Online

Format & print

Change how things look

Change the date format in Project desktop

Wrap text and change row height in a Project view in Project desktop

Hide or unhide a column in a Project view in Project desktop

Show task names next to Gantt chart bars in Project desktop

Change the timescale in a Project view in Project desktop

Change the color of external links in Project desktop

Rename a project in Project desktop

Views

Build a project in Grid and Timeline views in Project for the web

Organise your project in Board view in Project for the web

Split a view in Project desktop

Show the project summary task in Project desktop

Create a Network Diagram in Project desktop

Create and work with subtasks and summary tasks in Project desktop

Sort tasks, resources, or dates in Project desktop

Project functions for custom fields in Project desktop

Print, save, and export

Print a project schedule in Project desktop

Save a project file in Project desktop

Save or convert to PDF or XPS in Project desktop

Copy reports, calendars, and views in Project desktop

Export project data from Project desktop to Excel

File formats supported by Project desktop

Expert

Reporting

Portfolio dashboard

Use the portfolio analysis scatter chart in Project Online

Create report

Use Excel to create a Project Online report

Create a project report in Project desktop

Create a burndown report in Project desktop

Expert

Troubleshooting

I can’t figure out how to install Project. Help?

What should I do if my Project Online administrator gets locked out?

Why do my dates keep moving around?

More fixes for recent issues

What’s the difference between Project Online and Project Professional?

I can’t access Project Online. What should I do?

An indicator says a resource is overloaded. How come?

When I copy and paste a task, I lose its duration and dependencies. Why?

Create New Calendar is greyed out. How do I change working days?

Ask the Project community

Sway

Quick Start

Sign in

Create

Add content

Design and share

Learn more

Beginner

Add content

Getting Started with Sway

How to Sway

Import content into Sway

Search for content in Sway

Add video and audio files into Sway

Record audio in Sway

Embed content in your Sway

Embed an Office document in Sway

Embed a form in your Sway

Add Focus Points to images in Sway

Copy and paste cards in Sway

Create a Sway in seconds with QuickStarter

See Also

Frequently Asked Questions about Sway

File size limits in Sway

Intermediate

Share and access

Share your Sway

Add a password to your Sway

Privacy settings in Sway

Sway system requirements

Accessibility features in Sway

Sway keyboard shortcuts

See Also

Frequently Asked Questions about Sway

File size limits in Sway

Expert

Customise

Add more content to your Sways with Microsoft 365

Remove the Sway informational footer

Administrator settings for Sway

Frequently Asked Questions about Sway

Frequently Asked Questions about Sway – Admin Help

See Also

File size limits in Sway

To-Do

Beginner

Get Started

Welcome to Microsoft To Do

My Day and Suggestions

Import your Wunderlist account to Microsoft To Do

Lists

Create and share lists

Assign tasks in shared lists

Get notifications for shared lists

Organise your lists

Sort and search in lists

Customise your lists

Delete and restore lists

Report abusive content in shared lists

Intermediate

Tasks

Create, edit, delete, and restore tasks

Add due dates and reminders to your tasks

Add steps, importance, notes, and tags to your tasks

Add files to your tasks

Move tasks between or within lists

Tips & tricks

Productivity

Productivity and Microsoft To Do

Finding your magic number with Microsoft To Do

Reflecting on your accomplishments in Microsoft To Do

Prioritising yourself with Microsoft To Do

Keeping yourself accountable with Microsoft To Do

Creating daily habits with Microsoft To Do

Accountability buddies and Microsoft To Do

Resolutions and Microsoft To Do

Learn more about Microsoft To Do from experts on YouTube

Windows

Integrations

Using Microsoft To Do with Outlook Tasks

Using Microsoft To Do with Outlook.com

Using Microsoft To Do with flagged email

Using Microsoft To Do with Cortana

Using Microsoft To Do with Microsoft Launcher

Using Microsoft To Do with Microsoft Power Automate

See Planner tasks in Microsoft To Do

Using Microsoft To Do’s API

iOS

Using 3D Touch with Microsoft To Do

Using Siri with Microsoft To Do on iOS11, iOS12 & iOS13

Using Apple Watch with Microsoft To Do

Android

Using Routine reminders on Android

Using the Android widget with Microsoft To Do

Using OK Google with Microsoft To Do

Sharing to Microsoft To Do 

Sharing from Microsoft To Do

Adding Home screen shortcuts on Android

Expert

Setup

System requirements and supported accounts

Supported languages

Syncing your Microsoft To Do account

Exporting your Microsoft To Do account

Enabling Microsoft To Do on a MAM managed device

Using multiple accounts with Microsoft To Do

Using Microsoft To Do in Dark theme

Becoming a Microsoft To Do Insider

Troubleshoot

Why isn’t my account syncing with Outlook 2016 on Windows?

Why do I receive the error “Sorry, there’s an issue signing you in right now”?

Why does my app keep crashing?

Why do I receive the message that my license for To Do is disabled? 

Why do I receive a 503 error on web? 

Why do I receive the message that the list I try to join is unavailable?

Why can’t I sign in to the importer? 

Visio

Quick Start

Select a template in Visio

Add and connect shapes

Format

Learn more

Collaborate

Print

Use Visio Viewer to view or print Visio drawings

Reduce or enlarge a drawing when you print it

Change the page orientation to portrait or landscape in Visio

Share

Share schedule and task details with a Visio Gantt chart

Work together on Visio drawings

Save diagrams to SharePoint

Format pages

Text

Add text to a page

Add, edit, move, or rotate text in Visio

Add, edit, move, or rotate text on a connector

Format text in a Visio drawing

Colours and themes

Apply a professional look to your drawings with themes

Create a custom theme

How to use colour by value

Fill a shape with a colour, gradient, or pattern

Intermediate

Pages

Snap to guides to lay out a drawing

Edit your drawing using the Drawing Explorer window

Change the drawing scale

Add a table to a drawing

Copy pages and shapes in a Visio drawing

Add a header or footer in Visio 

Add a background or watermark in Visio

Add a page border or title

Change the ruler measurement units in Visio

Change grid spacing and size

Show, hide, or change the grid

Specify dimensions by using the Size & Position window

Show size or dimensions of shapes in Visio

Adjust snap strength or turn snap off

Draw lines and shapes with the Pencil, Line, Arc, or Freeform tools 

Measure the distance between two points

Shapes

Basics

Create a shape

Edit a master shape

Format a shape in Visio

Shape basics: resize, format, move and add text to shapes 

Use the Shapes window to organize and find shapes

Use layers to set properties for multiple shapes

Stencils

Find 3D shapes and stencils

Find more shapes and stencils

Create, save, and share custom stencils

Import downloaded stencils

Add a stencil to a template in Visio

Connect shapes

Edit connector lines, arrows, or points

Add connectors between shapes

Add or remove connector line jumps

Create a custom connector

Add and edit connector text

Glue or unglue connectors

Flip or reverse a shape

Rotate lines

Data

Add data to shapes 

Add data sets to shapes

Importing data into Visio, an overview

Import data to shapes in your drawing

Data graphics, an overview 

How to use data bars

How to use icon sets 

How to use text callout data graphics

Expert

Create

Use the Create Diagram from Data wizard

Create a wireframe diagram for user interfaces

Clarify the structure of diagrams by using containers and lists

Annotate a diagram by using callouts

Insert pictures into a Visio diagram

Zoom and pan in a diagram 

Build Visio diagrams using touch

Create subprocesses and reuse them in a process diagram

Validate a structured diagram

Align and position shapes in a diagram

Use a SharePoint process repository to store process diagrams

Save a diagram as a graphic or image file

Flowcharts

Create a basic flowchart

Add swimlanes to a flowchart

Make a Visio flowchart to visualize a process

Create a cross-functional flowchart

Create a decision tree

Create BPMN-compliant processes

Create a value stream map

Create IDEF0 diagrams

Create an SDL diagram

Business charts

Create a brainstorming diagram

Create an EPC (Event-driven Process Chain) diagram

Create a fault tree analysis diagram

Create a line graph

Create a PivotDiagram

Create a marketing diagram

Create a Visio organisation chart

Create an organisation chart automatically from employee data

Create an organisation chart without external data

Create a TQM flowchart

Create a tree diagram

Create a Venn diagram

Network, Software, Database

Create a basic network diagram

Create a data flow diagram

Create a Database Model (also known as Entity Relationship diagram)

Define categories in a Database Model diagram

Create a cause and effect diagram

Create a Data Visualiser diagram

Create a Gane-Sarson data flow model diagram

Create a rack diagram

Generate a Web Site map

Create a UML activity diagram

Create a UML communication diagram

Create a UML component diagram

Create a UML deployment diagram

Create a UML sequence diagram

Create a UML use case diagram

Plan your Web site using the Conceptual Web Site diagram

Specify multiplicity on an UML shape

UML diagrams in Visio

Building plans and maps

Create a floor plan

Create a home plan

Create an HVAC plan

Create an electrical engineering diagram

Create an electric and telecom plan

Create a map in Visio

Create an office layout diagram

Create a reflected ceiling plan

Create a plant layout

Create a plumbing and piping plan

Create a pneumatic or hydraulic control system diagram

Create a site plan

Create a space plan

Create a security and access plan

Introduction to working with AutoCAD drawings

Open an AutoCAD drawing

Crop an AutoCAD drawing

Unlock an AutoCAD drawing

Import an AutoCAD drawing

Convert multiple AutoCAD drawings

Change the line color or line weight of a CAD layer

Save a Visio diagram as an AutoCAD file

Yammer

Quick Start – Get started

Get started

Welcome to Yammer

What’s new in Yammer

Change my Yammer profile and settings

Which languages is Yammer available in?

Set up Yammer on your mobile phone

Beginner

Manage communities

Manage Communities

Join and create a Yammer community or group

Manage a Yammer community or group

Manage Yammer community members

Customise a Yammer community

View community or group insights in Yammer

Use and manage resources in my Yammer community or group

Restrict All Company posts in Yammer

Share files and group resources

Favourite Yammer communities

Delete a community or group in Yammer

Export Yammer community or group members to a .csv file

Use Yammer

Conversations

Edit Yammer conversation posts, replies, and messages

View Seen Counts in Yammer

Share and move Yammer conversations and files

Pin, close, and report conversations in Yammer

Create polls, praise, announcements, and questions in Yammer

Create and annotate short videos in Yammer

Send a message to a specific person in Yammer

Use questions and answers in a Yammer community or group

Post to Yammer by sending an email message

What’s in the Yammer Home and Discovery Feeds?

Files

Edit documents from Yammer

Edit a previously uploaded file when your Yammer group now stores files in SharePoint

Attach a file or image to a Yammer conversation or message

Video posts in Yammer upload and encode separately

Inbox and Notifications

Manage your Yammer Inbox

Enable or disable Yammer email and phone notifications

Can I unsubscribe myself from Yammer?

Live events in Yammer

Organise a live event in Yammer

Attend a live event in Yammer

Schedule and produce a live event

Get help producing a live event

Broadcast a live event using Teams

Drive engagement in a Yammer live event

Discover Yammer live events with the event carousel

Video posts in Yammer upload and encode separately

Live events FAQ

Accessibility

Accessibility in Yammer

Keyboard shortcuts for Yammer

Use a screenreader to explore

Use Yammer with voice control

Expert

Integrations

Integrations with Yammer

Add apps to Yammer

Use the Yammer Communities app for Microsoft Teams

Work with Yammer from Outlook

Add a Yammer page to a Teams channel

Use a Yammer web part in SharePoint Online

Troubleshoot

Troubleshoot

Is my community or group connected to Office 365?

How do I tell where my files are being stored?

Yammer for Windows and Mac

How do I find a Yammer community or group feed ID?

I can’t log into Yammer on my Android device

When I log in to Yammer I get the wrong network

Copy and paste problem when using Yammer in Internet Explorer

Skype for Business on Windows Quick Start 

Download and install

Set up

Chat

Share and schedule

Set up your mobile apps

Learn more

Beginner

Meetings with Skype for Business

Join

Join a Skype for Business meeting

Call into a Skype for Business meeting on your mobile or other phone

Start a Skype for Business conference call

Find a local number to join a Skype for Business meeting

Let the Skype for Business meeting call you

Video: Join a Skype for Business Meeting

Set up

Set up a Skype for Business meeting in Outlook

Mute or unmute your microphone in a Skype for Business meeting or call

Start an impromptu Skype for Business meeting

Set up a Skype for Business meeting on behalf of someone else

Switch the meeting audio to your phone

Change participant settings for Skype for Business meetings

Skype for Business meeting help

Learn about the Skype for Business meeting window

Video: Schedule a Skype for Business Meeting

Change your dial-in conferencing settings

Meeting Update Tool for Skype for Business and Lync

Share

Present PowerPoint slides in a Skype for Business meeting

Play a video in a Skype for Business meeting

Add a file to a Skype for Business meeting

Preload attachments for a Skype for Business meeting

Take a poll in a Skype for Business meeting

Use the whiteboard to collaborate in a Skype for Business meeting

Have a Q&A session in a Skype for Business meeting

Present programmes in Skype for Business

Who can look at content on their own?

Use shared and private notes in a Skype for Business meeting

Co-author in a Skype for Business meeting or conversation

Video-based screen sharing in Skype for Business

Set File Saving options in Skype for Business

Video: Meet and share using Skype for Business

Troubleshoot OneNote file sharing in Skype for Business

Record

Record and play back a Skype for Business meeting

Skype for Business recording, save, and publish

Recording Manager save and publish

Skype for Business recording location and resolution

Skype for Business Recording Manager

Set Recording options in Skype for Business

Broadcast

What is a Skype Meeting Broadcast?

Join a Skype Meeting Broadcast

Best Practices for Skype Meeting Broadcast

Skype Meeting Broadcast help

Schedule a Skype Meeting Broadcast

Manage a Skype Meeting Broadcast event

Record and post a Skype Meeting Broadcast

Add Microsoft Pulse to a Skype Meeting Broadcast

Add a Yammer feed to a Skype Meeting Broadcast

Add a Q&A session to a Skype Meeting Broadcast

Add a custom URL for troubleshooting and support to a Skype Meeting Broadcast

I get a certificate error when joining a Skype Meeting Broadcast

Make calls with Skype for Business

Make and receive calls

Make and receive calls using Skype for Business

Use your desk phone to make a Skype for Business call

Make and receive a video call using Skype for Business

Transfer a Skype for Business call

Video: Make a call in Skype for Business

You were added as an agent for a response group

Intermediate

Manage calls

Set Call Forwarding options in Skype for Business

Call forwarding and simultaneously ring

Check Skype for Business voicemail and options

Set up TTY (text telephone)

Manage calls as a delegate for a Skype for Business user

Chat in Skype for Business

Conversations

Send an IM in Skype for Business

Find a previous Skype for Business conversation

Use stories in Skype for Business

Set IM options in Skype for Business

Presence

Change your presence status in Skype for Business

Control access to your presence information in Skype for Business

Video: Presence and IM in Skype for Business

Use offline messaging in Skype for Business

Contacts in Skype for Business

Add a contact in Skype for Business

Search for people in Skype for Business

Find info from a contact card in Skype for Business

Set Contacts List options in Skype for Business

Tell me when someone’s status changes

Set Alerts options in Skype for Business

Video: Add a contact in Skype for Business

Expert

Settings

Skype for Business, Skype for Business Basic, Skype for Business for Mac, Skype for Business Online.

Set Personal options in Skype for Business

Set General options in Skype for Business

Change my phone number for Skype for Business

Edit phone number

Announce your name when you join a Skype for Business meeting or call

Set Ringtones and Sounds options in Skype for Business

Customise your location info in Skype for Business

Set options for online meetings and conference calls

Reset your PIN (Personal Identification Number)

Learn more about work hours in Outlook

Change your work hours and days in Outlook

Set Audio Device options in Skype for Business

Set Video Device options in Skype for Business

Set Advanced Connection options in Skype for Business

Set Advanced Phone Integration options

Give feedback about Skype for Business

Troubleshoot problems with Skype for Business

Troubleshoot audio and video in Skype for Business

Troubleshoot connection issues in Skype for Business

Turn on error logs in Skype for Business

Uninstall Skype for Business

An apple with some pears. Image by Tracy Lundgren from Pixabay .

Using the ODD Function

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will tell you how to use the ODD function in Microsoft Excel. It will include a summary of this function, its formula syntaxContinue reading “Using the ODD Function”

beautiful calm clouds dark

The EVEN Function Explained

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.  This post outlines how the EVEN function works, including a summary of this function, important conditions to keep in mind when using it asContinue reading “The EVEN Function Explained”