Office Online - Discover Excel Online Tutorial

In this video, you will learn about discovering Excel Online in Microsoft 365. The video covers the potential of Excel online and how to use its basic and intermediate features.
This will help you become proficient in using Excel Online and enhance your productivity.

992 views

00:00:03

The office online suite recommends

00:00:05

to use Microsoft's most well known

00:00:07

apps directly online, similar to the

00:00:09

desktop app and just as functional.

00:00:11

You can access documents from your

00:00:14

online storage or shared with you space.

00:00:16

These documents can be shared

00:00:18

quickly and simply.

00:00:19

In this video you learn how to

00:00:22

navigate the Excel online interface.

00:00:25

On your office home page, click here.

00:00:28

You can access a menu specifically

00:00:30

dedicated to Microsoft Excel.

00:00:31

Here you can find blank templates

00:00:34

and documents to create new content.

00:00:37

Just below Microsoft recommends

00:00:39

documents you may need.

00:00:43

The last section includes all

00:00:45

your Microsoft Excel files.

00:00:47

The ones you stored online yourself

00:00:49

or the ones shared by your coworkers,

00:00:51

weather on one drive,

00:00:53

SharePoint teams or outlook with a

00:00:55

right click you can perform the same

00:00:57

actions as on the Office home page.

00:00:59

You can use different filters but also

00:01:01

search your document with keywords.

00:01:03

Clicking below the file name takes

00:01:04

you to its storage location.

00:01:06

To open it, click in the document row.

00:01:09

Note that the advantage of the online

00:01:11

version is that it automatically saves

00:01:13

your document as soon as you edit it.

00:01:15

The online app opens.

00:01:16

Let's take a tour of the interface.

00:01:19

First of all, you have the upper headband.

00:01:21

This menu is the link between Excel

00:01:23

online and the entire office suite.

00:01:25

You can open another app with one click.

00:01:29

Or return to the office portal.

00:01:32

Right next to it.

00:01:33

This is where you can change

00:01:35

the name of your document.

00:01:36

Click on it and change the name just below.

00:01:39

You can change the path of your document.

00:01:42

Of course this is only possible if you

00:01:44

have permission to change the location

00:01:46

of the file in the online storage.

00:01:48

In addition to searching your documents,

00:01:50

contacts and whatever the search bar can

00:01:52

be used to search your apps features.

00:01:55

For example, I want to add a chart,

00:01:57

but I don't know how.

00:01:59

I search then select any feature

00:02:00

I want and create my chart.

00:02:08

Excel online displaced by

00:02:09

default as simplified ribbon,

00:02:11

but to switch to a classic ribbon,

00:02:13

click here. Here you can find all the

00:02:16

tools to process your Excel workbook.

00:02:19

The three buttons here allow you to

00:02:21

share the workbook with a few clicks,

00:02:24

add comments, or catch up.

00:02:27

When you work together on a spreadsheet,

00:02:29

this is where you can find your

00:02:31

coworkers modification history.

00:00:03

Office online apartman preporučuje

00:00:05

za korišćenje najpoznatijeg microsofta

00:00:07

aplikacijama direktno na mreži, slično

00:00:09

aplikacija na radnoj površini i jednako funkcionalna.

00:00:11

Dokumentima možete da pristupite iz

00:00:14

skladište na mreži ili deljeno sa prostorom.

00:00:16

Ovi dokumenti se mogu deliti

00:00:18

brzo i jednostavno.

00:00:19

U ovom videu saznajete kako da

00:00:22

kretanje kroz Excel interfejs na mreži.

00:00:25

Na matičnoj stranici vaše kancelarije kliknite ovde.

00:00:28

Meniju možete pristupiti posebno

00:00:30

posvećeno programu Microsoft Excel.

00:00:31

Ovde možete pronaći prazne predloške

00:00:34

i dokumente za kreiranje novog sadržaja.

00:00:37

Odmah ispod preporuke korporacije Microsoft

00:00:39

dokumenta koja će vam možda biti potrebna.

00:00:43

Poslednji odeljak obuhvata sve

00:00:45

Microsoft Excel datoteke.

00:00:47

One koje ste sami uskladištili na internetu

00:00:49

ili one koje dele tvoji saradnici,

00:00:51

vremenska prognoza na jednoj vožnji,

00:00:53

SharePoint timovi ili Outlook sa

00:00:55

desnim klikom možete da izvršite isto

00:00:57

radnje kao na matičnoj stranici sistema Office.

00:00:59

Možete koristiti različite filtere ali i

00:01:01

pretražite dokument pomoću ključnih reči.

00:01:03

Klik ispod imena datoteke je potreban

00:01:04

vi na njegovu lokaciju za skladištenje.

00:01:06

Kliknite na red dokumenta da biste ga otvorili.

00:01:09

Imajte na kraju da prednost na mreži

00:01:11

verzija je da automatski čuva

00:01:13

dokument čim ga uredite.

00:01:15

Otvoriće se aplikacija na mreži.

00:01:16

Hajde da obiđemo interfejs.

00:01:19

Pre svega, imate gornju traku za glavu.

00:01:21

Ovaj meni je veza između programa Excel

00:01:23

online i ceo kancelarijski apartman.

00:01:25

Možete da otvorite drugu aplikaciju jednim klikom.

00:01:29

Ili se vrati u kancelarijski portal.

00:01:32

Odmah pored njega.

00:01:33

Ovde možeš da se promeniš

00:01:35

ime dokumenta.

00:01:36

Kliknite na njega i promenite ime odmah ispod.

00:01:39

Možete da promenite putanju dokumenta.

00:01:42

Naravno da je ovo moguće samo ako

00:01:44

imaju dozvolu da promene lokaciju

00:01:46

datoteke u skladištu na mreži.

00:01:48

Pored pretraživanja dokumenata,

00:01:50

kontakti i šta god traka za pretragu može

00:01:52

koristi se za pretraživanje funkcija aplikacija.

00:01:55

Na primer, želim da dodam grafikon,

00:01:57

ali ne znam kako.

00:01:59

Pretražujem, a zatim bi izbor bilo koje funkcije

00:02:00

Želim i kreiram svoj grafikon.

00:02:08

Excel na mreži je izmešten sa

00:02:09

podrazumevano kao pojednostavljena traka,

00:02:11

već da se prebacim na klasičnu traku,

00:02:13

kliknite ovde. Ovde možete pronaći sve

00:02:16

alatke za obradu Excel radne sveske.

00:02:19

Tri dugmeta ovde ti to dozvoljavaju

00:02:21

deljenje radne sveske sa nekoliko klikova,

00:02:24

dodavanje komentara ili sustigavanje.

00:02:27

Kada radite zajedno na unakrsnoj tabeli,

00:02:29

ovde možete da pronađete svoj

00:02:31

coworkers modifikacija istorije.

RELATED COURSES This tutorial is part of the following courses

Microsoft 365 Video Training - Learn Microsoft Office Online

The difficulty of working in an emergency or remotely is that our favorite apps are not always available on the computer. Let's look together at the advantages of working with the Office Online suite!

715 vues

ALL COURSES