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

Showing posts with label Excel Tutorial Videos. Show all posts
Showing posts with label Excel Tutorial Videos. Show all posts

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 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

Sep 19, 2010

Minimizing the Ribbon

Posted by elvinperia at 7:32 AM 0 comments
This tip is really helpful for those who are using tablet PC or a laptop with a small screen. The Ribbon in Excel 2007 takes up too much space on your screen.

Here's how to minimize the ribbon.
1. Press Ctrl+F1
2. Right click the ribbon and choose "Minimize the Ribbon"

In the minimized state, you will only see the Office Icon, the Quick Access toolbar and the ribbon tab names.

Watch the video for the demonstration.



Try it out and share this tip to your friends.


For questions or clarifications, please send them at questions@pinoyexcelguru.com.

Until my next video.

Pinoy Excel Guru,
Elvin Peria
Read more

Sep 13, 2010

The Office Icon

Posted by elvinperia at 8:10 AM 0 comments
Here's another video that will teach you an Excel Basic. This video is about the Office Icon.

The Office Icon is located in the upper-left corner of the screen. It contains menu options such as saving, printing and sharing with others. It contains menu items that are straightforward choices such as save and close. Other menu items, such as New, Open and Print lead to a dialog boxes where the user can specify details about the command. Some commands, there is a right arrow next to the command. Hovering your mouse through this arrow will display a fly-out menu containing more options.

For more details, feel free to watch the video below.



For questions or clarifications, please send them at questions@pinoyexcelguru.com.

Until my next video.

Pinoy Excel Guru,
Elvin Peria
Read more

Sep 12, 2010

Excel 2007 Interface

Posted by elvinperia at 7:31 AM 0 comments
Welcome to PinoyExcelGuru.com.

This is my first tutorial video and this will teach your the MS Excel Basic. This will give you a quick start so you can quickly get used to the Ribbon Interface.

There are six elements found in the New Microsoft Excel 2007 interface.

1. Office Icon Menu
2. Quick Access Toolbar
3. Ribbon Tabs
4. Groups
5. Drop-down buttons
6. Dialog Launchers

Feel free to watch the video below for more details.



For questions or clarifications, please send them at questions@pinoyexcelguru.com.

Until my next video.

Pinoy Excel Guru,
Elvin Peria
Read more

Subscribe to: Posts (Atom)

Pinoy Excel Guru Design by Insight © 2009