Microsoft Office Tutorials: January 2021

Sunday, January 31, 2021

View your tasks

Tasks are displayed in three locations in Outlook — in the To-Do Bar, in Tasks, and in the Daily Task List in Calendar. If you subscribe to a SharePoint task list, any task assigned to you from this list also appears in all three locations.

Newer versions Office 2010 Office 2007



On the navigation bar, click Tasks.
Click a task to view it in the Reading Pane, or double-click it to open it in a new window.

Another way to see tasks, including flagged to-do items, is the Tasks peek.
- Point to Tasks on the Navigation Bar.
The Tasks peek pops up. To keep the Tasks peek in view, pin it by clicking .

Tip: Sort your task list by clicking Tasks > Home and choosing one of many Current View options available. Click Tasks, and choose an option in Current View.

To view your tasks, do any of the following:

In the Navigation Pane Click Tasks. Click a task to view it in the Reading Pane, or double-click it to open it in a new window.

Tip: You can change the task list appearance by clicking a style in the Current View group on the Home tab.
In the To-Do Bar The Tasks List is at the bottom of the To-Do Bar, below Appointments. You can get more information about your tasks by expanding the To-Do Bar, or double-click a task to open it in a new window.

Tip: To show more or fewer tasks, click the top border of the Tasks List when your pointer becomes a , and then drag up or down.
In the Daily Task List The Daily Task List appears only in the Day and Week views in your Outlook Calendar. To display only the count of current tasks, in Calendar, on the View tab, in the Layout group, click Daily Task List and then click Minimized.

View your tasks in the To-Do Bar

The To-Do Bar appears in all Outlook views by default. You can turn the To-Do Bar on or off. In addition, you can choose a minimized version of the To-Do Bar that uses less screen space.

To-Do Bar

When you turn the To-Do Bar on or off, or view it minimized in a specific view, the setting applies only to that view. For example, if you turn off the To-Do Bar in Mail, it remains off whenever you are in Mail, including the next time that you restart the program. However, it remains on in other views such as Calendar, Notes, and Tasks.

Click View, point to To-Do Bar, and then click Normal, Minimized, or Off.

View your tasks in Tasks

In the Navigation Pane, click Tasks.

Tip: You can change how the task list is presented by changing the Current View setting in the Navigation Pane.

View your tasks in the Daily Task List in Calendar

The Daily Task List appears only in the Day and Week views in your Outlook Calendar. To toggle the Daily Task List on or off, in Calendar, click View, point to Daily Task List, and then click Normal or Off.

To display only the number of current tasks, in Calendar, click View, point to Daily Task List, and then click Minimized — or, alternately, click the top edge of the Daily Task List when your pointer becomes a Size handle icon , and then drag up or down.

Daily Task List

Tip: To create new tasks in the Daily Task List, you must use the Normal Daily Task List setting.

Crowdsource new product ideas

Coming up with the next big product idea can be challenging if you're only asking for opinions from your internal talent. You need to expand your network to include feedback from customers, supply chain partners, and employees company-wide.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Details

Discover new product ideas from your employees, suppliers, and customers. Find relevant existing content that your colleagues have shared using Intelligent Search & Discovery and find out what design concepts others are considering. Create a channel in Microsoft Teams to bring people across your global workforce together to brainstorm. Share new product developments and encourage people to weigh in.

Set up an external Yammer group so your suppliers and customers can give feedback on your product and add comments or concerns. Conduct polls to get new insights your team hasn't thought of and get more engagement from your customers.

Highlights

Discover what other design concepts colleagues are working on.
Work together to review new products.
Engage your suppliers and customers to gain new insights.

Learn More

Create and manage external groups in Yammer

Connect the boardroom to the shop floor

Employees can feel disconnected from executive commitments, company goals and changing business direction. At the same time, executives often miss valuable feedback, real-time customer insights, and opportunities for improvement.

Details

Provide employees with the ability to tell executives what their top-of-mind issues are with an internal social network. Using Yammer, executives can assess, respond and connect to provide real-time answers to employee challenges and ideas. You can get the pulse of how employees feel about key policy changes and corporate initiatives with the ability to ingest and provide feedback across the corporation from anywhere, at any time. Using Microsoft 365, executives can deliver key messages via virtual town halls, share business goals, promote dialogue and let employees know they are being heard.

Highlights

