Ask Microsoft Office

Choose a Random Number in PowerPoint

noreply@blogger.com (One Stop Portal) — Sat, 07 Aug 2010 15:24:00 +0000

This may seem difficult to achieve in PowerPoint without vba code. However, there are ways to avoid using vba or macros, which may be useful if you are using a free viewer or using Open Office or the security level may not be sufficient to run the macros.

The solution is to use a spinner, akin to those we see in the gameshow "Wheel of Fortune". One limitation of this is that it is not 100% random (unless we make it fast enough, so that there is little chance of using skill to time the result). Another shortfall is that there will be limited choices of numbers/words, whereas in a real random generator, we can have theoretically unlimited options.

Nevertheless, it is still a useful tool in classes or parties, where you can even have your own game of "Wheel of Fortune"!

Download options:
1) Direct downloadShort Credit version:
2) From DocstocShort Credit version: here

OR see all in docstoc__________________________________________________________________

BMI Calculation - Excel application

noreply@blogger.com (One Stop Portal) — Mon, 21 Dec 2009 07:10:00 +0000

The Body Mass Index(BMI) formula was developed by Belgium statistician Adolphe Quelet(1796-1874), and was known as the Quetelet Index where the definition of Body mass index (BMI) is a measure of body fat based on height and weight that applies to both adult men and women as defined in National Hearth Lung and Blood Institute in USA.

You can visit their site for more information.

Using this simple Microsoft Office Excel application, it allows you to find out your BMI and BMI status with ease.

**In this "BMI Calculator", a few Excel strategies were used. For example, "Data Validation" were used to for the dropdowns and to limit the choices. Also conditional formattings were used to highlight the relevant cells. Formulas were nested to use "IF...ELSE" given the different conditions - male/female, BMI values etc. Microsoft Excel is a suitable tool to create applications like this. This Excel file had security measures, such as locking cells, protecting worksheet, to ensure that the user does not click and delete the wrong cells.

Download options:
1) Direct download : here

2) From Docstoc: here

OR see all in docstoc

__________________________________________________________________

Professional Translation Service at Low Cost

noreply@blogger.com (One Stop Portal) — Sat, 05 Dec 2009 09:30:00 +0000

At AMO, we have been providing quality professional translation services since its incorporation. While most of our translation has been from English to Chinese (and vice versa), we are pleased to have engaged the assistance of AlwaysAsia to translate English and Chinese documents, advertisements, websites etc to Spanish (and vice versa).

Serving a growing clientele base, we have our recent project with Intel and we are pleased to work with all our clients. At AMO, we are committed to provide low cost but yet quality professional translation services and would lend our expertise readily to individuals and companies to reach their target audiences effectively. Do contact us to get a free quote if you think we can meet your needs.

__________________________________________________________________

Excel ISBN and UIN Checker (with algorithm provided!)

noreply@blogger.com (One Stop Portal) — Fri, 25 Sep 2009 02:59:00 +0000

There is often a need to use the check digit often to detect any errors such as from data entry. For example, one might need to check if the digits and letter in a UIN were legitimate or valid before registering the person in a course or before granting access for further online transactions.

"A check digit is a form of redundancy check used for error detection, the decimal equivalent of a binary checksum. It consists of a single digit computed from the other digits in the message.

With a check digit, one can detect simple errors in the input of a series of digits, such as a single mistyped digit, or the permutation of two successive digits."

There are various uses of the check digit. In this post, we are using the "Modulo 11" checksum algorithm to find the check digit for ISBN and UIN (for Singapore and Hong Kong).

Why do we use the "modulo 11"? For numerical check digit, using modulo 11 allows checksum to be written as single digit.

In Singapore, the National Registration Identity Card (NRIC) number is the Unique Identification Number (UIN) or Foreigner Identification Number (FIN)

The algorithm for UIN is not officially announced but is common knowledge among those in the industry.

When used appropriately, this could be a useful first-level protection against malicious attacks or to prevent frivolous usage of certain services your company provide.

Download options:
1) Direct download
ISBN:
Singapore NRIC/UIN/FIN:
Hong Kong UIN:

2) From Docstoc

ISBN: here

Singapore NRIC/UIN/FIN: here

Hong Kong UIN: here

OR see all in docstoc

__________________________________________________________________

Sudoku Excel Solver

noreply@blogger.com (One Stop Portal) — Wed, 23 Sep 2009 03:21:00 +0000

Sudoku is a logic-based puzzle. The most common variant is the 9×9 grid with 3×3 regions.

The objective is to fill this 9×9 grid so that each column, each row, as well as each of the nine 3×3 boxes contains the digits from 1 to 9 only one time each (per row/column/3x3 region), but not including the diagonals.

The puzzle provides a partially completed grid - this provides the constraint on the contents of individual regions and hence each Sudoku has an unique solution that can be reached logically without guessing.

Sudoku is a deceptively simple game of logic, but it is acutally a challenge to master.

You will be able to find various programmes on the internet that can help you solve the Sudoku puzzles.

Right here we are introducing a free Microsoft Excel file that will enable you to solve most Sudoku puzzles with ease.

