Difference between MS Excel and Kingsoft spreadsheet shortcuts

Kingsoft Office is very much similar to MS Office and highly compatible. On the surface one will observe very few differences between them. Though there are some key differences between two suites, our key focus lies on understanding how much the shortcuts of the two differ. Today we'll see the differences in the shortcuts of MS Excel and Kingsoft Spreadsheet. 

Most of the important shortcuts of MS Excel, that we've discussed in our previous articles, can be used in Kingsoft Spreadsheet as well. However, there are some dissimilarities as given below:

1. Formatting keys don't work in Kingsoft

The formatting keys (Ctrl + Shift + ~/$/3/%/! ), used for changing the given number in different formats like date, currency, percentage etc. doesn't work in Kingsoft spreadsheet. Only CTRL + 1 shortcut can be used to open the dialogue box showing different formats. The user will have to select the appropriate format to get the desired result. 

2. No shortcut for Hiding/Unhiding rows and columns

There are no dedicated shortcuts for hiding and unhiding rows or columns in Kingsoft Spreadsheet. This action can be performed by going through the 'Rows & Columns' tab given under Home tab or by selecting a row/column and choosing 'Hide' option after right click. 

3. ALT based shortcuts work in little different manner

The ALT based shortcuts in Kingsoft spreadsheet need little explanation as they work in slightly different way from that in MS Excel. Let's understand how 

a) A normal Kingsoft spreadsheet looks like this

b) Now when we press ALT on keyboard, a menu emerges which has been highlighted in the red colour. This is similar to appearance of the numbers on the tabs when ALT is pressed in Excel. 

c) The user can either press an alphabet key or use arrow keys to open a particular section. For example, upon pressing I, following options appear in front of the user.

Use the arrow keys to select the appropriate option and perform the intended action. 

Excel v/s Kingsoft Spreadsheet: Major differences in features

Kingsoft Office is very similar to MS Excel in many ways. In the previous article we had seen how only a small part of the whole set of shortcut keys in Excel is missing in Kingsoft. The user interface of both the applications is very similar. In addition, the availability of many common tools, functions and file saving extensions in Kingsoft make it an good alternative to Excel. That explains its success in many of the small to mid level organisations.

However, there are some major differences between Excel and Kingsoft spreadsheet & you should be well aware of the latter's limitations. 

Note - The points discussed here pertain to the free office version of Kingsoft spreadsheet only. 

1. Formatting and colour scheme

The formatting and colour scheme in Kingsoft aren't good at all. A screenshot given below gives you a better idea. 

2. Charts

The charts layout isn't as refined as that of Excel. In fact it gives you the feeling of Excel 2003 version. The screenshot shows the comparison between Excel and Kingsoft. 

3. Autocomplete feature

Autocomplete feature doesn't works for the functions in the Kingsoft spreadsheet. As you can see in the screenshot given below, a user needs to type the whole function name in Kingsoft unlike Excel which gives the options. 

4. Customization

 The customization of quick access toolbar, one of the prominent additions to Excel in 2007, is absent in Kingsoft. 

5. Trace Precedent and Data Table

Kingsoft doesn't offer the 'trace precedents in cells' and 'data table' feature. Both these features are very prominent for the people dealing with advanced level of Excel.

6. Pivot Capability

Kingsoft doesn't provides 'Pivot capability' to its users.

7. Functions library

In spite having a lot of common functions, Kingsoft's library of fucntions, as a whole, pales in comparison to Excel.

Kingsoft Office suite

In the last few years many new sophisticated & improved Office suites have emerged and that has given the users other alternatives of Excel and Numbers. Undoubtedly the most successful so far has been Kingsoft Office

Kingsoft Office is an office suite developed by Chinese software developer Kingsoft. Like Word, PowerPoint and Excel in MS Office, Kingsoft includes three applications in its offering: Kingsoft Writer, Kingsoft Presentation and Kingsoft Spreadsheet. The current version is KSOffice 2013.

Kingsoft has seen much more success in its smartphone offering where it has more than 100 million registered users. But in this article our focus is on understanding some important features of desktop application of Kingsoft Spreadsheet. 

Features of Kingsoft Spreadsheet