Keep employees informed about strategy and company goals.
Promote cross-organizational discussions and feedback.
Help executives stay informed and employees engaged.

Learn More

Employee engagement and communications in the modern workplace

Lof function

Note: The function, method, object, or property described in this topic is disabled if the Microsoft Jet Expression Service is running in sandbox mode, which prevents the evaluation of potentially unsafe expressions. For more information on sandbox mode, search for "sandbox mode" in Help.

Returns a Long representing the size, in bytes, of a file opened using the Open statement.

Syntax

LOF( filenumber )

The required filenumberargument is an Integer containing a valid file number.

Note: Use the FileLen function to obtain the length of a file that is not open.

Example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the LOF function to determine the size of an open file. This example assumes that TESTFILE is a text file containing sample data.

        Dim FileLength
Open "TESTFILE" For Input As #1    ' Open file.
FileLength = LOF(1)    ' Get length of file.
Close #1    ' Close file.

Manage your team scrum

When you're in development, it's important for your team to respond to bugs quickly. You need a way to apply scrum practices to communicate and react to updates and blockers as efficiently as possible.

Details

Solve issues in real time with Microsoft Teams. Store important documents in the Files tab to keep everything in one central location to refer to at any time. Use chat, @mentions, and audio or video calling to ask questions and quickly get answers to issues.

Add in third-party tools like Jira or GitHub to Teams to identify bugs for visibility. You can also add Planner in a tab to create, update, and assign tasks, like coding activities, to your scrum team.

Finally, add a OneNote connector to scribe meeting notes and action items. You can easily revisit the notes for tracking and resolution.

Highlights

Resolve issues and blockers in real time.
Surface and respond to bugs faster.
Assign tasks and commitments, and easily follow up.

Learn More

Apps and services

Fix search issues by rebuildling your instant search catalog

If you search for items in Outlook and don't receive the results that you expect, the indexing of your Microsoft Windows and Microsoft Office system data files (the search catalog) may not be complete.

Symptoms of an incomplete index include the following:

Partial or no search results are returned.
Items that you expect to appear based on your search criteria aren't displayed.

You can rebuild the search catalog, which restarts the indexing of your data files. The search catalog is a file where all of your Outlook and Microsoft Windows items (data files) are indexed.

What is indexing?

In simple terms, it's a catalog that's built from terms found in email messages. The catalog is similar to an index for a reference book, but instead of manually searching for the term in the book's index, you're search for it electronically by entering the term in a Outlook search box. You simply need to make sure you've set the indexing options to begin.

If you're using Outlook 2007, the body of digitally signed and encrypted email message are never indexed. This is not the case, however, for Outlook 2016, Outlook 2013, and Outlook 2010. The body of digitally signed email messages in those Outlook versions are indexed if they're signed and encrypted.

What data is indexed in Outlook?

The index is made up of folders that you choose. Those choices become the search scope. This is a two-step process. You set the Outlook indexing options, and then you check the search scope.

Set Outlook search options

Identifies locations to be indexed, and locations to be excluded from indexing.

On the File tab, choose Options > Search.
Under Sources, click Indexing Options.

Note: In the Indexing Options dialog box, under Index these locations, make sure Microsoft Outlook is an included location. You can click Modify if necessary to change selected locations.

Check the Outlook search scope

In Outlook, use the Search box or choose a mailbox list or a folder to find the Scope group.

Click the Current Mailbox list to check the Scope group.

All Mailboxes
Current Mailbox
Current Folder
All Subfolders
All Outlook Items

In the Search box, on the Search tab, check the Scope group.

All Mail items
Current Folder
All Subfolders
All Outlook Items

Check the All Mail Items list, and then add or remove data files.

Rebuild your search catalog

Close Outlook and open Control Panel.

Note: Depending on the version of Office you're using, you might need to click the Start button, and on the Start menu, right-click Control Panel.
Do one of the following:
- Choose Indexing Options.
- In the Search box, type Indexing, and then choose Indexing Options.
In the Indexed Locations dialog box, under Change selected locations, select the check box for the location you want to modify, and then click OK.
In the Advanced Options dialog box, on the Index Settings tab, under Troubleshooting, click Rebuild.

Note: A Rebuild Index dialog box opens warning that the "index might take a long time to complete." Choose OK to start rebuilding the index.

Saturday, January 30, 2021

Change your password in outlook com

Your Outlook.com password is the same as your Microsoft account password.

