Excel Tip: Excel on the Road

SHARE

Excel Tip:  Excel on the Road
reprinted with permission from the HP Small Business Center

We all know Excel is a powerful application. But what about Excel Mobile? Does Excel’s functionality translate to the spreadsheet’s mobile version for use on your smartphone?

The answer is yes and no. Excel Mobile can only offer a subset of Excel’s features. This is, however, enough for viewing and editing spreadsheets so that you can stay productive on the road, even with a non-touch screen phone.  

Not to be overlooked is also the fact that, in its portable form, Excel takes on versatile new roles. It’s not just a spreadsheet application any more, it’s also a sophisticated calculator, an electronic to-do list, a portable data manager – you get the idea. 

Here we share some tips and tricks to help you get the most out of Excel Mobile for Windows Mobile 6 Standard. After finding your way around Excel Mobile, you may just discover that it’s indispensable.   

Different viewing modes
When you open an Excel file on your device, you will see the spreadsheet in Full Screen view. In this default view, menus and scrollbars are removed in order to maximize your viewing space. The two main menus can be seen by pressing the soft keys: the right one for Menu and the left one for the View menu. 

In the View menu, you have the option to switch between Full Screen and Cell Text views. In Cell Text view, you’ll see the contents of a particular cell and the cell name (A13, B9 etc.) in an enlarged, highlighted, easy-to-read format. Another view option is Overview, which zooms out to give you a thumbnail shot of the entire sheet, allowing you to navigate around the spreadsheet to quickly find the parts you want to view or edit.  

How to edit
To add or edit content, go to Menu > Edit to enter edit mode. Highlighting and selecting a cell will open the text box at the top of the screen. When you are done editing, click on Done. You can select multiple cells for editing with the Select option in the Menu. Many of the standard Excel menu options, such as File, Edit, Insert and Tools can also be found in the edit Menu. For example, under Insert you’ll find Function just like in Excel. Some things have been shuffled around: for example, Find is located under Tools. When you click on Menu > Close File you will be prompted to name and save your file.    

Beyond view and edit
Excel Mobile for Windows Mobile 6 Standard does not allow you to create a new spreadsheet. However, there’s a way to get around this.  Simply create a new worksheet in Excel and save it with a generic name like “New worksheet” or “Blank sheet” and mark it as read-only. Then open it with Excel Mobile on your device, save it with a new name, and you have basically created a new worksheet that you can “edit” as you need.  

While creating a new data-heavy spreadsheet on your mobile phone might be painful and not to be recommended, it is, however, perfect for creating simple spreadsheets to keep track of information throughout your day. For example, you could use it to keep track of your gas usage and mileage or your business travel expenses. There are many ways to use Excel Mobile, and with some exploration, you might just find your own specific use for it.   

Need a calculator that’s more advanced than the basic one built into your phone? Don’t forget that with Excel Mobile you can create formulas and functions to calculate a simple to complex string of values. 

Those who need to do intensive data entry while on the go may find the extended functionality available for Excel Mobile with Windows Mobile 6 Professional and a touchscreen display even more useful. 

Microsoft and Excel are trademarks of the Microsoft group of companies.

UPCOMING VIRTUAL EVENTS

Demystifying Cyber Security for SMBs

sb-cyber-security-master-class

The continually changing threat landscape requires us to update best practices and add new concepts to keep your organization safe.

SESSION 4: Cyber Security Strategy
Watch On-Demand

SESSION 5: Cyber Insurance & MFA
Watch On-Demand

SESSION 6: Threat Detection | JAN. 15

Microsoft Copilot
Master Class Workshop

sb-microsoft-copilot-master-class

eMazzanti will host 60-minute Master Classes, that speak to how AI can help your business streamline and grow.

In each session, you will have Artificial Intelligence and Automation explained, view a live demo of Copilot, and see it live in action in a dynamic format.

RESOURCES

Cyber Security Awareness Hub

sb-Cyber-Security-Awareness-Hub

Cyber Security Awareness Kit, designed to be delivered to your team in bitesize chunks.

We are sharing the resources and highlighting services your organization needs, covering everything from multifactor authentication to software updates, showing your users just how easy it is to improve their security posture.

Resource Library

sb-resource-library

Insights to help you do what you do better, faster and more profitably.

> Tips to Stay Protected Against Phishing Attacks

> Understanding Ransomware 

> The 6 Known Wi-Fi Threat Categories Targeting Your Business and How to Defend Against Them

> Practical Advice for Avoiding Phishing Emails

Recent Articles

NEWSLETTER

Categories