Pinoy Excel Guru Pinoy Excel Guru

PinoyExcelGuru

Why Learn Microsoft Excel?

Microsoft Excel is conceivably the most important computer program used in the most of the offices today. This is the reason why so many employers require their workers and prospective employees to learn Microsoft Excel.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

Even outside of work, Excel is in broad use for everyday problem solving.

Let’s say you have a home office. You can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. You can track your debt, income and assets, determine your debt to income ratio, calculate your net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software.

Practical Excel Tips by Pinoy Excel Guru!

Learn how to simplify and automate your routine tasks using spreadsheets.

Learn how to apply practical tips and tricks in Excel to impress your boss and your office mate with the comprehensive step by step videos.

Learn the basic functions and the things that Microsoft Excel can do for you and your company.

Major Topics that can help You Grow Your Microsoft Excel Skills

You’ll love the videos found on this site because they are step by step and easy to follow. PinoyExcelGuru will guide you to the process of learning simple and practical excel tips and tricks that will bring you to mastering the best application developed in Personal Computers.

Here are the topics you’ll see in this site…

Excel Basics – How to navigate and maximize different Excel features in this easy to follow video tutorials

Excel Formulas – How to use the autosum function of Excel is just the basic. You’ll learn more a lot of these that will surely make your life at the office easier.

Excel Tips and Tricks – Impress all your officemates and specifically your boss with a lot of useful tricks found on this site.

PinoyExcelGuru also provides consulting services that can fit your need and budget.

Sign Up for PinoyExcelGuru Video Tutorial

Name*

First
Last
Email*

Excel Blog

Oct 7, 2010

Excel Trivia: Why Did Microsoft Replaced the Menus and Toolbars in 2007 Version?

Posted by elvinperia at 4:00 AM
If you are an Excel 2003 super user and your company decided to upgrade your Microsoft Office version you'll be shocked with the change. The menu, toolbars and task pane have been completely removed from Excel 2007.

Why did they change this?

Excel 2003 had 1,223 commands on 127 command bars. If you tried to display them all at once, you would not be able to see the Excel grid at all. I guess the image below will definitely help you visualize what I'm saying.



Microsoft figured that if it didn't make some sort of big change, this problem would only get worst in future versions of Excel.

And they come up with the current design.

Special toolbars (like Picture Toolbar, Pivot Toolbar etc) only appear when they are needed.

This trivia came from Bill Jelen of MrExcel.

Pinoy Excel Guru,
Elvin Peria

Labels: , , , ,

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Pinoy Excel Guru Design by Insight © 2009