How to use Microsoft Excel Online in Outlook

Nowadays, internet users have the possibility and advantage to use plenty of online services, covering almost any function and product of interest for people across the world. For example, if we need a calendar, a calculator, and a chatting platform and of course; email services, these are all available online and can be used without the need of downloading any other resources or related software into the device.

That is why; a company as Microsoft with great relevance in technological and software business is moving to this new paradigm of use, by redesigning all of its service platforms to have an available and functional online version for all the users. So, Outlook Mail, Skype, OneDrive, Tasks, Photos Sway and software included in the Office suite as Word, PowerPoint, OneNote and others are there to be used by anyone.

In order to take advantage of these service platform offered by Microsoft, we just need to create an Outlook or Microsoft account, functioning in first instance as an email product that opens the door for a more useful and powerful conjoined set of instruments and software online to enjoy. In relation to this, in this tutorial we will be speaking about how to use Microsoft Excel Online in Outlook, as a very powerful version of this financial program to be used.

Opening Excel Online through Outlook

To begin with, in order to take advantage of the different functions provided by Excel Online, we need to be logged in with our Outlook account in the our preferred browser. To do so, we just have to enter the URL address https://outlook.live.com/ and provide the platform with proper email address and password, and by doing so we will be in the Outlook´s homepage.

In this page we can see our inbox and email content, however from this home screen we also have the opportunity to access the different services related and provided by Microsoft, where we will be able to open Excel Online at just one click.

First, let us find de “Application” button placed at the top left of the home screen with a 9 dot icon, exactly next to the Outlook home button. So, by clicking on this option a menu will get displayed and show all the different services and products you can use, such as Skype, OneDrive and others.

Microsoft Excel Online

Included in this list there is the Excel icon for you to find it, being placed with the other online versions of Word, PowerPoint and OneNote. Just click on it and at once another page will be opened showing you Excel as if it were the installable program on Windows.

Microsoft Excel Online

Microsoft Excel Online

Choosing templates to use on Excel Online and opening locally or cloud stored workbooks

Being in the Excel Online platform as another page or tab opened in the browser you are using, at first the service shows you some sort of home screen where you can select the templates to use, in case you require creating a workbook with specific purpose and design, as well as uploading work and projects stored locally or in cloud services.

At the left we have the recent panel where are shown all the files opened in date order. Also at the bottom of this panel we can see the options to open files from cloud services like OneDrive and DropBox. To do so, we just have to click in the cloud service where the document is saved, select it and it will get opened.

Microsoft Excel Online

Microsoft Excel Online

On the other hand, at the left of the screen we have the different templates available for using and creating workbooks with distinct functions and intentions. For example, we can use the traditional “New Blank Workbook” to use an empty template for adding customizable cells, equations and general layout. To select the template we just click on it and Excel will get opened.

Microsoft Excel Online

Although, if we scroll down a little bit we will be able to see other useful templates that can help us to track tasks, manage personal money and expenses and establish family budgets. As in the case explained earlier, we just have to click on the wanted template to open it.

Microsoft Excel Online

In this section of the home screen we can also upload workbooks that are stored locally in our computer or device and we want to still editing them on the go, thanks to possibilities provided by Excel Online. To open such file, just click in “Upload a Workbook” as a button placed at the top right.

Microsoft Excel Online

Using Excel Online: different options to edit and create workbooks

As it happens with the other Office products provided by Microsoft, Excel Online can be used by six main tabs that give the users the different options to perform, regarding on what they want to do in their workbook.

Microsoft Excel Online

First of all we have the “File” main tab from where you can see the different saving and printing options, as well as allowing the user to obtain help about using the service, sharing the workbooks and creating new ones. In the same way, at the left of the displayed menu we can see the recent documents and open OneDrive.

Microsoft Excel Online

Continuing with the “Home” main tab, in this one we have the options related to paragraphs with fonts and effects, alignment with bullets and numbering, tables; the inserting of cells and how to give them format, as well as using editing options as AutoSum.

Microsoft Excel Online

Moving to the “Insert” main tab, this one can be considered ad one of the most important for Excel, since from it we can choose options to apply mathematical operations and equations to calculate information and even creating visual graphics.

In this case, the first button corresponding to “Functions” on this tab will apply math operation to the cells selected, such as Sum, Average, Max, Account, Min, If and others depending on the purpose of the sheet in the workbook.

Microsoft Excel Online

Also, in this tab the user can insert surveys, tables, PivotTables, pictures, shapes, charts that can include graphics, bars, lines, areas, scatters, statistical, radars, funnel and more.

