Relative Nature of Formulas in Microsoft Excel

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

Build Excel Formulas

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

Excel Trivia: Excel 2007 Color Schemes

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

Add and Remove Buttons in the Quick Access Toolbar

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

Changing Quick Access Toolbar Location

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

Minimizing the Ribbon

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

The Office Icon

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

Excel 2007 Interface

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