Looking for:
Microsoft outlook 2013 tasks tutorial free. 18 Best Resources to Learn MS Outlook
If you want to import data using a native database query, specify your query in the SQL Statement box. Windows This is the default selection. Select this if you want to connect using Windows authentication. After you select this, specify a user name and password to connect to your SQL Server instance. By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection.
If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted connection.
Click OK in the message to connect using an unencrypted connection. For more information about advanced connector options, see SQL Server database. In the Import Data dialog box, browse for and locate the Access database file. Select the file, and then select Open. The Navigator dialog box appears. If you have many tables and queries, use the Search box to locate an object or use the Display Options along with the Refresh button to filter the list.
For more information about advanced connector options, see Access database. Note When you use a workbook connected to a SQL Server Analysis Services database, you may need additional information to answer specific product questions, such as reference information about multidimensional expressions MDX , or configuration procedures for an online analytical processing OLAP server.
The first page of the Data Connection Wizard appears. Its title is Connect to Database Server. Tip: If you know the name of the offline cube file that you want to connect to, you can type the complete file path, file name, and extension.
Under Log on credentials , do one of the following, then click Next :. To use your current Windows user name and password, click Use Windows Authentication. To enter a database user name and password, click Use the following User Name and Password , and then type your user name and password in the corresponding User Name and Password boxes.
Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements. For example, Y6dh! Passwords should contain 8 or more characters. A pass phrase that uses 14 or more characters is better. It is critical that you remember your password. If you forget your password, Microsoft cannot retrieve it.
Store the passwords that you write down in a secure place away from the information that they help protect. Select Next to go to the second wizard screen. Its title is Select Database and Table. To connect to a specific cube file in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. In the Select the database that contains the data you want box, select a database, and then click Next. Click Next to go to the third wizard screen.
Click Browse to change the default file location of My Data Sources , or check for existing file names. In the Description , Friendly Name , and Search Keywords boxes, type a description of the file, a friendly name, and common search words all are optional.
To ensure that the connection file is used when the PivotTable is refreshed, click Always attempt to use this file to refresh this data. Selecting this check box ensures that updates to the connection file will always be used by all workbooks that use that connection file.
You can specify how a PivotTable is accessed if the workbook is saved to Excel Services and is opened by using Excel Services. If you want to ensure that the same data is accessed whether you open the workbook in Excel or Excel Services, make sure that the authentication setting in Excel is the same.
Select Authentication Settings , and select one of the following options to log on to the data source:.
Windows Authentication Select this option to use the Windows username and password of the current user. This is the most secure method, but it can affect performance when there are many users. A site administrator can configure a SharePoint site to use a Single Sign On database where a username and password can be stored. This method can be the most efficient when there are many users. None Select this option to save the username and password in the connection file.
Important: Avoid saving logon information when connecting to data sources. This information may be stored as plain text, and a malicious user could access the information to compromise the security of the data source. Select Finish to close the Data Connection Wizard. Decide how you want to import the data, and then select OK. For more information about using this dialog box, select the question mark? You can connect to a specific offline cube file if it has been created on the database server.
You can also import data into Excel as either a Table or a PivotTable report. In the Navigator pane select the database, and then select the cube or tables you want to connect.
Click Load to load the selected table into a worksheet, or click Edit to perform additional data filters and transformations in the Power Query Editor before loading it. Note: Before you can connect to an Oracle database using Power Query , you need the Oracle client software v8.
If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import data from database using Native Database Query. For more information about advanced connector options, see Oracle Database. Select the driver that matches your Power Query installation bit or bit. For more information, see Import data from a database using Native Database Query.
For more information about advanced connector options, see MySQL database. Select the driver that matches your Office version bit or bit. For more information, see Which version of Office am I using? Also make sure you have the provider registered in the machine configuration that matches the most recent. NET version on your device. For more information about advanced connector options, see PostgreSQL.
Select the driver that matches your Excel installation bit or bit. By default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection. Note: Before you can connect to a Teradata database, you need the. This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription.
If you are a Microsoft subscriber, make sure you have the latest version of Office. You will need an SAP account to login to the website and download the drivers. If you are unsure, contact the SAP administrator in your organization.
The server name should follow the format ServerName:Port. Optionally, if you want to import data using native database query, Select Advanced options and in the SQL Statement box enter the query. Azure SQL Database is a high-performing, fully managed, scalable relational database built for the cloud and used for mission-critical applications.
For more information about advanced connector options, see Azure SQL database. Azure Synapse Analytics combines big data tools and relational queries by using Apache Spark to connect to Azure data services and the Power Platform. You can load millions of rows in no time. Then, you can work with tabular data by using familiar SQL syntax for queries.
For more information, see What is Azure Synapse Analytics. For more information about advanced connector options, see Azure Synapse Analytics. Azure HDInsight is used for big data analysis when you need to process large amounts of data. It supports data warehousing and machine learning; you can think of it as a data flow engine.
Select your cluster in the Navigator dialog, and then find and select a content file. Select Load to load the selected table, or Edit to perform additional data filters and transformations before loading it. If you are connecting to the Blob storage service for the first time, you will be prompted to enter and save the storage access key. Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then select the Manage Access Key icon on the bottom of the page.
Select the copy icon to the right of the primary key, and then paste the value in the Account Key box. The Azure Storage provides storage services for a variety of data objects. For more information, see Introduction to Table storage. Azure Data Lake Storage Gen 1 combines different data warehouses into a single, stored environment.
You can use a new generation of query tools to explore and analyze data, working with petabytes of data. For more information, see Azure Data Lake Storage. Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. It can handle large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more. For more information, see What is Azure Data Explorer. In the Azure Data Explorer Kusto dialog box, enter appropriate values.
Each prompt provides helpful examples to walk you though the process. You can import Datasets from your organization with appropriate permission by selecting them from the Power BI Datasets pane, and then creating a PivotTable in a new worksheet. The Power BI Datasets pane appears.
If many Datasets are available, use the Search box. Select the arrow next to the box to display keyword filters for versions and environments to target your search. Select a Dataset and create a PivotTable in a new worksheet.
Select the 2. As an alternative to 2. For more information about advanced connector options, see SharePoint Online list. If you have many objects, use the Search box to locate an object or use he Display Options along with the Refresh button to filter the list.
Select or clear the Skip files with errors checkbox at the bottom of the dialog box. If you select the Advanced option, you can append certain additional parameters to the query to control what data is returned. If you aren’t signed in using the Microsoft Work or School account you use to access Dataverse for Apps, select Sign in and enter the account username and password.
The Salesforce Objects dialog box appears. Select either Production or Custom. If you select Custom , enter the URL of a custom instance. For more information about advanced connector options, see Salesforce Objects. Because Salesforce Reports has API limits retrieving only the first 2, rows for each report, consider using the Salesforce Objects connector to work around this limitation if needed. The Salesforce Reports dialog box appears. For more information about advanced connector options, see Salesforce Reports.
Make sure you have the latest version of the Adobe Analytics connector. Sign in with you Adobe Analytics Organizational account, and then select Connect. For more information about advanced connector options, see Adobe Analytics. Select Advanced , and then In the Access Web dialog box, enter your credentials. For more information about advanced connector options, see Web. Microsoft Query has been around a long time and is still popular. In many ways, it’s a progenitor of Power Query. For more information, see Use Microsoft Query to retrieve external data.
By default, the most general URL is selected. Select Anonymous if the SharePoint Server does not require any credentials.
Select Organizational account if the SharePoint Server requires organizational account credentials. For more information about advanced connector options, see SharePoint list. Select Marketplace key if the OData feed requires a Marketplace account key. Click Organizational account if the OData feed requires federated access credentials.
For Windows Live ID, log into your account. For more information about advanced connector options, see OData feed. HDFS connects computer nodes within clusters over which data files are distributed and you can access these data files as one seamless file stream.
Enter the name of the server in the Server box, and then select OK. In the Active Directory Domain dialog box for your domain, select Use my current credentials , or select Use alternate credentials and then enter your Username and Password. After the connection succeeds, use the Navigator pane to browse all the domains available within your Active Directory, and then drill down into Active Directory information including Users, Accounts, and Computers.
In the next dialog box, select from Default or Custom , Windows , or Database connection options, enter your credentials, and then select Connect. In the Navigator pane, select the tables or queries that you want to connect to, then select Load or Edit.
For more information about advanced connector options, see ODBC data source. In the Navigator dialog box, select the database, and tables or queries you want to connect to, and then select Load or Edit. Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, Note: If this is the first time you’ve connected to Facebook, you will be asked to provide credentials.
Sign in using your Facebook account, and allow access to the Power Query application. You can turn off future prompts by clicking the Don’t warn me again for this connector option. Note: Your Facebook username is different from your login email. Select a category to connect to from the Connection drop-down list. For example, select Friends to give you access to all information available in your Facebook Friends category.
If necessary, click Sign in from the Access Facebook dialog, then enter your Facebook email or phone number, and password. You can check the option to remain logged in. Once signed in, click Connect. After the connection succeeds, you will be able to preview a table containing information about the selected category. For instance, if you select the Friends category, Power Query renders a table containing your Facebook friends by name. You can create a blank query. Get a closer look at a shared screen at any time, so you never miss a detail.
From marathon video calls to wedding bells, this couple relied on Skype to stay connected while living thousands of miles apart. As citizens of the world were faced with the question of how to navigate these challenging times, they looked to technology to find inventive ways to stay connected.
Read on to see our plans for an improved, faster, reliable, and super modern-looking Skype. We’ve been listening closely to your feedback, and many of the changes come directly from your suggestions. Check out some of the highlights we will bring to you over the next few months.
Break the ice on your next Skype call by showing off your favorite Super Hero. Our brand-new digital environments take virtual get-togethers to a whole new level, so you can travel the world without ever leaving home. Video calls just got a whole lot more fun with our new Name Your Call feature. Our fun new features help you stay connected on a massive scale. Large Grid means you can keep an eye on 49 participants at a time — plus, Skype audio and video calls now support up to users.
International Women’s Day is a reminder to celebrate women’s achievements and strive for change. With Skype’s Meet Now, you can connect with the women that inspire you with just one click.
Meet some of our female colleagues in Skype who inspire us. Whenever you find yourself doing the same thing repeatedly, try creating a Quick Step. And as projects change, update your Quick Steps so that they are only the things you really do. Once you set up your system, you are ready to begin managing incoming messages.
By making your Inbox the central place for receiving important messages, you can go through it with the confidence that each item is something you need to deal with. If you need to do it, but it takes longer than two minutes including reading , defer hold off on it. If you need it as reference even if you have decided to defer it , move it into your reference folder. The goal is to reduce the number of times you touch each message. If you never want to receive another message as part of this conversation, ignore it.
For example, many messages can be responded to in two minutes or less. But if a message takes longer than two minutes to deal with, defer it. To get a sense of what two minutes feels like, try timing yourself. File it in one of your reference folders for example, 1-Reference using a Quick Step. To keep a record of the things that you have done, especially for the purposes of reflection around the time of annual reviews or for preparing reports, use the Done Quick Step, which also marks messages as completed.
Sometimes you receive a message that is really meant for someone else to deal with. In these cases, reply and include the person you’re delegating the message to on the To line. If you find you’re doing this often, consider creating a Quick Step that replies and adds the delegated person to the To line.
If you want to follow up later, flag it for yourself before sending. In your To-Do Bar, mark the task with the Waiting category. If you will need to refer to the message more than once and you want easy access to it, drag it to the Later group in the To-Do Bar. If you find that you are repeatedly applying the same categories and flags, create a new Quick Step that flags, categorizes, and files.
Once an item has been flagged, it will appear in the To-Do Bar. By flagging it and filing it into your reference folder, you have processed it, and now you can move it out of your view. Change the name of the task by selecting it in the To-Do Bar or right clicking on it and selecting Rename Task.
You can also add a category to help you see at a glance where your next action is. A quick glance at your To-Do Bar with categorized tasks lets you know what is immediately actionable Office , which tasks you are waiting on other people for Waiting , and what you will be meeting about Meeting. After you process your messages, you can tackle your task list. This is when you respond to those messages that you have deferred.
A good example is a message with instructions. File these messages in your reference folder 1-Reference by selecting your Reference Quick Step. Adding a category will make the message easier to find later if you need it for example, Project. Do this before filing with your Quick Step. After you finish processing your messages, you should have a clean Inbox and can switch your focus to your calendar and tasks. This includes:.
As you review your calendar and your task list, be realistic about what you can accomplish. Sometimes that means saying no. Here are some ways to gain back time by saying no:. Send messages to let people know that you are working on a response and make sure to flag it for yourself on send.
The reality is that if you have a day filled with meetings, you have less time to complete tasks and write messages, so move tasks to other days.
As you go through your calendar and tasks, inevitably you will start thinking of more things you need to do. Here are some ways to create tasks in Outlook:. If you are in a meeting, take notes in OneNote.
Flagged items in OneNote appear in the Outlook task list. Add tasks as they come to you by typing in the Type a new task box in the To-Do Bar or in the top of Task list, in a blank space in the Daily Task List, or by selecting New Task in the ribbon.
Clean out tasks that you don’t need to do. For flagged messages that you want to keep, select Remove from List , otherwise, just Delete. Make tasks more actionable by changing the task subject of a flagged message. To change the task subject, select the item in the To-Do Bar and type a new subject or right click, and then select Rename Task. Only the subject you see in your task list changes.
Create and assign color categories to help you identify where you need to be to take the next step and to make some tasks stand out. Rearrange your tasks to group together similar tasks, such as tasks with the same category. To move a task, select the task in the task list and drag it. In this way, you can work on similar tasks together. For tasks that will take some time, drag the tasks onto the calendar to set aside time to get these tasks done.
The process of managing your task list shouldn’t take over your life! As part of good time management, you need time to deal with your messages, manage your appointments and tasks, and reflect on what you have to do.
You can schedule this time for yourself with regular appointments and meetings on your calendar. Your calendar should be treated as your real plan for your time — if you have scheduled it, then that is what you are committed to doing at that time.
Deal with your messages. Setting aside time to deal with messages is especially important if you receive a lot of messages. Even if you have rules set up so that only the important messages appear in your Inbox, you still need time to deal with those messages. Tip: When processing and reading your messages, remove visual clutter by minimizing the Navigation Pane and To-Do Bar by selecting the Reading button in the status bar.
To go back to everything open, select Normal just to the left of Reading. Do a daily and weekly review of your tasks and appointments. Look at your calendar and tasks, and evaluate your appointments and tasks against your priorities. If you have a busy calendar, this is the time for:.
Reflecting on what you’re doing, whether it’s a valuable use of your time, and whether you’re setting the right priorities. Meet regularly with your manager. Regular meetings with your manager can help you explain what you are working on and reset priorities where needed. To set up a regular or recurring meeting, select Recurrence.
Looking at the whole picture of your time and your tasks will help you to prioritize important work over less urgent tasks. Reviewing your past week and upcoming week is also a useful way to help you prepare for a weekly meeting with your manager or help you prepare a status email message. After you have processed your messages, the best place to do work in Outlook reply to messages and so on is in Tasks.
As you go through your task list and your calendar, do similar tasks together. For example, if you have only a few minutes, make all of your phone calls if you have just a few. Tackle energy-intensive tasks for some, that might be responding to messages when you have more energy.
Deal with your low-energy tasks, such as reading status messages, later in the day or whenever your energy is lower. By “bulk processing” your tasks, you will make progress on all of your projects simultaneously.
To do this, select the Arranged By heading, and then select Categories. Note: If you have tasks that are blocking other people from getting their work done, do those tasks first.
As you finish your tasks, mark them complete. Outlook keeps the list of your completed tasks automatically. This can be a useful summary of what you’ve accomplished. If you don’t need to keep a record of the task or the message, delete it or clear the flag.
If you have a lot of work to do, consider going offline to stem the tide of incoming message distractions. When you switch between working online and offline, all email accounts within your Outlook profile are changed. If you want to find a message from a particular person, select the Search box in any folder, and then on the Search tab, select From.
Or, start by typing the name in the Search box, and then press the down arrow key to select From to narrow the results. To find a message with an attachment, select the Search box and on the Search tab, select Has Attachments. All search terms are additive, so if you want to find a message from someone with attachments, select the commands on the ribbon From , Has Attachments to build your search.
In these cases, start by searching in any folder Inbox , 1-Reference , etc. If you suspect that what you are looking for might be in an accepted meeting request and therefore is on your calendar , try selecting All Outlook Items.
If you find that you are often performing searches across your whole mailbox, you can set the default search scope to always search across all folders by going to the Backstage view.
Once you have found the item that you are looking for and are ready to move on to your next task, select the close icon next to the Instant Search box or on the Search tab, in the Close group, select Close Search. Make your subject descriptive and action-oriented. Bold people’s names when asking questions. Use a signature when appropriate, but keep your signature simple, short, professional, and if possible, free of graphics. If you are on an email conversation that has more than ten messages without a resolution, consider setting up a meeting to discuss the issue.
With the message selected, on the Home tab, in the Respond group, select Meeting. Acknowledge messages that require a more extensive response. If you are too busy to respond with a full answer right away, let the sender know that you are looking into the issue and will respond by a certain time or date. Flag it for yourself to do later. Use High Importance sparingly.
If you are asking a question and there are several people who could respond, choose just one person rather than sending your question to a group.
When you take these three steps, you know that your next action is to send another message or watch for a response.
Tip: Reminding yourself to send another message is often more effective than flagging the message for your recipient. Similarly, when you promise to do something in a message, flag it for yourself so that you have a task in your To-Do Bar to remind you. Don’t send a message when you are angry. Better to write it, save it to your drafts folder, and come back to it later.
Don’t send a follow-up message less than a day after the first message. If you don’t hear back in a timely manner, try using the phone or a messaging app such as Microsoft Teams. Don’t use read receipts or delivery receipts on every message you send.
Use them only if you are unsure whether your recipients will receive the message. Don’t attach flags or high importance to every message you send. Your recipients will learn to ignore them. Don’t send attachments — send links instead. This rule applies especially to meeting requests, where attachments can contribute significantly to server quotas.
Don’t expand distribution lists. Expanding distribution lists makes messages harder to read and causes them to go into the wrong mail folders for people using rules. Don’t write something you wouldn’t want everyone in your company to read. You never know where your message might end up. If you need more information or are investigating the issue separately, respond to the whole Contact Group to let everyone know that you are responding and then reply to the individual separately.
Make sure to respond to the Contact Group after the issue is resolved with the resolution. In this way, the resolution can be referenced by other people on the Contact Group.
If someone sends a message to a Contact Group that you are a member of and the message would be better answered by someone else or another Contact Group, do the following:.
Rather, leave the Contact Group on the To or Cc line. If you are transitioning to a new role and find that you are redirecting people regularly, set up a Quick Step. Adding inline comments to a message that you receive is a convenient way to answer questions and respond directly to issues. In your message, mention that you are commenting inline.
For example, include “See additional comments below. If you only want to comment on a small part of a longer message, copy that section of your message into your response, using a different color and prefixing the quote with quotes, and then type your response. Use the Bcc feature to remove extra people from an email conversation when you deem that they no longer need the extra email or if the conversation topic has changed. For example, if you are one of five people who receive a question and you want to answer it, move the other four people to the Bcc line and write something such as ” Bcc’ing Joe, Jeff, James, and Jennifer.
Here’s the answer… ” Future messages will then be between only you and the original sender. The Bcc recipient might not realize that he or she has received a Bcc and might respond to everyone, exposing that he or she received a Bcc message. This might come across as sneaky behavior on your part. Rather than using Bcc to inform a third party of an issue, forward the message after you send it. Only invite people who need to be involved. Each additional person you invite to a meeting adds to the complexity of the meeting, making it harder to control.
On the other hand, if a decision needs to be made, make sure all of the key stakeholders are present, or the meeting will be a waste of time and resources.
Use the Scheduling Assistant to view all meeting attendees availability. A pair of lines and a highlight show the proposed start and end of the meeting.
Basic tasks in Outlook
Outlook ; Outlook ; Outlook ; Power Automate. Introduction to Power Automate; PowerPoint. For this free Microsoft Project tutorial, Lesson 1 – Entering Tasks in Project. OK, let’s get started. In this first video, we introduce MS Project and launch our practice exercise – a sample wedding project. Important: Before you can use Power Query in Excel , you must activate it: click File > Options > Add-Ins. In the Manage section at the bottom, choose the COM Add-ins option from the drop-down list, then click Go. Click the Power Query check box, then OK. The Power Query ribbon should appear automatically, but if it doesn’t, close and. All classifieds – Veux-Veux-Pas, free classified ads Website. Come and visit our site, already thousands of classified ads await you What are you waiting for? It’s easy to use, no lengthy sign-ups, and % free! If you have many products or ads, create your own online store (e-commerce shop) and conveniently group all your classified ads in your shop! Webmasters, .
Microsoft outlook 2013 tasks tutorial free
Click the topic links for free lessons! Contact Us: sales@replace.me Microsoft®. Outlook Quick Reference. Basic Skills. The Outlook Program Screen. Another Computer Mama Guide – Free Course. The Complete Guide to Microsoft Outlook Another Computer Mama Guide. Free tutorial. In Outlook, you can combine your various lists into one list, enhanced with reminders and tracking. Create a task. Select New Items > Task or press Ctrl+Shift+K.
Microsoft outlook 2013 tasks tutorial free.Outlook training
Finally, changing your view can help slice through a large body of tasks. Yes No. Create tasks and to-do items. Choose a single task in one of your folders— To-Do List or Tasks list—or choose a folder. Browse All Buying Guides.