Just enter the given numbers in their correct places and click the "Start Solving" button in the Excel file. Note that you would have to enable the macro before you can click the button.

If you have a better variant of a Sudoku Solver using MS Excel (or others), do feel free to introduce us by making a comment here.

Download options:
1) Direct download

2) From Docstoc

here

OR see all in docstoc

__________________________________________________________________

Social Networking Media– Verdict?

noreply@blogger.com (One Stop Portal) — Wed, 09 Sep 2009 16:37:00 +0000

Just a little sidetrack from the usual postings...

Facebook 'enhances intelligence' but Twitter and Youtube 'diminishes it', claims psychologist Dr Tracy Alloway from the results of her study.

http://www.telegraph.co.uk/technology/twitter/6147668/Facebook-enhances-intelligence-but-Twitter-diminishes-it-claims-psychologist.html

“Sudoku also stretched the working memory, as did keeping up with friends on Facebook, she said.

But the ''instant'' nature of texting, Twitter and YouTube was not healthy for working memory."

Interestingly, I found her on twitter, perhaps as part of her study as she has likely joined in Feb this year.

In a speech today, US President Barack Obama praised twitter, google and facebook but not Microsoft’s Xbox. He had a blunt status update for America's permanently wired youth: your Facebook postings could come back to haunt you.

Well, that’s good advice from someone who has experienced its aftereffects.

http://searchengineland.com/obama-praises-twitter-google-facebook-but-not-microsofts-xbox-25406

http://sg.news.yahoo.com/afp/20090909/ttc-us-politics-obama-it-internet-facebo-0de2eff.html

So whether you come from a psychologist or a socialist or a politician’s point of view, there is little doubt that the world we are in are getting more and more linked with social networking media. So instead of total avoidance, we should learn to embrace it with wisdom and a little trepidation, but not indulge in it without much understanding of its dangers.

__________________________________________________________________

Rolling credits slide template

noreply@blogger.com (One Stop Portal) — Wed, 09 Sep 2009 09:04:00 +0000

Use this rolling credits slide template, you can easily use it at the end of a group presentation, play, or video to give it a professional feel and look!

Limitation: This will work for PowerPoint 2002, 2003 and 2007.

You might need to edit the timing of the animations if you have a longer credit list of cast and crew.

What you need to do is to add more 'Credit textboxes' and also incrementally increase the delay by 7.5 sec for each additional 'Credit textbox' added. Enough said, you can explore more of it by downloading it!

Download options:
1) Direct download
Short Credit version:

Longer Credit version:

Both versions: as potx or as ppt

2) From Docstoc

Short Credit version: here

Longer Credit version: here

OR see all in docstoc

__________________________________________________________________

Multiplication Table

noreply@blogger.com (One Stop Portal) — Sat, 05 Sep 2009 14:52:00 +0000

This is an application designed to allow children learning the multiplication table to play with, test themselves or to compete with one another.

The sample I have uploaded is for the 10x10 multiplication table. If you will like to use 9x9 or even 16x16 etc to cater to children of difference levels, the application can be edited. Do contact us if you have any question or requests.

Download options:
1) Direct download

2) From Docstoc
OR see all in docstoc

__________________________________________________________________

Countdown Timer in Excel

noreply@blogger.com (One Stop Portal) — Thu, 03 Sep 2009 05:58:00 +0000

Ever wanted to know how long is it to the vacation that you are looking forward to, or how much time it has passed since the first anniversary, but realise you are taking some time to calculate and you are getting frustrated because the time keep changing?

Well, there are softwares you can install in your computer. But if you want a free and installation-free application, look no further to the Microsoft Excel programme you have in your computer.

To download the 2 versions of this application (Microsoft Excel macro may need to be enabled) all in one file, click here or

Another version without the macros (not recommended as you will miss out on the real-time countdown function), click here or

Or get them from docstoc. Just click on the image below!

__________________________________________________________________

Ask Microsoft Office Questions

noreply@blogger.com (One Stop Portal) — Wed, 02 Sep 2009 09:49:00 +0000

Got a question/request/customer technical support for Ask Microsoft Office?

Well, there are at least 2 ways you can do that now.

1) Fill up the form - your question/request will be confidential, replies would via emails

2) Add a comment to this post - your question/request will be published for all to view, replies would be via the comment page

3) Just tweet AMO at http://twitter.com/askmsoffice

4) Use the Chatbox on the right hand column

Do not hesistate to ask us any time!

* You can read more about services provided here.

__________________________________________________________________

Accessing AMO's documents - all in one spot

noreply@blogger.com (One Stop Portal) — Wed, 02 Sep 2009 06:33:00 +0000

Some tips to finding the document that you want in this site:
1) use the "Search This Blog" that you see on the right hand side of this page.

2) click on the relevant "Catgories"

3) If you have a docstoc account, the next best way to view and download all the documents we have posted in this site is to visit my docstoc page.

Just click on the image below!

__________________________________________________________________

Calendar for all years (Part 2)

noreply@blogger.com (One Stop Portal) — Mon, 31 Aug 2009 04:37:00 +0000

