The First look at Excel

In the first part of our Excel tutorials, we'll explain what you will see when the programme first starts. We're not going to explain what a spreadsheet is and assume that you already know. If you don't, we have an introduction here:

What is a Spreadsheet?

Launch your Excel software. When the programme starts, you'll see something like this in Excel 2007:

Excel Main Screen (Opens in a new window

In newer versions of Excel, you may see a screen like this one first (Excel 2013):

Excel 2013 Main Screen (Opens in a new window)

To create a new spreadsheet in Excel 2013, click one of the templates. For this course, we'll be using the Blank Workbook temple. Click on that option from the list available. You'll be taken to the main spreadsheet area.

If you've ever used a previous version of Excel then you'll notice that the new version looks quite different! Even if you have never used Excel, the software looks quite intimidating. But we'll make a gentle start so that you can get used to the way everything works.

The first thing to notice is the Ribbon running right across the top. The Ribbon is supposed to be more intuitive than drop-down menus. Emphasis is placed on the tools and options appropriate to what you're doing. Here's a closer look at the Ribbon when Excel first starts (it's split in half, here):

Left Side of the Ribbon in Excel 2007

Right Side of the Ribbon in Excel 2007

Left Side of the Ribbon in Excel 2010 and 2013

Right Side of the Ribbon in Excel 2010 and 2013

Notice that in both versions the Home tab is the one that is selected. Other tabs are: Insert, Page Layout, Formulas, Data, Review and View. (In the image above, there's also a Developer tab. If you don't do any programming then you don't have to worry about this tab.)

In the top left of the Ribbon in Excel 2007 there's a big circle. This one:

Click this, and you'll see all the file operations: New, Open, Save, Exit, etc.

To see the same menu in Excel 2010, you have to click on the File tab, which is on the far left. (It looks as though it's already selected, but it's not.):

Excel 2013 also has a File menu like the one above. When you click the File menu in Excel 2013, however, you'll see this instead:

To get back to your spreadsheet in Excel 2013, click the left-pointing arrow in the top left:

We'll go through all these menu options later, along with the various options on the Ribbon tabs. But the best place to start with Excel is getting to grips with all those numbers and letters. These are the Grid Coordinates. We'll do that in the next part.

Unable to create events in eM client's calendar

This usually happens when you try to create an event in read-only folder.

For Example : Weather Calendar,U.S holidays Calendar.

Check Calendar When you Add and Event.

Select calendar and you have resovled the issue.

Thanks

 

Reset RecordNumber or Serial No for New Group in Crystal Report

For Example.


Group 1
---------
1
2
3
4

Group 2
---------
1
2
3
4
5

Group 3
----------
1
2
3
 


Go to Insert running total field

There choose new and give any name for the running total fields

Then in the fields to summarize option choose any field and in type to summarize choose count

In evaluate option choose For each record

In reset option choose

On change of group

Then click ok and insert it in your report.

Address bar cursor is no longer on left side but on right side

I was typing something in the address bar and somehow I pressed a series or combination of keys so that the cursor of the address bar has shifted from the left side to the right side. All the web addresses now are displayed from right to left instead of vice versa. It's like the equivalent of me hitting "Align Side Right " in Microsoft Word. How do I change it back to "Align Side Left" like it normally is?

 Helpful replies
You may have touched the Shift key when trying to cut text via Ctrl+X.
You can flip the bidi text direction from right-to-left to left-to-right with Shift+Ctrl+X.


Ref: http://support.mozilla.org/en-US/questions/945919
.