Excel 2013 Online Tutorial-Harness the Power of Excel Online

excel 2013Excel 2013 comes with built in cloud services. For those who don’t know what that is, quite simply it means no more documents left behind, left at home or multiple versions of one document gumming up your PC. Storing your files in your OneDrive folder means your files are really being stored online on the server you have been assigned by Microsoft, so any files stored on one drive are stored on the “cloud” and you can log into your  account and access them from anywhere in the world at any time. Cloud storage also means you can share links to your documents in the cloud to allow others to work on your documents, without having to synchronize the changes that each person or team member makes to the documents.

If you want to learn about the amazing new features offered by Excel 2013, check out Excel 2013 For Dummies Video Training, Deluxe Edition and join thousands of students who are learning to use the new Excel features. This course includes 109 lessons that will teach you everything your need to know about Excel 2013. You will learn how to launch and navigate worksheets, how to enter data and how to use the AutoFill features to get Excel to fill in data for you. You will learn about formulas and how to use them in your worksheets. The course will teach you about Pivot tables and charts and how to sort and filter data sheets. You will also learn how to save and share worksheets via SkyDrive.

So how does OneDrive work and how do you store your documents in the cloud? This tutorial will show you how to access the Excel 2013 online services easily. It is really very similar to storing your documents on your PC with huge advantages. The steps in this tutorial include:

1.       Creating your worksheet

2.       Saving your worksheet on SkyDrive

3.       Sharing your file with others

4.       Accessing the file on OneDrive

Creating Your Worksheet for Excel Online Storage

We will create a simple worksheet for the tutorial. To create your worksheet, open Excel 2013 and then select “Blank Workbook” to start a new workbook. Or select one of the templates to create a specific type of worksheet if you like.

Excel1

Enter some test data for your worksheet. I have entered the following data:

Excel2

Once you have created your worksheet, it’s time to save your worksheet to your SkyDrive.

To learn more about Excel 2013 and how the new features and functions can make your life easier, sign up for the Microsoft Excel 2013 Simplified course now. This course is aimed at beginners and will take you step by step through the process of creating workbooks in Excel and sharing those workbooks to allow people to collaborate on the workbook. You will also learn advanced formulas and techniques to ensure you know how to harness the power of Excel in your office or home.

Save Your Worksheet to Excel 2013 Online OneDrive

To save your workbook to your cloud storage, select “file”, and then “Save as” and then select “Someone’s OneDrive”.

When you select “Someone’s OneDrive” your Windows Explorer browser will open up at the location where OneDrive has been installed on your computer.

Your OneDrive will contain various folders. You can set up folders that you share with others, folders for public sharing as well as any other folders you need. Choose to save this document in the main folder and give your file a name. For the purposes of this tutorial, I have called the file “Excel 2013 Tutorial.”

Excel3

Now that the file is saved on OneDrive, there are a number of ways you can access the file online. First you can invite people to share this document. Since the document is actually stored online, your computer does now need to be “switched on” when others access or work on the document.

To share the document with others, click “File” and then select share from the menu:

Excel4

This menu will allow you to select a contact to share the document with or to invite people via email to share the document. You can set the permission for the users by changing what they can do from “can edit” to “can view.”

Excel5

To select people from your existing email contacts, just push the contact button and Excel will automatically allow you to select contacts from your address book:

Excel6

Once you have selected the contacts you want to share the document with, click the share button and Excel will send an email to each of the contacts with a link so that they can access the document.

If you would like to learn more about Excel 2013 and the new Excel 2013 online features, then sign up for the Excel 2013 The Basics course now. This course has 160 lessons that will really teach you everything you need to know about working in Excel 2013. It is aimed at both the beginner and advanced Excel user and includes how to get started, how to create, format and modify worksheets. It will show you how to work with formulas and calculations. It even includes lessons on customizing the Excel environment to make Excel one of the most powerful applications on your PC.

Access Your Online Excel 2013 files

To access your files from anywhere, simply login to your OneDrive account online via your internet browser or smartphone:

Excel7

You will see the file we just saved in the OneDrive folder on your PC. To access the file online, right click the file you want to edit or open and then select open in Excel if the PC you are using has a copy of Excel 2013 installed or you can choose to open online. It is important to note that not all of the Excel features are available if you choose to edit online but you can make basic changes to your worksheet online.

Excel8

When you select “open online” an online copy of the worksheet will open in a new window or tab and you can view, edit or print the worksheet:

Excel9

For more lessons on Excel, sign up for theExcel 2013 course now and become a master of Excel in the Workplace. This course offers 101 lectures that will teach you all of the Excel essentials to give you the confidence to work with Excel in the office.

Share Your Online Files From OneDrive

You can also choose to share your documents via OneDrive instead of sharing via the Excel menu. To share the document via OneDrive, select the file you want to share, right click the file and then select “Share”.

Exceln10

Excel 2013 Online OneDrive is Powerful

Having the ability to save and then access your documents anywhere, anytime, has become one of my favorite Excel 2013 features. I no longer have to worry about copying documents to USB drives, emailing copies or synchronizing various versions of my documents. Once you have saved your documents to the cloud, you’ll be hooked.

Learn to harness the genius of Excel 2013 and join over twenty thousand students who are learning to master Excel with Excel 2013 online tutorials in the Microsoft Excel 2013 Course Beginners/ Intermediate Training course. This course offers 107 lectures and 8 hours of content that will teach you basic and advanced Excel 2013 techniques. The course is suitable for both beginner and advanced users and offers video and step-by-step instructions to ensure students really know and understand how to apply the lessons. Its visual training methods offer students increased retention and accelerated learning to ensure you are up and running as an Excel 2013 master in no time at all.