Microsoft Excel Online

In the fourth main tab “Data we can refresh selected and all connections, calculate workbook, sort ascending or descending, as well as apply filters and perform data validations.

Microsoft Excel Online

And last but not least, by using the main tabs “Review” and “View” we can check our workbook in terms of different functions as accessibility and adding comments, at least in the first main tab called. Regarding the second one, in this tab the user can establish parameters of reading and viewing on the document, including headings and gridlines that are useful in slideshows with projectors and video beams.

Microsoft Excel Online

Microsoft Excel Online

How to use Microsoft PowerPoint Online in Outlook

At present time, service platforms offered by different internet corporations and companies like Microsoft, Google and Apple include series of products that allow the user to take advantages of useful benefits and advantages online; from email to personal cloud storage, video and music streaming, messengers and productivity, these service platform are imperative for users nowadays.

Most of these services named before can be utilized throughout the use of a single account, functioning as the user´s credential that conjoined the products involved and provided by the company in question. In this case, through Outlook we can take advantage of different platforms given by Microsoft, such as Skype, OneDrive, Sway, as well as functioning with personal accounts to open session in Windows OS.

However, one of the most interesting and requested features provided by Microsoft through Outlook is the use of the Office productivity software, including programs like Word, Excel and PowerPoint on their online version to be enjoyed with the web browser, not requiring any additional installation to work.

Next, we will be explaining how to use Microsoft PowerPoint Online in Outlook, by standing out all of its functions to make creative and awesome presentations and with all the included options and tools, which in fact are not that different from the installable Office software and with the chance to be automatically uploaded in saved thanks to OneDrive personal cloud storage provided by Microsoft with Outlook.

Accessing PowerPoint Online on Outlook´s home page

In order to access and be able to use PowerPoint Online, as mandatory requirement you need to have an Outlook or Microsoft account. So, to enter your credentials after having your account you can visit the URL address https://outlook.live.com and type in your email address and password.

When you have entered your credentials properly, the next thing you will see is the Outlook´s home page showing to you, as the main page of the email service where you can see your inbox, folder lists, and message´s content when they are selected among other important information as settings and obviously the possibility to compose new emails to send one or several receipts.

Microsoft PowerPoint Online

Also, within the homepage of your platform you will be able to see an “Applications” button placed at the top left of the screen, allowing you Microsoft to access its different services and products at just one option away. By clicking on “Applications” you will see a list with all the platforms to be used completely online in the browser of your choice.

Microsoft PowerPoint Online

In this list, all you have to do is selecting the “PowerPoint” option by scrolling depending on the size of your screen in the device used. By clicking on it, a new browser page or tab will be opened with PowerPoint Online ready to be enjoyed.

Microsoft PowerPoint Online

Picking templates for new presentations and opening created ones

Now that you have opened PowerPoint Online with your Outlook account, you will be able to create new presentations and also upload the ones you already have in local and online cloud storage as OneDrive or DropBox. Also, you have the possibility to select the available templates for new presentations and also to use the blank option to release all of your creativity.

In this sort of Power Point Online home screen there is a general menu placed at the left, where you will be able to see your recently opened documents and .PPT files, as well as showing you the possibility to open presentations stored in your OneDrive personal cloud or DropBox.

Microsoft PowerPoint Online

Continuing, at the right of this type of home screen you will be able to see the different templates available for using, and by just clicking in them you can start creating your presentation almost instantly. In the same way, in case you have a presentation saved in the local storage of the device or computer you are using, you can do it with the “Upload a presentation” option.

Microsoft PowerPoint Online

In this case we will click in the “New Blank Presentation” option to open a completely empty template to work with, although the others result quite useful in many specific cases and purposes.

Making a new presentation from scratch with the available tools in PowerPoint Online

We have chosen the template to use in our new PowerPoint Online presentation, and now all we need to do is starting to add the things we want using the available tools. As an overview of the layout, at the right we have the viewing panel where we can see and edit the selected slide, and on the left there is the slide list from where we can select the one we need to modify.

Microsoft PowerPoint Online

Now, in order to start modifying and adding different effects and elements into the slides, we have available an option panel with eight main tabs addressing different purposes and actions to perform.

Microsoft PowerPoint Online

In first place we have the “File” tab, and by clicking on it we will have access to different options regarding saving, opening, renaming, printing and sharing of presentations and files. Also, in this menu the user can know about the software and obtain help to use it.

Microsoft PowerPoint Online

