Excel

How to work with documents Word, Excel on iPhone and iPad

17/09/2021 by

It happens that Word, Excel, Pages, Keynote and Numbers documents created on Windows or Mac require urgent corrections, and only an iPhone or iPad is at hand. How to provide for the possibility of editing documents, as well as their synchronization between all iOS devices and computers, we will tell in this material.

♥ BY THEME: Continuity Camera, or how to take pictures on Mac with iPhone camera.

Using Google Docs

Probably the most convenient way to keep your documents close at all times (on any device with a browser and the Internet) is to upload them to Google Docs. The only drawback of the service is the lack of support for files created in Apple applications (Pages, Keynote and Numbers), but for Microsoft Word and Excel files, this is ideal.

To download and work with Word documents and Excel spreadsheets in Google Docs, do the following.

1… Register a Google account (create a Gmail box) following this instruction.

2… Go to the Google Docs service page.

3… At the top of the screen, select the desired online web application: Documents, Sheets, or Presentations.

4… To add files from your computer (and other sources), click on the folder icon.

5… Upload the required documents.

6… To create a new document, click the “+” button at the bottom of the screen.

7… To change the web application, click the three-bar button in the upper left corner.

To view and edit files from Google Docs on iOS devices, use the official Google Docs and Google Sheets apps.

Be sure to check out our other Google Docs content:

♥ BY THEME: What is the battery life of a MacBook and how to find out the number of recharge cycles.

Using iWork for iCloud in a browser

With free cloud service iWork for iCloud you can transfer work documents to iCloud for sharing on iOS and Mac. This can be done on any computer with Internet access.

1… Open icloud.com on any computer and sign in to your account using your Apple ID.

2… Depending on which document you want to upload to the “cloud” – select the web application Pages (Microsoft Word files) or Numbers (Microsoft Excel files).

3… Then just drag the file (or several) into the program window in the browser. In a moment, all documents will be available for work with iPhone, iPad or Mac.

Again, the above method can be used not only for documents iWorkbut also for MS Office files (Word, Excel) for Windows.

To edit the downloaded files, just open them in the online editor.

Optionally, you can add a user to co-edit the document online.

♥ BY THEME: iCloud on a computer, or how to upload photos, videos from the cloud to Windows and vice versa.

Using iCloud Drive on Mac

1… Open Finder and go to the tab iCloud Drive… You can enable the service along the way System settings → Apple ID → iCloud…

2… Copy (or drag and drop) the necessary documents from your computer to the cloud storage iCloud Drive…

It should be noted that when using applications with iCloud support, corresponding folders will be automatically created for them in iCloud Drive…

After completing the above steps, your documents will always be available on any Apple device with Internet access, including the iWork for iCloud service described above.

Pages and Numbers can open Word text files and Excel spreadsheets.

♥ BY THEME: How to delete files past the recycle bin on macOS.

How to View and Edit Documents from iCloud on iPhone and iPad

Documents uploaded to iCloud Drive will be available in the Files app (iOS 11+ device required).

Also, the files will be available for viewing and editing in the respective applications. Pages (link) or Numbers (link) downloaded on iOS devices.

Below is a screenshot of the application Pages with available files from the “cloud” iCloud Drive…

See also:

Free Office (Word, Excel) for Mac, Windows, iPhone, iPad and Android from Russian developers

10/04/2021 by ALOK DAS

Whether we like it or not, from April 1, 2021, all smartphones and computers sold in Russia must have domestic software preinstalled. And even if his list is not very extensive yet, it will definitely be supplemented. In the meantime, out of almost three dozen applications, the main part is Yandex and Mail.ru products, while the rest are clients of online cinemas and other entertainment platforms. But there is also the “MyOffice” package among office products, which can become a competitor to the classic MS Office.

♥ BY TOPIC: Virus check online, or how to check your computer without installing the usual antivirus.

“MyOffice” did not appear out of nowhere – the product developed by Russian programmers from scratch was often mentioned in various publications and reviews. In January 2021, the platform received a major update that significantly improved the user experience and expanded functionality. It is not surprising that the package was included in the list of domestic software offered for installation on digital devices.

♥ BY TOPIC: How to convert PDF to JPEG for free on Windows and Mac.

It’s free!