1. High compatibility with Excel 
The biggest plus with it is that Kingsoft is highly compatible with Microsoft Excel. The compatibility thing includes similarity in layout, shortcuts, availability of common tools and file saving extensions. 

2. Various templates for the users
Kingsoft has various templates to offer to its users with themes ranging from business, education, office and resume etc. 

3. Built-in PDF converter
Kingsoft has a built-in PDF converter sub-software which can convert Spreadsheets slides into PDF format for free.

4. Multiple tabs in spreadsheets
Taking a leaf out of the latest web browsers, Kingsoft has introduced multiple tab interface in the spreadsheets. So a user needn't worry about switching between a lot of windows. 

5. Creation of group hyperlinks
Another very interesting feature of Kingsoft is that it allows users to create group hyperlinks. Through it a user can convert large amounts of text into hyperlinks to the internet, Email or other sections within the same document.

6. Summarize feature
In the end comes the summarize feature. If a cell contains a lot of content then Kingsoft automatically summarizes the information for the user and display it.

Shortcut differences between MS Excel and Mac Numbers

A previous article on Mac keyboard has already made the users aware about how different it is from a normal desktop windows keyboard. In this article we go one step further and see how much the shortcuts of Numbers (the spreadsheet application of Mac) differ from that of Excel. 

For the sake of simplicity in understanding, we can divide the shortcuts of Numbers in 2 groups

1. The shortcuts which are same as their windows counterpart, with only difference being the equivalent modifier key. 

2. The shortcuts in which the key combination is different from that of Excel

In the first set of shortcuts the user needs to remember only the equivalent modifier key if he/she is well-versed with the Excel shortcuts. So a shortcut like 'Ctrl + A' in Excel becomes 'Cmd + A' in Numbers as the command key is the equivalent key of control in Mac. 
Few more examples are - 

Command + F = Ctrl + F
Command + Page Down = Ctrl + Page Down

We are interested in the second set of shortcuts as here lies a greater difference. A person moving to Numbers from Excel need to learn them as there are more differences than just substitution of an equivalent key. There are a lot of such shortcuts but we will be keeping our focus solely on the shortcuts (in fact, the actions performed by them) that we have already discussed in Excel. 

One important thing to note here is that Mac doesn't have shortcuts for a no. of actions that we do frequently on Excel. So here we will be discussing only 5 such shortcuts in Mac which are very much different from Excel. 

Action	Excel Shortcut	Numbers Shortcut
Switching between applications	ALT + Tab	Cmd + Tab
Closing Excel application	ALT + F4	Cmd + W
Addition of row/column	CTRL+ Shift + ‘Plus’	Option + arrow
Switching between spreadsheets	CTRL + Tab	Function + cmd + up/down arrow

Addition of row/column

This action needs a bit of description. Unlike Excel, where you can only insert a row/column just above the row or to the left of the column you are on, Numbers allows you to insert a row/ column in any direction. For example, pressing Option + down arrow will lead to insertion of a new row just below the selected row. That gives you a lot more flexibility in Numbers as compared to Excel. 

Numbers – The Spreadsheet Application of Apple Mac

MS Excel isn't the only spreadsheet application around, though its popularity makes it far more recognizable than others. Nevertheless, there are other equally effective spreadsheet applications around. The most popular amongst them is Numbers, the spreadsheet application of Apple's OS Mac.

Like Microsoft, Apple has its own office suite for its OS Mac - iWork. Just like MS Word, Excel and PowerPoint, it consists of word processing software (Pages), presentation software (Keynote) and spreadsheet software (Numbers). We will be getting some basic idea about Numbers today. 

First of all, let's see how this spreadsheet application of Mac looks like.

Now let's go through some unique features of Numbers and see how similar/different it is from MS Excel. 

1. Version

The first version of Numbers, 1.0, was launched in 2007 and the latest version is 3.0. 

2. Templates

Instead of using tables, Numbers provides the users with a blank canvas. It gives you freedom in choosing fonts as well as style cell borders. There are as many as 30 templates to choose from. A screenshot given below gives an idea regarding that

3. Functions

Features like formulas, functions, charts and smartArt etc. which make Excel so productive are present in Numbers. However, the functions library of Numbers isn't as rich as MS Excel. 

4. Chart Quality

At the same time, though, the quality of charts prepared on Numbers is a notch higher than its Windows counterpart. 