In second place we have the “Home” main tab, giving us options to redo and undo actions, paste and copy content and text, duplicate slides; modify text in terms of effects as adding italic, bold, underline and others as colors; to include paragraph options to organize content as bullets, indent and numbers; drawing and arranging shapes with quick styles and more.

Microsoft PowerPoint Online

By using the third main tab “Insert” we can get into the presentation new slides, default or customizable tables, to add pictures and shapes, using SmartArt, Office Add-ons, hyperlinks, text box, comments and local and online videos.

Microsoft PowerPoint Online

For example, to use the option “New Slide” we can insert another slide with other template that you choose.

Microsoft PowerPoint Online

To add an image to the presentation, you just have to click on the slide you are working on and then select the option “Picture”, and by doing so a window allowing you to search the file to insert will be opened. Now the image is included and can be modified and moved in the slide for best convenience.

Microsoft PowerPoint Online

 

Microsoft PowerPoint Online

When you enter an image on a slide and you click on it for further use and edition, a new main tab will be opened as “Format” in order to add effects and modifications to the image.

Microsoft PowerPoint Online

Moving on to the fourth main tab “Design”, in here we can choose to change between different layouts and templates to apply, as well as editing color, slide size and background.

Microsoft PowerPoint Online

The next main tabs corresponds to “Transitions” and “Animations” as effects we can include when slides get in and out between each other, such as how they appear or fade and if they got cut or pushed. Of course, transition and animation timing can also be controlled using these tabs.

Microsoft PowerPoint Online

Microsoft PowerPoint Online

Lastly, we have the “Review” tab to check availability for example, as well as the “View” main tab to run the presentation and see how it performs in terms of effects and included content as sound and images. From the “View” tab users can also manage options regarding zoom, viewing space, speed and more parameters.

Microsoft PowerPoint Online

Microsoft PowerPoint Online

How to use Microsoft Word Online in Outlook

Outlook is the email service par excellence offered by Microsoft, as a company specialized in software and responsible for relevant product like Windows, being the most used operating system around the world, as well as Office as productivity suite. In the same way, Microsoft has had the interest on offering products and services online, being its star the email service of Outlook, former Hotmail.

So, being the enterprise from Redmond a software company and by having seen the huge growth online products and programs are having at present time, Microsoft now offers the possibility to use most of its service online through the use of a compatible web browser like EDGE, Internet Explorer, Chrome or Mozilla Firefox, not requiring any other program or installation to use the service.

Therefore, the company with the use of a Microsoft or Outlook account provides the user with the chance to use an email platform, working at the same time as a bridge for other services online that can be used right there in the browser, such as Skype, OneDrive, Sway and MSN.

However, one of the most important and required services offered by Microsoft is the Office suite, with products like Word, Excel and PowerPoint, providing the tools to be more productive on the go. In this case, we will be addressing how to use the Word platform on the browser throughout Outlook, offering almost the same advantages and characteristics of the installable software for Windows.

Opening Word Online through the web browser and Outlook account

In order to use Microsoft Word Online and the rest of the services offered by Microsoft, you need to open session and log in with the proper account. So, to get signed in you only have to enter the next URL address: https://outlook.live.com/ and then within the loaded page you just have to enter your credentials in terms of Outlook address and password.

By doing so, you will be signed in and on your email home page for you to check emails and compose new ones. Well, now that you are in the platform you can access the other online services provided by the Redmond company, by just clicking in the “Applications” button placed at the very top left of the screen, displaying at once a service menu with all available platforms to use.

Microsoft Word Online

With such service menu displayed, the next step is to find the Word Online button to open such service, allowing use to create new documents with edition capabilities, online sharing, local storage and even revision functions, acting as the main installable Office software suite. So, click on the “Word” button to open the platform.

Microsoft Word Online

Now, a new browser tab or page will be opened showing the Word Online platform. First of all, the service will show at the left a panel including all the recent opened documents, as well as including the option to open a Word file saved in OneDrive or DropBox as cloud storage services.

Microsoft Word Online

At the left of the platform you have the option to select the new blank document to create, as well as open templates with different functions and purposes. For example, you can choose “General Notes” and “APA Style Paper” templates, among others available for you to pick.

Microsoft Word Online

Also, you can upload an already created document with regular Word software installed on Windows, Mac or Linux, in order to edit and modify it with the online Office platform throughout Outlook. To do so, click on the “Upload a Document” button at the top right of the templates panel.

Microsoft Word Online

Using available Word Online options to modify and edit documents

