Excel - Using Excel on a phone Use Case

In this video, you will learn about using Excel on a phone.
The video covers how to create an Excel spreadsheet on your smartphone using the application and save it to your OneDrive storage.
It also demonstrates how to use calculation functions like SUM and find functions easily sorted into categories.
Additionally, it shows how to share the document with colleagues and access advanced functions online.
This tutorial will help you effectively use Excel on your phone and improve your productivity.

3:47
3075 views

Available in Microsoft365

Objectifs :

This video aims to demonstrate how to use the Excel mobile application to create, edit, and share spreadsheets effectively, even when away from a PC. It highlights the convenience of accessing OneDrive for document storage and collaboration.

Chapitres :

Introduction to Mobile Excel Usage
In today's fast-paced work environment, being away from your PC doesn't mean you can't fulfill your responsibilities. This video illustrates a scenario where a colleague requests an Excel file while you are out of the office. Instead of admitting you forgot, you can utilize the Excel mobile application to send the file promptly.
Creating a New Spreadsheet
Using the Excel application on your smartphone, you can easily create a new spreadsheet. The app allows you to start with a blank document or use templates. In this example, a new blank document is created where numbers can be entered.
Using Functions for Calculations
The mobile version of Excel supports various calculation functions similar to the desktop version. To calculate the sum of the numbers entered, you can type the first few letters of the SUM function, which will appear for selection. Once selected, the sum is displayed in the chosen cell.
Saving Your Document
Automatic saving is enabled by default in the mobile app, ensuring that your document is saved to OneDrive storage. This feature allows you to access your document from any device without the fear of losing your work.
Calculating the Average
To calculate the average of the numbers, the mobile Excel app categorizes functions for easy access. By selecting a cell and browsing through the available functions, you can quickly find the average function, select the necessary arguments, and confirm your choice.
Navigating Between Tabs
The mobile application allows seamless navigation between different tabs. Users can select the desired tab to access various features and functions, enhancing the overall user experience.
Sharing Your Document
If you need to share your document with a colleague, the Share icon is readily available. You can enter the recipients' email addresses, write a message, and choose whether they can edit or only view the document. Additionally, you have the option to create a shareable link or send the file as an attachment.
Conclusion
The Excel mobile application provides robust features that allow users to create, edit, and share documents on the go. By leveraging OneDrive for storage and collaboration, you can maintain productivity and ensure that your work is accessible from anywhere. Thank you for your attention.

FAQ :

How can I create an Excel spreadsheet on my smartphone?

You can create an Excel spreadsheet on your smartphone by downloading the Excel mobile application from your device's app store. Once installed, you can open the app, create a new document, and start entering data.

What is OneDrive and how does it work with Excel?

OneDrive is a cloud storage service that allows you to save your Excel files online. When you save a document to OneDrive, you can access it from any device with internet access, making it easy to work on your files from anywhere.

What is the SUM function in Excel?

The SUM function in Excel is used to add a range of numbers together. You can use it by typing 'SUM' followed by the range of cells you want to add, and it will calculate the total for you.

How do I share an Excel document with someone?

To share an Excel document, open the document in the Excel application, click on the Share icon, enter the recipient's email address, and choose whether they can edit or only view the document. You can also create a shareable link.

Can I access my Excel documents offline?

You can access your Excel documents offline if you have downloaded them to your device. However, any changes made while offline will need to be synced with OneDrive once you reconnect to the internet.

Quelques cas d'usages :

Creating and Sharing Reports

Professionals can use the Excel mobile application to create financial reports while on the go. By saving the report to OneDrive, they can easily share it with colleagues via email or a shareable link, ensuring everyone has access to the latest data.

Budget Tracking

Individuals can track their monthly expenses using Excel on their smartphones. By utilizing the SUM function to calculate totals and averages, they can manage their budgets effectively and share their findings with financial advisors or family members.

Collaborative Projects

Teams working on collaborative projects can use the Excel mobile app to input data and analyze results in real-time. By sharing the document, team members can contribute simultaneously, enhancing productivity and ensuring everyone is on the same page.

Data Analysis on the Go

Data analysts can perform quick calculations and data analysis using the Excel mobile application while traveling. They can access their OneDrive files, make necessary updates, and share insights with stakeholders instantly.

Educational Purposes

Students can use the Excel mobile app to create spreadsheets for assignments or projects. They can calculate averages and sums for data analysis and share their work with classmates or instructors for feedback.

Glossaire :

Excel

A spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns.

OneDrive

A cloud storage service from Microsoft that allows users to store files and data online, enabling access from any device with internet connectivity.

SUM function

A built-in function in Excel that adds together a range of numbers. It can be accessed by typing 'SUM' followed by the range of cells to be summed.

Average

A statistical measure that represents the central value of a set of numbers, calculated by dividing the sum of the numbers by the count of the numbers.

Automatic saving

A feature that automatically saves changes made to a document at regular intervals or when certain actions are performed, reducing the risk of data loss.

Share icon

An icon in applications that allows users to share documents or files with others via email or links, often providing options for permissions.

Mobile application

A software application designed to run on mobile devices such as smartphones and tablets, providing functionalities similar to desktop applications.

00:00:07

the Excel file you promised him yesterday.

00:00:11

You don't want to admit you forgot.

00:00:14

And so, you promise to send it right away.

00:00:17

How will you do that without your PC on hand?

00:00:22

Will your colleague have to wait for you to get back to the office?

00:00:28

From the application installed on my smartphone,

00:00:31

I can easily create an Excel spreadsheet and save it to my OneDrive storage.

00:00:37

It's worth noting that templates can be used.

00:00:42

Here we are with a new blank document

00:00:45

that we can fill up with numbers for example.

00:00:51

Next I want to display the sum of the numbers I just entered.

00:00:56

Just like the Office version, the application lets me use

00:01:00

calculation functions, so I can easily select the SUM

00:01:04

function by putting in the first few letters.

00:01:09

Once my function is entered,

00:01:12

I just need to enter the arguments and confirm.

00:01:16

The sum of the elements appears in the selected cell.

00:01:21

Now I want to save my document.

00:01:24

Automatic saving is active by default,

00:01:27

but I can also manually save my changes to put the document

00:01:31

in a new location or give it a new name.

00:01:43

There, my document is saved to my OneDrive storage

00:01:47

so I can\ access it from any device.

00:01:52

To make changes, all I have to do is find it in the list and click on it.

00:01:59

Next, I want to calculate the average of the numbers in the list,

00:02:04

but I don't remember what the formula is called.

00:02:07

The mobile version of Excel can present all the functions

00:02:11

sorted into categories, so they can be used with a simple click.

00:02:16

Here to calculate the average, I select a cell and bring up

00:02:21

the available functions to find the one I'm looking for.

00:02:25

Different categories are available to help me find it,

00:02:29

but since this is a commonly used function, it appears right on top.

00:02:35

Now I just need to select the arguments and confirm.

00:02:42

Just like the Office version, you can move from one tab to the other.

00:02:48

All you have to do is select the one you want to open in.

00:02:53

Finally, if I want to share this document

00:02:56

with an associate, the Share icon is available.

00:03:01

I fill in the recipients and eventually write a message

00:03:05

and choose whether my colleagues can modify or only read the document.

00:03:12

You also have the option of creating a link

00:03:17

or sharing the file as an attachment.

00:03:26

Online access to your documents lets you take advantage

00:03:30

of advanced functions even on Excel.

00:03:34

In our example, we were able to create and share

00:03:37

a spreadsheet from a smartphone with the mobile application.

00:03:42

Thank you for your time and attention.

Mandarine AI: WHAT YOU SHOULD KNOW