Mobile gadgets can get “MyOffice Documents”, and on personal computers you can install “MyOffice Standard. Home version “… Thus, buying a device, along with it, out of the box, an office suite will also be available. with an official free license for home users. And you can download the product yourself, again is free evaluating the functional. The distribution kit is available both on the developer’s website and in the Microsoft Store, Apple Mac App Store. And the mobile application can be easily found in Google Play, App Store and even Huawei AppGallery. In addition, you can use the web version of the MyOffice editors. Download links are available at the end of the article.

♥ BY TOPIC: How to create albums from Instagram photos or videos.

What is included in MyOffice?

Web version of MyOffice editor

The package “MyOffice Standard. Home version “, available for PC, includes two applications – the text editor” MyOffice Text “and the editor of spreadsheets” MyOffice Spreadsheet “. Installation requires 64-bit Windows 10 or macOS 10.15 or newer product versions. The mobile version of the package, oddly enough, is richer – it includes 4 products. In addition to the aforementioned main pair, there is also a tool for viewing presentations and PDF documents, as well as a file manager. As a reminder, the app works with major mobile operating systems and is available in their stores.

♥ BY TOPIC: How to download files, documents, videos and music to iPhone and iPad from the Internet.

What can MyOffice do?

There are only two products in the standard free home package. But let’s be frank, for the vast majority of users this is quite enough.

Applications work both with open formats ODF / ODT / ODS, as well as OOXML / DOCX / XLSX, and with their own XODT / XODS formats. Outdated DOC / XLS are also supported, but when you save the documents, you will be prompted to convert them to a more modern format. MyOffice applications easily open RTF, TXT and PDF, while the editors will display text identically on different operating systems.

The very same pair of desktop applications are a great alternative to the classic Word and Excel. MyOffice allows you to both easily create and edit text documents, and carry out their complex layout – add tables, graphs, images. The text editor can use templates, styles, various kinds of lists, hyperlinks, tables of contents and tables, formatting the text in the desired form.

Work with spreadsheets is handled by “MyOffice Spreadsheet”. This tool also supports templates and, importantly, provides formulas for calculations – there are more than two hundred of them, both mathematical and logical. In addition to data processing, there are tools and their visualization – graphs and diagrams. In tables, you can create multiple sheets, sort and filter data.

An important requirement for products of this kind is macro support. MyOffice has it, and the Lua programming language is used to develop scripts that help automate actions. The package can check spelling in Russian and English, and for the former there is also a grammar checker. To solve problems with font compatibility and the same display of documents on different platforms, a proprietary set of XO Fonts is used.

The mobile version of the package is an excellent addition to the main desktop one. Let us again recall the important advantage of this domestic product – “MyOffice Documents” is distributed free of charge and without imposing advertising products. Mobile applications also provide the ability to edit text files and tables, as well as view PDF files. To exchange files, it is proposed to use instant messengers or cloud storage – Google Drive, Yandex.Disk, Dropbox and others. The mobile application will be in demand when making edits literally on the go, and its functionality allows it. Moreover, “MyOffice Documents” allows you to make audio comments. To do this, open the desired file, hold your finger in the right place for a couple of seconds and call the context menu.

With its help, you can comment on this place with your voice. The attached audio can then be listened to in a mobile application in the same application or on a computer with the MyOffice package installed. The function is convenient and unique – voice notes speed up the processing of documents, because it is easier to speak notes on the go than to enter them from the keyboard. At the same time, the audio itself is not transmitted to third-party servers, but is stored directly inside the document, which allows the XODT format.

♥ BY TOPIC: How to enable identifier of unknown numbers on iPhone for free.

Distinctive features of the MyOffice package

The adaptive toolbar allows you to display all commands without tabs; they are grouped into sections, the composition of which changes depending on the object selected in the document. As a result, the user sees on the panel only those tools that may be useful to him for the current work. This makes MyOffice understandable even for an inexperienced user.

Another useful feature is the extended clipboard, which can contain up to 10 text fragments. The “Quick Actions” menu can be called without a mouse and quickly find the desired function. MyOffice keeps a history of formatting, using the Brush History tool, allowing you to return to the previously used style options. There are also “chips” for spreadsheets – they can select the active area, freeze columns and rows, rotate text in cells. Another interesting feature is the support for table-style formatting of cells with alternating row fillings. Also, “MyOffice Table” can restore accidentally deleted sheets.

♥ BY TOPIC: Hotkeys for working with windows in Windows.

Package performance