When we click on any of the templates available Word Online will be opened just like if it were Office on its regular installable version, showing all sorts of options to edit, review and improve the document we are creating. To start, we have six main tags in the navigation panel to modify and edit the text regarding different options of design, layout, revision and view.

Microsoft Word Online

In first place, we have the “File” main tag that allow us to create and open new documents and templates, save documents on local or online storage with OneDrive, publish to web, print and share, as well as obtaining info on the current document and get help in case of doubts.  All of these options are available by clicking on such “File” button to carry out the actions of interest for the users.

Microsoft Word Online

Microsoft Word Online

Continuing, by clicking on the “Home” main tab you will have access to different editing options to apply on the current document, such as using clipboard and copy-paste; changing fonts in terms of size, style and affects like bold, italic and underline or modify color; to include options for organization paragraph like bullets, numbering, indent and line spacing; as well as apply different general styles to differentiate text from titles and content lists.

Microsoft Word Online

All changes and options you choose will be applied automatically on the text. In case you want to redo or undo a selected tool or effect used, you just have to click on the “Undo” or “Redo” buttons at the very left of the tab panel.

Microsoft Word Online

Moving on to the “Insert” main tab, in this category you will be able to insert multimedia files like photos or videos, include custom or default tables and Office add-ons, hyperlinks, header and footers, page numbers and page breaks, as well as inserting footnotes, symbols and emoji’s.

As you can see, we insert in this example a jellyfish image that we can modify in terms of size and even visual effects, as well as modify the layout options to set the image in the way we want in accordance to text. To insert the image, click on the “Picture” option and locate the file you want to add from the local storage on the device you are using.

Microsoft Word Online

Microsoft Word Online

Moving the “Page Layout” main tab, in this one you can modify the text in relation to margins, general orientation, size and indent and spacing in paragraphs. Like this you can establish the required format for the document you are creating and its main purpose.

Microsoft Word Online

Regarding the next main tab corresponding to “Review”, in this one we can choose options to know the word count of the document, spelling and grammar corrections, checking accessibility, add comments and track general changes.

Microsoft Word Online

For example, with the word count option we can know exactly how many words the document has, as well as characters with and without spaces and number of paragraphs.

Microsoft Word Online

And last but not least, we have the “View” main tab to modify the viewing options in the case we are reading, also including editing options, navigation panel, header and footers, footnotes, page ends and the zoom to work properly depending on the monitor or display size.

Microsoft Word Online

In case you want to still editing the current document using Office as installed software in the device, just click in the “Edit in Word” option.

Microsoft Word Online

How to use OneNote or NoteBooks online with Outlook

When it comes to internet services, Microsoft definitely stands out as one of the most relevant and influential companies around the world, offering a service platform like no other that includes plenty of useful and known products, being all of them conjoined to give a comprehensive experience by the use of one account only, in order to make the use of this platform simpler.

For example, Microsoft includes in this service platform all of its relevant and important products, where most of them are free and a few others are paid, with the possibility to be used through proper and installable software, as well as online stages by using Outlook as some sort of anchor to access the other services involved, being the email platform of the company from Redmond.

Along with Outlook, other services offered by Microsoft are Skype, Windows, XBOX, OneDrive, Bing and Office; the best office suite for productivity which is compatible with plenty of devices and operating systems, also providing the advantage to be used online through web browsers with the tools included as PowerPoint, Excel, Word, Publisher and more, with different functions.

However, there is also an important function that is required by most of the users of Microsoft products and Outlook as email platform; the possibility to use notebooks, in order to write reminders and short messages with useful information. In this case, Microsoft offer the chance to use notebooks through its free software OneNote, completely online and free as we will show you.

Using notebooks through OneNote completely online

In order to use notebooks online with Outlook trough the dedicated service platform OneNote, the first thing you need to do is open session on Microsoft´s email platform, which can be accessed by the URL www.login.ive.com. In case you do not have an account, you can sign up by clicking in the “Create one” button.

Also, at present time Outlook is providing users with a beta version that improves functionality and a simpler but powerful design, which can be activated by clicking in the “Outlook beta” switch placed at the top right of the screen.

OneNote

OneNote

Now that you are logged in on Outlook and the platform shows you your home screen, in order to locate notebook functions and others you have to click on the applications icon, which is located at the top left corner of the screen, right above the navigation panel.

Like this, you will have access to different products and services offered by Microsoft that can be used online through your web browser, such as Skype, One Drive, Bing and others. In this case, we are interested in finding the way to use notebooks, and for that we will find the “One Note” icon in the application panel, being the service platform belonging to the Office suite to perform this function.

OneNote

