Excel Change Management Plan Templates (MS Office) $ 19.99. Apple Business Business Analysis Checklist Database Datasheet Deployment Disaster Recovery Excel Finance Form Grant HR iWork Log Logs Management Manufacturing Marketing Market Research Numbers Operations Pages Plan Planning Plans Policy Procedure Product. When I Work is easy-to-use employee scheduling and time clock software. Simplify the shift and start your free 14-day trial today!
One of the aspects new Mac users struggle the most when they just start using their Macs, is the switch from their frequently used productivity applications from PCs to their Mac alternatives. Word and Excel are perhaps the most common examples of this, which is why it is important for Mac users to know as much as possible about any alternative out there.
Apple Iwork Excel
In a past entry, we have already discussed a few basic aspects that every MS Word user should know about Apple’s own Pages, which is part of its excellent iWork productivity suite of apps. This time, let’s focus on Numbers for Mac, Apple’s (much cheaper but very capable) alternative to MS Excel and some of the things that Windows users looking forward to use it should know.
- While Excel comes with versions that are both Windows and Mac compatible, Apple Numbers can only be operated on a Mac. When a comparison of functions is done between Excel and Apple Numbers, Excel offers 138 more functions that can be used to perform convoluted financial calculations.
- When I Work is an employee scheduling app that does more than just save you time on scheduling. It also helps you improve communication, eliminate excuses, boost accountability among your staff, track.
- Pages 4.x ( iWork '09 ) or above Numbers 2.x ( iWork '09 ) or above Keynote 5.x ( iWork '09 ) or above. Note: The iWork software of appropriate version should be installed before use; Keynote 6.0 or above is needed for the conversion of Keynote 5.x files.
Ready? Let’s get started.
Just as with Excel, the basic commands of Numbers are located at the top of every Numbers’ document on both its main Toolbar and its Formatting Toolbar.
The main toolbar of Numbers, as is the case with Pages, allows you to perform the most basic options, but is also home to more advanced elements that are usually not as easily accessible on Excel.
For example, the right side of the Toolbar lets you insert different kinds of elements to your spreadsheets, like text boxes, charts and shapes, as well as allowing you to bring up the all-important Inspector Panel and to adjust some of your spreadsheets’ fonts and colors.
The left side of the main Toolbar though, is home to a few far more interesting options. From there, you can access lists of the most important formulas and functions, as well as being able to change the view and overall layout of your spreadsheet. Additionally, the Reorganize button on the toolbar lets you access some really convenient sorting and filtering options with just one click.
The Format and Formula Bars, as expected, behave almost identically as on Excel. There you can adjust the cells’ borders, the alignment and format of the text and much more.
One of the major differences between Numbers and Excel though, is the left panel that is shown by default on Apple’s spreadsheet application.
This area of every Numbers’ document houses three different (and very useful) panes:
1. The Sheets Pane: This is the equivalent of sheets on Excel. The only exception is that in Numbers, you can have different sheets in one single page, and you can control and position each of them independently.
2. The Styles Pane: As its name implies, you can use this pane to apply different styles to any sheet with just a click. What is even more, you can also create your own styles, save them and set the default style for all future sheets.
Iwork Excel Compatibility
3. The Instant Calculations Pane: This pane is as simple as it is convenient. It works just like the status bar on Excel when it shows the total of a group of values you select, only that Numbers shows five different operations at the same time instead of just one.
As mentioned above, one of the coolest features of Numbers is that you can have several sheets on one page and choose to arrange them and customize them independently. While it takes a bit to get used to, this feature provides a lot of flexibility, especially when working with smaller sets of data.
That’s all for now. Keep an eye on the site for more tutorials and cool tips on Pages, Numbers and Keynote, and if you want to learn something in particular, let us know in the comments below.
The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.
Read Next
3 Tips to Master Numbers On Mac With a Few Clicks
3 cool tips to make working with