Microsoft Office

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the...

How do you learn all excel formulas?

A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depended on the item chosen in my first list.

In this tutorial First, we will discuss what a meeting is, How can we schedule it in Outlook. A meeting can be defined as a mass of two or more people have a common motive. All the people present in a meeting can share their ideas and exchange information, to carry out the actions to achieve their goal. This tutorial helps those people who are looking for the steps to Schedule a Meeting in MS Outlook.

Can I turn off "panning hand?"

Some people may don't like the default word or hyperlink font in their Excel. Though you can change the word font of the whole sheet by using the font tools in the Home menu, but the default font still remains when you create a new Excel file. So, here is the solution.

Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is Not Sold What Is the Syntac for Sold Date=Today()

When you create a chart, you often want that it looks similar to some other one. So that instead of formatting the new chart from scratch, which may be quite time consuming, I use simply to copy the template chart and paste it to the new one AS FORMAT from the Paste Special icon. A real life saver if you create a lot of charts...

Many systems offer true dashboard capabilities, but they are usually part of BI (Business Intelligence), complex and expensive applications, that only enterprises may afford

How to Insert Random Time Between 7:30 AM to 8:00 AM in Ms Excel with Interval of 5 Minutes ?

Creating Excel 2013 Sparklines chart. In Excel 2010 and Excel 2013 we can use a new chart type named sparklines.

Excel Premium Power maps series are a brand new project for you! After the one month development phase finally we are ready to present our new excel map templates for you which enable you to use the power of the excel sales heat map.

In my first article in this category I made a simple free excel kpi gauge dashboard. It was one of my first attempts in world of Excel Templates. The time is now for me to refresh my old excel template and I achieved some changes in order for the workbook to be more useful.

A picture tells a story just as well as a large amount of words, but building pretty cool excel data visualization can be time consuming 'passion'.

In this tutorial explains the geometry and trigonometry used to create a new rotating gauge needle to replace the static one.

This dynamic template let us check sales by consumer type or location and examine values with averages too.

When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly.

Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use.

This video will provide an idea about the watermark which is a background effect of either text or graphics that prints in a lighter shade behind the content of your MS Word 2007 document. Watch the tutorial video and employ it yourself.