How to Protect your excel workbook so that no other user can Read it?

A workbook can be password protected so that no user can read it unless he knows the password. While saving the file use prepare > encrypt document option.

WebSite: http://www.ascentprofessional.com/
Email: info@ascentprofessional.com

Keyboard shortcuts and Key tips in Office 2007/2010

Open any MS office document and press ALT key, key board short cuts are displayed








Key in the letter of options you wish to choose, sub level options’ letter appears

How to Create and Send Business Card using MS Outlook 2010

1.Create a contact: Outlook->Contact->New Contact. Key in all information and see how the business card is created.



2.Attach Business Card: Mail->New Message-> Attach Items-> Business Card and then select a card from the list.

What’s new in MS PowerPoint 2010?

One of the fun features of MS Power Point is the animation. In the MS PowerPoint 2007, Animation was just a one option, which was dealing with slide animation as well as text and content animation. In MS PowerPoint 2010 these are now 2 separate options, making animation even more user friendly. See as follows:

MS POWERPOINT 2007


MS POWERPOINT 2010

WebSite: http://www.ascentprofessional.com/
Email: info@ascentprofessional.com

Quick way to identify relation between data and formulas

Formulas Trace Dependence:
When you have a excel sheet full of formulas, understanding how each value is used by different formulas becomes more challenging. Easiest way to see the relation is:
Highlight the cell you want to know is used by which formulas and click on Formulas->Trace Dependence. All formulas which are directly using this value are highlighted.






Sign up our newsletter at: http://www/ascentprofessional.com/contact%20us.htm

WebSite: http://www.ascentprofessional.com/

Introduction to Office Live Workspace

Still carrying Pen Drive or CDs? Sending documents through emails?

Now all your documents goes with you, you may be anywhere on the globe, if you are connected to internet, you can be at your office.
Microsoft has started Office Live Workspace, it’s a free Online Document Sharing and Storage, perfectly compatible with MS Office 2010 and more. Create your documents and store it on web, you do not need a website or a blog. Invite any one to view or modify your document. Microsoft Office Live Workspace will automatically send invitation email.

See the sample below:

What’s new in MS Office 2010?

Insert -> Screenshot Feature:

Inserting a screen shot in Excel, Word Power point and Outlook in now quick and easy. Just click on Insert and select Screenshot option in Illustration section. All active windows are displayed, select the one you need and will be inserted at the position of you active cursor.

What’s new in MS Office 2010?

MS Excel 2010 : SPARKLINES

A sparkline is a quick way to make a graph and understand the market trend. This is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact.
You can select sparklines feature in the Insert tab. This has 3 options, Line, Column, Win and Loss.

Sign up our newsletter at: http://www/ascentprofessional.com/contact%20us.htm

WebSite: http://www.ascentprofessional.com/