In this excel for beginners tutorial we introduce the Excel ribbon, the different tabs, commands, and types of buttons. This is a very detailed basic Excel tutorials series. Some of the stuff you see might seem like common sense but if you follow this tutorial series thoroughly you will learn many efficient features that you may not know exists in Excel. This tutorial series is good for Excel 2007, 2010 and Excel 2013 Microsoft Office 365 Excel 365.
The Excel Ribbon is the main location of most Excel Commands. You can see an image of the Excel ribbon in 1-2 below.
The Excel Ribbon
Tabs on the Ribbon
The Excel ribbon has tabs labeled as follows: File, Home, Insert, Data, Review, View and sometimes Developer depending on whether or not it is showing. Inside these tabs are Excel commands that are separated into different groups. An image of the different tabs is shown below by image 1-3.
Excel for noobs Tutorial Ribbon Tabs
Commands on the Ribbon?
A Command is something that tells Excel what to do. An example of a command would be the Fill Color Command as shown in image 1-4. By click this command the activated cell will be filled with the selected color.
Excel For Noobs Tutorial Commands
As mentioned there are groups of commands on every ribbon offered by each individual tab. On the bottom right corner of some command groups you will see a small arrow button pointing down-right. This arrow appears in command groups that provide more command options than can fit into the command group. By clicking this button a dialog box will appear offering more options. For example, if you click on the Insert tab you will see the arrow button in the Charts Group. If you click on the right arrow button the Insert Charts dialog box will appear offering you a large variety of Chart options. This can be seen in Image 1-5 below.
NOTE: Some commands require dialog boxes to gather more information before performing the command.
Commands With Contextual Tabs
Some commands such as Charts, WordArt & Equation have contextual tabs. Contextual tabs offer options directly related to the command you are using. For example, If you click on the Equation command listed in the Insert Tab, two contextual tabs names Drawing Tools and Equation Tools will appear. This can be seen in image 1-7 below.
Please be sure the rate, share, and subscribe. Please also visit our website at http://www.excelfornoob.com
where we add detailed Microsoft Excel tutorials weekly. We also have a section of tutorials dedicated to fund Excel tricks and tips.
Excel 2010 Tutorial
Excel 2007 Tutorial
Excel 2013 Tutorial
Excel 2010 Tutorial For Beginners