Go to Microsoft account security and select Password security.
As a security measure, you might be prompted to verify your identity with a security code. Decide if you want to receive the security code by email or phone. You'll be asked to verify your email address or the last four digits of your phone number, and then select Send code. When you receive the code, enter it and select Submit.

Tip: If your can't get the code by email or phone, you might be able to enter an email address that's different from the one you're trying to recover. Go to the Recover your account page and follow the prompts.
Enter your current password, enter your new password, and then select Save.

I forgot my password

Go to the Recover your account page and follow the prompts.

My Outlook.com account's been hacked

If you think your Outlook.com has been hacked, see My Outlook.com account has been hacked.

My Outlook.com account's been blocked

If your Outlook.com account has been blocked, see Unblock my Outlook.com account.

Applies to

Form Object

Sets or returns the value of the On Current box in the Properties window of a form. Read/write String.

expression.OnCurrent

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

This property is helpful for programmatically changing the action Microsoft Office Access 2007 takes when an event is triggered. For example, between event calls you may want to change an expression's parameters, or switch from an event procedure to an expression or macro, depending on the circumstances under which the event was triggered.

The Current event occurs when the focus moves to a record, making it the current record, or when the form is refreshed or requeried.

The OnCurrent value will be one of the following, depending on the selection chosen in the Choose Builder window (accessed by clicking the Build button next to the On Current box in the form or report's Properties window):

If Expression Builder is chosen, the value will be "=expression", where expression is the expression from the Expression Builder window.
If Macro Builder is chosen, the value is the name of the macro.
If Code Builder is chosen, the value will be "[Event Procedure]".

If the On Current box is blank, the property value is an empty string.

Example

The following example associates the Current event with the macro "Current_Macro" for the "Order Entry" form.

Forms("Order Entry").OnDeactivate = "Current_Macro"

Create a presentation in powerpoint for the web

With PowerPoint for the web running in your web browser, you can:

Create presentations that include images, videos, transitions, and animations.
Get to your presentations from your computer, tablet, or phone.
Share and work with others, wherever they are.

Notes:

If you're using the desktop version of PowerPoint on a Windows PC, see the PowerPoint Quick Start.
If you're using the desktop version of PowerPoint on a Mac, see Office for Mac Quick Start Guides and PowerPoint for Mac Help.

Create, open, and name a presentation

Go to powerpoint.office.com.

Or sign in to office.com/signin, select the Microsoft 365 App Launcher , and then select PowerPoint.
Select New blank presentation, open a Recent file, or select one of the themes.
To name the presentation, select the title at the top and type a name.

If you need to rename the presentation, select the title and retype the name.

Name file

Add a slide

Select the slide you want your new slide to follow.
Select Home > New Slide.
Select Layout and the you type want from the drop-down.

Save

When working in PowerPoint for the web, your work is saved every few seconds. You can select File > Save a Copy to create a duplicate copy in another location.
Or choose File > Download As to save a copy to your device.

Offline

When you're online, AutoSave is always on and saves your changes as you work. If at any time you lose your Internet connection or turn it off, any pending changes will sync as soon as you're back online.

Add a border to a table

When you add a border to a picture, text, or page, you can make those elements in your document stand out. You can do the same with the tables in your documents.

Note: This article describes procedures for Office for Mac applications. For Windows procedures, see Add, change, or delete borders from documents or pictures

Newer versions Office 2011



Depending on the program you're using, you can add a border to a table by using the Border Styles gallery, you can apply a pre-designed table style, or you can design your own custom border.

Word

Use the Border Styles gallery to add a border

The quickest way to add borders in Word is from the Border Styles gallery.

Click in the table, and then click the Table Move Handle to select the table.

The Table Tools Design tab appears. (In Office for Mac, the Table Design and Layout tabs appear. Click the Table Design tab.)
Click Border Styles and choose a border style.
Click Borders and choose where you want to add the borders.

Tip: To change or add borders for part of your table, check that Border Painter is selected and then, in the table, click each border that you want to change or add. Word applies the border style you've already chosen, and you don't need to select the table first.

Use a table style to add a border

Applying a pre-designed table style is another quick way to make your table stand out. Table styles add coordinating borders, shading, and text formatting.

Click inside a table, and then click the Table Tools Design tab (the Table Design tab in Office for Mac).
In the Table Styles gallery, click a table style. To see more gallery styles, click the More arrow. (This arrow appears below the gallery in Office for Mac.)

Add a custom border

To design your own custom border, choose the color, width, line style, and where you want to apply the borders.

In Word or Outlook, click in the table, and then click the Table Move Handle to select the table.

In PowerPoint, click anywhere on the outside border of the table to select it. (The Table Move Handle does not appear in PowerPoint.)
Click the Table Tools Design tab (the Table Design tab in Office for Mac).
Design your border.

Click Line Style (Pen Style in PowerPoint) and choose a style.

Click Line Weight (Pen Weight in PowerPoint) and choose the border width you want.

Click Pen Color and choose a color.
Click Borders and choose the borders you want.

Tip: To change or add borders for part of your table, check that Border Painter is selected and then click each border in the table. Word adds a border in the style, width, and color you've already chosen, and you don't need to select the table first.

PowerPoint

Use a table style to add a border

Applying a pre-designed table style is a quick way to make your table stand out. Table styles add coordinating borders, shading, and text formatting.

Click inside a table, and then click the Table Tools Design tab (the Table Design tab in Office for Mac).
In the Table Styles gallery, click a table style. To see more gallery styles, click the More arrow. (This arrow appears below the gallery in Office for Mac.)

Add a custom border

To design your own custom border, choose the color, width, line style, and where you want to apply the borders.

In Word or Outlook, click in the table, and then click the Table Move Handle to select the table.

In PowerPoint, click anywhere on the outside border of the table to select it. (The Table Move Handle does not appear in PowerPoint.)
Click the Table Tools Design tab (the Table Design tab in Office for Mac).
Design your border.

Click Line Style (Pen Style in PowerPoint) and choose a style.

Click Line Weight (Pen Weight in PowerPoint) and choose the border width you want.

Click Pen Color and choose a color.
Click Borders and choose the borders you want.

Tip: To change or add borders for part of your table, check that Border Painter is selected and then click each border in the table. Word adds a border in the style, width, and color you've already chosen, and you don't need to select the table first.

You can add custom borders in Word or PowerPoint.

Word

Add borders to a whole table or to selected table cells

Click the table or select the cells to which you want to add borders.
On the Tables tab, under Draw Borders, click Borders, and then click the borders that you want.

Add or change the line style

Click the table or select the cells where you want to add or change borders.
On the Tables tab, under Draw Borders, on the Line Style pop-up menu, click the line style that you want.
On the Tables tab, under Draw Borders, click Borders, and then click the borders that you want.

Add or change the line width

Click the table or select the cells where you want to add or change borders.
On the Tables tab, under Draw Borders, on the Line Weight pop-up menu, click the line weight that you want.
On the Tables tab, under Draw Borders, click Borders, and then click the borders that you want.

Remove a border

Click the table or select the cells in which you want to remove borders.
On the Tables tab, under Draw Borders, click Borders, and then click None.

PowerPoint

Add borders to a whole table or to selected table cells

Click the table or select the cells to which you want to add borders.
On the Tables tab, under Draw Borders, click the arrow next to Borders , and then click the borders that you want.

Add or change the line style

Click the table or select the cells where you want to add or change borders.
On the Tables tab, under Draw Borders, on the Line Style pop-up menu, click the line style that you want.
On the Tables tab, under Draw Borders, click the arrow next to Borders , and then click the borders that you want.

Add or change the line width

Click the table or select the cells where you want to add or change borders.
On the Tables tab, under Draw Borders, on the Line Weight pop-up menu, click the line weight that you want.
On the Tables tab, under Draw Borders, click the arrow next to Borders , and then click the borders that you want.

Add or change the line color

Click the table or select the cells where you want to add or change borders.
On the Tables tab, under Draw Borders, click the arrow next to Line Color , and then click the line color that you want.
On the Tables tab, under Draw Borders, click the arrow next to Borders , and then click the borders that you want.

Remove a border

Click the table or select the cells in which you want to remove borders.
On the Tables tab, under Draw Borders, click the arrow next to Borders , and then click No Border .

Sunday, January 31, 2021

View your tasks in the To-Do Bar

View your tasks in Tasks

Details

Highlights

Learn More

Details

Highlights

Learn More

Example

Details

Highlights

Learn More

Saturday, January 30, 2021

I forgot my password

My Outlook.com account's been hacked

My Outlook.com account's been blocked

See Also

Applies to

Remarks

Example

Word

PowerPoint

Word

PowerPoint

See also