During the tests, other popular packages were used as a comparison: P7-Office, LibreOffice and Office 365. Performance was evaluated in working with multi-page or multi-line (for tables) documents in DOCX, DOC, ODT, XLSX, XLS, ODS formats. The tests were carried out on computers of different generations; the time to launch an office editor with the opening of a test file was estimated.

I must say that Microsoft 365 proved to be the undisputed leader in almost all tests. The second and third positions were shared with alternating success between MyOffice and LibreOffice. At the same time, MyOffice proved to be excellent in working with DOCX, overtaking even the Microsoft product, and with the text format ODF, the de facto Russian national standard in paperwork, the package performs well.

In general, relative to competitors, MyOffice looks very decent, uncritically inferior to the leader in performance.

♥ BY TOPIC: The best “clouds” without registration, or how convenient it is to transfer files between iPhone, Android, Mac and Windows.

Conclusion

Developed since 2013, the platform has smoothly evolved into a reliable and convenient tool for working with the main formats of office documents. Previously, “MyOffice” was aimed at the corporate segment, and the appearance of a version for private users can significantly increase the popularity of the product. The quality, convenience and capabilities of the desktop version of “MyOffice Standard” and the mobile version of “MyOffice Documents” allow attracting new users to the product, because the ability to use a free powerful office suite without any advertising is a rarity in offline mode. Obviously, “MyOffice” is rightfully an important player in the Russian office software market.

Download “MyOffice Standard. Home version “for Windows
Download “MyOffice Standard. Home version “for Mac
Download “MyOffice Standard. Home version “for iPhone and iPad
Download “MyOffice Standard. Home version »for Android
Download “MyOffice Standard. Home version “in Huawei AppGallery
Web version “MyOffice”

How to create tables with functions and formulas in Numbers on Mac like Excel

16/10/2020 by ALOK DAS

Are you using Numbers on your Mac to track, log, modify, and analyze data? You may not know, but this application offers several built-in tools to help you better process data.

With Numbers, you can completely ditch the calculator and stop wasting time on manual work. We’ll try to show you how to use formulas and functions in Numbers to make your data easier.

♥ BY TOPIC: Mac Finder Quick Steps: How to Use.

How to open the formula editor in Numbers on Mac

Before you start inserting formulas and functions in Numbers, it’s worth reading Formula editor…

It’s easy to use, just click on the cell where you want to add a formula or function and enter an equal sign there =…

This is already enough to open the editor. You can also click on the tab Insert -> New Formula on the toolbar, which will also open Formula editor…

You can move the formula editor by dragging on the left side. Resizing is possible by dragging the double-headed arrow to the left or right.

If you click the button while the formula editor is open Format, will open Feature Browser, which contains many different functions with descriptions.

As an example, let’s create a table of monthly expenses, in which you want to add the rows and columns to the total for the month and year. For this:

1. Place the cursor in an empty cell and enter the symbol = to call Formula editor…

2. Specify the cells to be summed. They will appear in Formula editor…

3. Press the green button in Formula editor to automatically count and write the answer to the cell.

You can also use arithmetic operators for subtraction, multiplication, and division. Numbers can be entered with or without decimal places.

If the formula is entered incorrectly or is not needed, then click the red cross to close this window without saving the changes.

Plus, for convenience, Numbers provides some basic formulas that you don’t even need to call Formula editor…

Let’s create the same action in our table, but with different data and using the button Paste, which is used to quickly apply a formula without using an editor.

4. Select the cell in which you want to use the formula.

5. Press the button “Paste” on the toolbar and select one of the options: Amount, The average, Minimum, Maximum, number, Composition or Quotation…

In our case, we choose the option Amount…

6. Numbers tries to automatically make a correct guess for a formula based on your spreadsheet data. Quite often Numbers isn’t wrong, but it doesn’t always happen. If the program has made an incorrect count (the selected cells are not suitable for use), use Formula editor from the previous instruction.

♥ BY TOPIC: 10 Safari for Mac (macOS) Hotkeys You May Not Know

How to copy formulas and functions to apply to other rows and columns of a table

With the examples we’ve shown above, you most likely want to apply a formula or function to more than one cell. This way, you can easily use the formula in adjacent cells, rows or columns depending on the layout of the data.

Select the cell with the formula you want to copy. When you see a yellow dot on the border of a cell, click on it and drag it to the cells where you want to copy the formula. Release the pointer.