As a follow up to the previous post, here are more all year calendars done using different methods and for different preferences and Excel versions:

If your computer's setting for date is of the format "m/d", download here
You can use different themes for fast customisation.

If your computer's setting for date is of the format "d/m", download here
You can use different themes for fast customisation.

Download the calendar that works in all versions of Excel here
You can edit the styles for fast customisation.

If you are not sure which to use, just download all here

__________________________________________________________________

Generating random teams (text)

noreply@blogger.com (One Stop Portal) — Thu, 27 Aug 2009 08:32:00 +0000

If you have read the previous post, you may have realised that I have used numbers for the objects that I want to randomise (in that case, it was the teams). As a variation of the previous scenario, let say, we want to randomise a list of names (non-numerical), we will have to use a different method.

Yes, you can download a sample here (if you have a Docstoc account, this will be a better way for you to download).

Or you can download here without having to sign up.

If you wish to customise it, do contact us.

___________________________________________________________________

Generating random teams (numerical)

noreply@blogger.com (One Stop Portal) — Thu, 27 Aug 2009 08:11:00 +0000

You can use Microsoft Excel to create a simple program that can give you a random sorted list! SAY you have 5 teams - Team 1 to 5, you can randomly ranked the team without drawing lots.

You can download here especially if you have a Docstoc account.

Or you can download here without having to sign up.

If you wish to customise it, do contact us.

___________________________________________________________________

Calendar for all years (from 18 BC)

noreply@blogger.com (One Stop Portal) — Wed, 26 Aug 2009 04:34:00 +0000

Ever wanted a calendar that you can use every year?? Sound incredible.
Yes, it's possible. This is due to the fact that there are 14 possible ways to make up a Gregorian calendar.

Ever thought of which day you were borned? You no longer need to find the old calendar lying around the house.
Now, searching for a past date is made easy with this Excel application.

Download here using Docstoc.

Or you can download here

___________________________________________________________________

Who We Are and What We Do

noreply@blogger.com (One Stop Portal) — Fri, 21 Aug 2009 16:40:00 +0000

"Ask Microsoft Office" (or AMO in short): Making IT applications work for you
To maximise your time on your computer, you need to obtain a clear sense of the methods that are available in IT applications such as Microsoft Office. If you are using a computer for your work or studies, AMO might be what you are looking for.

Ever found tips in the world-wide web, but wonder how you can piece up all the information together? We may have the solution for you with downloadable samples as well as customed files. The idea behind AMO is that we do not dwell so much in the theories (which you will probably find them in many places already), but will instead give you the solutions for you to use directly (and explore on your own if you want to). Call it "problem-based learning".

AMO is also an educational training company, not affiliated with Microsoft in any way, but with more than 10 years of experience and interest in using Microsoft Office applications, hopes to deliver some measurable help for you!
You give us the problem - we solve it for you. No obligations, if no solution can be found.

Most of the services are free as this site is mainly for the benefit of the masses, but at a small fee, we may also tailor them to reflect your project scale and application-specific needs. Beneficiaries of the proceeds(whether as fees or as donations) are education initiatives for communities in Asia (such as Singapore's The Straits Times School Pocket Money Fund and South America (particularly Peru, Ecuador and Chile).

AMO provides services such as the following:
1) MS Office tips (free)

2) MS Office applications (Excel, Word, Access, PowerPoint, InfoPath, Sharepoint Designer/FrontPage, Visio etc) (free or probably at a fee if customised - just tell us the problem)

3) Conversions (likely to be at a fee) such as
- from pictures or text to Word/pdf documents
- from powerpoint to movie file formats

4) Data entry (at a fee)

5) Translation and transcription (English, Chinese and Spanish ) (at a fee)

and others.

Don't hesistate to drop a comment or an email if you want to find out the rates or whether we are able to help you. We hope to respond to your inquiries as much as we can.

*AMO does not profess to be the Expert, so if you have useful applications done from Microsoft Office softwares, we will be glad to post it for you here. Just contact us and then you can email us with your name, the application file and a brief description what it is for or can do.

*If you would like to support our work, do kindly make a donation here. On behalf of the beneficiaries, thank you in advance!
__________________________________________________________________

Contact AMO

noreply@blogger.com (One Stop Portal) — Fri, 21 Aug 2009 16:36:00 +0000

For any requests, enquiries, donations and advertisements, kindly fill up the form below and we will get back to you as soon as we can.

___________________________________________________________________

Our Amazing Givers and Deserving Beneficiaries

noreply@blogger.com (One Stop Portal) — Fri, 21 Aug 2009 11:22:00 +0000

Thanks to these kind donors that made possible this website as well as giving to our beneficiaries.

If you have just donated, we want to really thank you for your generority! And we will include your donation details below as soon as we can.

Givers
1. No given yet. Be the first!

Beneficiaries
1. The Straits Times School Pocket Money Fund (to give directly to SPMF, click here)
2. Alwaysasia's kids program (Chile-Santiago)

~~~~~
You can donate $5 or multiples of $5 (through our onestopportal paypal account):
(Preferred)