5. Application

But the main difference between them lies in their application. MS Excel is more business oriented and needs more refined approach. Numbers, on the other hand, caters more to casual or home users who have less complicated tasks to do on it. 

The next article will be dealing with the keyboard shortcuts in Numbers. 

Difference between Windows and Mac keyboard

Most of the people in one part of the world are habitual of working on Windows OS due to its wide presence in homes and offices outside USA. Apple’s Macintosh (Mac) is another popular OS, but limited knowledge about it, especially in Asia, dissuades many from adopting this OS. In this new series of articles our attempt will be imparting some basic knowledge about Mac and how its Office suite differs from that of Microsoft. 

The very first step in this direction is to understand how the keyboard of Mac differs from that of windows. Let's see how a Mac keyboard looks like. 

Windows keys and their Macintosh equivalents

Windows Keys	Mac Keys
Control (CTRL)	Command (CMD)
ALT	Option (OPT)
Delete	DEL
Backspace	Delete
Enter	Return

Mac Keys and their symbols

Key symbols	Mac Keys
⌘	Command (CMD)
⌃	Option (OPT)
⌥	DEL

Now let’s have a look at some brief information about the Macintosh keys mentioned above

1. Command - This key is the substitution of the ‘control’ key on windows keyboard. Like its windows counterpart, command is used in popular shortcuts. In some keyboards this key is labeled ‘cmd’ with a Bowen knot symbol. Earlier Apple logo was used as a symbol.

E.g. Command + A (shortcut for ‘Select All’)

2. Option -  This key is the substitution of the ‘ALT’ key on the windows keyboard. The combination of Option along with some other key (option + 8 key will insert the bullet character) is used to perform any action.

E.g. Option + 8 (Shortcut for ‘Inserting Bullet character)

3. Delete - There is no ‘Backspace’ key in the Mac keyboard. Instead you will find the key ‘Delete’. It is used to delete the typed characters.

4. DEL -  It is the substitute of ‘Delete’ key in the windows keyboard and functions in the similar way. 

5. Return - 'Enter’ in the Windows keyboard is replaced by Return in the Mac keyboard. The function though remains the same.

Function Keys in Mac keyboard

Unlike Windows, which has 12 function keys (F1 to F12) on any type of keyboard, a Mac keyboard can either has 12 or 19 function keys depending upon the inclusion of the num pad. It's imperative to give a brief knowledge about the function keys here. 

Function Keys	Use
F1 and F2	Controlling brightness
F3	Mission control
F4	Launchpad
F7-F9	For music
F10-F12	Volume control
F5/F6/F13-F19	Unassigned or blank keys

Some important points regarding these function keys are as follows

1. Mission Control gives an overview of all the running applications by showing them separately on screen. 

2. Launchpad lets you see, organize and easily open your apps. 

3. The blank keys can be assigned a particular function by the users.           

Grid Lines and Guides in MS PowerPoint

Gridlines and Guides is an important feature in PowerPoint which is often neglected. This is because it doesn't have a direct use in presentation making. Instead it aids in making presentations cleaner and more precise. Before moving forward, it is imperative to understand the difference between the two. 

Gridlines helps you in 
a) Ascertaining center of slide
b) Precise positioning shapes and objects 

By default, gridlines are spaced 0.083 inches apart. Guides, on the other hand, basically help you in drawing shapes and then precisely positioning it. They also help in adjusting the relative positions of the objects. Another important distinction between the gridlines and guides is that the gridlines are fixed positions (depending on your settings) while guides are movable lines. You can also create multiple guides by using Ctrl key with mouse/keypad (just like you replicate objects). 

Both gridlines and guides aren't visible during presentations.

Use of Gridlines 

In the picture to the left is an arrangement of the different objects. The same objects are shown individually in the right hand side. You can clearly see how neatly the objects have been positioned with respect to one another. This precise positioning can be attained through the gridlines. 

The picture below shows how the gridlines guide you in placing the object on the slide in the precise manner easily. 

Use of Guides

In the following example the aim is to draw a boomerang. The shape of boomerang requires symmetry on both sides. This can be achieved through the use of drawling guides. 

In the picture to the left you can see how the guides have helped in drawing the boomerang swiftly and easily. To the left is the finished boomerang.