The required formula or function is not only copied into these cells, but also immediately applied to the corresponding data.

♥ BY TOPIC: How to schedule your Mac to sleep and turn it on automatically.

Additional useful formulas and functions

If the basic formulas or functions already mentioned are simply not enough to accomplish your actual tasks, there are several other useful ways to work with your data.

Removing extra spaces

If the data in your spreadsheet was taken from a database, it may not always be formatted the way you want. Using the example customer table above, you can get the customer’s first and last name with a lot of spaces in between. This can cause problems when automatically sending emails using these names or merging them.

Using the function TRIM (Trim) in Numbers, we can automatically remove those extra spaces in a few simple steps.

1. Select the cell in which you want to use the formula, and then open Formula editor and Feature Browser…

2. Find the function TRIM (you can use the search), select it in the list and click “Insert function“.

3. In the formula editor, click on original line, and then click on the data cell.

4. Click on the green checkmark to apply the formula.

Now we have formed a correct and correct list of customer names without unnecessary spaces. In this format, the data will not cause crashes in other software.

♥ BY TOPIC: How to save Pages files as Word (doc, docx) on Mac, iPhone, iPad, or Windows.

Converting to plain text

Another feature in Numbers that can be very useful, especially when retrieving data from various sources, is SIMPLE TEXT… Perhaps your spreadsheet has text and numbers that are formatted in some way. These can be clickable links, or underlined, bold, or italicized names.

Using the function SIMPLE TEXT you can get rid of unnecessary formatting.

1. Select the cell where you want to place the formula and open Formula editor and Feature Browser…

2. Find the function SIMPLE TEXT, select it in the list and click “Insert function“.

3. Click on original line, and then click on the data cell.

4. Click on the green checkmark to apply the formula.

Now you should be able to see your text data without overlaying effects and fonts, URL links or other formatting.

ON THIS TOPIC: Continuity: How to get started on an iPhone or iPad, and continue on a Mac, and vice versa.

Easier ways to analyze data in Numbers

You can easily manage and analyze data in Numbers spreadsheets using formulas and functions. For processing numbers and text, try using formulas and explore some of the other built-in functions Numbers offers. You just never know which one might be useful until you test them.

See also:

How to create a handy checklist (checklist) in Excel so you don’t forget anything

19/07/2020 by ALOK DAS

Excel is a pretty handy tool with extensive functionality. Many applications offer the ability to create different lists, but why use other programs if you have Excel?

♥ BY TOPIC: Exposure of focus in the “Camera” iPhone: setting and fixing.

How to create a handy checklist (checklist) in Excel

Below we show how to create a table with checkboxes that you can delete as you complete tasks. Excel will even display when you uncheck all the boxes. Creating a table is quite simple. To do this, open the tab “Developer”, add a list of tasks, add checkboxes and advanced formatting. And now, in order.

♥ BY TOPIC: Notes Tables on iPhone, iPad, and Mac (macOS): How to create and customize.

1. Open the tab “Developer”

Default tab “Developer” not displayed. It can be added to the feed as follows: open “File” → “Parameters” → Customize Ribbon… In the list Main Tabs check the box “Developer”and then click Done…

♥ BY TOPIC: The “Rule of Thirds” when shooting with an iPhone: what it is and how to use it.

2. Adding a list of tasks to the table

In each cell of the table, specify the task. In our example, one of the cells will contain “Total number of items”second – “Packaged items”… Cell “I’m ready” will be displayed in red if not all the checkmarks in the list are unchecked, and in green if all the boxes are unchecked.

Open the tab “Developer”… Click “Paste” and in section Form Controls select “Checkbox” (icon with a check mark)…

♥ BY TOPIC: How to remotely connect to an iPhone or iPad and view its screen from a computer, Android or iOS device.

3. Add checkboxes

Click on the cell where you want to add a flag. You will see text displayed to the right of the checkbox box. Since we only need a field, select the text and delete it. After removing the text, the field does not automatically resize.

If you want to change it, right-click on a cell to select a field, and then left-click on it. This way you can resize it and move it to the middle of the cell. To copy the checkbox field and place it in other cells, select the cell, and then use the cursor keys (keyboard arrow keys) to move to the checkbox cell. In order to copy a checkbox field to other cells, move the cursor to the bottom corner of the cell, grab it with the mouse button and drag it over the cells where you want to copy the field. Release the mouse button.