OneNote

By doing so, a new browser window or tab will be opened with the corresponding OneNote website, logging you in automatically to start using the service, as well as showing you “My notebooks” page where all of your created notebooks and default ones will be available.

OneNote

For example, the platform will create a default notebook with your name, being at the bottom of the “My notebooks” menu, while at the top of it  two options will be shown that allow you to manage and delete created notebooks, as well as creating new ones.

OneNote

OneNote

Creating a new notebook with customizable name is easy; just click on the “+New” option and a special window will be opened for you to type the new notebook´s name. After that, just click in “Create” button and the new notebook will be there ready for use. In this case, the new notebook will be named “Fast Notes” and from there we will continue the tutorial.

OneNote

OneNote

OneNote notebooks: main operating panels, creating and naming new notes

Being in the recently created notebook, the next logical thing to do is starting using it with the wide set of possibilities offered by OneNote Online through Microsoft´s Outlook platform.

First of all, the platform gets loaded showing three main panels or spaces in the layout; at the left the notebook panel where all of your created notebooks are displayed, at the center the detailed panel where you can see and add new sections and pages into the selected notebook, as well as the writing panel placed at the right, from where you can add and modify individual notes.

OneNote

Also, from this page and permanently while you are using the service you will be able to see the option bar at the top of the screen, where you have access to different actions and tools to modify notes and all the entered information. Nevertheless, we will address this option bar in detailed in the next section of this tutorial, after explaining the use of the different panels and note creation.

OneNote

Continuing, for you to hide and show the notebook panel you can click in the “Notebook list” button, and from this panel you can access your stock and created notebooks to add and modify sections and notes. Also, from this panel at the bottom you can access the option “More notebooks”, for you to create new notebooks and manage them.

OneNote

OneNote

Moving to the detailed panel at the center, from this space in the platform you can see the sections and pages added, as well as the possibility to create and delete them easily.

For example, sections are useful to organize notes by criteria and give general order to the notebook platform. So, to create a new section you can click in the “+Section” button at the button of the detailed panel, appearing a pop-up window allowing you to enter the name of it. Then, click in “OK” and the new section of the notebook you are will be created.

OneNote

OneNote

Having been created the new section, in this case called “Work Notes” as some type of folder specially created for notes related with working matters, now we can start creating pages or notes to keep important information at first hand.

To do so, click in the option “+Page” at the right button of the detailed panel. By default, a note called “Untitled Page” is available just to modify and be customized.

OneNote

In details, you can change the name of the default page or one created by you by just clicking or pressing Enter in the writing panel at the right, specifically in the space bar above the date and time information. In this case we will write “Next Week Meeting” and automatically such name will be added to identify the page or note.

OneNote

Now, by just clicking below the name of the page you are into you will be able to write any information you want.

OneNote

In case you want to delete created sections and notes, you can do it easily using this method: just click with the right button of your mouse and a little menu will be shown, where you only have to click in the “Delete” option, working this method with sections and pages.

Also, by clicking with the right button of your mouse on the section or page you can change the section color by choosing this option from the pop-up menu.

OneNote

OneNote

Modifying created notes and pages in OneNote easily

We know now how to create sections and new pages with proper recognizable names and information, however, in this part of the tutorial we will be showing you how to modify created notes in an easy way.

In order to modify notes and pages you have created you have access to an option panel previously shown, placed at the top of the layout with options like “File”, “Home”, “Insert”, “Draw”, “View” and “Print”, having all of them different functions.

OneNote

First, from the File option you can have info related with the software, print and share notes. In the same way, by clicking on “Home” you have access to text ribbon with options to change fonts and size, color, add effects like bold, italic underline, bullets, to apply headings, copy, paste and more. Some tools will be used on a note as example.

OneNote

In second place, from the Insert option you will be able to insert images, open new sections in the note, insert attachments, adding Add-ins hyperlinks and other options.

OneNote

By using the “Draw” tab in the option panel you will be able to use tools to draw and paint, by choosing pen, erasers and highlighters, as well as allowing to change color and thickness.

OneNote

In relation to the View option you can manage accessibility, setting notebook views, versions and navigation.

OneNote

And last but not least, with the “Print” button you will be able to print the notes and pages you have created, in case you need actual physical record of the information you have saved in such notes.

Also, it is important to remember all changes and modifications you make or saved automatically. Additionally, the note or page you are creating using OneNote Online can be opened directly into OneNote as installed software in Office. To do so, just click in the option “Open in OneNote” placed next to the option panel at the top of the screen.

OneNote