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

Nov 7, 2010

Excel Resources : Excel Password Remover

Posted by elvinperia at 8:27 AM 0 comments
My friend asked me to hack a password protected excel sheet. He has this file which he protected a couple months ago so that other people would not be able to change his formulas. However, he forgot the password he used.

I helped him out and found this tool that can remove passwords of any length and passwords containing special characters.

This Excel Password Remover tool is an Excel Add in that works fine in Excel 5.0 and above (including Excel 2000, XP, 2003 and 2007 - I haven't tried in Excel 2010).

This file would give you two extra menu item in the Tools Menu (Excel 2003). These are unprotect workbook and unprotect sheet.

Hope this Excel Password Remover can help you as well.

Pinoy Excel Guru,
Elvin Peria
Read more

Oct 31, 2010

Relative Nature of Formulas in Microsoft Excel

Posted by elvinperia at 9:07 PM 0 comments
Here's an introductory video with regards to Relative Nature of Formulas in Microsoft Excel. Microsoft Excel simplifies the tasks of re-entering common formula to the rest of the cells. Excel called this Relative Referencing.

Watch the video below to understand the Relative Nature of Formulas in Microsoft Excel.



Until my next video.

Pinoy Excel Guru,
Elvin Peria
Read more

Oct 11, 2010

Build Excel Formulas

Posted by elvinperia at 3:00 AM 0 comments
Microsoft Excel is very good at performing calculations. Everytime we use Excel we typically use a combination of cells with numbers and cells with formulas.

Here's a step by step guide how to write your own formulas in Microsoft Excel.

1. Put the cell pointer in the desired cell.
2. Type in equal sign. The equal sign tells Excel that we are starting a formula
3. Type in your equation just like in any calculator. If one of the terms in our formula is already stored in a cell in Excel, we can point to that cell's address instead of typing in the number of that cell. This method allows us to change the value in one cell and then watch all of the formulas recalculate.

Tip: Use + to add. Use - to subtract. Use * to multiply and use / to divide.

4. Press Enter. Excel calculates the formula in the desired cell.

Watch the video for more details.





Until my next video.

Pinoy Excel Guru,
Elvin Peria
Read more

Oct 7, 2010

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

Posted by elvinperia at 4:00 AM 0 comments
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
Read more

Oct 5, 2010

Excel Trivia: Excel 2007 Color Schemes

Posted by elvinperia at 4:00 AM 0 comments
The Excel 2007 interface has three available color schemes. You can select a blue scheme, a black scheme or a silver scheme. You can change the color scheme by clicking on the Office icon and choosing Excel Option, Popular and choose a color scheme from the drop down.


Blue Scheme is best if you are using Windows XP
Black Scheme matches the Windows Vista theme
Silver Scheme provides the higher contrast

Feel free to try it out!

Pinoy Excel Guru,
Elvin Peria
Read more

Oct 4, 2010

Add and Remove Buttons in the Quick Access Toolbar

Posted by elvinperia at 8:07 AM 0 comments
Last week, I've shown you how to change the location of the Quick Access Toolbar.

Today's video will teach you how to add or remove icons in this toolbar.

Placing your favorite icons in the Quick Access Toolbar is the best thing to do if you're using Microsoft Excel on a daily basis.

Why?

Because the Quick Access Toolbar remains visible irregardless of which Ribbon Tab is selected.

Watch the video for more details.



Until my next video.

Pinoy Excel Guru,
Elvin Peria

PS. In case you have Microsoft Excel problems you wanted to share, feel free to email them at questions@pinoyexcelguru.com.
Read more

Sep 27, 2010

Changing Quick Access Toolbar Location

Posted by elvinperia at 6:17 AM 0 comments
Initially the Quick Access Toolbar is located above the ribbon, next to the Microsoft Office Icon.

This video will teach you how to change the location of the Quick Access Toolbar for your convenience.



Some facts about quick access toolbar.

1. Quick Access Toolbar remains visible, so it is best to store your most used commands.
2. Quick Access Toolbar holds up to 90 of your favorite icons.
3. Quick Access Toolbar is included in every Microsoft Office products.

Until my next video.

Pinoy Excel Guru,
Elvin Peria

PS. In case you have Microsoft Excel problems you wanted to share, feel free to email them at questions@pinoyexcelguru.com.
Read more

Subscribe to: Posts (Atom)

Pinoy Excel Guru Design by Insight © 2009