♥ BY TOPIC: Gmail Master, or How to Clean Up Your Google Mailbox: 5 Tips.

Advanced list formatting

Depending on the purpose of the list, you can use advanced formatting.

Create a TRUE / FALSE column

To do this, use the column to the right of the checkbox fields. The checkbox will return TRUE (if checked) or FALSE (if it is removed). This way you can see if all the check boxes are cleared.

Right-click the first checkbox field and select “Object format”…

In the tab “Control element” in the window “Object format” click on the cell selection button on the right side of the field “Cell Link”…

Select the cell to the right of the checkbox. The address of the selected cell is placed in the field “Cell Link” in the compact version of the window “Object format”to expand it re-click on the button “Link to cell” and select “OK”… Repeat the procedure for each cell in the list.

♥ BY TOPIC: Viber for Windows, Linux and Mac in Russian: eight life hacks you might not know.

The total number of items and the count of marked items in the list

Specify the total number of checkboxes in the list in the cell to the right of the cell “Total number of items”… The number of checked boxes can be counted using a special function. Enter

=СЧЁТЕСЛИ(C2:C8; ИСТИНА)

=COUNTIF(C2:C8,TRUE)

to the cell to the right of the cell “Packaged items” and press Enter… As shown in the example below, the function will count the number of cells in column C (C2 through C8) that have the value TRUE or TRUE…

Hide TRUE / FALSE column

In order to hide this column, right-click on its heading and in the menu that appears, select “Hide”… The column will be hidden.

How to check if all checkboxes are unchecked

To do this, select the cell “I’m ready” and enter

=ЕСЛИ(B10=B11;"Да";"Нет")

=IF(B10=B11,"YES","NO")

If the number in cell B10 matches the value of the counted flags in cell B11, it will automatically display “Yes”otherwise “Not”…

♥ BY TOPIC: How to look good in any photo: 5 simple tips.

Apply conditional formatting

With conditional formatting, you can highlight cells with color. For example, you can set conditional formatting so that all cells with values of a certain type are colored red.

Create a rule by opening “Home” → Conditional Formatting → “Create rule” → Conditional Formatting Rules Manager → “Use a formula to define formatted cells”… Enter

=$B10<>$B11

in field “Format values for which the following formula is true:”… Replace values B10 and B11 with cell addresses “Total number of items” and “Packaged items”if they are not the same cells.

Create another rule, but in the field “Format values for which the following formula is true:” enter the formula

=$B10=$B11

Then press “Format”, select a color and click “OK”…

In the window Conditional Formatting Rules Manager enter the addresses of the cells to be filled with color in the field “It applies to”… Enter the same addresses for both rules. In our case it is = $ B $ 13… Click “OK”…

Cell “I’m ready” turns green if all the checkboxes are unchecked, or red if not.

See also:

How to Convert Numbers File to Excel Format on Mac

15/06/2020 by ALOK DAS

Do you have a file created in Numbers and want to turn it into an Excel document? Nothing is easier! Follow our instructions – and you get an Excel file in the format .xls or xlsx, compatible with any version of Microsoft Excel and other applications.

♥ BY TOPIC: How to use tags in Finder on Mac.

How to turn a table from Numbers to Excel file?

For conversion, we need the Numbers program. If you don’t have it yet, you can easily download it from the Mac App Store. It will not cost you anything – Apple has not been asking users for money for its Excel counterpart for many years.

After installation, open the program and do the following:

1. Open in Numbers the file you want to convert to Excel format.

2. With Numbers open, in the menu bar at the top, select File → Export to → Excel.

3. On the export screen, tap Extra options and select the necessary parameters for the future Excel file, including make a choice between the “old” .xls extension and the “new” .xlsx.

If you do not know which is better, specify .xls. This ensures that your file is opened on a computer with any version of Microsoft Excel. It’s no secret that many users still work with Office 2003, and in the days when it was created, the .xlsx format did not exist yet (it appeared in Office 2007).

4. Name the file and specify the path to save it, then click Export.

Done – you have just converted a Numbers file to Excel!

♥ BY TOPIC: How to schedule a sleep mode and automatically turn on your Mac.

Can I open Excel files in Numbers?

Yes. Reverse conversion (from Excel to Numbers) is not required, because Apple’s spreadsheet program supports Excel format.

See also: